Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate And Project Finance Modeling Theory And Practice

Authors: Edward Bodmer

1st Edition

1118854365, 9781118854365

More Books

Students also viewed these Finance questions

Question

Patients are kept waiting two hours for appointments.

Answered: 1 week ago