0
How do I calculate the payment amount needed to arrive at a known value if I know these variables Present value Future value Rate and that the payment will increase by a known percent each period?
Wiki User
∙ 14y ago
You might be able to use the PMT function. It returns the payment amount for a loan based on an interest rate and a constant payment schedule. You can try different numbers of payments to see what different monthly payments are required.
Syntax: PMT(interest_rate,number_payments,PV,FV,Type)
interest_rate = interest rate
number_payments = number of payments
PV = present value (or principal)
FV (optional) = future value (if omitted, the assumed value is 0)
Type (optional) = indicates when the payments are due
0 = payments due at end of period (default or if not included)
1 = payments due at beginning of period
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Is it beneficial to calculate a mortgage payment for the future?
It is always beneficial to calculate a mortgage payment for the future. Being aware of financial obligations, especially one as large a a mortgage payment, whether in the present or future, is a good step toward financial security.
What variables are used in solving a time value of money problems without a periodic payment?
Present Value (PV)Future Value (FV) Number of periods (n) Interest Rate (i) Payment Amount (PMT)
How do you calculate the benefits of payment terms?
The benefit of payment terms are considered cash flows. A price increase can offset the cost of having an account opened for extended periods of time.
Does the present value of money increase as the number of years before the payment is received increases?
No, it should decrease, assuming the interest rate is the same.
increase tax witholding ?
increase tax payment
Where can I calculate a car payment online?
You can visit pnc.com for your help on calculate a car payment. I hope this helps you find the right car and the right car payment for you. They have the tools to help you.
Are there websites that can calculate car loan payments?
There are websites that calculate your car loan payments. Most dealership websites have a payment calculater on there site that will allow you to enter your down payment amount and will calculate your payment after taking everything into play.
Why would Accounts payable increase?
payment to account payble has increase
Potentential effect of an increase in mortgage interest rate?
Increase in principal + interest payment.
Is the payment mortgage on the first of the month covers for that month?
The payment due for the 1st is for present month.
Can you calculate your mortgage payment online?
You can calculate your mortgage payment online by using the handy mortgage calculators that certain banks provide. All you have to do is put in your information and the calculator will do the rest.
The payment of a current liability will?
increase working capital
