More Capital Project

.xlsx

School

Temple University *

*We aren’t endorsed by this school

Course

3512

Subject

Finance

Date

Apr 3, 2024

Type

xlsx

Pages

1

Uploaded by ColonelPuppy4204

Report
SAG Corp. - CAPITAL PROJECT ANALYSIS - COST SAVINGS $ in millions Cost of machine $ 7,500,000.00 Initial Working Capital Investment $ 45,000.00 Sale/Residual value end of year 10 10% Expected COGS Savings 20% Annual incremental working capital $45,000 Tax Rate 26% Required Rate of Return 11% Tax depreciation 5 year MACRS based on cost of the machine Year 1 20% Year 2 32% Year 3 19% Year 4 12% Year 5 12% Year 6 5% PERIOD 0 1 2 3 4 5 6 7 8 9 10 Production costs $ 7,000,000 $ 7,140,000 $ 7,282,800 $ 7,428,456 $ 7,577,025 $ 7,728,566 $ 7,883,137 $ 8,040,800 $ 8,201,616 $ 8,365,648 Cost savings $ 1,400,000 $ 1,428,000 $ 1,456,560 $ 1,485,691 $ 1,515,405 $ 1,545,713 $ 1,576,627 $ 1,608,160 $ 1,640,323 $ 1,673,130 Less Depreciation 1,500,000 2,400,000 1,425,000 900,000 900,000 375,000 Add Residual Value 750,000 Taxable Income (100,000) (972,000) 31,560 585,691 615,405 1,170,713 1,576,627 1,608,160 1,640,323 2,423,130 Less Taxes (26,000) (252,720) 8,206 152,280 160,005 304,385 409,923 418,122 426,484 630,014 After Tax Income (74,000) (719,280) 23,354 433,411 455,400 866,328 1,166,704 1,190,038 1,213,839 1,793,116 Add: Depreciation 1,500,000 2,400,000 1,425,000 900,000 900,000 375,000 - - - - Less: Annual Working Capital Investment 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 (45,000) After-Tax Cash Flow $ (7,545,000) $ 1,381,000 $ 1,635,720 $ 1,403,354 $ 1,288,411 $ 1,310,400 $ 1,196,328 $ 1,121,704 $ 1,145,038 $ 1,168,839 $ 1,838,116 Cumulative Cash Flow $ 1,381,000 $ 3,016,720 $ 4,420,074 $ 5,708,486 $ 7,018,886 $ 8,215,213 $ 9,336,918 $ 10,481,956 $ 11,650,795 $ 13,488,911 (7,545,000) Payback-----> OCF in year 6 not needed $ 670,213 NPV $ 460,257 Percentage not needed 56.0% IRR 12.5% Percentage needed 44.0% PAYBACK PERIOD 5.4 plus first 5 years Profitability Index 1.06 SAG Corp. is a manufacturer of cleaning products with locations in the United States. Its manufacturing plant in Greenville, SC is considering the purchase of a new filling machine. The cost of the machine is $7,500,000 and will require an initial working capital investment of $45,000. It is expected to result in cost savings of 20.0% of that location's production costs over the life of the filling machine which is 10 years. Over the 10 years an annual investment in working capital will be required of $45,000 at the start of each year and will be realized as a cash inflow in the final year when the project's life is completed and the accounts receivable and inventory are liquidated. At the end of its life it can be sold as scrap for 10% of the original cost. Five year MACRS depreciation will be used for tax purposes and the company's average tax rate is 24% and the marginal rate is 26%. Given the risk level of this project, SAG Corp. requires a rate of return 1% below its weight cost of capital. The weighted cost of capital is 12%. Prepare an analysis to determine if this project will generate an attractive level of economic benefits. Specifically determine the net present value, internal rate of return, payback period and profitability index of the project.
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help