Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

image text in transcribed

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 $347000 and will last 9 years, at which time they will have an estimated salvage value of $20,000. However, a capital upgrade of $107.000 will be required at the end of five years. An inventory of spare parts (working capital) amounting to $9,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 $159,000 a year for 9 years. Cash expenses for each of the 9 years will be $10,000. The company's tax rate is 24 percent, the CCA rate is 6 percent and the cost of capital is 18 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.) 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 347000 0 347000 Working Capital 9000 0 9000 Revenues 159000 Expenses Opportunity Cost Capital Upgrade Salvage Working Capital Revcovery CCA Tax Shield N/A NIA NA NA Net present value B. It's not worth any marks, but it helps with the marking: what number did you use for (Cpv - Spv)? "Enter your answer as a positive number (Click to select) C. Should Quixotic dream the impossible dream and invest in the Windmill venture

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

Financial Management Concepts and Applications

Authors: Stephen Foerster

1st edition

013293664X, 978-0132936644

More Books

Students also viewed these Finance questions

Question

List one populat operating system

Answered: 1 week ago