9.3A part c: (Use this information for reference for my actual question; I do not need the solution to the words in paranthesis; only what I ask after:A company purchased new shelving for its store in April 1, 2024. The shelving is expected to have a 20-year life and no residual value. The following expenditures were associated with the purchase: Cost of shelving- $12,000 Freight charges- $520 Sales taxes- $780 Installation of shelving- $2,700 Cost to repair shelf damaged during installation- $400 Prepare a depreciation schedule for the years 2024- 2027 under each depreciation method listed as follows. Include annual depreciation expense, accumulated depreciation, and book value for each year

1. straight-line, with fractional years rounded to the nearest whole month
2. 200% declining-balance, using the half-year convention
3. 150% declining-balance, using the half-year convention

(If any calculations or formulas are used in making the spreadsheets please include those))) THE REAL QUESTON based off the above information: Which of the depreciation methods applied above will result in the lowest reported book value at the end of 2027? Is book value an estimate of an asset's fair value? Explain