(PLEASE USE FORMULAS, NOT EXCEL)

CSUN uses MACRS depreciation with the half-year convention and it has decided to purchase a mainframe computer system & high end copier machines. CSUN'S CFO asked the accounting department to list the depreciation schedule well-in-advance so that a better tax-savings approach can be adopted. Given the following data: First cost = $550,000 Salvage Value = $50,000 Tabulate the annual findings/figures to include the following: Depreciation Amount Book Value Year MACRS%