using excel, how would i type in the formulas needed to complete the MACRS

The equipment costs $1,000,000, and, if it were purchased, Bolden could obtain a term loan for the full purchase price at 210 pereent interest rate. Although the equipment has a aix year useful life, it is chassified as a special purpose computer, so it falls into the MACRS three-year class. If the aystem were purchased, a four-year maintenance contract could be obtained at a cost of $20,000 per year, payable at the boginning of each year. The i. equipment would be sold after four years, and the best estimate of its residual value at that time is $200,000. Howerer, aince real-time display aystem technology is changing rapidly, the actual residual value is uncertain. As an alternatire to the borrow-and-buy plan, the equipment manufacturer informed Bolden that Consolidated Learing Center would be milling to write a foun-year guideline lesse on the equipment, including maintenance, for payments of $260,000 at the beginning of each yean. Bolden's marginal federal-plus-atate tax rate is 40 percent. You hare been asked to analyze the lease-renus-purchase decision, and in the process to answer the 36 ANSWRR