Question: If using Excel could you please include screenshots of the formulas used? Soft Touch Company was started several years ago by two golf instructors. The

If using Excel could you please include screenshots of the formulas used?

If using Excel could you please include screenshots of the formulas used?Soft Touch Company was started several years ago by two golf instructors.

Soft Touch Company was started several years ago by two golf instructors. The company's comparative balance sheets and income statement are presented below, along with additional Information. Current Year Previous Year Balance sheet at December 31 Cash Accounts Receivable Equipment Accumulated Depreciation-Equipment Total Assets Accounts Payable Salaries and Wages Payable Note Payable (long-term) Common Stock Retained Earnings Total Liabilities and Stockholders' Equity Income Statement Service Revenue Salaries and Wages Expense Depreciation Expense Income Tax Expense Net Income $ 13,500 2,500 11,000 (3,880) $ 24,00 $ 1,200 1,000 3,00 10,000 9,000 $ 24,00 $ 8, eee 3,500 10, eee (2,500) $19,900 $ 2,80 1,5ee 1,000 10,000 4,500 $19, see $75, mee 68,00 5ee 2, see $ 4, 5ee Additional Data: a. Bought new golf clubs using cash, $1.000. b. Borrowed $2,000 cash from the bank during the year. c. Accounts Payable Includes only purchases of services made on credit for operating purposes. Because there are no liability accounts relating to Income tax, assume that Income Tax Expense was fully paid In cash. Required: 1. Prepare the statement of cash flows for the current year ended December 31 using the Indirect method. (Amounts to be deducted should be indicated with a minus slgn.) SOFT TOUCH COMPANY Statement of Cash Flows For the Year Ended December 31 Cash Flows from Operating Activities: Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities: 0 Cash Flows from Investing Activities: 0 Cash Flows from Financing Activities: 0 S

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!