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(C5 12, C7, C6)To calculate a loan payment amount, given an interest rate, the loan term, and the loan amount, you can use the PMT function. In the example shown, the formula in C10 is: = PMT ( C6 12, C7, - C5 )We will input this value into the formula. Pmt 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 AmountIn this formula the result of the PV function is the loan amount, which is then subtracted from the purchase price to get the down payment. Using the function PV (rate,NPER,PMT) =19000-PV (, 3 12,-350) the down payment required would be $6, formula: Calculate original loan amount | ExceljetExcel formula: Calculate payment for a loan | ExceljetHow to Calculate Monthly Loan Payments in Excel excel loan calculate total amount02/06/2021 · For example, a 30-year mortgage paid monthly will have a total of 360 payments (30 years x 12 months), so you can enter "30 12", "360", or the corresponding cell (in this case, C4) 12. If you wanted to calculate a five-year loan that's paid back monthly, you …Select the cell you will place the calculated result in, type the formula =CUMIPMT (B2/12,B3 12,B1,B4,B5,1), and press the Enter key. See screenshot: Note: In the formula, B2 is the annual loan interest rate, B2/12 will get the monthly rate; B3 is the years of the loan, B3 12 will get the total number of periods (months) during the loan; B1 is the 05/05/2009 · I am trying to use an excel formula to calculate the maximum amount that a person can borrow. I have used the "PV" formula and while it gives an approximate amount I want something more exact. The known variable factors are: Loan Interest Rate. Loan Term [number of repayments] Surplus income. [Gross Income minus living expenses other loans etc]

Tags: