Quixotic Enterprises is about to embark on another venture. Poncho Sanchos, the faithful financial analyst, once...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 $402,000 and will last 9 years, at which time they will have an estimated salvage value of $22,000. However, a capital upgrade of $96,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 $5,000 per year. This enterprise is expected to generate cash from the sale of electricity of $149,000 year for 9 years. Cash expenses for each of the 9 years will be $8,000. The company's tax rate is 29 percent, the CCA rate is 10 percent and the cost of capital is 19 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 402000 402000 402000 Working Capital Revenues Expenses Opportunity Cost Capital Upgrade Salvage Working Capital Revcovery CCA Tax Shield Net present value N/A N/A 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)? (Enter your answer as a positive number) 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 $402,000 and will last 9 years, at which time they will have an estimated salvage value of $22,000. However, a capital upgrade of $96,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 $5,000 per year. This enterprise is expected to generate cash from the sale of electricity of $149,000 year for 9 years. Cash expenses for each of the 9 years will be $8,000. The company's tax rate is 29 percent, the CCA rate is 10 percent and the cost of capital is 19 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 402000 402000 402000 Working Capital Revenues Expenses Opportunity Cost Capital Upgrade Salvage Working Capital Revcovery CCA Tax Shield Net present value N/A N/A 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)? (Enter your answer as a positive number)
Expert Answer:
Related Book For
Foundations of Financial Management
ISBN: 978-1259024979
10th Canadian edition
Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen, Doug Short, Michael Perretta
Posted Date:
Students also viewed these finance questions
-
Let 1 -2 2 A -2 1 -3 1 -5 3 Determine whether (1, 1, 1) Row(4), and whether (1,1,1)' Nul(4), showing working and explaining your reasoning in terms of the defini- tions and methods presented in this...
-
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...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
In Problems 2738, the reduced row echelon form of a system of linear equations is given. Write the system of equations corresponding to the given matrix. Use x, y; or x, y, z; or x 1 , x 2 , x 3 , x...
-
A copper rod of length 0.85 m is lying on a frictionless table (see the drawing). Each end of the rod is attached to a fixed wire by an unstretched spring that has a spring constant of k = 75 N/m. A...
-
We have all had that friend, an individual who attaches himself or herself to us without our encouragementor approval, for that matter.1 For Debbie Woodruff, that friend was David Quinn. Debbie met...
-
The following is an extract from the Sudzucker AG 2003 Annual Report: Inventories are stated at acquisition or production cost using average cost or first-in, first-out. As set out in IAS 2 the...
-
1. When Lynda.com began offering subscriptions to a library of e-learning courses, what new value did the company provide to their customers? What advantages did e-learning from Lynda.com have over...
-
N U X 67 32 mm 45 mm 151 82 W 48 mm 60 P Q 10 mm NOPQWXUV. What is PQ?
-
MARKETING EXCELLENCE Given today's increasingly hectic lifestyles, precooked meals and processed ingredients are becoming the norm for Canadian families to use in preparing their daily meals....
-
Imperial Jewelers manufactures and sells a gold bracelet for $406.00. The company's accounting system says that the unit product cost for this bracelet is $265.00 as shown below: Direct materials...
-
The following questions relate to the auditor's consideration of the internal control structure. Select the best response. a. The primary purpose of the auditor's consideration of internal control...
-
Eagle Outfitters expects to sell 5,000 water bottles in January and 6,000 water bottles in February for \(\$ 10\) each. Prepare the sales budget for January and February.
-
Jones, CPA, who has been engaged to audit the financial statements of Ajax Inc., is about to commence obtaining an understanding of the internal control structure and is aware of the inherent...
-
Eagle Outfitter's store in Butte, Montana, is projecting sales as follows: January, \$50,000; February, \$80,000; March, \$40,000; April, \$50,000. Cash sales are \(60 \%\) of total sales; credit...
-
As a part of understanding the control environment, an auditor studies the organization structure as it relates to the division of labor and responsibility. The auditor also studies the accounting...
-
Using the image below, classify each attribute (column) with their Stevens Classification (Nominal, Ordinal, Interval, and Ratio) for Columns A through J. Include a description as to why you...
-
Jax Incorporated reports the following data for its only product. The company had no beginning finished goods inventory and it uses absorption costing. $ 57.30 per unit $ 10.30 per unit $ 7.80 per...
-
You farm in Alberta and expect to have 1,000 tonnes of canolafor sale in the fall. You would like to hedge your risk of price fluctuations through the Winnipeg Commodity Exchange. Today is early...
-
Bill Board must choose between two bonds: Bond A pays $90 annual interest with semiannual payment and has a market value of $850. It has 10 years to maturity. Bond B pays $80 annual interest with...
-
Huron Ltd. has the following capital structure: 16% Debentures , due in 14 years.....................$30,000,000 Preferreds (8% dividend, 40,000 shares)..............3,000,000 Common shares:...
-
Which is more costly for an issuer an underwritten deal or a bought deal? Why?
-
Will a shareholder who subscribes a capital increase with a pre-emptive subscription right become poorer if the share price drops after the operation? Why?
-
Which placement procedure carries the most risk for a bank? Why?
Study smarter with the SolutionInn App