To 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 …This 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 calculate the original loan amount, given the loan term, the interest rate, and a periodic payment amount, you can use the PV function. Formula =PV(rate,periods,-payment)31/05/2021 · Original loan amount: $180,000; Original loan date: Nine years ago; Interest rate on the loan: , Loan term: 30 yearsExcel formula: Calculate original loan amount | ExceljetTOTAL LOAN COST FORMULA and CALCULATORHow to calculate loan payments in 3 easy stepsLoan Payment Formula (with Calculator)10/10/2011 · But this time solve for A, the original loan amount: i A ------------ = P 1 - (1+i)^-N A P ------------ = --- 1 - (1+i)^-N i (4)P = Initial principal or loan amount (in this example, $10,000) r = Interest rate per period (in our example, that's divided by 12 months) n = Total number of payments or periods The formula for calculating your monthly payment is: A = P (r (1+r)^n) ( (1+r)^n -1 ) When you plug in your numbers, it would shake out as this: P = $10,000

Tags: How to find the original loan amount formula, Formula to calculate original loan amount,