Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer the balance sheet from Cash all the way down to Revenue growth rate thank you here is the numbers for them thank you

please answer the balance sheet from Cash all the way down to Revenue growth rate
thank you
image text in transcribed
image text in transcribed
here is the numbers for them
thank you
image text in transcribed
image text in transcribed
Actual 2017 Actual 2015 Actual 2018 Actual 2019 Actual 2020 Forecast 2021 Forecast 2022 Forecast 2025 Forecast 2014 Forecast 2025 $ 245.0000 $ 261,000,0 $280,000.0 % 155,500.0 166,000.0 177.8350 89.000 97,000.0 102,165.0 20.325.0 22,415.0 21,900.0 25,500.0 26.7000 28.700.0 45,225.0 49.1150 SOOD 41,675.0 473850 51,565 4,875.0 4.6875 4,3125 38.000 43,1975 47,2525 9.2000 10,799.4 11,8181 $ 29.10005 32.398 15 35.419.45 295.000.000.000.0 1,000 197,200 106,100.0 110,750,0 22.550 24.195.0 29,600.0 30,00 52.150.0 54,955 $1WOD 55.7950 3,9325 3,562,5 50,0125 52.232.5 12.503.1 13,058.1 37 5094 39,1144 Income Statement Revenge Cost of services Grass profit Depreciation expense SOLAR Total expenses ERIT interest Expense Pretax Pro Tax Net Income Balance Sheet Cash Accounts receivable Inventory Total current assets Property. Plant, and quipment.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 earning Total Liabilities and Equity Revenue growth rate 5 5.0000 $ 8,7444 $ 12.8713 5 14.66415 24.100.0 24,000 26.245.0 26,900.0 5.2000 S 5000 5,900.0 6,460.0 34.500.0 39 0444 45 0163 41,0241 205,000.0 207,300.0 209, 5000 213.00.0 2.000.0 2.500.0 2,500.0 3,000 0 241,500.0 248,8444 292016 264,921 19,750.0 21.500.0 23,500.0 24,000 3,150,0 1.525.0 3.765.0 4,090.0 22,900.0 25,0250 27,265.0 28,520,0 65,000.0 60,000.0 55,000.0 50,000.0 3.5000 4.000.0 4,3000 4,700D 91.400.0 89,0250 86,565.0 83,220.0 30,0000 30,000.0 30,0000 30,000.0 120,100.0 129,819.4 140,4513 151,7041 $ 241.500,0 $24.8644 $257,016 3 5 264,9241 $ na 7.3 6.5% 5.4% 178014 29.200.0 6,640.0 53,6414 216, 115.0 3,250.0 273,0064 25,100.0 4,300.0 29.4000 45,000.0 5.150.0 79,550.0 30,0000 163,456.4 273,0064 4.4% 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 375094 39174.4 40517 41508 42117 42322 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,0255.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% $ Actual 2017 Actual 2015 Actual 2018 Actual 2019 Actual 2020 Forecast 2021 Forecast 2022 Forecast 2025 Forecast 2014 Forecast 2025 $ 245.0000 $ 261,000,0 $280,000.0 % 155,500.0 166,000.0 177.8350 89.000 97,000.0 102,165.0 20.325.0 22,415.0 21,900.0 25,500.0 26.7000 28.700.0 45,225.0 49.1150 SOOD 41,675.0 473850 51,565 4,875.0 4.6875 4,3125 38.000 43,1975 47,2525 9.2000 10,799.4 11,8181 $ 29.10005 32.398 15 35.419.45 295.000.000.000.0 1,000 197,200 106,100.0 110,750,0 22.550 24.195.0 29,600.0 30,00 52.150.0 54,955 $1WOD 55.7950 3,9325 3,562,5 50,0125 52.232.5 12.503.1 13,058.1 37 5094 39,1144 Income Statement Revenge Cost of services Grass profit Depreciation expense SOLAR Total expenses ERIT interest Expense Pretax Pro Tax Net Income Balance Sheet Cash Accounts receivable Inventory Total current assets Property. Plant, and quipment.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 earning Total Liabilities and Equity Revenue growth rate 5 5.0000 $ 8,7444 $ 12.8713 5 14.66415 24.100.0 24,000 26.245.0 26,900.0 5.2000 S 5000 5,900.0 6,460.0 34.500.0 39 0444 45 0163 41,0241 205,000.0 207,300.0 209, 5000 213.00.0 2.000.0 2.500.0 2,500.0 3,000 0 241,500.0 248,8444 292016 264,921 19,750.0 21.500.0 23,500.0 24,000 3,150,0 1.525.0 3.765.0 4,090.0 22,900.0 25,0250 27,265.0 28,520,0 65,000.0 60,000.0 55,000.0 50,000.0 3.5000 4.000.0 4,3000 4,700D 91.400.0 89,0250 86,565.0 83,220.0 30,0000 30,000.0 30,0000 30,000.0 120,100.0 129,819.4 140,4513 151,7041 $ 241.500,0 $24.8644 $257,016 3 5 264,9241 $ na 7.3 6.5% 5.4% 178014 29.200.0 6,640.0 53,6414 216, 115.0 3,250.0 273,0064 25,100.0 4,300.0 29.4000 45,000.0 5.150.0 79,550.0 30,0000 163,456.4 273,0064 4.4% 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 375094 39174.4 40517 41508 42117 42322 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,0255.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% $

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

Return Jahrgang 2018 Magazin Fur Transformation Und Turnaround

Authors: Stefanie Burgmaier, Hans Haarmeyer, Thorsten Garber

3rd Edition

365825601X, 9783658256012

More Books

Students also viewed these Accounting questions

Question

47. If E[Y |X] = 1, show that Var(X Y ) Var(X)

Answered: 1 week ago