financial model

the project was to build a 3 statements financial model with 5 years forecast to test whether the company is will be able to pay its debts(payments + interest) under the assumption that they are going to use Long term debt to finance its expanding projects.

the forecast was built under three different scenarios (management , basic , & worst case) scenarios, under each scenario i used different assumptions that driving the sales forecast, cost, & interest rates.

and the final section was to sensitize the company's ability to pay its fixed charges taking into consider the drooping sales and increasing interest rates.