Do table 25.2 please change the depreciation rate and method from 5 years straight line to MACRS. Please show the spreadsheet calculating the amount of the depreciation tax shield. I will attach MACRS Info if you ask for additional info

Ices from Leasing Versus Buying Year N Buy Additional Assumptions Capital Expenditures (50,000) Debt Cost of Capital (Pretax) 2 Depreciation Tax Shield at 25% Corporate Tax Rate 25% Free Cash Flow (Buy) (50,000) Debt Cost of Capital (After-Tax) Lease Capital Expenditures 50,000 4 Lease Payments (12,000) (12,000) (12,000) (12,000) (12,000) Lease Payments 12,000 5 Income Tax Savings at 25% Straightine Years of Dep Free Cash Flow (Lease) (12,000) (12,000) (12,000) (12,000) (12,000) TABLE 25.2 SPREADSHEET Incremental Free Cash Flows of Leasing Versus Buying Year Lease versus Buy ($) FCF Lease Less: FCF Buy Lease-Buy