Initial Investment = 20 + 2.2 = 22.2million
Pre tax profit = 19 - 6.2 - 5(depreciation) = 7.8 million
Tax Expense = 7.8*35% = 2.73 million
Therefore, Net cash flows per year = 19 - 6.2 - 2.73 = 10.07
million.
a) If co. operates for 4 years
Present value of cash inflows = 10.07*PVAF(4years,15%) + Terminal
value * PVIF of 4th year
= (10.07 * 2.855) + 0 = 28.75 million
Initial Outlay = 22.2 million
Therefore, NPV = 28.75 - 22.2 = 6.55 million
b) a. If co. operates for 1year
Present value of cash inflows = 10.07*PVAF(1years,15%)
+ Terminal value * PVIF of 1st year
= (10.07*0.8696) + 13.5*0.8696 = 20.4957
Therefore, NPV = 20.4957 - 22.2 = -1.7043 million
b. If co. operates for 2years
Present value of cash inflows = 10.07*PVAF(2years,15%)
+ Terminal value * PVIF of 2nd year
= (10.07*1.6257) + 11.7*0.7561 = 25.2173
Therefore, NPV = 25.2173 - 22.2 = 3.0173 million
c. If co. operates for 3years
Present value of cash inflows = 10.07*PVAF(3years,15%)
+ Terminal value * PVIF of 3rd year
= (10.07*2.2832) + 10.5*0.6575 = 29.8958
Therefore, NPV = 29.8958 - 22.2 = 7.6598 million
c) If the company operates the project for 3years, it maximises its value as the NPV is highest if it operates for 3 years. The value of the option is = 29.8958 million.
(Consider using an Excel Spreadsheet to solve this problem.) Blueberry Farms Inc. is considering a four-year...
1. (25 points) Calder Inc. is considering a four-year project to manufacture military drones. This project requires an initial investment of $10 million that will be depreciated straight-line to zero over the project's life. An initial investment in the Net Working Capital of $1.3 million is required to support spare parts inventory; this cost is fully recoverable whenever the project ends. The company believes it can generate $7.35 million in pretax revenues with $2.4 million in total pre-tax operating costs....
Consider the following project of Hand Clapper, Inc. The company is considering a four-year project to manufacture clap-command garage door openers. This project requires an initial investment of $16.3 million that will be depreciated straight-line to zero over the project’s life. An initial investment in net working capital of $1,030,000 is required to support spare parts inventory; this cost is fully recoverable whenever the project ends. The company believes it can generate $13.5 million in pretax revenues with $5.4 million...
Consider the following project for Clapper, Inc. The company is considering a 4-year project to manufacture clap-command garage door openers. This project requires an initial investment of $15.5 million that will be depreciated straight-line to zero over the project’s life. An initial investment in net working capital of $950,000 is required to support spare parts inventory; this cost is fully recoverable whenever the project ends. The company believes it can generate $11.9 million in revenues with $4.6 million in operating...
Halloween, Inc., is considering a new product launch. The firm expects to have an annual operating cash flow of $9 million for the next 8 years. The discount rate for this project is 14 percent for new product launches. The initial investment is $39 million. Assume that the project has no salvage value at the end of its economic life. a. What is the NPV of the new product? (Do not round intermediate calculations and enter your answer in...
Hit or Miss Sports is introducing a new product this year. If its see-at-night soccer balls are a hit, the firm expects to be able to sell 51,000 units a year at a price of $69 each. If the new product is a bust, only 26,500 units can be sold at a price of $41. The variable cost of each ball is $25 and fixed costs are zero. The cost of the manufacturing equipment is $5.9 million, and the project...
9. value: 1.00 points Allied Products, Inc., is considering flow of $9.1 million for the next 9 years. Allied Products uses a discount rate of 14 percent for new product launches. The initial investment is $39.1 million. Assume that the project has no salvage value at the end of its economic life. product launch. The firm expects to have annual operating cash a new a. What is the NPV of the new product? (Do not round intermediate calculations. Enter your...
Halloween, Inc., is considering a new product launch. The firm expects to have an annual operating cash flow of $8.4 million for the next 8 years. The discount rate for this project is 12 percent for new product launches. The initial investment is $38.4 million. Assume that the project has no salvage value at the end of its economic life. a. What is the NPV of the new product? (Do not round intermediate calculations and enter your answer in dollars,...
Solve not in Excel and provide all the formulas. The company is evaluating if the replacement of an old machine is economically feasible. You have the following information: New machine: purchase price is $8 million, economic life 10 years, annual EBITDA is $4.4 million, book value in 5 years is 0, while market value is 0.8 million. Old machine: book value today is $4 million while market value $2.8 million, remaining economic life is 10 years, annual EBITDA is $2.5...
Excel sheet, please. Calculating NPV Thurston Petroleum is considering a new project that complements its existing business. The machine required for the project costs $4.1 million. The mar- keting department predicts that sales related to the project will be $2.35 million per year for the next four years, after which the market will cease to exist. The machine will be depreciated to zero over its 4-year economic life using the straight-line method. Cost of goods sold and operating expenses related...
1. undersatnd how to use EXCEL Spreadsheet (a) Develop proforma Income Statement Using Excel Spreadsheet (b) Compute Net Project Cashflows, NPV, and IRR (c) Develop problem-solving and critical thinking skills and make long-term investment decisions 1) Life Period of the Equipment = 4 years 2) New equipment cost $(200,000) 3) Equipment ship & install cost $(35,000) 4) Related start up cost $(5,000) 5) Inventory increase $25,000 6) Accounts Payable increase $5,000 7) Equip. salvage value before tax $15,000 8) Sales...