Chapter 10 Capital Investment & Cash Flow Analysis

.xlsx

School

Iowa State University *

*We aren’t endorsed by this school

Course

301

Subject

Finance

Date

Apr 3, 2024

Type

xlsx

Pages

6

Uploaded by AdmiralBisonMaster164

Student Name Joseph Marasco 2024 Spring Assumptions: Project Investment 1,345,000 Depreciation in Years 3 Annual Depreciation 448,333 Annual Revenue 955,000 Annual Expense 375,000 Required Return 12.0% Year 0 Year 1 Year 2 Year 3 Revenue 955,000 955,000 955,000 Expense 375,000 375,000 375,000 Depreciation 448,333 448,333 448,333 EBIT 131,667 131,667 131,667 Taxes 21% 27,650 27,650 27,650 Net Profit 104,017 104,017 104,017 OCF 552,350 552,350 552,350 New Equipment (1,345,000) Results Decision NPV ($18,348) Reject Total Cash Flow (1,345,000) 552,350 552,350 552,350 IRR 11.20% Reject (792,650) (240,300) -0.44 Payback 2.44 Accept A company is considering the introduction of a new product. The company will utilize existing equipment with a book value of $1,100,000 and a market value of $1,195,000 to produce the product. Upgrades to this equipment valued at $150,000 will be made to enable production of the product. The new product is expected to generate annual sales of 10,000 units priced at $95.50 per unit with a cost of $37.50 per unit. The new product has a estimated life of 3 years and the investment will be depreciated using the straight-line depreciation method. At the end of 3 years the investment will have no value. The marginal tax rate is 21%. The required return is 12.0% and the business targets a 3 year payback period. Perform an investment analysis of the new product and calculate its NPV, IRR and Payback Period.
Assumptions: Project Investment 1,345,000 Depreciation in Years 3 Annual Depreciation 448,333 Annual Revenue 955,000 Annual Expense 375,000 Required Return 12.0% Year 0 Year 1 Year 2 Year 3 Revenue 955,000 955,000 955,000 Expense 375,000 375,000 375,000 Depreciation 448,333 448,333 448,333 EBIT 131,667 131,667 131,667 Taxes 21% 27,650 27,650 27,650 Net Profit 104,017 104,017 104,017 OCF 552,350 552,350 552,350 New Equipment (1,345,000) Results Decision NPV ($18,348) Reject Total Cash Flow (1,345,000) 552,350 552,350 552,350 IRR 11.20% Reject (792,650) (240,300) 0.44 Payback 2.44 Accept A company is considering the introduction of a new product. The company will utilize existing equipment with a book value of $1,100,000 and a market value of $1,195,000 to produce the product. Upgrades to this equipment valued at $150,000 will be made to enable production of the product. The new product is expected to generate annual sales of 10,000 units priced at $95.50 per unit with a cost of $37.50 per unit. The new product has a estimated life of 3 years and the investment will be depreciated using the straight-line depreciation method. At the end of 3 years the investment will have no value. The marginal tax rate is 21%. The required return is 12.0% and the business targets a 3 year payback period. Perform an investment analysis of the new product and calculate its NPV, IRR and Payback Period.
Student Name Joseph Marasco 2024 Spring Assumptions: Project Equipment Life in years 5 Original Equipment Cost 2,495,000 Annual Depreciation 499,000 Salvage Value in 5 Years 75,000 Annual cost savings 755,000 Required Return 12.5% Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Cost Savings 755,000 755,000 755,000 755,000 755,000 Depreciation 499,000 499,000 499,000 499,000 499,000 EBIT 256,000 256,000 256,000 256,000 256,000 Taxes 21% 53,760 53,760 53,760 53,760 53,760 Net Profit 202,240 202,240 202,240 202,240 202,240 OCF 701,240 701,240 701,240 701,240 701,240 New Equipment (2,495,000) After Tax Salvage 59,250 Results Decision NPV $34,692 Accept Total Cash Flow (2,495,000) 701,240 701,240 701,240 701,240 760,490 IRR 13.06% Accept (1,793,760) (1,092,520) (391,280) (0.56) Payback 3.56 Accept A company is considering a new computer system that will initially cost $2,495,000. It will save $755,000 per year in inventory and receivables management costs. The system is expected to last for five years and will be depreciated using the straight-line method for 5 years. The system is expected to have a salvage value of $75,000 at the end of year 5. There is no impact on net working capital. The marginal tax rate is 21%. The required return is 12.5% and the company targets a project payback period of 4 years. Perform an investment analysis of the project and calculate its NPV, IRR and Payback Period.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help