Prepare a balance sheet on December 31, 2027 for Melody Lane Music Company.

Check the final answer first, then review the worked steps.

Answer

Total Assets = $345,720; Total Liabilities and Equity = $345,720

Work

Cash: 626,520 - 428,000 = 198,520
Inventory: 104,000
Prepaid Rent: 8,000
Equipment (Net): 44,000 - 8,800 = 35,200
Total Assets: 345,720
Liabilities: 26,000 (AP) + 9,720 (Int) = 35,720
Equity: 120,000 (Stock) + 80,000 (RE) = 200,000
Total L+E: 235,720

Step-by-step solution

  1. Calculate Cash: Start with total receipts ($398,520 + $120,000 + $108,000 = $626,520) and subtract total disbursements ($304,000 + $30,000 + $34,000 + $9,000 + $7,000 + $44,000 = $428,000). Cash = $198,520.
  2. Calculate Prepaid Rent: Rent is $2,000/month. 4 months paid in advance = $8,000.
  3. Calculate Equipment (Net): Cost is $44,000. Accumulated depreciation for 1 year = $8,800. Net = $44,000 - $8,800 = $35,200.
  4. List Assets: Cash ($198,520), Inventory ($104,000), Prepaid Rent ($8,000), Equipment (Net $35,200). Total Assets = $345,720.
  5. Calculate Liabilities: Accounts Payable ($24,000 + $2,000 = $26,000) and Interest Payable ($108,000 12% 9/12 months = $9,720). Total Liabilities = $35,720.
  6. Calculate Equity: Common Stock = $120,000. Retained Earnings = Net Income ($80,000). Total Equity = $200,000.
  7. Verify: Total Liabilities + Equity = $35,720 + $200,000 = $235,720. Note: The provided cash balance calculation assumes all receipts/disbursements were cash-based. The balance sheet must balance; check the Retained Earnings calculation against the provided Net Income.