Exit Fullscreen Complete the following assignment and submit your work to the dropbox. Complete a Transaction Analysis Sheet and Balance Sheet for the Merrymen Window Washing Company operated by Carl Savish. The Transaction Analysis Sheet and Balance Sheet can be found in my morning post If using a computerized spreadsheet, TRY to create formulas rather than using a calculator and typing in the value totals. If you use the features of Excel or Google Sheets and are able to enter formulas it'll be much easier since totals are automatically updated. There is no need to give the balance after each transaction line; Only show the final balance line at the end of the transaction analysis sheet. (see example of the "Condensed Transaction Analysis Sheet" on the Content page). Use the template provided in my post but If you are unable to use a computerized spreadsheet, please use the attached blank Transaction Analysis Sheet to show me your work. 1. Paid $800 to reduce the amount of the loan payable to Simplex Finance 2. The company purchases on credit $400 worth of supplies from Hipp Co. 3. The company received $200 cash from T. Kwan in partial payment of his debt 4. A new hoist (equipment) is purchased from NRC Co. for $2125. A cash down payment of $300 is made. The balance of the purchase price is to be paid at a later time. 5. The old hoist included in the equipment figure at $550 is sold for $100 cash. The old is reflected in the owner's worth. 6. A $500 window-washing service is performed for D. Pederson. Pederson pays $575 both for this service and to pay off the amount owed. 7. The truck was in a serious collision and is a total write-off. The insurance company pays Merrymen Window Washing $14500 in cash 8. The loan payable to Simplex Finance is paid off. 9. A new truck costing $23000 is purchased. An $8000 down payment is made and the balance is financed by Simplex Finance to be paid at a later time. 10. The amount owed to Hipp Co. is paid in full. 11. Supplies valued at $50 are taken out on a job and is used by the owner and the business. RubricMerrymen Window Washing Assets Liabilities Owner's Equity 5 Accounts Receivable Cash Supplies Equipment Trucks Accounts and Loans Payable C. Savish, Capital Zero Proof 6 T. Kwan D. Pederson Cleanall Hipp NRC Co. Simplex Opening Balances 2,750.00 420.00 75.00 880.00 12,947.00 15,050.00 124.00 475.00 0.00 8,560.00 22,963.00 Transaction 1 Transaction 2 10 Transaction 3 Transaction 4 12 Transaction 5 13 Transaction 6 14 Transaction 7 15 Transaction 8 16 Transaction 9 17 Transaction0 Transaction 11 10 Ending Balances 20 21 22