due tonight.

85 86 Problem 2: 7 Year Your fimm recently purchased an industrial machine costing $555,000. It is classified as a seven-year property under MACRS. 87 What are the annual depreciation allowances and end-of-the-year book values for this machine? 88 89 Finance Concept: For tax purposes, the depreciation expense is computed under MACRS, which was 90 enacted as part of the Tax Reform Act of 1986. The depreciation is larger at the beginning Beginning Book 92 Depreciation Year Ending Book Value MACRS Allowance 93 Value 1 555,000 94 2 95 3 96 4 97 5 98 99 7 100 8 101 102 103 6 Solution: 104 Solution: 1 Enter the Beginning Book Value (cost of the machine) in cell E93. 2 Calculate the remaining Beginning Book Values: enter =193 in cell E94 and copy down the column. 3 Calculate the Depreciation Allowance by multiplying $E$93 (Beg Bk V) * F93 (MACRS %). 4 Find the Ending Book Value by subtracting the depreciation from the Beginning Book Value. 5 Copy all your formulas down the columns 6 Year 8 Ending Book Value should equal zero, and beg bk val = depreciation in year 8