AutoSave OFF + 5 = Home Insert Draw Page Layout Paste 115 A BIU MAA363 T3 2020 Tax Assignment Excel proforma-2 Formulas Data Review View Tell me ' ab Wrap Text Insert 28 Delete v Merge & Center %9 Conditional Format Cell Formatting as Table Styles Format Sort & Filter x fx B C D E F G H 1 2 3 ut student ID here Student ID 218026291 4 5 6 7 8 9 10 11 12 13 14 15 16 Background information The profit before tax, reported in the statement of comprehensive income of DuperX Ltd for the year ended 30 June amounted to: 2020 7,760,000 Service revenue 242,000 iPrize money 436,000 iDoubtful debts expense Depreciation (Vehicle) Depreciation (Buildings) Maintenance expense Warranties expense Insurance expense Government issued fine The draft statements of financial position of the company at 30 June 2020 and 2019 showed the following assets and liabilities: 48,000 472,800 77,000 218,000 145,000 72,000 121,200 17 18 Assets 19 Cash 20 21 Inventory Accounts receivable 22 Allowance for doubtful debts 23 24 25 26 27 28 29 30 31 32 33 34 Prepaid insurance Vehicle Accumulated depreciation - Vehicle Buildings Accumulated depreciation - Buildings Land Patents Deferred tax asset Liabilities Accounts payable Provision for maintenance 2020 ($) 2019 ($) 509,000 1,091,000 557,000 994,000 3,152,000 3,007,000 (252,000) 135,000 3,152,000 (1,891,200) 1,940,000 (232,000) 126,000 3,152,000 (1,418,400) 1,940,000 | (776,000) (698,000) 1,212,000 1,212,000 485,000 485,000 ? 71,760 35 Provision for warranties 36 Service revenue received in advance 37 38 Deferred tax liability Background Information Calculating Taxable Income Calculating DTA DTL 2020 Change in Tax Rate Select destination and press ENTER or choose Paste 1,843,000 1,649,000 388,000 291,000 266,000 194,000 169,000 121,000 ? 0 Find & Select Share 4 Ideas Comments Sensitivity K M 115%