Looking for Excel Functions where applicable.

What is the present value of a perpetuity that pays 1,000 per year, beginning one year from now, if the appropriate interest rate is 5%? PMT 1,000 5% PV= What would the value be if the perpetuity began its payments immediately? The perpetuity formula values payments 1 through infinity. If a payment is to be received immediately, it must be added to the formula result. PMT 1,000 5% PV=