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

Report
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
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.
Student Name Joseph Marasco 2024 Spring MACRS 7 Year Year 1 14.29% Year 2 24.49% Year 3 17.49% Year 4 12.49% Year 5 8.93% Year 6 8.92% Year 7 8.93% Year 8 4.46% Total 100.00% Project Original Equipment Cost 1,425,000 Salvage Value 150,000 Annual revenue 525,000 Annual expense 180,000 Net Working Capital Requirements 175,000 Required Return 13.0% Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Revenue 525,000 525,000 525,000 525,000 525,000 525,000 525,000 525,000 Expense 180,000 180,000 180,000 180,000 180,000 180,000 180,000 180,000 Depreciation 203,633 348,983 249,233 177,983 127,253 127,110 127,253 63,555 EBIT 141,368 (3,983) 95,768 167,018 217,748 217,890 217,748 281,445 Taxes 21% 29,687 (836) 20,111 35,074 45,727 45,757 45,727 59,103 Net Profit 111,680 (3,146) 75,656 131,944 172,021 172,133 172,021 222,342 OCF 315,313 345,836 324,889 309,926 299,273 299,243 299,273 285,897 New Equipment (1,425,000) After-tax Salvage Value 118,500 Impact of NWC (175,000) 175,000 Results Decision NPV $16,447 Accept Total Cash Flow (1,600,000) 315,313 345,836 324,889 309,926 299,273 299,243 299,273 579,397 IRR 13.29% Accept (1,284,687) (938,851) (613,962) (304,036) (4,762.68) 0.015916 PayBack 5.02 Reject A $1,425,000 8 year investment is depreciated using a seven-year MACRS class life. There will be a $150,000 salvage value for the investment at the end of the project. It requires $175,000 investment in NWC (driven by a $275,000 increase in inventory and a $100,000 increase in accounts payable). It will generate $525,000 in revenue and $180,000 in cash expenses annually, and the tax rate is 21%. What is the incremental cash flow in years 0 through 8? The required return is 13.0%. What is the NPV, IRR and Payback Perod? The company targets a 4 year payback on investments.
MACRS 7 Year Year 1 14.29% Year 2 24.49% Year 3 17.49% Year 4 12.49% Year 5 8.93% Year 6 8.92% Year 7 8.93% Year 8 4.46% Total 100.00% Project Original Equipment Cost 1,425,000 Salvage Value 150,000 Annual revenue 525,000 Annual expense 180,000 Net Working Capital Requirements 175,000 Required Return 13.0% Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Revenue 525,000 525,000 525,000 525,000 525,000 525,000 525,000 525,000 Expense 180,000 180,000 180,000 180,000 180,000 180,000 180,000 180,000 Depreciation 203,633 348,983 249,233 177,983 127,253 127,110 127,253 63,555 EBIT 141,368 (3,983) 95,768 167,018 217,748 217,890 217,748 281,445 Taxes 21% 29,687 (836) 20,111 35,074 45,727 45,757 45,727 59,103 Net Profit 111,680 (3,146) 75,656 131,944 172,021 172,133 172,021 222,342 OCF 315,313 345,836 324,889 309,926 299,273 299,243 299,273 285,897 New Equipment (1,425,000) After-tax Salvage Value 118,500 Impact of NWC (175,000) 175,000 Results Decision NPV $16,447 Accept Total Cash Flow (1,600,000) 315,313 345,836 324,889 309,926 299,273 299,243 299,273 579,397 IRR 13.29% Accept (1,284,687) (938,851) (613,962) (304,036) (4,763) 0.016 PayBack 5.16 Reject A $1,425,000 8 year investment is depreciated using a seven-year MACRS class life. There will be a $150,000 salvage value for th investment at the end of the project. It requires $175,000 investment in NWC (driven by a $275,000 increase in inventory and a $100,000 increase in accounts payable It will generate $525,000 in revenue and $180,000 in cash expenses annually, and the tax rate is 21%. What is the incremental cash flow in years 0 through 8? The required return is 13.0%. What is the NPV, IRR and Payback Perod? The company targets a 4 year payback on investments.
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