1) use an accounting worksheet to analyse transactions and performing balance-day

adjustments for the months activities. An Excel worksheet to assist you is

available.

2) prepare financial statements: Income Statement, Balance Sheet, and Classified

Statement of Cash Flows.

3)The Statement of Cash Flows must be classified, i.e. cash flows must be shown in the categories of operating, investing, and financing cash flows;

You must use the Direct Method to prepare the Statement of Cash Flows. Show all calculations;

Proprieto Name Ms. Ferntrees Gally Muscle Up Description Gymnasium and Health Club Additional Information: The business has the following opening balances: Stationery Supplies Gym Equipment Bank Loan (due 2022) Account Payable Motor Vehicle Account Receivable Cash At Bank $495 S18,616 Closing stock of stationery supplies on 30 6 (S) S21,428 Gym equipment scrap value (S) S9,239 Gym equipment useful life (years) 35,903 Rent paid for (months) S17,04 Insurance paid for (months) S17,182 Motor vehicle scrap value (S) 517 4,S18 5,162 Motor vehicle useful life (years) Bank loan interest rates (% per year) Transactions: Dstepd Description Amount Date 1-Jun Paid General Insurance 1Jun Motor Vehicle Expenses 3-Jun Rent of Business Premises 6-Jun Membership fees Cash S-Jun Advertising Expense - Account 9-Jun Payment to Account Payable 11-Jun Squash fees Cash 13-Jun Gym fees Account 13-Jun Purchase stationery Supplies 15-Jun Advertising Expense Cash 16-Jun Advertising Expense Account 16-Jun Purchase stationery Supplies 1S-Jun Squash fees - Account 19-Jun Gym fees Cash Amount $164 $2,106 S1,379 $522 1,484 $464 $2,677 5665 $593 1,484 S213 1,097 $826 $1,652 2,271 Jun Sundry Expenses 138 Jun Squash fees Cash 4,025 4-Jun Receive Payment from Account Customers S2,529-Jun Cash Withdrawals by Owner $739 S-Jun Staff Wages SS50 9-Jun Advertising Expense Cash 2,345 12-Jun Membership fees Cash 984 13-Jun Equipment hiring expense Account $406 13-Jun Cash Withdrawals by Owner 393 15-Jun Staff Wages 753 16-Jun Motor Vehicle Expenses $451 18-Jun Payment to Account Payable 1,328 19-Jun Gym fees- Account $1,498 19-Jun Gym fees Cash