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.
| 2018 | 2017 | 2016 | ||||||||||
| Balance Sheet | ||||||||||||
| Cash | $ | 8,300 | $ | 5,800 | $ | 5,400 | ||||||
| Accounts Receivable, Net | 2,800 | 3,300 | 2,600 | |||||||||
| Inventory | 1,600 | 3,400 | 2,000 | |||||||||
| Prepaid Expenses | 1,070 | 1,370 | 520 | |||||||||
| Other Current Assets | 380 | 430 | 280 | |||||||||
| Total Current Assets | 14,150 | 14,300 | 10,800 | |||||||||
| Property and Equipment, Net | 72,000 | 87,000 | 35,000 | |||||||||
| Total Assets | $ | 86,150 | $ | 101,300 | $ | 45,800 | ||||||
| Current Liabilities | $ | 11,200 | $ | 11,200 | $ | 12,200 | ||||||
| Long-Term Liabilities | 37,800 | 52,800 | 16,800 | |||||||||
| Total Liabilities | 49,000 | 64,000 | 29,000 | |||||||||
| Common Stock | 29,000 | 34,000 | 14,900 | |||||||||
| Retained Earnings | 8,150 | 3,300 | 1,900 | |||||||||
| Total Stockholders Equity | 37,150 | 37,300 | 16,800 | |||||||||
| Total Liabilities and Stockholders Equity | $ | 86,150 | $ | 101,300 | $ | 45,800 | ||||||
| Income Statement | ||||||||||||
| Sales Revenue | $ | 84,000 | $ | 60,000 | $ | 48,000 | ||||||
| Cost of Goods Sold | 67,400 | 50,400 | 37,400 | |||||||||
| Gross Profit | 16,600 | 9,600 | 10,600 | |||||||||
| Operating Expenses | 4,400 | 2,400 | 7,400 | |||||||||
| Income from Operations | 12,200 | 7,200 | 3,200 | |||||||||
| Interest Expense | 1,240 | 3,340 | 1,040 | |||||||||
| Income before Income Tax Expense | 10,960 | 3,860 | 2,160 | |||||||||
| Income Tax Expense | 3,450 | 1,200 | 900 | |||||||||
| Net Income | $ | 7,510 | $ | 2,660 | $ | 1,260 | ||||||
Required:
1-a. Calculate the gross profit percentage, return on equity, and fixed asset turnover ratio for 2018 and 2017.
1-b. Was NGS more profitable in 2018 or 2017?
2. Calculate the current ratio for 2018 and 2017.
3-a. Calculate the debt-to-assets ratio and times interest earned ratio for 2018 and 2017.
3-b. Was NGS more solvent in 2018 or 2017?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
