Question: Solve the payback and provide the excel formula All 000's Investment: Capital Outlay Net Working Capital (10% Sales) Total Investment Investment Recovery: Equipment Salvage Net

Solve the payback and provide the excel formula

All 000's Investment: Capital Outlay Net Working Capital (10% Sales) Total Investment

All 000's Investment: Capital Outlay Net Working Capital (10% Sales) Total Investment Investment Recovery: Equipment Salvage Net Working Capital (full recovery) Sales Revenue Cost of Goods Sold (75% Sales) SG&A (5% Sales) Operating Savings Depreciation ($18,000/6) Total Costs & Expenses EBIT - Taxes (40%) NOPAT + Depreciation - Investment = Free Cash Flow Year 0 $ $ S S $ inlin $ $ 2016 16,000 $ $ 16,000 $ 1,800 $ 75% $ 5% $ $ $ $ $ LA SALA SA $ $ $ 16,000 $ (16,000) $ 2017 2018 2,000 $ $ 400 $ 600 $ 2,400 $ 1,000 $ 2019 $ $ 2020 555 2021 $ SASA SA $ $ 4,500 $ 4,500 $ 2022 $ 1,800 $ 1,000 $10,000 4,000 $10,000 $10,000 $10,000 $10,000 3,000 $7,500 $ 7,500 $ 7,500 $ 7,500 $ 7,500 200 $ 500 $ 500 $ 500 $ 500 $ 500 2,000 $3,500 $3,500 $3,500 $3,500 $ 3,500 (3,000) $ (3,000) $ (3,000) $ (3,000) $ (3,000) $ (3,000) 4,200 $7,500 $7,500 $7,500 $ 7,500 $ 7,500 (200) $2,500 $ 2,500 $ 2,500 $ 2,500 $ 2,500 (80) $1,000 $1,000 $1,000 $1,000 $1,000 (120) $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 1,500 3,000 $3,000 $3,000 $3,000 $3,000 $3,000 2,400 $1,000 $ $2,800 480 $ 3,500 $ 4,500 $ 7,300

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To calculate the payback period we need to determine the number of years it takes for the cumulative ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!