Net income + cash flow and NPV for a company
1. Wind Power Inc. (WPI) builds and operates wind farms that generate electric power suing windmills. The firm has wind farms throughout the Southwest. In December 2017, the owner of WPI, Steve Simonson, decided to invest $100,000 in a new production monitoring system. Steve is an engineer by profession, but he is fully aware of the difference between the accounting profit and economic profit. As a result he would like to utilize the Economic Value Added (EVA) concept to determine whether to invest in this new piece of equipment? He has hired you to assist him in determining the present value of EVA. His accountant has provided the following information pertaining to income statement. The projected sales revenue information is contained in the attached Excel file (FIN630_Final Exam Version_2018.xlsx):
a. Cost of goods sold is 40% of revenue; Operating expense is 20% of revenue; Depreciation is straight line to zero salvage value over a 5-year life; Interest expense is $1,600 per year for the next 5 years; and Tax rate is 30%.
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper Nowb. WPI’s book value capital structure is as follows: 75.0% equity and 25% debt. WPI’s before tax cost of debt is 6.4% and has a beta of 1.8. The risk free rate of interest is 3% and the market risk premium (Rm-Rf) is 6%. Based on the information provided above, you are asked to do the following:
1- Complete the income statements for 2018-2022. Examine the trend in net income (NI). What is your assessment of financial suitability of this project? Although Steve is not a fan of selecting projects based solely on accounting profitability, he is, however, willing to hear your assessment of this project. What will you present to Steve?
2- Calculate the Weighted Average Cost of Capital (WACC) for WPI. Place your answer is cell C4.
3- Calculate the Free Cash Flow to Firm (FCFF) for years 2017-2022. Place your answer in cells C30-H30. As stated above, 2017 cash outflow is exclusively based on initial capital investment and no additional capital was invested thereafter. The annual changes in net working capital are given in the spreadsheet.
4- Find the Net Present Value (NPV) of this project based on FCFF. Place your answer in cell C33. What is your recommendation? Is the NPV based recommendation different from what you stated in response to question (i)? Explain.
5- Calculate EVA for the years 2018-2022. Find the present value of all future EVAs and place the answer in cell C43. Does the project add economic value? What is your overall recommendation regarding this project. Should WPI accept this project? Explain.
