Case Study, please see attached file
Group / Individual Assignment Due: Week 6 To be submitted in Assignment Drop Box Submission Format: Times New Roman 12, Typewritten, With Cover Page indicating you and your group members’ complete name From the financial information of Jaded Restaurant, calculate the following ratios and comment on any of the calculated ratios that you may notice to appear to have an unusually high or low or totally out of range (from any given acceptable standard or number and what should be considered as acceptable). 1. Working capital for Years 2019 and 2020 2. Current ratio for Years 2019 and 2020 3. Quick ratio (Acid test ratio) for Years 2019 and 2020 4. Credit card receivables as a percentage of credit card sales revenue for Year 2020 5. Credit card receivables turnover ratio based on credit card sales revenue for Year 2020 6. Credit card receivables average collection period ratio, based on credit card sales revenue for Year 2020 7. Accounts receivable as a percentage of accounts receivable credit sales revenue for Year 2020 8. Accounts receivable turnover ratio based on accounts receivable credit sales revenue for Year 2020 9. Accounts receivable average collection period based on accounts receivable credit sales revenue for Year 2020 10. Total assets to total liabilities for Years 2019 and 2020 11. Total liabilities to total assets for Years 2019 and 2020 12. Total liabilities to stockholders’ equity for Years 2019 and 2020 13. Net return on total assets for Year 2020 14. Number of times interest is earned for Year 2020 15. Net income to total sales revenue ratio for Year 2020 16. Return on stockholders’ equity for Year 2020 17. Food inventory turnover ratio for Year 2020 18. Property, plant, and equipment (fixed assets) turnover ratio for Year 2020 Balance Sheet As at December 31 2019 2020___ Assets Cash $ 9,100.00 $ 14,200.00 Credit receivables 4,920.00 6,240.00 Accounts receivable 5,280.00 6,160.00 Food inventory 14,600.00 13,900.00 Prepaid expenses 3,800.00 4,500.00 Land 32,000.00 32,000.00 Building 315,800.00 323,200.00 Equipment 66,640.00 73,200.00 Furnishings 16,660.00 18,300.00 Accumulated Depreciation - 113,700.00 - 124,500.00 Total Assets 355,100.00 367,200.00 Liabilities & Stockholders' Equity Accounts payable 16,700.00 12,500.00 Bank note payable 4,900.00 3,600.00 Income tax payable 12,500.00 12,600.00 Accrued expenses payable 7,100.00 7,500.00 Mortgage payable (current) 10,400.00 12,100.00 Long-term mortgage payable 192,000.00 180,900.00 Common Stock 10,000.00 10,000.00 Retained earnings 101,500.00 128,000.00 Total Liabilities & Stockholders' Equity 355,100.00 367,200.00 Jaded Palate Restaurant Income Statement For the Year Ending December 31, 2020 Sales Revenue $ 742,600.00 Cost of sales $ 301,900.00 Operating expenses 381,200.00 Total Operating Costs 683,100.00 Operating income, before interest and tax $ 59,500.00 Interest expense 19,400.00 Income before tax $ 40,100.00 Income tax 12,600.00 Net Income $ 27,500.00