R Construction needs a piece of equipment that costs $200 million. R can either lease the equipment or borrow $300 million from a local bank and buy the equipment. If the equipment is leased, the lease would not have to be capitalized. Assume that Rs tax rate is 30% and that the equipments depreciation would be $100 million per year. If the company leased the asset on a 3-year lease, the payment would be $110 million at the beginning of each year. If R borrowed and bought, the bank would charge 10% interest on the loan. In either case, the equipment is worth nothing after 3 years and will be discarded. Should R lease or buy the equipment?

requirement: prepare excel sheet