Loan Payment Amount Calculator - EasyCalculationExcel formula: Calculate original loan amount | ExceljetTOTAL LOAN COST FORMULA and CALCULATORLoan Payment Formula (with Calculator)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)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 know the Loan Balance, including the current payment, interest and term remaining – Loan balance calculator is used. To know the amount remaining to be repaid by the borrower in a certain time, then the Loan Balance formula is used. The banks provide a loan with easy repayment option that is called the equated monthly 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: Loan amount formula excel, Maximum loan amount formula, Loan amount calculation formula, Total loan amount formula, Principal loan amount formula, Calculate maximum loan amount formula, Eidl loan amount formula, Original loan amount formula,