Q1. Construct the balance sheet and income statements.
Q2. Construct the cash flow statement for 2015
Q3. Evaluate the firms absolute and relative liquidity positions in 2015, and compare them with its liquidity position in 2014
Q4. Carefully interperate the liquidity postions from Q3
Q5. For 2015, calculate the firms cash flow to investors (CFI) measure using its accounting statements
x Table 1 Gillian Pool & Spa Supplies Balance Sheet 2011 2012 2013 2014 2015 ASSETS Cash and Marketable Securities Accounts Receivable Inventory Current Assets Land, Building, Plant, and topment Accumulated Depreciation Not Fixed Asset Total Assets LIABILITIES AND EQUIT Short-Term Bank Loan Accounts Payable Acoru Current Labios $155.000 10.000 250.000 3415.000 1260.000 -25,000 $225,000 560,000 $300,000 12,000 270.000 3501000 250,000 50,000 $200,000 3701.000 575,046 20.000 500.000 $505. 6500,000 - 100.000 5400.000 05 040 526. 77,053 520,000 26.400 5600,000 - 150.000 $350.000 5070,400 $19,425 20.07 500,000 1000,000 1600,000 ..200.000 $300,000 5000.00 550.000 10.000 5.000 365.000 5145.000 10.500 5.100 $160,000 $140,000 19,00 7,331 $167.320 $140.000 15,005 0301 517320 5140.000 10.705 11020 5178,421 6.300 125.000 Long Term Bank Loan Mortgage Long Term Dobi Total Liabiti SOB.000 173.000 $71.000 5431.000 110.000 271.000 5467.000 1654,320 $100,000 8,000 $450,000 5631,00 1163.000 204.000 1447.000 $234.300 $300.000 Common Stock (100,000 shares) Retained Earrings Total Equity $320,000 16,654 3330,654 $320.000 30.495 1960.405 $320 DOO 41.619 $30.010 1320.000 25.184 54.14 $320.000 05.02 1345.0 5.600.000 1.000 3070.480 5068503 Total Liabi and Equity Table 2 Gillian Pool & Spa Supplies Income Statements 2012 2013 2014 2015 159 Net Sales Cost of Goods Sold Gross Profit Admin and selling Depreciation Mincolaneous Expenses Total Operating Exp EBIT Interest on ST Loans Interoton LT Loans Interest on Mortgage 2011 5000.000 720,000 $171.000 545,000 37.500 3,041 $26.541 $85.450 50.000 5.400 10,000 5002,800 001,000 $180,000 350.000 40,000 3,557 $102,507 $7.093 19,400 5.400 13.640 $1,170,000 902.000 $207,720 $64.350 50.000 4.000 $119,050 388,000 39.000 5.400 12.240 $1,310,400 1,100.750 1209,664 579,072 50.000 14,414 $136.40 573,170 $17.700 13.500 21.440 $1,620,064 1,305.000 $215,004 $91,204 50.000 22,801 $104,005 $51,080 517,700 10,470 21.120 4 be 39 Total Interest $31.000 3:28.640 27.240 52.700 555, Before Tax Laring $54,400 340.250 561.450 120/70 (54,2911 Tacos Not income Dividends on tok Addition to ined Earrings 21.784 2070 0 $32,670 10.01 30,00 0 SA 24.000 536870 0 30.070 101 S12.207 O 112287 1,710 (2.674) 0 182.670 70 72 7 0 31 8 RE x Table 1 Gillian Pool & Spa Supplies Balance Sheet 2011 2012 2013 2014 2015 ASSETS Cash and Marketable Securities Accounts Receivable Inventory Current Assets Land, Building, Plant, and topment Accumulated Depreciation Not Fixed Asset Total Assets LIABILITIES AND EQUIT Short-Term Bank Loan Accounts Payable Acoru Current Labios $155.000 10.000 250.000 3415.000 1260.000 -25,000 $225,000 560,000 $300,000 12,000 270.000 3501000 250,000 50,000 $200,000 3701.000 575,046 20.000 500.000 $505. 6500,000 - 100.000 5400.000 05 040 526. 77,053 520,000 26.400 5600,000 - 150.000 $350.000 5070,400 $19,425 20.07 500,000 1000,000 1600,000 ..200.000 $300,000 5000.00 550.000 10.000 5.000 365.000 5145.000 10.500 5.100 $160,000 $140,000 19,00 7,331 $167.320 $140.000 15,005 0301 517320 5140.000 10.705 11020 5178,421 6.300 125.000 Long Term Bank Loan Mortgage Long Term Dobi Total Liabiti SOB.000 173.000 $71.000 5431.000 110.000 271.000 5467.000 1654,320 $100,000 8,000 $450,000 5631,00 1163.000 204.000 1447.000 $234.300 $300.000 Common Stock (100,000 shares) Retained Earrings Total Equity $320,000 16,654 3330,654 $320.000 30.495 1960.405 $320 DOO 41.619 $30.010 1320.000 25.184 54.14 $320.000 05.02 1345.0 5.600.000 1.000 3070.480 5068503 Total Liabi and Equity Table 2 Gillian Pool & Spa Supplies Income Statements 2012 2013 2014 2015 159 Net Sales Cost of Goods Sold Gross Profit Admin and selling Depreciation Mincolaneous Expenses Total Operating Exp EBIT Interest on ST Loans Interoton LT Loans Interest on Mortgage 2011 5000.000 720,000 $171.000 545,000 37.500 3,041 $26.541 $85.450 50.000 5.400 10,000 5002,800 001,000 $180,000 350.000 40,000 3,557 $102,507 $7.093 19,400 5.400 13.640 $1,170,000 902.000 $207,720 $64.350 50.000 4.000 $119,050 388,000 39.000 5.400 12.240 $1,310,400 1,100.750 1209,664 579,072 50.000 14,414 $136.40 573,170 $17.700 13.500 21.440 $1,620,064 1,305.000 $215,004 $91,204 50.000 22,801 $104,005 $51,080 517,700 10,470 21.120 4 be 39 Total Interest $31.000 3:28.640 27.240 52.700 555, Before Tax Laring $54,400 340.250 561.450 120/70 (54,2911 Tacos Not income Dividends on tok Addition to ined Earrings 21.784 2070 0 $32,670 10.01 30,00 0 SA 24.000 536870 0 30.070 101 S12.207 O 112287 1,710 (2.674) 0 182.670 70 72 7 0 31 8 RE
