PLEASE CHECK THIS NOTE: "VALUE" NUMBER IN CELL/ "?" ENTER EITHER REFERENCE TO A CELL OR FORMULA IN CELL

PLEASE ANSWER WITH FORMULA NOT ONLY NUMBER.

B D E F G H 1 N 3 North Van Tacos Balance Sheet December 31 st 5 2019 6 7 8 Cash Accounts receivable (net) Other current assets Investments Plant and equipment (net) $30,000 50,000 90,000 55,000 550,000 $775,000 2018 $20,000 45,000 95,000 70,000 420,000 $650,000 2017 $18,000 48,000 64,000 45,000 358,000 $533,000 9 10 11 12 13 14 Current liabilities Long-term debt Common stock, $10 par Retained Earnings 15 $85,000 145,000 320,000 225,000 $775,000 $80,000 85,000 310,000 175,000 $650,000 $70,000 50,000 300,000 113,000 $533,000 16 17 20 21 22 23 24 25 North Van Tacos Income Statement For the Year Ended December 31 2019 2018 Sales revenue $790,000 $650,000 Cost of goods sold 425,000 350,000 Gross profit 365,000 300,000 Operating expenses (including income taxes) 180,000 150,000 Net income 185,000 150,000 30 Additional information: 31 #5 (*) The market price/common: $7.00, $7.50, and $8.50 (2017, 2018, 2019) 32 #6 (#) Determine dividends paid. All dividends were paid in cash. 26 27 28 29 33 35 36 37 34 Instructions Compute the following ratios for 2019 and 2018. (1) Profit margin 5. Price-earnings ratio. (2) Gross profit rate. 6. Payout ratio. (3) Asset turnover. 7. Debt to assets ratio. (4) Earnings per share. 40 41 NOTE: "value" - Enter number in cell 42 "?" - Enter either: reference to a cell or a formula in cell 38 39 A B D E F G Profit margin 52 (1) 53 54 2019 ? ? ? Net income Net sales Profit margin 2018 ? ? ? 55 56 57 58 59 (2) 60 Gross profit rate 61 2019 ? ? ? Gross profit Net sales Gross profit rate 2018 ? ? ? 62 63 64 65 Asset turnover 66 (3) 67 8 8 8 RM Beginning Balance Ending Blance Average total assets 2019 ? ? ? 2018 ? ? ? Net sales Average total assets Asset turnover 2019 ? ? ? 2018 ? ? ? 75 A B D E F G 76 77 78 (4) Earnings per share 79 80 2019 ? ? ? Common shares outstanding, Beg Common shares outstanding, End Average common shares outstanding 2018 ? ? ? 81 82 83 84 85 2019 ? ? ? Net income - Pfd. Dividends Average common shares outstanding Earnings per share 2018 ? ? ? 86 87 88 89 90 (5) 91 Price-earnings ratio 92 93 Stock price per share (*) Earnings per share Price-earnings ratio 2019 Value ? ? 2018 Value ? ? 94 95 96 97 (6) Payout ratio 98 99 100 Retained Earnings - Beg Plus: current year net income Less: Retained Earnings - End Cash dividends declared (#) 2019 ? ? ? ? 2018 ? ? ? ? 101 102 103 A B D E TI G 109 Debt to assets ratio 110 (7) 111 112 113 2019 ? ? ? ? ? Current Liabilities Long-term debt Total liabilities Total assets Debt to assets ratio 2018 ? ? ? ? ? 114 115 116