Forecast the year 2021 for both the income and balance sheet, I need to fill in the blanks. After completing both sheets I need to create a common size income statement and a common size balance sheet and a common size cash budget statement.

do you need me to add another picture because I do not understand your comment.

Every thing needed should be there

PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need fx M22 A E E 1 2 INCOME STATEMENT (In millions, except per share amounts)(Unaudited) 3 4 5 6 Twelve Months Ended June 30, 2019 2020 2021" $57,190 32,760 89,950 $61,502 23,818 85,320 8 Revenue 9 Product 10 Service and other 11 Total revenue 12 Cost of revenue 13 Product 14 Service and other 15 Total cost of revenue 16 Earnings Before Interest and Taxes 17 Research and development 18 Sales and marketing 19 General and administrative 20 Impairment and restructuring 21 Operating income 22 Other income (expense), net 23 Earnings Before Taxes 24 Income Taxes 25 Net income 26 Earnings per share: 27 Basic 28 Diluted 29 Weighted average shares outstanding 30 Basic 31 Diluted 32 15,175 19,086 34,261 55,689 13,037 15,539 4,481 306 22,326 823 23,149 1.945 $21.204 17,880 14,900 32,780 52,540 11988 14,697 4,563 1.110 20,182 (431) 19,751 2,953 $16,798 $2.74 $2.71 $2.12 $2.10 7,746 7,832 7.925 8,013 8,085 8,175 Instructions Incoise Statement Balance Sheet Cash Flows Ready Common-Size Type here to search Uias Loco ain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing G H K L M N P Q R ) FORECAST 2021 nths Ended June 30, 2020 2021 Assumptions Price per Unit $ Unit Sales Variable Costs as % of Sales Tax Rate Degree of Operating Leverage Degree of Financial Leverage Degree of Combined Leverage $61,502 23,818 85320 23.00 270,000 Products 30% Service 60% 18% 7 9 1 06 26 17 880 14.900 32780 52.540 11.988 14,697 4,563 1.110 20,182 (431) 19.751 1 2 3 4 BALANCE SHEET in millions (Unaudited) June 30, 2019 June 30, 2020 June 30 2021 5 $7,663 $6,510 125 318 106,730 132981 113.240 19,792 2,181 4897 159,851 18, 277 2.251 5,892 139,560 6 Assets 7 Current assets 8 Cash and cash equivalents Short-term investments including securities 9 loaned of $3,694 and $204) Total cash, cash equivalents, and short term 10 investments Accounts receivable, net of allowance for doubtful 71 accounts of $405 and 5426 12 Inventories 13 Other 14 Total current assets Property and equipment, net of accumulated 15 depreciation of $24,179 and 519,800 16 Equity and other investments 17 Goodwill 18 Intangible assets.net 19 Other long-term assets 20 Total assets 21 Liabilities and stockholders' equity 22 Current liabilities 23 Accounts payable Short-term debt 25 Current portion of long-term debt 26 Accrued compensation 27 Income taxes 28 Short-term unearned revenue 29 Securities lending payable 30 Other 31 Total current liabilities 23,734 6023 35 122 10.106 6,250 $241.086 18.356 10.431 17.872 3.783 3,416 $193,468 $7390 9,072 1,049 5,819 718 34.102 97 6.280 64 527 $6,898 12.904 0 5,254 580 27 468 294 5.949 59357 23 734 6,023 35.122 10.106 6.250 $241,086 18.356 10431 17,872 3.733 3,416 $199,468 56.898 12.904 57 390 9,072 1.049 5,819 roperty and equipment net of accumulated 15 depreciation of $24,179 and $19.800 16 Equity and other investments 17 Goodwill 18 Intangible assets, net 19 Other long term assets 20 Total assets 21 Liabilities and stockholders' equity 22 Current liabilities: 23 Accounts payable 24 Short-term deb 25 Current portion of long term debt 26 Accrued compensation 27 Income taxes 28 Short-term unearned revenue 29 Securities lending payable 30 Other 31 Total current liabilities 32 Long-term debt 33 Long-term unearned revenue 34 Deferred income taxes 35 Other long-term liabilities 36 Total liabilities 37 Commitments and contingencies 38 Stockholders' equity Common stock and paid in capital shares 39 authorized 24,000; outstanding 7.708 and 7808 40 Retained earnings 41 Accumulated other comprehensive Income 42 Total stockholders' equity 43 Total liabilities and stockholders equity 34 TOZ 97 6280 64527 76,072 10.377 531 17.184 168,692 5.264 580 27.468 294 5949 59 357 40 557 1.476 13.540 121.471 69,315 2.648 431 72,394 5241086 68.178 2.282 1.537 71.997 $193 468 Discretionary Financir 2021 44 45 46 47 Common Size Income Statement Common-Site Balance Sheet Instructions Income Statement Balance Sheet Cash Flows -223 E14 D E F 2 CASH FLOWS STATEMENT 3 in millions)(Unaudited) 4 5 Twelve Months Ended 6 June 30, 2019 2020 7 8 Operations 9 Net income $21,204 $16,798 Adjustments to reconcile net income 10 to net cash from operations: 11 Goodwill and asset impairments 0 630 Depreciation, amortization, and 12 other 8,778 6,622 Stock-based compensation 3 expense 3,266 2,668 Net recognized gains on 4 investments and derivatives (2,073) (223) 5 Deferred income taxes (3.296) 332 6 Deferral of unearned revenue 67,711 57,072 7 Recognition of unearned revenue (57,735) (48,498) Changes in operating assets and 8 liabilities: 9 Accounts receivable (925) (530) 0 Inventories 50 600 1 Other current assets 1,066 (1,167) 2 Other long-term assets (539) (41) 3 Accounts payable 81 Other current liabilities 386 (260) 5 Other long-term liabilities 1,533 (766) 5 Net cash from operations 39,507 33,325 Financing Proceeds from issuance Instructions Income Statement Balance Sheet Cash Flows Commc 88 Lady Type here to search File Home Insert Draw Page Layout Formulas Data PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless y H43 F 39,507 E 33,325 (4,963) 44,344 (7.922) 772 (11,788) (11,845) (190) 7,195 13,884 (2,796) 668 (15,969) (11,006 (369) 8,408 (8,393) (8,129) (8,343) A 26 Net cash from operations 27 Financing Proceeds from issuance (tepayments) of short-term debt, 28 maturities of 90 days or less net 29 Proceeds from issuance of debt 30 Repayments of debt 31 Common stock issued 32 Common stock repurchased 33 Common stock cash dividends paid 34 Other Net cash from (used in) 35 financing 36 Investing 37 Additions to property and equipment Acquisition of companies, net of cash acquired, and purchases of 38 intangible and other assets 39 Purchases of investments 40 Maturities of investments 41 Sales of investments 42 Securities lending payable 43 Net cash used in investing Effect of foreign exchange rates on cash and cash equivalents Net change in cash and cash 45 equivalents Cash and cash equivalents, 46 beginning of period Cash and cash equivalents, end of 47 period 48 Instructions Income Statement Heady (25,944) (176,905) 28,044 136,350 (197) (46.781) (1,393) (129,758) 22,054 93,287 203 (23,950) 44 19 (67) 1.153 915 6,510 5,595 $7,663 $6,510 Balance Sheet Cash Flows Comm ma D Page Layout Hole 7 B H Instructions: This is an assessment of some of the skills learned in the first part of this course. Complete the HIGHLIGHTED portions of the worksheets as well as 1. Completing each of the three Common Size Statements. Worksheets are inserted already for your convenience. 2. Completing a Ratio Analysis with 2 ratios your choice) from each category: Liquidity ratios Efficiency ratios Leverage ratios Coverage ratios Profitability ratios Note: There are 17) worksheets not including this worksheet. The Cashflow worksheet anly serves as a reference for your common Size worksheet exercise. PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need fx M22 A E E 1 2 INCOME STATEMENT (In millions, except per share amounts)(Unaudited) 3 4 5 6 Twelve Months Ended June 30, 2019 2020 2021" $57,190 32,760 89,950 $61,502 23,818 85,320 8 Revenue 9 Product 10 Service and other 11 Total revenue 12 Cost of revenue 13 Product 14 Service and other 15 Total cost of revenue 16 Earnings Before Interest and Taxes 17 Research and development 18 Sales and marketing 19 General and administrative 20 Impairment and restructuring 21 Operating income 22 Other income (expense), net 23 Earnings Before Taxes 24 Income Taxes 25 Net income 26 Earnings per share: 27 Basic 28 Diluted 29 Weighted average shares outstanding 30 Basic 31 Diluted 32 15,175 19,086 34,261 55,689 13,037 15,539 4,481 306 22,326 823 23,149 1.945 $21.204 17,880 14,900 32,780 52,540 11988 14,697 4,563 1.110 20,182 (431) 19,751 2,953 $16,798 $2.74 $2.71 $2.12 $2.10 7,746 7,832 7.925 8,013 8,085 8,175 Instructions Incoise Statement Balance Sheet Cash Flows Ready Common-Size Type here to search Uias Loco ain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing G H K L M N P Q R ) FORECAST 2021 nths Ended June 30, 2020 2021 Assumptions Price per Unit $ Unit Sales Variable Costs as % of Sales Tax Rate Degree of Operating Leverage Degree of Financial Leverage Degree of Combined Leverage $61,502 23,818 85320 23.00 270,000 Products 30% Service 60% 18% 7 9 1 06 26 17 880 14.900 32780 52.540 11.988 14,697 4,563 1.110 20,182 (431) 19.751 1 2 3 4 BALANCE SHEET in millions (Unaudited) June 30, 2019 June 30, 2020 June 30 2021 5 $7,663 $6,510 125 318 106,730 132981 113.240 19,792 2,181 4897 159,851 18, 277 2.251 5,892 139,560 6 Assets 7 Current assets 8 Cash and cash equivalents Short-term investments including securities 9 loaned of $3,694 and $204) Total cash, cash equivalents, and short term 10 investments Accounts receivable, net of allowance for doubtful 71 accounts of $405 and 5426 12 Inventories 13 Other 14 Total current assets Property and equipment, net of accumulated 15 depreciation of $24,179 and 519,800 16 Equity and other investments 17 Goodwill 18 Intangible assets.net 19 Other long-term assets 20 Total assets 21 Liabilities and stockholders' equity 22 Current liabilities 23 Accounts payable Short-term debt 25 Current portion of long-term debt 26 Accrued compensation 27 Income taxes 28 Short-term unearned revenue 29 Securities lending payable 30 Other 31 Total current liabilities 23,734 6023 35 122 10.106 6,250 $241.086 18.356 10.431 17.872 3.783 3,416 $193,468 $7390 9,072 1,049 5,819 718 34.102 97 6.280 64 527 $6,898 12.904 0 5,254 580 27 468 294 5.949 59357 23 734 6,023 35.122 10.106 6.250 $241,086 18.356 10431 17,872 3.733 3,416 $199,468 56.898 12.904 57 390 9,072 1.049 5,819 roperty and equipment net of accumulated 15 depreciation of $24,179 and $19.800 16 Equity and other investments 17 Goodwill 18 Intangible assets, net 19 Other long term assets 20 Total assets 21 Liabilities and stockholders' equity 22 Current liabilities: 23 Accounts payable 24 Short-term deb 25 Current portion of long term debt 26 Accrued compensation 27 Income taxes 28 Short-term unearned revenue 29 Securities lending payable 30 Other 31 Total current liabilities 32 Long-term debt 33 Long-term unearned revenue 34 Deferred income taxes 35 Other long-term liabilities 36 Total liabilities 37 Commitments and contingencies 38 Stockholders' equity Common stock and paid in capital shares 39 authorized 24,000; outstanding 7.708 and 7808 40 Retained earnings 41 Accumulated other comprehensive Income 42 Total stockholders' equity 43 Total liabilities and stockholders equity 34 TOZ 97 6280 64527 76,072 10.377 531 17.184 168,692 5.264 580 27.468 294 5949 59 357 40 557 1.476 13.540 121.471 69,315 2.648 431 72,394 5241086 68.178 2.282 1.537 71.997 $193 468 Discretionary Financir 2021 44 45 46 47 Common Size Income Statement Common-Site Balance Sheet Instructions Income Statement Balance Sheet Cash Flows -223 E14 D E F 2 CASH FLOWS STATEMENT 3 in millions)(Unaudited) 4 5 Twelve Months Ended 6 June 30, 2019 2020 7 8 Operations 9 Net income $21,204 $16,798 Adjustments to reconcile net income 10 to net cash from operations: 11 Goodwill and asset impairments 0 630 Depreciation, amortization, and 12 other 8,778 6,622 Stock-based compensation 3 expense 3,266 2,668 Net recognized gains on 4 investments and derivatives (2,073) (223) 5 Deferred income taxes (3.296) 332 6 Deferral of unearned revenue 67,711 57,072 7 Recognition of unearned revenue (57,735) (48,498) Changes in operating assets and 8 liabilities: 9 Accounts receivable (925) (530) 0 Inventories 50 600 1 Other current assets 1,066 (1,167) 2 Other long-term assets (539) (41) 3 Accounts payable 81 Other current liabilities 386 (260) 5 Other long-term liabilities 1,533 (766) 5 Net cash from operations 39,507 33,325 Financing Proceeds from issuance Instructions Income Statement Balance Sheet Cash Flows Commc 88 Lady Type here to search File Home Insert Draw Page Layout Formulas Data PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless y H43 F 39,507 E 33,325 (4,963) 44,344 (7.922) 772 (11,788) (11,845) (190) 7,195 13,884 (2,796) 668 (15,969) (11,006 (369) 8,408 (8,393) (8,129) (8,343) A 26 Net cash from operations 27 Financing Proceeds from issuance (tepayments) of short-term debt, 28 maturities of 90 days or less net 29 Proceeds from issuance of debt 30 Repayments of debt 31 Common stock issued 32 Common stock repurchased 33 Common stock cash dividends paid 34 Other Net cash from (used in) 35 financing 36 Investing 37 Additions to property and equipment Acquisition of companies, net of cash acquired, and purchases of 38 intangible and other assets 39 Purchases of investments 40 Maturities of investments 41 Sales of investments 42 Securities lending payable 43 Net cash used in investing Effect of foreign exchange rates on cash and cash equivalents Net change in cash and cash 45 equivalents Cash and cash equivalents, 46 beginning of period Cash and cash equivalents, end of 47 period 48 Instructions Income Statement Heady (25,944) (176,905) 28,044 136,350 (197) (46.781) (1,393) (129,758) 22,054 93,287 203 (23,950) 44 19 (67) 1.153 915 6,510 5,595 $7,663 $6,510 Balance Sheet Cash Flows Comm ma D Page Layout Hole 7 B H Instructions: This is an assessment of some of the skills learned in the first part of this course. Complete the HIGHLIGHTED portions of the worksheets as well as 1. Completing each of the three Common Size Statements. Worksheets are inserted already for your convenience. 2. Completing a Ratio Analysis with 2 ratios your choice) from each category: Liquidity ratios Efficiency ratios Leverage ratios Coverage ratios Profitability ratios Note: There are 17) worksheets not including this worksheet. The Cashflow worksheet anly serves as a reference for your common Size worksheet exercise