Answered step by step
Verified Expert Solution
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
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
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