Blog


Management No Comments

Income Statement & KPI

Question Description

I’m working on a Accounting question and need guidance to help me study.

Hello. I need the income Statement & KPI template completed. All of the details are in the tabs within the excel spreadsheet. Thank you.

Unformatted Attachment Preview

Your Company ______________ OPERATING FORECAST In Millions (000,000) Projected Annual Increases Over 2019 Actual **** Total Sales $ ACTUAL * * * * __ / __ / 2019 __ / __ / 2021 2 100.0% Total Cost of Sales 1 Gross Profit: Selling & Corp Expenses Selling Expenses Corporate/Admin Expenses Other Expense (if any) Total Operating Expenses Operating Income 2 100.0% 50.0% 1 1 50.0% 0 1 Interest (Income) enter with ” – sign” Interest Expense Other (Income) / Expense Net Taxable Income 50.0% 1 1 50.0% 0.0% 0.0% 0.0% 0.0% 50.0% 3 150.0% 3 150.0% Income Tax Net Income 100.0% -100.0% 0.0% 0.0% 100.0% 33.3% 1 2 66.7% 0 0.0% 0.0% 0.0% 0.0% 1 50.0% 100.0% 20.0% 7 4 80.0% 0 0.0% 0.0% 0.0% 0.0% 2 66.7% 1 50.0% 1 50.0% 2 66.7% 2 66.7% 0.0% $ 100.0% 25.0% 70.0% 12 60.0% 23.0% 3 30.0% 8 40.0% 2.0% 0 0.0% 0.0% 0.0% 0.0% 0 0.0% 0.0% 0.0% 0.0% 0 0.0% 0.0% 0.0% 0.0% 17.0% 19.0% 2.0% TBD 4 80.0% 3 30.0% 8 40.0% TBD 0.0% 0.0% 0.0% 4.0% -10.0% 5.0% 8 40.0% TBD 0.0% Note 2 8 40.0% 0.0% 0.0% 0.0% 4 80.0% 4 80.0% 0.0% $ 0.0% 0.0% 0.0% 3 30.0% 3 30.0% 0.0% $ 0.0% $ $ Note 1 Note 1 Note 1 TBD Note 1 Only if any amount for 2019 Note 2 Compute as 30% of Taxable Income Outstanding Shares at Year-End ** ** – Assume no change in # of shares Outstanding Shares – Basic Facebook Amazon Apple Netflix Google (Alphabet) $ % Change 20 0.0% 0.0% 0.0% $ __ / __ / 2025 10 0.0% 0.0% 0.0% $ __ / __ / 2024 5 0.0% $ $ __ / __ / 2023 3 (2) $ __ / __ / 2022 BE SURE to record all amounts excluding “000,000” which is MILLIONS. 2,854,000,000 480,000,000 4,617,834,000 437,799,000 693,049,000 Your Company __________________ Balance Sheet 5 Year Forecast All Amounts in Millions (000,000) Google 2019 Actual __/__/2021 __/__/2022 __/__/2023 __/__/2024 __/__/2025 $ $ $ 21,414 114,477 29,318 1,156 7,615 173,980 $ 22,484 105,730 30,784 1,214 7,996 168,208 1.05 Assets Cash Cash Equivalents + Short-term Investments Accounts Receivable, net of allowances Inventoriies Other Current Assets Current Assets $ 18,498 101,177 25,326 999 6,578 152,578 19,423 131,118 26,592 1,049 6,907 185,089 20,394 122,932 27,922 1,101 7,252 179,601 $ 23,609 96,675 32,323 1,275 8,395 162,278 Net Fixed Assets 73,646 77,328 81,195 85,254 89,517 93,993 Long-Term Assets (e.g. Goodwill) 49,685 52,169 54,778 57,517 60,392 63,412 $ 275,909 $ 314,587 $ 315,574 $ 316,751 $ 318,117 $ 319,683 45,221 5,839 41,643 47,482 6,131 43,725 49,856 6,438 45,911 52,349 6,759 48,207 54,966 7,097 50,617 57,715 4,554 24,692 29,246 4,326 23,457 27,784 4,110 22,285 26,395 3,904 21,170 25,075 3,709 20,112 23,821 3,524 19,106 22,630 74,467 75,266 76,251 77,424 78,787 80,345 50,552 152,122 50,552 190,001 (1,232) 239,321 50,552 190,003 (1,232) 239,323 50,552 190,007 (1,232) 239,327 50,552 190,010 (1,232) 239,330 50,552 190,018 (1,232) 239,338 Total Assets Liabilities & Equity Accounts Payable Accrued Expense + Other Short Term Liabilities Current Portion of LTD Current Liabilities Long Term Debt (both Notes & Bonds Payable) Other Long Term Liabilities Long Term Liabilities Total Liabilities Stockholders’ Equity: Common Stock & Additional Paid-In Capital Beginning Retained Earnings (see schedule below) Treasury Shares Other Equity Amounts Total Stockholders’ Equity Total Liabilities & Equity Retained Earnings Calculation: Beginning Retained Earnings – Jan 1 2021 (Estim) Add: Net Income Minus: Dividends Paid Other (if any) Ending Retained Earnings Note: ignore any stock repurchases for 2021-2025 years for all FAANG companies $ 5,561 39,660 (1,232) 201,442 $ 275,909 $ 314,587 $ 315,574 $ 316,751 $ 318,117 $ 319,683 – – – – – – 2020 Estim $ 152,122 35,000 n/a 2,878 $ 190,000 $ 190,000 1 n/a $ 190,001 2 n/a $ 190,003 4 n/a $ 190,007 3 n/a $ 190,010 8 n/a $ 190,001 $ 190,003 $ 190,007 $ 190,010 $ 190,018 0.95 Your Company ___________________ Key Performance Indicators (KPI) 5 Year Forecast All Amounts in Millions (000,000) 2019 Actual __/__/2021 Liquidity Metrics Working Capital: Current Assets – Current Liabilities Current Ratio: Current Assets / Current Liabilities Quick Ratio: Certain Cur Assets / Current Liab Solvency Metrics Debt Ratio Total Liabilities / Total Assets Debt to Equity Ratio Total Liabilities / Total Shareholder Equity Profitability Metrics Return on Assets: (A) Operating Income / Average Total Assets N/A Return on Equity: (B) Operating Income / Average Shareholder Equity Leverage Effect: ROA – ROE Earnings per Share Net Income / Total Shares Outstanding * * – Assume no change in # of shares Price-Earnings Ratio Market Price / Earnings per Share ** ** – use Year-End Market Price

Comments are closed.

Instant Homwork Help
Need Help? Whatsapp a Tutor