Unadjusted Trial balance

Dr Cr

Cash 11400

Accounts Receivable 5620

Supplies 1050

Prepaid Insurance 2400

Equipment 30000

Notes Payable 10000

Accounts Payable 12350

Capital 20000

Dividends 600

Service Revenue 13620

Salaries and Wages Expense 2200

Travel Expense 1300

Rent Expense 1200

Miscellaneous Expense 200

Total 55970 55970

Other data:

1. Supplies on hand total $280.

2. Depreciation is $800 per quarter.

3. Interest accrued on 6-month note payable, issued January 1, $300.

4. Insurance expires at the rate of $200 per month.

5. Services performed but unbilled at March 31 total $2,030.

Using your Unadjusted Trial Balance and adjusting entries prepared above, prepare the ten-column worksheet in Excel for the month ended 31 March 2023 (refer to page 162 174 of the prescribed text for an example of worksheet and financial statements). In the spreadsheet, you are required to have a data section separated from the worksheet section. Use formulas to generate all of the figures in the worksheet from the data section. Use the IF function for the Profit or Loss and also to check that the debit and credit columns balance.