Please explain in Excel. Thank you!

High energy costs have made a piece of equipment in your firm's production process obsolete. Two machines are available to replace the existing equipment. Here are the details for Option A and Option B: Option A: Lease Option B: Purchase - Lease payments of $65,000 per year - Purchase for $330,000 - 5 years, due at the beginning of each year - Energy savings of $25,000 per year - Save \$15,000 per year in energy bills - Bank will finance the loan at 10 percent on the remaining balance - Five principal payments of $66,000 will be required by the bank Please note: - The firm has a target debt-to-asset ratio of 67 percent. The firm is in the 34 percent tax bracket. - In each option, straight-line depreciation and equipment will be worthless after 5 years. As part of your analysis, answer the following: 1. Should your firm lease (Option A) or purchase (Option B)? 2. Does your answer depend on the form of financing for direct purchase? 3. How much debt is displaced by the debt? 4. What annual lease payment will make WCF indifferent to whether it leases or not