Question

In: Accounting

QUESTION 1 Below are the financial statements of Purple Panther Ltd. PURPLE PANTHER LTD Statement of...

QUESTION 1

Below are the financial statements of Purple Panther Ltd.

PURPLE PANTHER LTD

Statement of Financial Position

as at 31 December 2007

2007

2006

Assets

Cash

72,000

31,200

Accounts receivable

43,200

33,600

Inventory

81,600

84,000

Plant

168,000

187,200

Less: Accumulated depreciation

(72,000)

96,000

(57,600)

129,600

Total Assets

292,800

278,400

Liabilities and Equity

Accounts payable

69,600

79,200

Income tax payable

36,000

48,000

Debentures payable

36,000

24,000

Share capital

72,000

60,000

Retained earnings

79,200

67,200

Total Liabilities and Equity

292,800

278,400

PURPLE PANTHER LTD

Statement of Profit or Loss

for the year ended 31 December 2007

Sales

600,000

Cost of sales

432,000

Gross profit

168,000

Selling expenses

60,000

Administrative expenses

45,600

Interest expense

4,800

110,400

Profit before income tax

57,600

Income tax expense

16,800

Profit

40,800

The following additional data was provided:

  1. All operating expenses except depreciation are paid in cash.
  2. Additional equipment was purchased for $16,800 cash.
  3. Accounts payable pertains to inventory creditors.
  4. Dividends of $28,800 were declared and paid.
  5. All sales and purchases are on account.
  6. During the year furniture was sold for $24,000 cash. This furniture originally cost $36,000 and had an accumulated depreciation of $12,000 at the time of sale.
  7. All the depreciation expense, $26,400, is in the selling expense category.

Required:

  1. Prepare a statement of cash flows for the year ended 31 December 2007 for Purple Panther Ltd, use the direct method for operating cash flows.
  1. Peter Purple, the owner of the business, has come to you because he is confused about his current business situation. He asks you to explain to him how his cash from operations could be less than his profit for the year. Explain to Peter how this can be.

Solutions

Expert Solution

a.

PURPLE PANTHER LTD
Statement of Cash Flows
For the Year Ended December 31, 2007
Cash flows from operating activities:
Cash received from customers 590400
Cash payments for inventory -439200
Cash payments for operating expenses -79200
Cash payments for interest -4800
Cash payments for income taxes -28800
Net cash flow from operating activities 38400
Cash flows from investing activities:
Cash paid for purchase of equipment -16800
Cash received from sale of furniture 24000
Net cash flow used for investing activities 7200
Cash flows from financing activities:
Cash received from sale of common stock 12000
Cash received from issue of debentures 12000
Cash paid for dividends -28800
Net cash flow from financing activities -4800
Change in cash 40800
Cash at the beginning of the year 31200
Cash at the end of the year 72000

Working:

Cash received from customers
Sales Revenue 600000
Less: Increase in Accounts Receivable -9600
590400
Cash payments for inventory
Cost of sales 432000
Less: Decrease in Inventory -2400
Add: Decrease in Accounts Payable 9600
439200
Cash payments for operating expenses
Selling expenses 60000
Less: Depreciation -26400
Administrative expenses 45600
79200
Cash payments for income tax
Income tax expense 16800
Add: Decrease in Income tax payable 12000
28800

b.  The cash from operations is less than the profit due to several reasons which are shown below by way of a reconciliation between the two amounts.

Net profit $ 40800
Uncollected sales -9600
Non-cash expense of depreciation 26400
Payments in excess of expense:
For Income tax -12000
For inventory -7200 -2400
Cash from operations $ 38400

Related Solutions

The financial statements of Morgan Ltd appear below: Morgan LTD Comparative Statement of Financial Position 31...
The financial statements of Morgan Ltd appear below: Morgan LTD Comparative Statement of Financial Position 31 December 2018 ________________________________________________________________________________________ Assets                                                                                                         2018                    2017    Cash ..................................................................................................     $ 25,000              $ 40,000 Marketable securities ...........................................................................         15,000                 60,000 Accounts receivable (net) .....................................................................         50,000                 30,000 Inventory ............................................................................................       150,000                170,000 Property, plant and equipment (net) ......................................................       160,000                200,000       Total assets ..................................................................................     $400,000              $500,000 Liabilities and equity Accounts payable ................................................................................     $ 20,000              $ 30,000 Short-term notes payable .....................................................................         40,000                 90,000 Bonds payable...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales $ 3,300.0 $ 3,000.0 Operating costs excluding depreciation and amortization 2,475.0 2,550.0 EBITDA $ 825.0 $ 450.0 Depreciation and amortization 86.0 66.0 Earnings before interest and taxes (EBIT) $ 739.0 $ 384.0   Interest 72.6 66.0 Earnings before taxes (EBT) $ 666.4 $ 318.0   Taxes (25%) 266.6 127.2 Net income $ 399.8 $ 190.8 Common dividends...
eBook Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for...
eBook Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales $ 3,500.0 $ 2,800.0 Operating costs excluding depreciation and amortization 2,975.0 2,380.0 EBITDA $ 525.0 $ 420.0 Depreciation and amortization 67.0 56.0 Earnings before interest and taxes (EBIT) $ 458.0 $ 364.0   Interest 77.0 61.6 Earnings before taxes (EBT) $ 381.0 $ 302.4   Taxes (25%) 152.4 121.0 Net income $ 228.6 $ 181.4 Common...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales $ 3,190.0 $ 2,900.0 Operating costs excluding depreciation and amortization 2,712.0 2,465.0 EBITDA $ 478.0 $ 435.0 Depreciation and amortization 73.0 64.0 Earnings before interest and taxes (EBIT) $ 405.0 $ 371.0   Interest 70.2 63.8 Earnings before taxes (EBT) $ 334.8 $ 307.2   Taxes (25%) 133.9 122.9 Net income $ 200.9 $ 184.3 Common dividends...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales $ 3,105.0 $ 2,700.0 Operating costs excluding depreciation and amortization 2,562.0 2,295.0 EBITDA $ 543.0 $ 405.0 Depreciation and amortization 81.0 65.0 Earnings before interest and taxes (EBIT) $ 462.0 $ 340.0   Interest 68.3 59.4 Earnings before taxes (EBT) $ 393.7 $ 280.6   Taxes (25%) 157.5 112.2 Net income $ 236.2 $ 168.4 Common dividends...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales $ 3,480.0 $ 2,900.0 Operating costs excluding depreciation and amortization 2,871.0 2,465.0 EBITDA $ 609.0 $ 435.0 Depreciation and amortization 109.0 84.0 Earnings before interest and taxes (EBIT) $ 500.0 $ 351.0   Interest 76.6 63.8 Earnings before taxes (EBT) $ 423.4 $ 287.2   Taxes (25%) 169.4 114.9 Net income $ 254.0 $ 172.3 Common dividends...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales $ 2,420.0 $ 2,200.0 Operating costs excluding depreciation and amortization 1,997.0 1,870.0 EBITDA $ 423.0 $ 330.0 Depreciation and amortization 48.0 44.0 Earnings before interest and taxes (EBIT) $ 375.0 $ 286.0   Interest 53.2 48.4 Earnings before taxes (EBT) $ 321.8 $ 237.6   Taxes (25%) 128.7 95.0 Net income $ 193.1 $ 142.6 Common dividends...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales $ 1,440.0 $ 1,200.0 Operating costs excluding depreciation and amortization 1,116.0 1,020.0 EBITDA $ 324.0 $ 180.0 Depreciation and amortization 42.0 32.0 Earnings before interest and taxes (EBIT) $ 282.0 $ 148.0   Interest 31.7 26.4 Earnings before taxes (EBT) $ 250.3 $ 121.6   Taxes (25%) 100.1 48.6 Net income $ 150.2 $ 73.0 Common dividends...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales $ 3,480.0 $ 2,900.0 Operating costs excluding depreciation and amortization 2,610.0 2,465.0 EBITDA $ 870.0 $ 435.0 Depreciation and amortization 96.0 87.0 Earnings before interest and taxes (EBIT) $ 774.0 $ 348.0   Interest 76.6 63.8 Earnings before taxes (EBT) $ 697.4 $ 284.2   Taxes (25%) 279.0 113.7 Net income $ 418.4 $ 170.5 Common dividends...
eBook Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for...
eBook Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales $ 2,040.0 $ 1,700.0 Operating costs excluding depreciation and amortization 1,734.0 1,445.0 EBITDA $ 306.0 $ 255.0 Depreciation and amortization 39.0 36.0 Earnings before interest and taxes (EBIT) $ 267.0 $ 219.0   Interest 44.9 37.4 Earnings before taxes (EBT) $ 222.1 $ 181.6   Taxes (25%) 88.8 72.6 Net income $ 133.3 $ 109.0 Common...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT