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...
-
The frequency of alcohol-related arrests during a single season at a sporting arena ranged from 0 to 17 arrests per game. What is the interval width if you choose to create a frequency distribution...
-
The depth of water behind the Hoover Dam is 220 m. Show that the water pressure at the base of this dam is 2200 kPa.
-
What does the term current liabilities mean?
-
The cash register tape for Kelly Kapoor Industries reported sales of $6,891.50. Record the journal entry that would be necessary for each of the following situations. (a) Cash to be accounted for...
-
tal Practice Bank Reconciliation-Ax M Question 1-Practice Bank Reco x education.com/ext/map/index.html?_con-con&external browser 08launchUrl=https%253A%252F%252Flms.mhed Reconciliation i Saved...
-
The following is a cross-tabulation of whether respondents rent or own their home by social class for a sample of 240 heads of household: a. Which is the independent variable and which is the...
-
Let F(x, y, z)=((1-2)(1-2)2,8) and C is the boundary of the surface S shown in the figure: open Use stokes' Theorem to evaluate S; 2= 1-1x + y jezi f(n)-dr.
-
Submit at least 300 word typed self-evaluation in essay form. Please do not submit answers to questions like a survey. Rather, demonstrate critical thinking by providing analysis and evaluation of...
-
The budgeted costs for Connor Company for direct materials, direct production labor and direct distribution labor are $40, $8 and $12, respectively. The vice-president is deeply satisfied with the...
-
Give three examples of how Philippe Crosby used the principles of "quality is free" to drive organizational changes resulting in better market performance. Explain how each example resulted in...
-
A lossless transmission line is 80 cm long and operates at a frequency of 600 MHz. The line parameters are L = 0.25 pH/m and C = 100 pF/m. Find the characteristics impedance, the phase constant, and...
-
Write an INFORMATIONAL LETTER TO INVESTORS AND PRESENTATION AT A STAFF MEETING You have an email from the chief information officer, Ms. Boss: Hello, I need you to handle the communication for big...
-
BMA is manufacturer of wholesale food products. Their sales fluctuate with consumer tastes. Revenue was greater in 2020 as people stayed home during COVID buying more food for their household....
-
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:...
-
Equivalent Units and Product Cost Report-FIFO Method Following are the September 2019 charges (and certain annotations) appearing in the work-in-process account for Empire Company's processing...
-
what spanning tree does the Spanning Tree One Step function find when the order of edges is: (a) \(\{\{5,6\},\{4,5\},\{3,4\},\{2,6\},\{2,5\}\),...
-
Prove that a connected, undirected graph \(G\) is a tree if and only if for each edge \(\{u, v\} \in G, G-\{u, v\}\) is not connected.
Study smarter with the SolutionInn App