Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Panther Marine Ratio Analysis June 30, 2017, 2016, 2015 Instructions: Calculate each of the below ratios for the current year. FOLLOW the below steps to
Panther Marine | |||||||||
Ratio Analysis | |||||||||
June 30, 2017, 2016, 2015 | |||||||||
Instructions: Calculate each of the below ratios for the current year. FOLLOW the below steps to complete the ratio analysis: | |||||||||
1. Round ALL answers 2 decimal places | |||||||||
2. Must SHOW ratio descriptions (see current ratio for example) | |||||||||
3. MUST use excel formulas and links to IS comparative and BS comparative worksheets within this workbook (see current ratio for example) | |||||||||
4. MUST indicate if current year answer is favorable, unfavorable, or same in realtion to prior year AND industry (see current ratio for example) | |||||||||
5. USE information at bottom of this worksheet to calculate certain ratios | |||||||||
6. If portion of ratio is not available, still use in ratio description and use 0 as part of formula | |||||||||
7. Inventory calculations do NOT include estimated returns inventory | |||||||||
8. USE below ratios and comparative statements to write a memo to Panther Marine management explaining your findings | |||||||||
6/30/2017 | 6/30/2016 | 6/30/2015 | INDUSTRY | Prior Year/Industry: Favorable, Unfavorable, Same | |||||
Liquidity | |||||||||
Current Ratio | 2.01 | 1 | 2.10 | 2.10 | 2.20 | Prior Year - Unfavorable | |||
Current Assets | 1,428,076 | 1,513,761 | 1,460,080 | Industry - Unfavorble | |||||
Current Liabilities | 709,775 | 752,362 | 723,971 | ||||||
Quick Ratio | 1.41 | 1.41 | 1.62 | ||||||
Accounts Receivable Turnover | 7.44 | 7.63 | 10.00 | ||||||
Inventory Turnover | 2.76 | 3.04 | 2.50 | ||||||
Profitability | |||||||||
Profit Margin | 4.45% | -2.32% | 3.5% | ||||||
Asset Turnover | 1.10 | 1.12 | 1.02 | ||||||
Return on Total Assets | 4.89% | -2.60% | 10.50% | ||||||
Return on Common Shareholders' Equity | 36.88% | -19.58% | 18.30% | ||||||
Earnings per Share (EPS) | $ 3.68 | $ (1.99) | $ 3.05 | ||||||
Price-Earnings (P/E ) Ratio | 11.13 | (15.54) | 12.54 | ||||||
Dividends per Share | $ 5.00 | $ 6.00 | $ 2.00 | ||||||
Solvency Ratios | |||||||||
Ratio of Fixed Assets to Long-Term Liabilities | 0.83 | 0.78 | 0.80 | ||||||
Fixed Assets (net) | |||||||||
Long-Term Liabilities | |||||||||
6/30/2017 | 6/30/2016 | 6/30/2015 | |||||||
Common Dividends | 200,000 | 250,000 | 300,000 | ||||||
Weighted Average Common Shares | 50,000 | 50,000 | 50,000 | ||||||
Market Price per Share | 46 | 41 | 31 |
June 30, 2017 | June 30, 2016 | June 30, 2015 | June 30, 2014 | June 30, 2013 | |||||||
Adjusted | Adjusted | Adjusted | Adjusted | Adjusted | |||||||
Trial Balance | Trial Balance | Trial Balance | Trial Balance | Trial Balance | |||||||
Acct. No. | Account Title | Dr. | Cr. | Dr. | Cr. | Dr. | Cr. | Dr. | Cr. | Dr. | Cr. |
100 | Cash | 384,504.00 | 407,574.24 | 392,194.08 | 419,109.36 | 376,813.92 | |||||
102 | Accounts Receivable | 555,666.00 | 589,005.96 | 566,779.32 | 605,675.94 | 544,552.68 | |||||
103 | Allowance for Doubtful Accounts | 22,580.00 | 23,934.80 | 19,588.80 | 24,612.20 | 22,128.40 | |||||
104 | Merchandise Inventory | 456,897.00 | 484,310.82 | 466,034.94 | 498,017.73 | 447,759.06 | |||||
105 | Estimated Returns Inventory | 32,500.00 | 34,450.00 | 33,150.00 | 35,425.00 | 31,850.00 | |||||
106 | Office Supplies | 5,689.00 | 6,030.34 | 5,802.78 | 6,201.01 | 5,575.22 | |||||
107 | Prepaid Insurance | 15,400.00 | 16,324.00 | 15,708.00 | 16,786.00 | 15,092.00 | |||||
120 | Investments - Trading | 80,000.00 | 84,800.00 | 81,600.00 | 87,200.00 | 78,400.00 | |||||
121 | Investments - Available for Sale | 35,400.00 | 37,524.00 | 36,108.00 | 38,586.00 | 34,692.00 | |||||
122 | Investments - Held to Maturity | 80,000.00 | 84,800.00 | 81,600.00 | 87,200.00 | 78,400.00 | |||||
123 | Valuation Allowance | 52,000.00 | 55,120.00 | 53,040.00 | 56,680.00 | 50,960.00 | |||||
140 | Land | 1,500,000.00 | 1,500,000.00 | 1,500,000.00 | 1,500,000.00 | 1,500,000.00 | |||||
145 | Building | 1,200,000.00 | 1,200,000.00 | 1,200,000.00 | 1,200,000.00 | 1,200,000.00 | |||||
146 | Accumulated Depreciation - Building | 750,000.00 | 720,000.00 | 690,000.00 | 660,000.00 | 630,000.00 | |||||
151 | Equipment | 85,000.00 | 80,000.00 | 80,000.00 | 80,000.00 | 75,000.00 | |||||
152 | Accumulated Depreciation - Equipment | 68,000.00 | 59,500.00 | 51,000.00 | 42,500.00 | 34,000.00 | |||||
153 | Office Furniture | 14,000.00 | 14,000.00 | 14,000.00 | 14,000.00 | 14,000.00 | |||||
154 | Accumulated Depreciation - Office Furniture | 12,000.00 | 10,000.00 | 8,000.00 | 6,000.00 | 4,000.00 | |||||
201 | Accounts Payable | 680,980.00 | 721,838.80 | 694,599.60 | 168,900.00 | 170,000.00 | |||||
202 | Wages Payable | - | - | ||||||||
203 | Interest Payable | - | - | ||||||||
204 | Dividends Payable | - | - | ||||||||
205 | Unearned Rent | 10,000.00 | 10,600.00 | 10,200.00 | 10,900.00 | 9,800.00 | |||||
206 | Customer Refunds Payable | 18,795.00 | 19,922.70 | 19,170.90 | 20,486.55 | 18,419.10 | |||||
250 | Notes Payable | 650,000.00 | 689,000.00 | 663,000.00 | 708,500.00 | 637,000.00 | |||||
251 | Bonds Payable | 1,300,000.00 | 1,378,000.00 | 1,000,000.00 | 1,417,000.00 | 1,274,000.00 | |||||
252 | Premium on Bonds Payable | 56,000.00 | 50,000.00 | 35,000.00 | 55,000.00 | 45,000.00 | |||||
253 | Discount on Bonds Payable | 16,000.00 | 10,000.00 | 10,000.00 | 12,000.00 | 15,000.00 | |||||
252 | Mortgage (Warehouse) Payable | 300,000.00 | 318,000.00 | 950,000.00 | 920,000.00 | 1,000,000.00 | |||||
300 | Common Stock, $2 Par, 100,000 Authorized; 50,000 shares Issued/Outstanding | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | |||||
301 | Paid In Capital - Excess of Par | 350,000.00 | 371,000.00 | 357,000.00 | 381,500.00 | 343,000.00 | |||||
330 | Retained Earnings | 222,158.00 | 258,022.60 | 358,176.52 | 281,556.86 | 294,694.17 | |||||
331 | Cash Dividends | 200,000.00 | 250,000.00 | 300,000.00 | 300,000.00 | 250,000.00 | |||||
340 | Treasury Stock | 50,000.00 | 60,000.00 | 20,000.00 | 20,000.00 | 10,000.00 | |||||
341 | Unrealized (Gain) Loss Available for Sale Securities | - | - | - | - | ||||||
500 | Sales | 4,056,800.00 | 4,137,936.00 | 4,302,480.00 | 4,097,368.00 | 3,935,096.00 | |||||
600 | Cost of Goods Sold | 1,285,698.00 | 1,311,411.96 | 1,464,267.80 | 1,298,554.98 | 1,247,127.06 | |||||
700 | Wage Expense (hourly workers) | 756,894.00 | 772,031.88 | 832,583.40 | 764,462.94 | 734,187.18 | |||||
701 | Salaries Expense (Exempt Staff) | 800,000.00 | 816,000.00 | 880,000.00 | 808,000.00 | 776,000.00 | |||||
702 | Marketing Expense | 295,000.00 | 300,900.00 | 324,500.00 | 297,950.00 | 286,150.00 | |||||
703 | Travel and Entertainment Expense | 56,789.00 | 57,924.78 | 62,467.90 | 57,356.89 | 55,085.33 | |||||
704 | Bad Debt Expense | 42,185.00 | 43,028.70 | 46,403.50 | 42,606.85 | 40,919.45 | |||||
705 | Property Tax Expense | 500,000.00 | 510,000.00 | 550,000.00 | 505,000.00 | 485,000.00 | |||||
706 | Office Maintenance & Repair Expense | 2,000.00 | 2,040.00 | 2,200.00 | 2,020.00 | 1,940.00 | |||||
707 | Accounting Expenses | 10,000.00 | 10,200.00 | 65,000.00 | 10,100.00 | 9,700.00 | |||||
708 | Insurance Expense | 12,000.00 | 12,240.00 | 13,200.00 | 12,120.00 | 11,640.00 | |||||
709 | Utilities Expense | 65,450.00 | 66,759.00 | 71,995.00 | 66,104.50 | 63,486.50 | |||||
710 | Office Supplies Expense | 546.00 | 556.92 | 600.60 | 551.46 | 529.62 | |||||
711 | Telecommunications Expense | 5,425.00 | 5,533.50 | 5,967.50 | 5,479.25 | 5,262.25 | |||||
712 | Depreciation Expense - Building | 30,000.00 | 30,000.00 | 30,000.00 | 30,000.00 | 30,000.00 | |||||
713 | Depreciation Expense - Equipment | 8,500.00 | 8,500.00 | 8,500.00 | 8,500.00 | 8,500.00 | |||||
714 | Depreciation Expense - Office Furniture | 2,000.00 | 2,000.00 | 2,000.00 | 2,000.00 | 2,000.00 | |||||
800 | Rent Income | 8,000.00 | 2,000.00 | 10,000.00 | 15,000.00 | 5,000.00 | |||||
801 | Unrealized Gain - Trading Securities | 5,500.00 | 1,200.00 | 5,600.00 | 16,000.00 | 8,000.00 | |||||
802 | Realized Gain - Investment Securities | 85,460.00 | 56,485.00 | 8,690.00 | 28,560.00 | 15,000.00 | |||||
900 | Interest Expense | 25,000.00 | 26,500.00 | 27,500.00 | 27,250.00 | 24,500.00 | |||||
901 | Unrealized Loss - Trading Securities | 2,500.00 | 2,650.00 | 2,750.00 | 2,725.00 | 2,450.00 | |||||
902 | Realized Loss - Investment Securities | 33,230.00 | 35,223.80 | 36,553.00 | 36,220.70 | 32,565.40 | |||||
Total | 8,696,273.00 | 8,696,273.00 | 8,927,439.90 | 8,927,439.90 | 9,282,505.82 | 9,282,505.82 | 8,953,883.61 | 8,953,883.61 | 8,545,137.67 | 8,545,137.67 | |
Total Expenses and Revenue | 3,933,217.00 | 4,155,760.00 | 4,013,500.54 | 4,197,621.00 | 4,426,488.70 | 4,326,770.00 | 3,977,002.57 | 4,156,928.00 | 3,817,042.79 | 3,963,096.00 | |
Net Income (Loss) | 222,543.00 | 184,120.46 | (99,718.70) | 179,925.43 | 146,053.21 |
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