4. 12.30 (Spreadsheet exercise) If B = $400,000, n = 8 years, S = 10% of B, and MARR = 12% per year, use the depreciation and book value schedule for the SYD method to determine the following: 1. Percent of the basis removed in the first 50% of useful life. 2. Depreciation rate for each year 1 through 8. 3. Comparison of book values after 10 years for SYD, SL, and MACRS methods.