Please only solve this problem using excel inputs, do not provide raw mathematical calculations Please just provide step by step excel operations I.e. step 1, step 2, step 3, each having excel inputs Please provide a definitive excel answer for each step and show the calculated final answer What are the answers to these inputs for this questions "

Input
Annual lease payment
Number of payments
Lease rate
FV
Type (in arrears)
Type (in advance)
=pv(rate,nper,pmt,fv,type)
PV in arrears
PV in advance
Loss to bank

Helpers of the Homeless plans to lease some new equipment. The lease calls for payments of $750 per year and is based on 10 annual payments and a 6 percent interest rate. As an accommodation to the not-for-profit organization, the bank has agreed to lease payments at the end of each year rather than the beginning, which is more common. What is the PV of the obligation? How much did the bank lose by allowing payments at the end of each year rather than at the beginning?