please provide excel calculations if possible. thank you

P17-4 (similar to) Lease versus purchase JLB Corporation is attempting to determine whether to lease or purchase research equipment. The firm is in the 22% tax bracket, and its after-tax cost of debt is currently 10%. The terms of the lease and of the purchase are as follows: Lease Annual end-of-year lease payments of $31,000 are required over the 3-year life of the lease. All maintenance costs will be paid by the lessor; insurance and other costs will be borne by the lessee. The lessee will exercise its option to purchase the asset for $3,000 at termination of the lease. Ignore any future tax benefit associated with the purchase of the equipment at the end of year 3 under the lease option. Purchase The research equipment, costing $75,000, can be financed entirely with a 12% loan requiring annual end-of-year payments of $31,226 for 3 years. The firm in this case will depreciate the equipment under MACRS using a 3-year recovery period. (See for the applicable depreciation percentages.) The firm will pay $2,600 per year for a service contract that covers all maintenance costs; insurance and other costs will be borne by the firm. The firm plans to keep the equipment and use it beyond its 3-year recovery period. a. Calculate the after-tax cash outflows associated with each alternative. (Hint: Because insurance and other costs are borne by the firm under both alternatives, those costs can be ignored here.) - X i Data Table a 5 years 1 W N Rounded Depreciation Percentages by Recovery Year Using MACRS for First Four Property Classes Percentage by recovery yeara Recovery 3 years 7 years 10 years year 33% 20% 14% 10% 2 45% 32% 25% 18% 3 15% 19% 18% 14% 4 7% 12% 12% 12% 5 12% 9% 9% 6 5% 9% 8% 7 9% 7% 8 4% 6% 9 6% 10 6% 11 4% Totals 100% 100% 100% 100% These percentages have been rounded to the nearest whole percent to simplify calculations while retaining realism. To calculate the actual depreciation for tax purposes, be sure to apply the actual unrounded percentages or directly apply double-declining balance depreciation using the half-year convention. Print Done