Question
The balance sheet and income statement for Joe's Fish Hut are presented below: Joe's Fish Hut Balance Sheet As at February 28 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 February 28 | ||
2020 | 2019 | |
ASSETS | ||
Current Assets | ||
Cash | $167,292 | $64,100 |
Accounts receivable | $23,700 | $15,700 |
Merchandise Inventory | $22,500 | $28,900 |
Total Current Assets | $213,492 | $108,700 |
Property, plant & equipment | $130,000 | $182,000 |
Less: Accumulated depreciation | $-28,400 | $-22,700 |
TOTAL ASSETS | $315,092 | $268,000 |
LIABILITIES AND EQUITY | ||
Liabilities | ||
Current Liabilities | ||
Accounts payable | $27,100 | $35,800 |
Notes Payable-Current Portion | $6,700 | $6,700 |
Total Current Liabilities | $33,800 | $42,500 |
Notes Payable-Long-Term Portion | $74,000 | $56,000 |
TOTAL LIABILITIES | $107,800 | $98,500 |
Shareholders' Equity | ||
Common shares | $79,000 | $56,600 |
Retained earnings | $128,292 | $112,900 |
TOTAL SHAREHOLDERS' EQUITY | $207,292 | $169,500 |
TOTAL LIABILITIES AND EQUITY | $315,092 | $268,000 |
Joe's Fish Hut Income Statement For the Year Ended February 28, 2020 | |
Sales | $130,000 |
COGS | $86,900 |
Gross Profit | $43,100 |
Operating Expenses | |
Insurance Expense | $1,520 |
Rent Expense | $4,740 |
Salaries Expense | $5,270 |
Telephone Expense | $700 |
Interest Expense | $1,490 |
Depreciation Expense | $5,700 |
Total Operating Expenses | $19,420 |
Operating Profit Before Tax | $23,680 |
Income Tax Expense | $8,288 |
Net Profit (Loss) | $15,392 |
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: ________ % 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: ________ j) 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 l) 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 Capital: ________
Step 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