Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

please answer the Balance sheet from cash all the way down for year 2021,2022,2023,2024, and 2025 i have the income statemnt in here if you

please answer the Balance sheet from cash all the way down for year 2021,2022,2023,2024, and 2025
i have the income statemnt in here if you need it
thank you
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Actual Actual Actual Actual Actual Forecast Forecast Forecast Forecast 2016 2017 2018 2019 2020 2021 2022 2023 2024 Revenue 245000 263000 280000 295000 308000 318554 326348 331135 332746 Cost of service 155500 166000 177835 188900 197250 204009 209001 212066 213098 Gross profit 89500 97000 102165 106100 110750 114545 117348 119069 119648 Depreciation expense 20325 22415 21900 22550 24195 25024 25636 26012 26139 SG&A expenses 25500 26700 28700 29600 30760 31814 32592 33070 33231 Total 45825 49115 50600 52150 54955 56838 58229 59083 59370 EBIT 43675 47885 51565 53950 55795 57707 59119 59986 60278 Interest Expenses 4875 4687.5 4312.5 3937.5 3562.5 3685 3775 3830 3849 Pretax Profit 38800 43197.5 47252.5 50012.5 52232.5 54022 55344 56156 56429 Tax 9700 10799.4 11813.1 12503.1 13058.1 13506 13836 14039 14107 Net Income 29100 32398.1 35439.4 37509.4 39174.4 40517 41508 42117 42322 Forecast 2021 Forecast 2022 Forecast 2023 Forecast 2024 Forecast 2025 $ Income Statement Revenue Cost of services Gross pro Depreciation expense SOLA expense Total expenses TT interest Expense Pretak Profit Tax Net income Balance Sheet Actual Actual Actual Actual Actual 2016 2017 2015 2020 245,000.0 263.0000 $200,0000 5 295.0000 $30,000.0 155.5000 1660000 177.8350 188.909.0 197,250.0 19,500.0 97,000 102,155.0 106 1000 110.750 0 20.325.0 22.415.0 21.5000 22.5500 24.1950 25.5000 26,700.0 28.700.0 29.5000 20.7600 45.825.0 49.1150 SO6000 52, 1500 5950 41,675.0 47.50 51.5650 539500 357930 4.875.0 4.62 4.3125 1975 25625 1000 41.1975 47.2525 30.012 2.2325 97000 1024 11.8131 12 5011 11.0581 20 1000 AWAWA 370143 12.17 5 C Accounts receivable Inventory Total current aus Property Mant, and mente Other long-term Total Assets Accounts Payable Accred Expenses Total Current Liabilities Debe long-term Other long-term bites Total Liabetes Common stock Retained ning Total Liabilities and Equity ta 5 5.00005 8.74445 24.100.0 24.000 52000 5000 34,5000 1.0414 205.000.0 207,100.0 2.0000 2.500 241.500 243444 19,7500 21:5000 ISO 3.5250 22.000 25.0250 65.0000 60,0000 3.5000 40000 91.400.0 89.025.0 30.0000 30,0000 120, 100.0 129.8194 $ 241.500.05 248.8644 nya 7.3 12.735 15 26.450 26.000 000 64600 45.016 0241 209,000 21.000 2.5000 10000 2016 240 23,5000 24.500 3.2050 4.000 27,2650 285200 55.0000 50.0000 4.3000 4,7000 86.5650 53.2200 30.000 10,000 140.4513 151,704 2570163 S 26492415 6.5 SAN 12.2014 29.2000 600 STALA 2161150 3.2500 >10064 25.1000 4,900 29.4000 45.0000 5.1500 79,500 0.0000 1684564 273.0064 LAN Balance Sheet Cash Accounts receivable Inventory Total current assets Property, plant, and Equipment - net Other long-term assets Total Assets Accounts Payable Accrued Expenses Total Current Liabilities Debt - long-term Other long-term liabilities Total Liabilities Common stock Retained earnings Total Liabilities and Equity Revenue growth rate $ 5,000.0 $ 24,300.0 5,200.0 34,500.0 205,000.0 2,000.0 241,500.0 19,750.0 3,150.0 22,900.0 65,000.0 3,500.0 91,400.0 30,000.0 120,100.0 241,500.0 $ la 8,744.4 $ 24,800.0 5,500.0 39,044.4 207,300.0 2,500.0 248,844.4 21,500.0 3,525.0 25,025.0 60,000.0 4,000.0 89,025.0 30,000.0 129,819.4 248,844.4 $ 17.3% 12,871.3 $ 26,245.0 5,900.0 45,016.3 209,500.0 2,500.0 257,016.3 23,500.0 3,765.0 27,265.0 55,000.0 4,300.0 86,565.0 30,000.0 140,451.3 257,016.3 $ 6.5% 14,664.1 $ 26,900.0 6,460.0 48,024.1 213,900.0 3,000.0 264,924.1 24,5G3.0 4,025.0 28,520.0 50,000.0 4,700.0 83,220.0 30,000.0 151,704.1 264,924.1 $ 5.4% 17,801.4 29,200.0 6,640.0 53,641.4 216,115.0 3,250.0 273,006.4 25,100.0 4,300.0 29,400.0 45,000.0 5,150.0 79,550.0 30,000.0 163,456.4 273,006.4 4.4% $ $ Balance Sheet Cash Accounts receivable Inventory Total current assets Property, Plant, and Equipment - net Other long-term assets Total Assets Accounts Payable Accrued Expenses Total Current Liabilities Debt - long-term Other long-term liabilities Total Liabilities Common stock Retained earnings Total Liabilities and Equity Revenue growth rate 5,000,0 $ 24,300.0 5,200.0 34,500.0 205,000.0 2,000.0 241,500.0 19,750.0 3,150.0 22,900.0 65,000.0 3,500.0 91,400.0 30,000.0 120,100.0 $ 241,500.0 $ n/a 8,744.4 $ 12,871.3 $ 14,664.1 $ 17,801.4 24,800.0 26,245.0 26,900.0 29,200.0 5,500.0 5,900.0 6,460.0 6,640.0 39,044.4 45,016.3 48,024.1 53,641.4 207,300.0 209,500.0 213,900.0 216,115.0 2,500.0 2,500.0 3,000.0 3,250.0 248,844.4 257,016.3 264,924.1 273,006.4 21,500.0 23,500.0 24,599.0 25,100.0 3,525.0 3,765.0 4,020.0 4,300.0 25,025.0 27,265.0 28,520.0 29,400.0 60,000.0 55,000.0 50,000.0 45,000.0 4,000.0 4,300.0 4,700.0 5,150.0 89,025.0 86,565.0 83,220.0 79,550.0 30,000.0 30,000.0 30,000.0 30,000.0 129,819.4 140,451.3 151,704.1 163,456.4 248,844.4 $ 257,016.3 $ 264,924.1 $ 273,006.4 7.3% 6.5% 5.4% 4.4%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Managerial Accounting

Authors: Ray Garrison, Eric Noreen, Peter Brewer

16th edition

978-1259307416

Students also viewed these Accounting questions