LICELIUrner CUITULIuna format as Cell Formatting Table Styles Cells Editing Clipboard 15 Font Styles A1 X B D E F 2 G H 3 A piece of newly purchased industrial equipment costs $1,240,000 and is classified as seven-year property under MACRS. Calculate the annual depreciation allowances and end-of-the-year book values for this equipment. 4 5 Complete the following analysis. Do not hard code values in your calculations. 6 6600 V A Depreciation Ending Book value Year Beginning Book Value $ 1,240,000.00 2 3 4 WN - CD 9 10 MACRS 0.1429 0.2449 0.1749 0.1249 11 3 A piece of newly purchased industrial equipment costs $1,240,000 and is classified as seven-year property under MACRS. Calculate the annual depreciation allowances and end-of-the-year book values for this equipment. 4 5 Complete the following analysis. Do not hard code values in your calculations. 6 7 Depreciation Ending Book value 8 Year Beginning Book Value 1 $ 1,240,000.00 2 3 9 10 11 OOOO AWN- MACRS 0.1429 0.2449 0.1749 0.1249 0.0893 0.0892 0.0893 0.0446 12 4 5 6 7 8 13 14 15 16 17 4