Please show excel formulas! P2.4 (LO 3, 4, 5) (Financial Statements, Adjusting and Closing Entries) The trial balance of Bellemy Fashion Center contained the following accounts at November 30, the end of the company's fiscal year Bellemy Fashion Center Trial Balance November 30, 2025 Adjustment data: 1. Supplies on hand totaled $1,500. 2. Depreciation is $15,000 on the equipment. 3. Interest of $11,000 is accrued on notes payable at November 30. Other data: 1. Salaries expense is 70% selling and 30% administrative. 2. Rent expense and utilities expenses are 80% selling and 20% admin 3. $30,000 of notes payable are due for payment next year. 4. Maintenance and repairs expense is 100% administrative. strative. Cash Accounts Receivable. Inventory Supplies Equipment Accumulated Depreciation-Equipment Notes Payable Accounts Payable Common Stock Retained Earnings Sales Revenue Sales Returns and Allowances Cost of Goods Sold Salaries and Wages Expense Advertising Expense Utilities Expenses Maintenance and Repairs Expense Delivery Expense Rent Expense Instructions a. Journalize the adjusting entries. b. Prepare an adjusted trial balance. c. Prepare a multiple-step income statement (ignore taxes) and retained earnings statement for the year and a classified balance sheet as of November 30, 2025. d. Journalize the closing entries. e. Prepare a post-closing trial balance. Debit $ 28,700 33,700 45.000 5.500 133,000 Credit $ 24,000 51,000 48,500 90.000 8.000 757.200 4.200 495.400 140.000 26.400 14.000 12.100 16,700 24,000 $978,700 $978,700

Aajustmunt ifas: 1. Supplier on kand suled 51.500 2 Depiediatian is $15000 on the nquipment. 3. Invient of $11.000 is accrupt ae nebs payable at Navember 39 . Qhiner data L. Salaries eppente is 70F weling and 30% atmiaistrative + Maimanance add repairs ropense is 1064 adminiatrative. instructions a posmalias the adisuting entries. b. Preart an adjusios biat balasce e. foarmulite the claning entries. e. Prefare a post cloning trial haluece