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. Cu
ent 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
XXXXXXXXXX
XXXXXXXXXX2020___
Assets
Cash
$ 9,100.00
$ XXXXXXXXXX,200.00
Credit receivables
XXXXXXXXXX,920.00
XXXXXXXXXX,240.00
Accounts receivable
XXXXXXXXXX,280.00
XXXXXXXXXX,160.00
Food inventory
XXXXXXXXXX,600.00
XXXXXXXXXX,900.00
Prepaid expenses
XXXXXXXXXX,800.00
XXXXXXXXXX,500.00
Land
XXXXXXXXXX,000.00
XXXXXXXXXX,000.00
Building
XXXXXXXXXX,800.00
XXXXXXXXXX,200.00
Equipment
XXXXXXXXXX,640.00
XXXXXXXXXX,200.00
Furnishings
XXXXXXXXXX,660.00
XXXXXXXXXX,300.00
Accumulated Depreciation
- 113,700.00
XXXXXXXXXX,500.00
Total Assets
XXXXXXXXXX,100.00
XXXXXXXXXX,200.00
Liabilities & Stockholders' Equity
Accounts payable
XXXXXXXXXX,700.00
XXXXXXXXXX,500.00
Bank note payable
XXXXXXXXXX,900.00
XXXXXXXXXX,600.00
Income tax payable
XXXXXXXXXX,500.00
XXXXXXXXXX,600.00
Accrued expenses payable
XXXXXXXXXX,100.00
XXXXXXXXXX,500.00
Mortgage payable (cu
ent)
XXXXXXXXXX,400.00
XXXXXXXXXX,100.00
Long-term mortgage payable
XXXXXXXXXX,000.00
XXXXXXXXXX,900.00
Common Stock
XXXXXXXXXX,000.00
XXXXXXXXXX,000.00
Retained earnings
XXXXXXXXXX,500.00
XXXXXXXXXX,000.00
Total Liabilities & Stockholders' Equity
XXXXXXXXXX,100.00
XXXXXXXXXX,200.00
Jaded Palate Restaurant
Income Statement
For the Year Ending December 31, 2020
Sales Revenue
$ XXXXXXXXXX,600.00
Cost of sales
$ 301,900.00
Operating expenses
XXXXXXXXXX,200.00
Total Operating Costs
XXXXXXXXXX,100.00
Operating income, before interest and tax
$ XXXXXXXXXX,500.00
Interest expense
XXXXXXXXXX,400.00
Income before tax
$ XXXXXXXXXX,100.00
Income tax
XXXXXXXXXX,600.00
Net Income
$ XXXXXXXXXX,500.00