Question
he balance sheet and income statement for Joe's Fish Hut are presented below: Joe's Fish Hut Balance Sheet As at June 30 2020 2019 ASSETS
he balance sheet and income statement for Joe's Fish Hut are presented below:
Joe's Fish Hut Balance Sheet As at June 30 | ||
2020 | 2019 | |
ASSETS | ||
Current Assets | ||
Cash | $178,757 | $56,900 |
Accounts receivable | $18,800 | $13,800 |
Merchandise Inventory | $24,900 | $26,500 |
Total Current Assets | $222,457 | $97,200 |
Property, plant & equipment | $128,000 | $198,000 |
Less: Accumulated depreciation | $-25,800 | $-21,500 |
TOTAL ASSETS | $324,657 | $273,700 |
LIABILITIES AND EQUITY | ||
Liabilities | ||
Current Liabilities | ||
Accounts payable | $26,400 | $39,500 |
Notes Payable-Current Portion | $9,000 | $9,000 |
Total Current Liabilities | $35,400 | $48,500 |
Notes Payable-Long-Term Portion | $87,000 | $55,000 |
TOTAL LIABILITIES | $122,400 | $103,500 |
Shareholders' Equity | ||
Common shares | $68,000 | $50,600 |
Retained earnings | $134,257 | $119,600 |
TOTAL SHAREHOLDERS' EQUITY | $202,257 | $170,200 |
TOTAL LIABILITIES AND EQUITY | $324,657 | $273,700 |
Joe's Fish Hut Income Statement For the Year Ended June 30, 2020 | |
Sales | $130,000 |
COGS | $89,600 |
Gross Profit | $40,400 |
Operating Expenses | |
Insurance Expense | $1,120 |
Rent Expense | $5,000 |
Salaries Expense | $4,970 |
Telephone Expense | $710 |
Interest Expense | $1,750 |
Depreciation Expense | $4,300 |
Total Operating Expenses | $17,850 |
Operating Profit Before Tax | $22,550 |
Income Tax Expense | $7,893 |
Net Profit (Loss) | $14,657 |
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
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