Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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.00

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

Practical Auditing

Authors: Ernest Evan Spicer, Ernest Charles Pegler

17th Edition

0406678014, 9780406678010

More Books

Students also viewed these Accounting questions

Question

=+nk so that p( B(k)) Answered: 1 week ago

Answered: 1 week ago

Question

Why could the Robert Bosch approach make sense to the company?

Answered: 1 week ago