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...
-
Consider a free-particle wave packet in one dimension. At 1= 0 it satisfies the minimum uncertainty relation in addition, we know Using the Heisenberg picture, obtain , as a function of t(t ? 0) when...
-
Lucas Mitchell, financial manager of Inland Industrial, has been asked by the firm's CEO to evaluate the company's inventory control techniques and to lead a discussion of the subject with the senior...
-
Three years ago, Girston Gravel Pit purchased a material conveyor system. The company has decided to sell the system and acquire more advanced technology. Data relating to the existing system follow....
-
Feeder Computer Systems Design Ltd. (Feeder) designs and installs com puter networks for commercial customers. In December 2016, Feeder signed a contract with Magyar Telecommunications Ltd. (Magyar)...
-
case study answer on "Serum institute of India: delivering Covid-19 vaccines"
-
Read the business case study SPACELIX and write a detailed paper on it
-
determine the order of the differential equation. 1. x - 3y +4(y") = 0 2. y" - 4y' + 5xy"" = 2 3. xyy" - 2x + xy' = 4y 4. y' = 2y' sin x - 3xy = 5 determine whether the given function is a solution...
-
Which country in the World has the strongest Economy? Please substantiate referring to their: - GDP - Economic System - Global growth - Top products or economic drivers - Resources - People and their...
-
PubCo, a semiweekly depositor, pays wages on Wednesday, June 3 0 , resulting in a deposit obligation of $ 2 3 , 0 0 0 . Assuming that Monday, July 5 is a federal holiday, when is they deposit due?
-
Write the definition of the of the function is Full() as a member function of the DArray class. The function returns true if the array is full, or false otherwise. Functions.cpp 1 #include "DArray.h"...
-
8 One of the fundamental assumptions of the mainstream model can be summarised by the equation below. max xtXi (1) t=0 (2) St p(St) U (x|St) StSt (3) (4) Which part or parts of the equation best...
-
asap pls help 30 min left Pinel the arca or volume. Tind the arraundery in the trt quadrant. O te
-
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...
-
The comparative financial statements for CompuCircuit Corporation are in the Working Papers. The financial statements have been completed up to the financial analysis section. The following...
-
The comparative financial statements for Advanced Auto Technology, Inc., are in the Working Papers. The financial statements have been completed up to the financial analysis section. The following...
-
Corporate annual reports include a letter from the chief executive officer (CEO). The letter highlights achievements and positive results from the past year. If necessary, it delivers news of...
Study smarter with the SolutionInn App