Whats the PV of a lease that has 60 months, monthly payments of $500, payed at the beginning, impricit rate of 5.5%, 50,000 guranteed residual value, fair value of asset is 75,000 with a 15 year useful life. Would he greatly appreciated if you showed on excel how you did it.