1 Perform a horizontal analysis on the balance sheets for 2018 and 2019. B (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Balance Sheet or if you type the numbers in, you will be marked wrong. Make sure any decreases are shown with a minus sign or parentheses.) RIVERSIDE SWEETS Balance Sheet June 30, 2018 and 2019 8 9 10 11 Assets Increase (Decrease) 2019 2018 Amount Percentage 13 14 15 16 17 18 19 Current Assets: Cash Short-term Investments i Accounts Receivable Merchandise Inventory Other Current Assets Total Current Assets Property, Plant, and Equipment, net Total Assets 225,000 $ 125,000 $ 685,000 119,000 650,000 198,000 65,000 70,000 195,000 1,295,000 191,000 1,228,000 875,000 832,000 $2,060,000 $ 2,170,000 20 21 Liabilities 22 Current Liabilities: 23 Accounts Payable $ 265,000 $ 251,750 24 25 26 27 Accrued Liabilities Total Current Liabilities. Long-term Liabilities: Bonds Payable 641,000 725,523 906,000 977,273 250,000 150,000 28 Mortgage Payable 150,000 175,000 29 Total Long-term Liabilities 400,000 325,000 30 Total Liabilities 1,306,000 1,302,273 31 Stockholders' Equity 32 Common Stock, $1 par, 225,000 shares issued and outstanding 225,000 225,000 33 Paid-In Capital in Excess of Par 58,000 58,000 34 Retained Earnings 581,000 474,727 35 Total Stockholders' Equity 864,000 26 Total Liabilities and Stockholders' Equity $ 2,170,000 757,727 $2,060,000 37 30 39 40 HINTS 41 1. For cell references, begin the formula with an equals sign (e), use the balance in this worksheet for your calculations, and press the enter key. 42 F12:F15, F23:F25,F27 F30, F32 F36 | When entering the calculation begin with the 2019 value. Some solutions will be negative. 44 2 3 4 5 6 Perform a vertical analysis on the income statement. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Income Statement or if you type the numbers in, you will be marked wrong. Enter all values as positive numbers.) RIVERSIDE SWEETS Income Statement Year Ended June 30, 2019 Net Sales 9 30 11 12 13 14 15 16 17 18 19 20 21 $ 2,800,000 Cost of Goods Sold Gross Profit Operating Expenses Operating Income Other Income and (Expenses) Interest Expense Income Before Income Taxes Income Tax Expense Net Income 1,551,600 1,248,400 450,540 797,860 15,000 782,860 153,529 $ 629,331 HINTS cancer haain the formula with an anuals sign (a) use the income statement in this worksheet for your calculations and press the enter key D mpute the following ratios. Do not round your calculations. ways use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Enteranswers1 or Enteranswers2 tabs you will be marked wrong. Enter all values as positive numbers.) Working Capital Current Ratio Acid-Test (Quick) Ratio Cash Ratio Accounts Receivable Turnover Days' Sales in Receivables Inventory Turnover Days' Sales in Inventory Gross Profit Percentage Debt Ratio Debt to Equity Ratio Times-Interest-Earned Ratio Profit Margin Ratio Rate of Return on Total Assets Asset Turnover Ratio Rate of Return on Common Stockholders' Equity Earnings per Share (EPS) Price/Earnings Ratio Dividend Yield Dividend Payout 2019 2018 HINTS Cell | Hint CS | Begin the formula with an equals sign (=), use the balance in the horizontal analysis worksheet for your calculations, and press the enter key. 7 | Use the function =SUM() to calculate the numerator. 9 if a decimal place is being used, be sure to enter a zero before the decimal: 0.75. 10 | Assume 365 days in a year and use the correct ratio in this worksheet for your calculations.