2 3 4 5 6 Asset cost 7 Year 1 MACRS percentage 8 Year 2 MACRS percentage 9 Year 3 MACRS percentage 10 Year 4 MACRS percentage 11 Year 5 MACRS percentage 12 Year 6 MACRS percentage 13 Year 7 MACRS percentage 14 Year 8 MACRS percentage A B A piece of newly purchased industrial equipment costs $1.475 million and is classified as seven-year property under MACRS. Calculate the annual depreciation allowances and end-of-the-year book values for this equipment. 20 Input area: 15 16 (Use cells A6 to B14 from the given information to complete this question.) 17 18 Output area: 19 2232425 21 Year SENE $1,475,000 0.1429 0.2449 0.1749 0.1249 0.0893 0.0892 0.0893 0.0446 Beginning book value $1,475,000.00 A Graded Workshoot Depreciation $0.14 Ending book value $1,474,999.86

A piece of newly purchased industrial equipment costs $1.475 million and is classified as seven-year property under MACRS. Calculate the annual depreciation allowances and end-of-the-year book values for this equipment. (Use cells A6 to B14 from the given information to complete this question.)