Assume a company with a single product. Listed below is some information, that you can use to recreate its income statement. You can also use this information to calculate the cash flows for the capital budgeting exercise for a period of 5 years. Furthermore, you can use this information to create a forecasted income statement and to create a cash budget as we have done in class.

You can use linear depreciation to calculate the depreciation expense.
To calculate interest payments, please use the number for capital expense and the leverage ratio.
To calculate equity, you can use the number for capital expense and correct for the leverage ratio (you can also deduct debt from capital expense).

Some points:
Please briefly discuss your answers.
The written text in your answers should not be longer than one written page (you can however include as many graphs as you like, even if these would get you over the 1 page limit). Quality answers are better than long.
Support your arguments with numbers, where applicable.
When you are done, you can upload your answers as a Word Document or as a pdf file.

download the following Excel file with the information to complete the case study:

Using the information above, please answer the following questions:

Capital Budgeting
1) Create a sensitivity analysis, a scenario analysis or a Monte Carlo Simulation for the capital budgeting project. Plot the results. What do you notice?
2) Is wealth being generated by the company with this project over a period of 5 years (Hint: calculate the NPV using equal cash flows for years 1 – 4 (same sales and costs for 4 years) and adjusting the final cash flow with the change in NOWC)?
3)How would you improve the outcome, looking at either scenario analysis or sensitivity analysis (Hint: changing the most sensitive driver only a little bit will still have a big impact).
4) How does changing the weighted average cost of capital influence results? Does the company have any control over its WACC?