using excel

2 Question 1: Preparing financial statements: Use the following information to create an income statement, a statement of retained earnings and a classified balance sheet in the correct format for Dubai Company for the 3 year ended December 31, 2017. 4 5 Buildings 6 Accounts Receivable 7 Allowance for doubtful accounts 8 Prepaid insurance 9 Cash 10 Equipment 11 Land 12 Insurance expense 13 Depreciation expense 14 Interest expense 15 Long term stock investment 16 Common Stock 17 Retained earnings (Jan 1, 2017) 18 Franchise rights 19 Accumulated Depreciation - buildings 20 Accounts payable 21 Notes Payable (13,600 is due in 6 months) 22 Accumulated depreciation - equipment 23 Unearned service revenue 24 Service Revenue 25 26 $125,800 14,000 1,400 3,200 21,840 72,400 50,200 1,780 5,300 2,600 10,000 72,000 42,000 14,000 45,600 9,500 113,600 18,720 3,600 14,700