Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Check my A number of windmills are to be constructed on the southern frontier to generate electricity. They will cost $340,000 and will last 11
Check my A number of windmills are to be constructed on the southern frontier to generate electricity. They will cost $340,000 and will last 11 years, at which time they will have an estimated salvage value of $22,000. However, a capital upgrade of $105,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 $5,000 per year. This enterprise is expected to generate cash from the sale of electricity of $153,000 a year for 11 years Cash expenses for each of the 11 years will be $10,000. The company's tax rate is 27 percent, the CCA rate is 6 percent and the cost of capital is 16 percent Requirements: A. Calculate the Net Present Value of the Windmill venture by completing the table below. You need a number for every cel 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 -340000 340000 -340000 Working Capital -10000 -10000 -10000 Revenues 153000 111690 561549 Expenses -10000 - 7300 -36709 Opportunity Cost -4000 2880 -14482 Capital Upgrade -105000 -105000 20519 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 -340000 -340000 -340000 Working Capital -10000 -10000 -10000 Revenues 153000 111690 561649 Expenses -10000 -7300 36709 Opportunity Cost 4000 -2880 -14482 Capital Upgrade 105000 105000 20519 Salvage 22000 Working Capital Revcovery CCA Tax Shield N/A NIA Net present value NIA B. It's not worth any marks, but it helps with the marking what number did you use for (Cpv - Spv)? Enter your answer at a positive number C. Should Quixotic dream the impossible dream and invest in the Windmill venture? (Click to select)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started