PLZ USE EXCEL. YOU DON'T HAVE TO SHOW EVERY LITTLE DETAIL BUT PLZ SHOW MAJOR FORMULAS. THANK YOU.

Calculating Lessor Payment-No Residual Value Konverse Inc. is negotiating an agreement to lease equipment to a lessee for 6 years. The fair value of the equipment is $80,000 and the lessor expects a rate of return of 7% on the lease contract and no residual value. If the first annual payment is required at the commencement of the lease, what fixed lease payment should Konverse Inc. charge in order to earn its expected rate of return on the contract? - Note: Enter the answer in dollars and cents, rounded to the nearest penny. - Note: Do not use a negative sign with your answer. Lease payment Calculating Lessor Payment-Purchase Option Armstrong Inc. is negotiating an agreement to lease equipment to a lessee for 5 years. The fair value of the equipment is $165,000 and the lessor expects a rate of return of 6% on the lease contract. The lessee has an option to purchase the equipment at the end of the 5 -year term at $27,500, which is 20% under the estimated fair value at that time. If the first annual payment is required at the commencement of the lease, what fixed lease payment should Armstrong Inc. charge in order to earn its expected rate of return on the contract? - Note: Enter the answer in dollars and cents, rounded to the nearest penny. - Note: Do not use a negative sign with your answer. Calculating Lessor Payment- Unguaranteed Residual Value Marshall Inc. is negotiating an agreement to lease equipment to a lessee for 5 years. The equipment has a useful life of 8 years. The fair value of the equipment is $56,000 and the lessor expects a rate of return of 5% on the lease contract. Marshall Inc. expects the equipment to have a fair value of $21,000 at the end of 5 years; however, the lessee does not guarantee the residual amount. If the first annual payment is required at the commencement of the lease, what fixed lease payment should Marshall Inc. charge in order to earn its expected rate of return on the contract? - Note: Enter the answer in dollars and cents, rounded to the nearest penny. - Note: Do not use a negative sign with your answer. Lease payment