Question: I dont know if my answer is fully right or not, can someone help me answer this assignment on my excel sheet. thank you Refer

I dont know if my answer is fully right or not, cansomeone help me answer this assignment on my excel sheet. thank youRefer to Gazelle Corporation's financial statements and related information in Problem 12-3B.I dont know if my answer is fully right or not, can someone help me answer this assignment on my excel sheet. thank you

Refer to Gazelle Corporation's financial statements and related information in Problem 12-3B. Required Prepare a complete statement of cash flows; report its operating activities according to the direct method. Disclose any noncash investing and financing activities in a note. Problem 12-3B: Gazelle Corporation, a merchandiser, recently completed its calendar-year 2015 operations. For the year, (1) all sales are credit sales, (2) all credits to Accounts Receivable reflect cash receipts from customers, (3) all purchases of inventory are on credit, (4) all debits to Accounts Payable reflect cash payments for inventory, and (5) Other Expenses are paid in advance and are initially debited to Prepaid Expenses. The company's balance sheets and income statement follow. GAZELLE CORPORATION Comparative Balance Sheets December 31, 2015 and 2014 2015 2014 $123,450 77,100 240,600 15,100 456,250 262,250 (110,750) $607,750 $ 61,550 80,750 250,700 17,000 410,000 200,000 (95,000) $515,000 Assets Cash ........ Accounts receivable Inventory .. Prepaid expenses ... Total current assets ....... Equipment ........ Accum. depreciation-Equipment ... Total assets Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities.. Long-term notes payable Total liabilities .. Equity Common stock, $5 par. Paid-in capital in excess of par, common stock Retained earnings Total liabilities and equity ...... $ 17,750 15,000 32,750 100,000 132,750 $102,000 10,000 112,000 77,500 189,500 215,000 200,000 30,000 230,000 $607,750 125,500 $515,000 GAZELLE CORPORATION Income Statement For Year Ended December 31, 2015 $1,185,000 595,000 590,000 Sales .............. Cost of goods sold ...... Gross profit Operating expenses Depreciation expense ......... Other expenses ......... Total operating expenses .. $ 38,600 362,850 401,450 188.550 Other gains (losses) Loss on sale of equipment Income before taxes ........ Income taxes expense .. Net income .............. (2,100) 186,450 28,350 158,100 $ Additional Information on Year 2015 Transactions a. The loss on the cash sale of equipment was $2,100 (details in b). b. Sold equipment costing $51,000, with accumulated depreciation of $22,850, for $26,050 cash. c. Purchased equipment costing $113,250 by paying $43,250 cash and signing a long-term note payable for the balance. d. Borrowed $5,000 cash by signing a short-term note payable. e. Paid $47,500 cash to reduce the long-term notes payable. f. Issued 3,000 shares of common stock for $15 cash per share. g. Declared and paid cash dividends of $53,600. Required 1. Prepare a complete statement of cash flows; report its operating activities using the indirect method. Disclose any noncash investing and financing activities in a note. Analysis Component 2. Analyze and discuss the statement of cash flows prepared in part 1, giving special attention to the wisdom of the cash dividend payment. Cash flows from operating activities: Net Income Add: Depreciation expense recorded Add: Decrease in prepaid insurance Add: Increase in wages payable Less: Increase in accounts receivable Less: Increase in merchandise inventory Less: Increase n computer supplies Less: Decrease in accounts payable Less: Decrease in unearned revenue Net cash used by operating activities o operating i investing f financing Business Solutions Cash Flow Worksheet For the three months ended March 31,2020 Dr (ar) 2020 2019 Difference 68,057 48,372 19,685 A Schedule of change in Retained Earnings: 22,867 5,668 (17,199) O Net Income 18,8330 704 170410 Dividends paid 14,800) F 2,005 580 (1,425) O Net Change 14,033 1.110 1.665 5550 825825 8.000 8.000 Office Eq. Depreciation 400 (800) (400) 400 B B Computer Eq. Deprecia 1,250 20,000 20.000 Total Depreciation 1,6500 (2,500) (1.250) 1,250 B - (1.100) (1,100) operating (515) (875) (500) 3750 investing . (1.500) (1.500) financing 20,200 (98,000) (73,000) 25,000 F Increase in cash 19,685 (21,393) (7,360) 14,033 A $18.833 1,650 555 375 (17,199) (704) (1.425) (1.10031 (1,500) (515) Cash Accounts receivable Merchandise Inventory Computer supplies Prepaid insurance Prepaid rent Office equipment Accur. Dep. - Office Eq. Computer equipment Accum. Dep. - Computer Eq. Accounts payable Wages payable Unearned revenue Common Stock Retained Earnings Totals Cash flows from investing activities Cash flows from financing activities: Cash received from issuance of common stock Cash paid for dividends Net cash provided by financing activities 25,000 (4.800) 20.200 Net increase in cash Cash balance at December 31, 2019 Cash balance at March 31, 2020 19,685 48,372 68,057

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!