The following information about the fixed assets for Iqra Books Inc. has been provided to you. Iqra uses straight-line depreciation. The assets were acquired on January 1 and have no residual value. Asset Cost Useful life at the date of acquisition Useful life remaining at December 31, 2022 Office building $5,000,000 15 years 10 years Warehouse $12,00,000 10 years 8 years

Using the SLN () function in Excel, calculate the depreciation expense for the office building and warehouse for the year ended December 31, 2022 (rounded to two decimal places).

Using Excel, calculate the accumulated depreciation and the carrying amount for the year ended December 31, 2022 (rounded to two decimal places).

Create a stacked column chart for each asset that shows the column as the asset value and the two stacks as carrying amount and accumulated depreciation.