Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Complete the spread sheet L Projections 2023 2022 2024 E H 1 HOSH Historical Income Statement 2 2017 2018 2019 2020 2021 3 Unit Sales

Complete the spread sheet
image text in transcribed
L Projections 2023 2022 2024 E H 1 HOSH Historical Income Statement 2 2017 2018 2019 2020 2021 3 Unit Sales 10,000 11,000 12,500 13,850 15,235.00 4 Sales Price $ 300.00 $ 320.00 $ 330.00 S 350.00 380.00 5 Revenue # $ 4,847,500.00 ### 6. Operating Expenses 7. Variable cost per unit s 50.00 S 55.00 $ 60.00 S 65.00 $ 35.00 8 Cost of good sold $ 500,000.00 $ 605,000.00 $ 750,000.00 S 900,250.00 $ 533,225.00 9 Admin, selling & operating Expense IN 10 Depreciation # 11 12 Operating Margin (EBIT) $ 159,645.00) 13 Tax (30%) S (17,893.50) 14 EBIT (1-1) S (41,751.50) 15 Depreciation 16 [EBIT(1 - T) - Depreciation] 17 18 CAPEX $ 150,000.00 19 NOWC $ 2,500,000.00 20 ANOWC $ 125,000.00 21 Capital expenditures + ANOWC $ 275.000.00 22 FCF 23 24 25 2. TERITI-Terroristinal.Canislawnanie AND L Projections 2023 2022 2024 E H 1 HOSH Historical Income Statement 2 2017 2018 2019 2020 2021 3 Unit Sales 10,000 11,000 12,500 13,850 15,235.00 4 Sales Price $ 300.00 $ 320.00 $ 330.00 S 350.00 380.00 5 Revenue # $ 4,847,500.00 ### 6. Operating Expenses 7. Variable cost per unit s 50.00 S 55.00 $ 60.00 S 65.00 $ 35.00 8 Cost of good sold $ 500,000.00 $ 605,000.00 $ 750,000.00 S 900,250.00 $ 533,225.00 9 Admin, selling & operating Expense IN 10 Depreciation # 11 12 Operating Margin (EBIT) $ 159,645.00) 13 Tax (30%) S (17,893.50) 14 EBIT (1-1) S (41,751.50) 15 Depreciation 16 [EBIT(1 - T) - Depreciation] 17 18 CAPEX $ 150,000.00 19 NOWC $ 2,500,000.00 20 ANOWC $ 125,000.00 21 Capital expenditures + ANOWC $ 275.000.00 22 FCF 23 24 25 2. TERITI-Terroristinal.Canislawnanie AND

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Contemporary Issues In Behavioral Finance

Authors: Simon Grima

1st Edition

1787698823, 978-1787698826

More Books

Students also viewed these Finance questions

Question

What are the classifications of Bank?

Answered: 1 week ago