Question: Looking back over the last few years, it is clear that Nicole Mackisey has accomplished a lot running her business, Nicoles Getaway Spa (NGS). Nicole
Looking back over the last few years, it is clear that Nicole Mackisey has accomplished a lot running her business, Nicoles Getaway Spa (NGS). Nicole is curious about her companys performance as she compares its financial statements.
| 2021 | 2020 | 2019 | |
|---|---|---|---|
| Balance Sheet | |||
| Cash | $ 11,700 | $ 9,200 | $ 8,800 |
| Accounts Receivable, Net | 4,500 | 5,000 | 4,300 |
| Inventory | 2,450 | 4,250 | 2,850 |
| Prepaid Expenses | 1,750 | 2,050 | 1,200 |
| Other Current Assets | 550 | 600 | 450 |
| Total Current Assets | 20,950 | 21,100 | 17,600 |
| Property and Equipment, Net | 89,000 | 104,000 | 52,000 |
| Total Assets | $ 109,950 | $ 125,100 | $ 69,600 |
| Current Liabilities | $ 18,000 | $ 18,000 | $ 19,000 |
| Long-Term Liabilities | 43,750 | 58,750 | 22,750 |
| Total Liabilities | 61,750 | 76,750 | 41,750 |
| Common Stock | 37,500 | 42,500 | 23,400 |
| Retained Earnings | 10,700 | 5,850 | 4,450 |
| Total Stockholders Equity | 48,200 | 48,350 | 27,850 |
| Total Liabilities and Stockholders Equity | $ 109,950 | $ 125,100 | $ 69,600 |
| Income Statement | |||
| Sales Revenue | $ 92,500 | $ 68,500 | $ 56,500 |
| Cost of Goods Sold | 72,500 | 55,500 | 42,500 |
| Gross Profit | 20,000 | 13,000 | 14,000 |
| Operating Expenses | 5,250 | 3,250 | 8,250 |
| Income from Operations | 14,750 | 9,750 | 5,750 |
| Interest Expense | 1,750 | 3,850 | 1,550 |
| Income before Income Tax Expense | 13,000 | 5,900 | 4,200 |
| Income Tax Expense | 4,300 | 2,050 | 1,750 |
| Net Income | $ 8,700 | $ 3,850 | $ 2,450 |
Required:
1-a. Calculate the net profit margin, gross profit percentage, return on equity, and fixed asset turnover ratio for 2021 and 2020.
1-b. Was NGS more profitable in 2021 or 2020?
2. Calculate the current ratio for 2021 and 2020.
3-a. Calculate the debt-to-assets ratio and times interest earned ratio for 2021 and 2020.
3-b. Was NGS more solvent in 2021 or 2020?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
