prepare the income statement and balance sheet

unction Used Time Reference Trig Functions Function Library A3 fo =Formula!B9 B 1 Manpreet Corporation Trial balance 3 For the year ended August 31, 2019 4 Account Name Debit Credit 5 Accounts Payable $ $ 91,365.63 6 Accounts Receivable $ 4,16,814.00 $ 7 Accumulated depreciation - Office Equipment $ $ 93,866.51 8 Advertising Expense $ 2,403.87 $ 9 Allowance for Doubtful Accounts $ $ 11,504.07 10 Bad Debts Expense $ 2,061.15$ 11 Cash $ 1,67,615.60 $ 12 Common Shares $ 92,699.43 13 Cost of Goods Sold $ 12,45,866.42 $ 14 Depreciation Expense $ 10,809.03 $ 15 Dividends declared S 2,150.76 $ 16 Income Tax Payable S $ 2,81,432.81 17 Insurance Expense $ 2,540.48 $ 18 Interest Expense S 4,961.13 S 19 Interest Revenue $ s 1.581.81 20 Inventory S 96,200.67 $ 21 Land $ 2,98,939.00 S Directions Data Income Statement Balance Sheel N Insert Function AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time Reference Trig Functions Function Library A3 X fox =Formula!B9 A B 16 Income Tax Payable 17 Insurance Expense 18 Interest Expense 19 Interest Revenue 20 Inventory 21 Land 22 Long term Investments 23 Miscellaneous Expense 24 Mortgage Payable 25 Notes Payable - Short Term 26. Office Equipment 27 Office Expense 28 Prepaid Insurance 29 Rent Expense 30 Retained Earnings - Opening 31 Revenue received in Advance 32 Sales 33 Supplies Expense 34 Supplies Inventory 35 Tax Expense 36 Wages Expense 37 Total $ $ 2,81,432.81 $ 2,540.48 $ $ 4,961.13 $ $ $ 1,581.81 $ 96,200.67 $ $ 2,98,939.00 $ $ 6,44,561.17 $ $ 28,975.87 $ $ $ 6,12,383.13 $ $ 22,341.23 $ 1,48,385.78 $ $ 24,613.91 $ s 1,000.35 $ $ 1,35,244.68 S $ S 94,533.42 $ S 71,692,01 $ 23,96,680.50 S 6,375.17 S 2,500.88 $ $ 2,56,468.78 $ S 2,71,591.83 S S 37,70,081 S 37,70,081 Income Statement Balance Sheet USU U U U U Directions Data w