Monthly Payment - APR with fees
Last modified by
on
Jul 24, 2020, 6:28:07 PM
Created by
on
Dec 6, 2013, 4:17:13 PM
mnthly payment=(Loan Amount+All Fees)⋅i1200⋅(1+i1200)n(1+i1200)n-1
Enter a value for all fields |
|
|
|
Tags | |
UUID | ddcaae79-5e91-11e3-84d9-bc764e202424 |
|
Annual Percentage Rate (APR) is the equivalent interest rate of a loan which includes all fees and interests paid.
INPUTS
The inputs to this equation include the following:
- Loan Amount - the original amount financed
- i - interest rate entered as a percentage; i.e, enter 6.4 for a 6.4% interest rate
- n - number of months
- All Fees - all costs of closing and loan expenses
NOTES
This formula calculates a monthly payment for a loan
EXAMPLES
For an amount of $50,000 loaned with $1,200 fees and closing costs, at an annual interest rate of 5% to be paid back over 5 years.
This equation will accept the interest rate as the percentage, for the above example, enter 5 as the interest rate.
The monthly payment will be calculated: $966.21
This equation, Monthly Payment - APR with fees, references 2 pages
This equation, Monthly Payment - APR with fees, is used in 0 pages