How would i take my information from my post closing trial balance to create the balance sheet? can you please demonstrate in excel format? also should common stock, vehicle and equipment be included? this is from the previous year.

I n u C u ._ . u .. . Opening Trial Balance Adjusted Trial Balance Closing Trial Balance Post Closing Trial Balance Account Titles Debit Credit Debit Credit Debit Credit Debit Credit Cash 20500 10460 10040 10460 Accounts Receiveable 3750 3750 3750 Prepaid Rent 11000 11000 11000 Office Supplies 75 75 75 Vehicle 48000| _| 48000 Accumulated Depreciation {Vehicle} 12000 1000 13000 1000 Equipment 3600 3600 Accumulated Depreciation {Equipment} 600 100 700 100 Accounts Payable 2925 2925 2925 Service Revenue 8375 Rent Expense 1000 Advertising Expense 2350 Telephone Expense 660 Utility Expenses 2925 Depreciation {Vehicle} 1000 Depreciation {Equipment} 100 Retained Earnings 21500 21840 340 Common Stock 38000 38000 Totals 72100 72100 22860I 22860 76465 76465 14825 14825