Question

A piece of newly purchased industrial equipment costs $1,375,000 and is classified as seven-year property under MACRS. The MACRS depreciation schedule is shown in Table 10.7. Calculate the annual depreciation allowances and end-of-the-year book values for this equipment. (Leave no cells blank - be certain to enter "O" wherever required. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Depreciation Year Beginning Book Value Ending Book Value 1 2 3 4 6 7

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

proiects (Autosav File Home Insert Page Layout Formulas Data Review View Add-Ins - Cut Ea Copy AutoSum A A Wrap Text Calibri 11 General Fill A Merge & Center Conditional Format Insert Delete Format Paste S % Cell Sort & Find & BIU 2 Clear Format Painter er Select Formatting ble Styles Clipboard Font Alignment Number Styles Cells Editing X90 S T U V W Y 78 79 NOTE DEPRECIATION COST 1375000 80 BEGINNING BOOK VALUE DEPRECIATION 81 YEAR DEPRECIATION BEGINNING DEPRECIATION ENDING RATE 82 BOOK VALUE BOOK VALUE 83 1 14.29 1375000.00 196487.50 1178512.50 84 2 24,49 1178512.50 336737.50 841775.00 85 17.49 841775.00 240487.50 601287.50 4 86 12.49 601287.50 171737.50 429550.00 87 5 8.93 429550.00 122787.50 306762.50 8.92 88 6 306762.50 122650.00 184112.50 89 7 8.93 184112.50 122787.50 61325.00 90 4,46 8 61325.00 61325.00 0.00 91 92 YEAR 1 DEPRECIATION: 1375000 X 14.29 % NOTE 93 94 YEAR 2 DEPRECIATION 1375000 X 24.49% 95 AND SO ON 96 STats NPVBETA LEVERED 14 H HPR GMAM EAC MACRS LEASE REPLACEMENT ABONDON Sheet2 SENSIT 130 % RATIOCASHBUDGET STEIN indiffEPS EBIT BOND BASE CASE wacc Re erences 03:49 AENG 4-06-2019