| Life of equipment: | 3 | Tax rate: | 20% | Loan amount = equipment cost: | $100,000 | Maintenance costs: | $3,000 | Interest rate, simple: | 10.0% | Salvage value: | $30,000 | Lease Pmt: | $29,000 | | | Loan Analysis: | 0 | 1 | 2 | 3 | Totals | MACRS factor | | 0.3333 | 0.4445 | 0.1418 | 0.9196 | Depreciation | | 33,330 | 44,550 | 14,180 | 91,960 | | | | | | | Loan repayment | | | | 100,000 | | Interest | | 10,000 | 10,000 | 10,000 | | Int tax saving (Interest T) | | 2,000 | 2,000 | 2,000 | | Maintenance | 3,000 | 3,000 | 3,000 | | | Maint. tax saving (Maint. T) | 600 | 600 | 600 | | | Depr'n tax saving (Deprn T) | | 6,666 | 8,890 | 2,836 | | Net operating CF | 2,400 | 3,734 | 1,490 | 105,164 | | Salvage value before taxes | | | | 30,000 | | Book value (Cost Total dep'rn) | | | | 8,040 | | Taxable salvage value | | | | 21,960 | | Tax on salvage value | | | | 4,392 | | Salvage value after taxes | | | | 25,608 | | Total Net CF | 2,400 | 3,734 | 1,510 | 79,556 | | PV cost at I(1 T) = 8.00% | 70,306 | | | | | | | | | | | Lease Analysis: | 0 | 1 | 2 | 3 | | Lease payment | 29,000 | 29,000 | 29,000 | | | Tax saving on pmt | 5,800 | 5,800 | 5,800 | 0 | | Net cost of lease | 23,200 | 23,200 | 23,200 | 0 | | PV cost of leasing at I(1 T) | 64,572 | | | | | | | | | | | NAL = $5,734 | | | | | | |