Project 2 Calculations must be done in Excel - You must create your own spreadsheet (do...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Project 2 Calculations must be done in Excel - You must create your own spreadsheet (do not copy and paste someone else's). This question should be done using Method 1 as outlined in lecture 6 (i.e. Tax Effects, then Cash Flows then NPV). As the financial advisor to Have Fun Manufacturing you are evaluating the following new investment in a manufacturing project: - The project has a useful life of 8 years. Land costs $10m and is estimated to have a resale value of $25m at the completion of the project. Buildings cost $12m, with allowable depreciation of 8% pa reducing balance and a salvage value of $10m. Equipment costs $5m, with allowable depreciation of 15% pa reducing balance and a salvage value of $1m. An investment allowance of 20% of the equipment cost is available. Revenues are expected to be $13m in year one and rise at 5% pa. Cash variable costs are estimated at 40% of revenue. Cash fixed costs are estimated at $3m pa. Tasks The firm has spent $2m on research and development for the project. Managerial salaries of $900,000 will be allocated to the project, but these managerial positions will be unaffected by the acceptance of the project. An amount of $200,000 has been spent on a feasibility study for the new project. The project is to be partially financed with a loan of $14m to be repaid annually with equal instalments at a rate of 3% pa over 8 years. Except for initial outlays, assume cash flows occur at the end of each year. The tax rate is 30% and is payable in the year in which profit is earned. The after-tax required return for the project is 12% pa. (a) Calculate the NPV. Is the project acceptable? Why or why not? Explain and defend your processes, answer, and calculations clearly. (b) Conduct a sensitivity analysis showing how sensitive the project is to revenues, fixed costs and to the required rate of return. Explain and defend your processes, answer, and calculations clearly. Project 2 Calculations must be done in Excel - You must create your own spreadsheet (do not copy and paste someone else's). This question should be done using Method 1 as outlined in lecture 6 (i.e. Tax Effects, then Cash Flows then NPV). As the financial advisor to Have Fun Manufacturing you are evaluating the following new investment in a manufacturing project: - The project has a useful life of 8 years. Land costs $10m and is estimated to have a resale value of $25m at the completion of the project. Buildings cost $12m, with allowable depreciation of 8% pa reducing balance and a salvage value of $10m. Equipment costs $5m, with allowable depreciation of 15% pa reducing balance and a salvage value of $1m. An investment allowance of 20% of the equipment cost is available. Revenues are expected to be $13m in year one and rise at 5% pa. Cash variable costs are estimated at 40% of revenue. Cash fixed costs are estimated at $3m pa. Tasks The firm has spent $2m on research and development for the project. Managerial salaries of $900,000 will be allocated to the project, but these managerial positions will be unaffected by the acceptance of the project. An amount of $200,000 has been spent on a feasibility study for the new project. The project is to be partially financed with a loan of $14m to be repaid annually with equal instalments at a rate of 3% pa over 8 years. Except for initial outlays, assume cash flows occur at the end of each year. The tax rate is 30% and is payable in the year in which profit is earned. The after-tax required return for the project is 12% pa. (a) Calculate the NPV. Is the project acceptable? Why or why not? Explain and defend your processes, answer, and calculations clearly. (b) Conduct a sensitivity analysis showing how sensitive the project is to revenues, fixed costs and to the required rate of return. Explain and defend your processes, answer, and calculations clearly.
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
3) Sauseda Corporation has two operating divisions-an Inland Division and a Coast Division. The company's Customer Service Department provides services to both divisions. The variable costs of the...
-
Let |a> and |a> be eigenstates of a Hermitian operator A with eigenvalues and , respectively ( ). The Hamiltonian operator is given by H = | > < | + | > < |, where is just a real number. a....
-
My grandmother just purchased a new house for \(\$ 500,000\). She made a down payment of \(50 \%\) of the negotiated price and then makes a payment of \(\$ 2,000.00\) per month for 36 months....
-
Indicate whether each of the following actions is primarily related to (a) acquisition of long-term assets, (b) evaluating the adequacy of financing of long-term assets, or (c) applying the matching...
-
Data for Virtual Gaming Systems are provided in P124A. Earnings per share for the year ended December 31, 2015, are $1.40. The closing stock price on December 31, 2015, is $28.30. In P124A, The...
-
Required information [ The following information applies to the questions displayed below. ] Cool Sky reports the following for its first year of operations. The company produced 4 2 , 0 0 0 ?units...
-
The Payroll Liabilities Balance Report identitifies (Choose all that apply): c Liabilities for employer taxes Liability amounts you owe by Payroll Item Liability amounts for employee deductions...
-
Identify a company that integrates goods and services similar to the LensCrafters example. Use the framework in Exhibit 5.1 to write a short case study about the company in a similar fashion as the...
-
Refer to the annual report of General Mills, Inc, for the year ending May 28, 2017 (fiscal year 2017), available on this book's Website. Review the consolidated balance sheets. Required a. Identify...
-
Problem Purpose: To learn more about the Financial Accounting Standards Board (FASB) Address: http://www.fasb.org Required Use the information on the FASB site to answer the following questions: a....
-
On January 1, 2011, Grayson Construction Company overhauled four cranes resulting in a slight increase in the life of the cranes. Such overhauls occur regularly at two-year intervals and have been...
-
During 1984-85, the credit union industry in Australia considered various ways of improving the electronic funds transfer services that it offered to its members. Most credit unions already provided...
-
make this paragraph flow: This reflection examines the variance in 2023 MAAP ELA Test Scores among students in grades third through sixth. The MAAP tool assesses student progress in English Language...
-
Review Exhibit 11.4. Analyze each product on the graph according to the characteristics that influence the rate of adoption. For example, what can you conclude from the data about the relative...
-
Effects of FIFO and Weighted Average} Sheepskin Company sells to colleges and universities a special paper that is used for diplomas. Sheepskin typically makes one purchase of the special paper each...
-
Examine the cash flow measures in requirement 2 of the review problem in this chapter. Discuss the meaning of these ratios. Computing Cash Flows from Operating Activities: Indirect Method
-
During 20x7, Arizona Company issued $500,000 in long-term bonds at 96, repaid $75,000 of bonds at face value, paid interest of $40,000, and paid dividends of $25,000. Prepare the cash flows from the...
Study smarter with the SolutionInn App