How to Calculate an Original Loan Amount in Excel. We can calculate an original loan amount by using the Present Value Function (PV) if we know the interest rate, periodic payment, and the given loan term. This function tells the present value of an steps below will walk you through the process of calculating an original loan ;s a good way to determine how the loan amount, its interest, and the loan term affect the total amount you’ll be paying. If you want to make your own, the ‘PMT’ function in Excel, coupled with other functions, can be used to create a loan payment calculator. But if you like the easier and quicker way, you can download and use existing loan calculator templates 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)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 …02/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 …Excel formula: Calculate original loan amountExcel formula: Calculate payment for a loan | Exceljetexcel loan calculate total amountHow To Use Excel's Loan Calculator: Get The Simple 08/04/2018 · Determine the loan amount you would like to borrow from the lender. Compare property's appraised value or actual sale price and use the lesser of those two numbers. Divide the two numbers using the formula below:31/08/2018 · Here is a simple calculation to calculate a loan value based on the # of months. You first have to find the rate and then calculate the number of months remaining, to get the present value (or loan value). This is a simple illustration and I did not include a balloon payment. The Formula is in COL D. The ROWS run normal.

Tags: Calculate future value of loan in excel, Calculate present value of loan in excel,