USE EXCEL IF YOU DON'T USE EXCEL I WILL MARK IT WRONG. I'VE HAD TOO MANY PEOPLE DO IT BY HAND AND GET IT WRONG. SO PLEASE USE EXCEL THAT IS WHAT I'M USING TO LEARN. IF YOU DON'T KNOW DON'T 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