please include excel functions

Paste BIU- 125 points Cells Editing Alignment Number Conditional Formatas Cell formatting Table Style Styles Clipboard Font > 8 04:12:58 A1 Skipped c B D G 1 2 3 cBook 4 Ask 5 6 7 Print 8 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 Complete the following analysis. Do not hard code values in your calculations. Year Beginning Book Value MACRS Depreciation Ending Book value $ 1.240.000.00 0.1429 2 0.2449 0.1749 0.1249 5 0.0893 0.0892 0.0893 00446 1 9 N c 10 3 4 Rofences 11 12 13 14 15 16 CO 0 0 6 7 8 12 18 19 Sheet1