Answered step by step
Verified Expert Solution
Question
1 Approved Answer
construct pro forma balance sheet and statements of cash flow for the next 5 years. Please show all steps 52 53 USD in million 54
construct pro forma balance sheet and statements of cash flow for the next 5 years. Please show all steps
52 53 USD in million 54 Revenue 55 Cost of revenue 56 Gross profit 57 R&D 58 Sales, G & Adm 59 Restructuring, M&A 60 Operating income 61 interest expense 62 income before tax 63 provision for income taxes 64 Net income 65 add: depreciation 66 Cash from operations 67 Less:CAPEX 68 FCF 69 DCf 70 71 72 1 2020 $51,829.85 $20,371.81 $31,458.04 $6,335.98 $12,584.52 $111.96 $12,425.57 10,223.07 $2,202.50 $1,739.98 $462.53 $2,591.49 $3,054.02 $2,073.19 $980.82 $883.63 2 3 4 5 5 2021 2022 2023 2024 $59,750.54 $62,279.07 $65,261.55 $68,513.30 $23,400.29 $24,380.86 $25,537.94 $26,798.33 $36,350.25 $37,898.22 $39,723.61 . $41,714.97 $7,304.25 $7,613.35 $7,977.95 $8,375.46 $14,507.70 $15,121.64 $15,845.80 $16,635.34 $129.07 $134.53 $140.98 $148.00 $14,409.22 $15,028.69 $15,758.89 $16,556.17 10,223.07 10,223.07 10,223.07 10,223.07 $4,186.15 $4,805.62 $5,535.82 $6,333.10 $3,307.06 $3,796.44 $4,373.30 $5,003.15 $879.09 $1,009.18 $1,162.52 $1,329.95 $2,987.53 $3,113.95 $3,263.08 $3,425.67 $3,866.62 $4,123.13 $4,425.60 $4,755.62 $2,390.02 $2,491.16 $2,610.46 $2,740.53 Terminal value $1,476.60 $1,631.97 $1,815.14 $2,015.08 $25,944.21 $1,198.44 $1,193.28 $1,195.69 $1,195.85 $15,396.62 BALANCE SHEET (USD in millions) Year End 2019 Assets Current assets Liabilities Current liabilities Short-term debt $ 3,897.00 Non-current liabilities Cash and cash equivalents $ 6,877.00 Short-term investments $53,539.00 Total current assets $ 60,416.00 Long-term debt $ 21,457.00 $ 25,354.00 Total liabilities Non-current assets Gross property, plant and equipment $ 12,427.00 Accumulated Depreciation $ (9,095.00) Total non-current assets $ 3,332.00 Stockholders' equity Common stock Retained earnings Total stockholders' equity $ 22,340.00 $ 16,054.00 $ 38,394.00 $63,748.00 Total assets Total liabilities and stockholders' equity $ 63,748.00 52 53 USD in million 54 Revenue 55 Cost of revenue 56 Gross profit 57 R&D 58 Sales, G & Adm 59 Restructuring, M&A 60 Operating income 61 interest expense 62 income before tax 63 provision for income taxes 64 Net income 65 add: depreciation 66 Cash from operations 67 Less:CAPEX 68 FCF 69 DCf 70 71 72 1 2020 $51,829.85 $20,371.81 $31,458.04 $6,335.98 $12,584.52 $111.96 $12,425.57 10,223.07 $2,202.50 $1,739.98 $462.53 $2,591.49 $3,054.02 $2,073.19 $980.82 $883.63 2 3 4 5 5 2021 2022 2023 2024 $59,750.54 $62,279.07 $65,261.55 $68,513.30 $23,400.29 $24,380.86 $25,537.94 $26,798.33 $36,350.25 $37,898.22 $39,723.61 . $41,714.97 $7,304.25 $7,613.35 $7,977.95 $8,375.46 $14,507.70 $15,121.64 $15,845.80 $16,635.34 $129.07 $134.53 $140.98 $148.00 $14,409.22 $15,028.69 $15,758.89 $16,556.17 10,223.07 10,223.07 10,223.07 10,223.07 $4,186.15 $4,805.62 $5,535.82 $6,333.10 $3,307.06 $3,796.44 $4,373.30 $5,003.15 $879.09 $1,009.18 $1,162.52 $1,329.95 $2,987.53 $3,113.95 $3,263.08 $3,425.67 $3,866.62 $4,123.13 $4,425.60 $4,755.62 $2,390.02 $2,491.16 $2,610.46 $2,740.53 Terminal value $1,476.60 $1,631.97 $1,815.14 $2,015.08 $25,944.21 $1,198.44 $1,193.28 $1,195.69 $1,195.85 $15,396.62 BALANCE SHEET (USD in millions) Year End 2019 Assets Current assets Liabilities Current liabilities Short-term debt $ 3,897.00 Non-current liabilities Cash and cash equivalents $ 6,877.00 Short-term investments $53,539.00 Total current assets $ 60,416.00 Long-term debt $ 21,457.00 $ 25,354.00 Total liabilities Non-current assets Gross property, plant and equipment $ 12,427.00 Accumulated Depreciation $ (9,095.00) Total non-current assets $ 3,332.00 Stockholders' equity Common stock Retained earnings Total stockholders' equity $ 22,340.00 $ 16,054.00 $ 38,394.00 $63,748.00 Total assets Total liabilities and stockholders' equity $ 63,748.00Step 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