Answered step by step
Verified Expert Solution
Link Copied!

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Financial Management

Authors: Eugene F. Brigham, Joel F. Houston

12th edition

978-0324597714, 324597711, 324597703, 978-8131518571, 8131518574, 978-0324597707

More Books

Students also viewed these Accounting questions