Question
The balance sheet and income statement for Joe's Fish Hut are presented below: Joe's Fish Hut Balance Sheet As at August 31 2020 2019 ASSETS
The balance sheet and income statement for Joe's Fish Hut are presented below:
Joe's Fish Hut Balance Sheet As at August 31 | ||
2020 | 2019 | |
ASSETS | ||
Current Assets | ||
Cash | $169,809 | $56,500 |
Accounts receivable | $17,600 | $13,700 |
Merchandise Inventory | $20,100 | $25,500 |
Total Current Assets | $207,509 | $95,700 |
Property, plant & equipment | $148,000 | $196,000 |
Less: Accumulated depreciation | $-27,000 | $-21,800 |
TOTAL ASSETS | $328,509 | $269,900 |
LIABILITIES AND EQUITY | ||
Liabilities | ||
Current Liabilities | ||
Accounts payable | $27,700 | $40,400 |
Notes Payable-Current Portion | $6,500 | $6,500 |
Total Current Liabilities | $34,200 | $46,900 |
Notes Payable-Long-Term Portion | $76,000 | $46,000 |
TOTAL LIABILITIES | $110,200 | $92,900 |
Shareholders' Equity | ||
Common shares | $82,000 | $55,400 |
Retained earnings | $136,309 | $121,600 |
TOTAL SHAREHOLDERS' EQUITY | $218,309 | $177,000 |
TOTAL LIABILITIES AND EQUITY | $328,509 | $269,900 |
Joe's Fish Hut Income Statement For the Year Ended August 31, 2020 | |
Sales | $126,000 |
COGS | $83,500 |
Gross Profit | $42,500 |
Operating Expenses | |
Insurance Expense | $980 |
Rent Expense | $5,830 |
Salaries Expense | $5,860 |
Telephone Expense | $700 |
Interest Expense | $1,300 |
Depreciation Expense | $5,200 |
Total Operating Expenses | $19,870 |
Operating Profit Before Tax | $22,630 |
Income Tax Expense | $7,921 |
Net Profit (Loss) | $14,709 |
Complete the following ratio analysis.
Do not enter dollar signs or commas in the input boxes. Round all answers to 2 decimal places. a) Calculate the gross profit margin for the 2020. Gross Profit Margin: Answer % b) Calculate the times interest earned ratio for 2020. Times Interest Earned: Answer times c) Calculate the net profit margin for 2020. Net Profit Margin: Answer % d) Calculate the return on equity for 2020. Return on Equity: Answer % e) Calculate the return on assets for 2020. Return on Assets: Answer % f) Calculate the asset turnover ratio for 2020. Asset turnover: Answer times g) Calculate the current ratio for 2020. Current Ratio: Answer h) Calculate the quick ratio for 2020. Quick Ratio: Answer i) Calculate the debt to equity ratio for 2020. Debt to Equity Ratio: Answer j) Calculate the days sales outstanding ratio for 2020. Assume all sales are credit sales. Days sales outstanding: Answer days k) Calculate the accounts receivable turnover for 2020. Assume all sales are credit sales Accounts Receivable turnover: Answer times l) Calculate the days' sales in inventory ratio for 2020. Days' Sales in Inventory: Answer days m) Calculate the inventory turnover for 2020. Inventory turnover: Answer times n) Calculate the debt to assets ratio for 2020. Debt to Assets Ratio: Answer % o) Calculate the working capital for 2020. Working Capital: Answer
a) Calculate the gross profit margin for the 2020. Gross Profit Margin: % b) Calculate the times interest earned ratio for 2020. Times Interest Earned: times c) Calculate the net profit margin for 2020. Net Profit Margin: % d) Calculate the return on equity for 2020. Return on Equity: % e) Calculate the return on assets for 2020. Return on Assets: % f) Calculate the asset turnover ratio for 2020. Asset turnover: times g) Calculate the current ratio for 2020. Current Ratio: h) Calculate the quick ratio for 2020. Quick Ratio: i) Calculate the debt to equity ratio for 2020. Debt to Equity Ratio: 1) Calculate the days sales outstanding ratio for 2020. Assume all sales are credit sales. Days sales outstanding: days k) Calculate the accounts receivable turnover for 2020. Assume all sales are credit sales Accounts Receivable turnover: times 1) Calculate the days' sales in inventory ratio for 2020. Days' Sales in Inventory: days m) Calculate the inventory turnover for 2020. Inventory turnover: times n) Calculate the debt to assets ratio for 2020. Debt to Assets Ratio: % o) Calculate the working capital for 2020. Working CapitalStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started