Table 1 Gillian Pool & Spa Supplies Balance Sheet 2011 2013 2012 2014 2015 ASSETS $155,000 $309,099 $75,948 $28,826 $18,425 Cash and Marketable Securities Accounts Receivable 10,000 12,000 20,000...


Calculate Gillian Pool and Spa Supplies’ average annual compound growth rate of sales, and analyze its earnings performance for the past five years.


Table 1<br>Gillian Pool & Spa Supplies<br>Balance Sheet<br>2011<br>2013<br>2012<br>2014<br>2015<br>ASSETS<br>$155,000 $309,099<br>$75,948 $28,826 $18,425<br>Cash and Marketable<br>Securities<br>Accounts Receivable<br>10,000<br>12,000<br>20,000<br>77,653<br>90,078<br>Inventory<br>250,000 270,000<br>500,000<br>520,000 560,000<br>$415,000 $591,099 $595,948 $626,480 $668,503<br>Current Assets<br>Land, Buildings,<br>Plant, and Equipment<br>$250,000 $250,000 $500,000 $500,000 $500,000<br>Accumulated Depreciation<br>-25,000 -50,000 -100,000 -150,000 -200,000<br>$225,000 $200,000 $400,000 $350,000 $300,000<br>Net Fixed Assets<br>$640,000 $791,099 $995,948 $976,480 $968,503<br>Total Assets<br>LIABILITIES AND EQUITIES<br>$50,000 $145,000 $140,000 $148,000 $148,000<br>Short-Term Bank Loans<br>Accounts Payable<br>10,506<br>10,000<br>19,998<br>15,995<br>16,795<br>Accruals<br>5,000<br>5,100<br>7,331<br>9,301<br>11,626<br>$65,000 $160,606 $167,329 $173,296 $176,421<br>Current Liabilities<br>$63,366 $98,000 $196,000 $190,000 $183,000<br>Long-Term Bank Loans<br>175,000 173,000 271,000<br>268,000 264,000<br>Mortgage<br>$238,366 $271,000 $467,000 $458,000 $447,000<br>Long-Term Debt<br>$303,366 $431,606 $634,329 $631,296 $623,421<br>Total Liabilities<br>Common Stock<br>(100,000 shares)<br>$320,000 $320,000 $320,000 $320,000 $320,000<br>25,082<br>Retained Earnings<br>16,634<br>39,493<br>41,619<br>25,184<br>$336,634 $359,493 $361,619 $345,184 $345,082<br>Total Equity<br>Total Liabilities<br>$640,000 $791,099 $995,948 $976,480 $968,503<br>and Equity<br>

Extracted text: Table 1 Gillian Pool & Spa Supplies Balance Sheet 2011 2013 2012 2014 2015 ASSETS $155,000 $309,099 $75,948 $28,826 $18,425 Cash and Marketable Securities Accounts Receivable 10,000 12,000 20,000 77,653 90,078 Inventory 250,000 270,000 500,000 520,000 560,000 $415,000 $591,099 $595,948 $626,480 $668,503 Current Assets Land, Buildings, Plant, and Equipment $250,000 $250,000 $500,000 $500,000 $500,000 Accumulated Depreciation -25,000 -50,000 -100,000 -150,000 -200,000 $225,000 $200,000 $400,000 $350,000 $300,000 Net Fixed Assets $640,000 $791,099 $995,948 $976,480 $968,503 Total Assets LIABILITIES AND EQUITIES $50,000 $145,000 $140,000 $148,000 $148,000 Short-Term Bank Loans Accounts Payable 10,506 10,000 19,998 15,995 16,795 Accruals 5,000 5,100 7,331 9,301 11,626 $65,000 $160,606 $167,329 $173,296 $176,421 Current Liabilities $63,366 $98,000 $196,000 $190,000 $183,000 Long-Term Bank Loans 175,000 173,000 271,000 268,000 264,000 Mortgage $238,366 $271,000 $467,000 $458,000 $447,000 Long-Term Debt $303,366 $431,606 $634,329 $631,296 $623,421 Total Liabilities Common Stock (100,000 shares) $320,000 $320,000 $320,000 $320,000 $320,000 25,082 Retained Earnings 16,634 39,493 41,619 25,184 $336,634 $359,493 $361,619 $345,184 $345,082 Total Equity Total Liabilities $640,000 $791,099 $995,948 $976,480 $968,503 and Equity
Table 2<br>Gillian Pool & Spa Supplies<br>Income Statements<br>2011<br>2012<br>2013<br>2014<br>2015<br>Net Sales<br>$900,000<br>$982,500 $1,170,000 $1,310,400 $1,520,064<br>Cost of Goods<br>Sold<br>1,100,736<br>729,000<br>801,900<br>962,280<br>1,305,000<br>$171,000<br>$180,600<br>$207,720<br>$209,664<br>$215,064<br>Gross Profit<br>$45,000<br>$58,950<br>$64,350<br>$91,204<br>Admin and<br>$72,072<br>Selling Exp<br>Depreciation<br>37,500<br>40,000<br>50,000<br>50,000<br>50,000<br>14,414<br>Miscellaneous<br>3,041<br>3,557<br>4,680<br>22,801<br>Expenses<br>$102,507<br>$136,486<br>$164,005<br>$85,541<br>$119,030<br>Total Operating Exp<br>$85,460<br>$78,093<br>$88,690<br>$73,178<br>$51,059<br>EBIT<br>$9,600<br>$9,600<br>$9,600<br>$17,760<br>$17,760<br>Interest on ST<br>Loans<br>5,400<br>Interest on LT<br>5,400<br>5,400<br>13,500<br>16,470<br>Loans<br>16,000<br>13,840<br>12,240<br>21,440<br>21,120<br>Interest on<br>Mortgage<br>$31,000<br>$28,840<br>$27,240<br>$52,700<br>$55,350<br>Total Interest<br>Before-Tax<br>$54,460<br>$49,253<br>$61,450<br>$20,478<br>($4,291)<br>Earnings<br>21,784<br>8,191<br>Тахes<br>19,701<br>24,580<br>-1,716<br>$32,676<br>$29,552<br>$36,870<br>$12,287<br>($2,574)<br>Net Income<br>Dividends on<br>Stock<br>Additions to<br>$32,676<br>$29,552<br>$36,870<br>Retained<br>$12,287<br>($2,574)<br>Earnings<br>

Extracted text: Table 2 Gillian Pool & Spa Supplies Income Statements 2011 2012 2013 2014 2015 Net Sales $900,000 $982,500 $1,170,000 $1,310,400 $1,520,064 Cost of Goods Sold 1,100,736 729,000 801,900 962,280 1,305,000 $171,000 $180,600 $207,720 $209,664 $215,064 Gross Profit $45,000 $58,950 $64,350 $91,204 Admin and $72,072 Selling Exp Depreciation 37,500 40,000 50,000 50,000 50,000 14,414 Miscellaneous 3,041 3,557 4,680 22,801 Expenses $102,507 $136,486 $164,005 $85,541 $119,030 Total Operating Exp $85,460 $78,093 $88,690 $73,178 $51,059 EBIT $9,600 $9,600 $9,600 $17,760 $17,760 Interest on ST Loans 5,400 Interest on LT 5,400 5,400 13,500 16,470 Loans 16,000 13,840 12,240 21,440 21,120 Interest on Mortgage $31,000 $28,840 $27,240 $52,700 $55,350 Total Interest Before-Tax $54,460 $49,253 $61,450 $20,478 ($4,291) Earnings 21,784 8,191 Тахes 19,701 24,580 -1,716 $32,676 $29,552 $36,870 $12,287 ($2,574) Net Income Dividends on Stock Additions to $32,676 $29,552 $36,870 Retained $12,287 ($2,574) Earnings
Jun 07, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here