PLEASE CHECK THIS NOTE: "value" - Enter number in cell /"?" - Enter either: reference to a cell or a formula in cell

PLEASE WRITE REFERENCE TO A CELL OR A FORMULA IN CELL. NOT ONLY THE ANSWER (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 D E F G A 97 (6) 98 B Payout ratio 99 100 Retained Earnings - Beg Plus: current year net income Less: Retained Earnings - End Cash dividends declared (#) 2019 $175,000 185,000 225,000 $135,000 2018 $113,000 150,000 175,000 $88,000 101 102 103 104 105 2019 ? ? ? Cash dividends declared (common) Net income Payout ratio 2018 ? ? 106 107