Marci Vigiani is a registered massage therapist in Ottawa, Ontario. A list of the assets and liabilities as of June 30, 2-, for her business, Marci's Massage Therapies, appears below. The assets and liabilities are not listed in the correct order.

Cash, $1 386; Bank Loan, $6000; A/R-J. Goertzen, $320; Equipment, $6809; A/P-BodyWorks Supply, $1345; Supplies, $655 A/R-L. Tyler, $480; Furniture, $3300; A/P-Live Well Equipment, $984.

A. Set up a simple T-account ledger for the business.

B. Using your organised ledger as a guide, make a balance sheet for the business.

May you please help me with this question and help me create the tables and sheets? I am unable to figure out how to do it. If you are also able to attach an excel of the tables and sheets, I would be very grateful. Thank you.