Question: i need step by step explanation plus answer. A. Calculate the Net Present Value of the Windmill venture by completing the table below. B. What

i need step by step explanation plus answer.
A. Calculate the Net Present Value of the Windmill venture by completing the table below.
B. What number did you use (Cov - Spc)?
C. should Quixotic dream the impossible dream and invest in the Windmill venture? Yes or No.
A number of windmills are to be constructed on the southern frontier to generate electricity. They will cost $408.000 and will last 9 years, at which time they will have an estimated salvage value of $30,000. However, a capital upgrade of $93,000 will be required at the end of five years. An inventory of spare parts (working capital) amounting to $10,000 will be required during the term of the venture and will be housed in a warehouse that is currently not being used, but which has been used for Quixotic's previous ventures. The warehouse could be rented out at $4,000 per year. This enterprise is expected to generate cash from the sale of electricity of $160,000 a year for 9 years. Cash expenses for each of the 9 years will be $8,000. The company's tax rate is 22 percent, the CCA rate is 6 percent and the cost of capital is 17 percent. Requirements: A. Calculate the Net Present Value of the Windmill venture by completing the table below. You need a number for every cell in this spreadsheet.) Event Expected Cash Flow After-tax Cash Flow Present Value Enter cash receipts os positive numbers, cosh payments as negotive numbers. Round oll your answers to zero decimol places nital Investment Working Capital Revenues Expenses Opportunity Cost Capital Upgrade Salvage Working Capital Revcovery CCA Tax Shield NA NA Net present value NA NA 3. It's not worth any marks, but it helps with the marking: what number did you use for (Cov - Spv)? Enter your one positive number C. Should Quixotic cream the impossible cream and invest in the Windmill venture? Click to seleo: v
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
