please help me solve this. thank you!

Quixotic Enterprises is about to embark on another venture. Poncho Sanchos, the faithful financial analyst, once again will examine the viability of this venture after 31 failures. A number of windmills are to be constructed on the southern frontier to generate electricity. They will cost $352,000 and will last 11 years, at which time they will have an estimated salvage value of $27,000. However, a capital upgrade of $99,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 $6,000 per year. 5 This enterprise is expected to generate cash from the sale of electricity of $152,000 a year for 11 years. Cash expenses for each of the 11 years will be $12,000. The company's tax rate is 30 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 as positive numbers, cash payments as negative numbers. Round all your answers to zero decimal places. Inital Investment -352000 -352000 -352000 Working Capital -10000 -10000 -10000 Revenues 152000 106400 Expenses -12000 -8400 Opportunity Cost -6000 -4200 Capital Upgrade -99000 -98000 Salvage 27000 Working Capital 10000 Revcovery CCA Tax Shield N/A N/A Net present value N/A N/A B. It's not worth any marks, but it helps with the marking: what number did you use for (Cpv - Spv)? mrithon nuimtari Quixotic Enterprises is about to embark on another venture. Poncho Sanchos, the faithful financial analyst, once again will examine the viability of this venture after 31 failures. A number of windmills are to be constructed on the southern frontier to generate electricity. They will cost $352,000 and will last 11 years, at which time they will have an estimated salvage value of $27,000. However, a capital upgrade of $99,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 $6,000 per year. 5 This enterprise is expected to generate cash from the sale of electricity of $152,000 a year for 11 years. Cash expenses for each of the 11 years will be $12,000. The company's tax rate is 30 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 as positive numbers, cash payments as negative numbers. Round all your answers to zero decimal places. Inital Investment -352000 -352000 -352000 Working Capital -10000 -10000 -10000 Revenues 152000 106400 Expenses -12000 -8400 Opportunity Cost -6000 -4200 Capital Upgrade -99000 -98000 Salvage 27000 Working Capital 10000 Revcovery CCA Tax Shield N/A N/A Net present value N/A N/A B. It's not worth any marks, but it helps with the marking: what number did you use for (Cpv - Spv)? mrithon nuimtari