Excel formula: Calculate original loan amount | ExceljetLoan Payment Formula (with Calculator)What Is Loan Amortization Formula? Calculation & Example?TOTAL LOAN COST FORMULA and CALCULATORTo 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)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 $ Knowing these calculations can also help you decide which loan type would be …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 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,