Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
To calculate the payback period we need to determine the number of years it takes for the cumulative ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started