THIS WILL
CALCULATE: If you have an investment that will pay in
equal periodic installments and you want to determine how much to pay for it to
earn a desired return.
EXAMPLE:
I would like to borrow some money from you today. I can pay you back in equal
monthly installments of $450 for 3 years. How much will you be
willing to loan me if you get a 12% rate of return.
Please
note: The result is a negative number
because it is a cash outlay. |
|
12 |
|
|
Sets period per year |
450 |
|
|
|
- |
13,548.38 |
|