excel loan calculate total amountTOTAL LOAN COST FORMULA and CALCULATORHow to calculate loan payments in 3 easy stepsHow to Use Excel to Calculate How Much a Loan Will Cost Use the above formula to determine the total amount you will pay for a loan. Example: If we borrow $100,000 for 10 years at 8 per cent annual percentage rate, what is the total cost of the loan (principal plus interest) ? 1) The rate (r) would be 8 divided by 1,200 which equals 2) The number of payments (n) would beTo calculate the original loan amount, given the loan term, the interest rate, and a periodic payment amount, you can use the PV function. In the example shown, the formula in C10 = PV …If you have an interest-only loan, calculating the monthly payment is exponentially easier (if you'll pardon the expression). Here is the formula the lender uses to calculate your monthly payment: loan payment = loan balance x (annual interest rate/12) In this case, your monthly interest-only payment for the loan above would be $ is the amount we will pay for each month within the four-year period. This amount covers only the principal which we collected and the interest. Formula. =PV (B3/12,B5,B4) We will type or copy and paste this formula into Cell B8. Figure 3: Inserting the Formula to Calculate the Original Loan Amount.

Tags: Total loan amount formula excel, Total loan interest formula, Total loan amount calculator, Total amount paid on loan formula, Total loan payment formula, Total loan payment formula excel, Total loan interest formula excel, Calculating total loan interest formula,