## What Is the Present Value of Annuity?

The present value of annuity is the current value of future payments from an annuity, given a specified rate of return, or discount rate. The higher the discount rate, the lower the present value of the annuity.

## Example of Present Value:

If you’ve got the selection of being paid $1,000 today or $1,200 one year from now. you furthermore may have the choice of investing the $1,000 that’ll earn a third rate of return over the subsequent year.

Using this value formula, the calculation is $1,200 (FV) / (1 +. 03)^1.

PV = $1,135.92, or the minimum amount that you simply would wish to be paid today to possess $1,200 one year from now. In other words, if you were paid $1,000 today and supported a third rate of interest, the quantity wouldn’t be enough to offer you $1,200 one year from now.

Of course, this value calculation includes the idea that you simply could earn 3% on the $1,000 over the subsequent year. If the rate of interest was much higher, it’d make more sense to require the $1,000 today and invest the funds because it might yield a greater amount than $1,200 one year from now.

The present value provides a basis for assessing the fairness of any future financial benefits or liabilities. for instance, a future cash rebate discounted to present value may or might not be worth having a potentially higher price . an equivalent financial calculation applies to 0% financing when buying a car.

Paying some interest on a lower sticker price may go out better for the customer than the payee.

## How to Calculate the Present Value of a multiple Bond Type With Excel?

A bond is a type of loan contract between an issuer (the seller of the bond) and a holder (the purchaser of a bond). The issuer is essentially borrowing or incurring a debt that is to be repaid at “par value” entirely at maturity (i.e., when the contract ends). In the meantime, the holder of this debt receives interest payments (coupons) supported income determined by an annuity formula. From the issuer’s point of view, these cash payments are part of the cost of borrowing, while from the holder’s point of view, it’s a benefit that comes with purchasing a bond.

The present value (PV) of a bond represents the sum of all the longer-term income from that contract until it matures with full repayment of the face value. To determine this in other words, the value of a bond today for a fixed principal (par value) to be repaid in the future at any predetermined time—we can use a Microsoft Excel spreadsheet.