Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Control Systems

Authors: Frank G.H. Hartmann Professor, Kalle Kraus, Göran Nilsson, Robert N. Anthony, Vijay Govindarajan

2nd Edition

1526848317, 978-1526848314

More Books

Students also viewed these Accounting questions

Question

3.4 Define HRIS and describe its main components.

Answered: 1 week ago