PV <\/strong>function to calculate the original loan amount given the other three elements.<\/p>\n\n\n\nThe Excel PV Function<\/h2>\n\n\n\n The PV function calculates the present value of a loan: the total amount a sequence of future payments is worth now, and it has the following syntax:<\/p>\n\n\n\n <\/figure>\n\n\n\nThe PV function has the following arguments:<\/p>\n\n\n\n
\nRate <\/strong>This argument is required, and it is the interest rate per period.<\/li>\n\n\n\nNper <\/strong>This argument is mandatory, and it is the total number of payment periods.<\/li>\n\n\n\nPmt <\/strong>This is a required argument, which is the payment amount paid each period.<\/li>\n\n\n\nFv <\/strong>This argument is optional. It is the future value or cash remainder you want to achieve after making the last payment. If we omit it, the default value of 0 (zero) is assumed.<\/li>\n\n\n\nType <\/strong>This argument is optional. It is either number 1 or 0, indicating when payments are due. The value 1 indicates that payments are due at the start of the period, and 0 (or omitted) shows that payments are due at the end.<\/li>\n<\/ul>\n\n\n\nExample Dataset<\/h2>\n\n\n\n We use the following example dataset that shows the interest rate, payment periods, and payment per period to explain how to calculate the original loan amount using the PV function.<\/p>\n\n\n\n <\/figure>\n\n\n\nCalculate the Original Loan Amount<\/h2>\n\n\n\n We calculate the original loan amount using the steps below:<\/p>\n\n\n\n
\nSelect cell B7 in the example dataset and type in the formula below:<\/li>\n<\/ol>\n\n\n\n=PV(B3\/12,B4,B5)<\/code><\/pre>\n\n\n\nNote:<\/strong> The annual interest rate in cell B3 is divided by 12 to determine the monthly interest rate.<\/p>\n\n\n\n <\/figure>\n\n\n\n\nPress Enter<\/li>\n<\/ol>\n\n\n\nThe original loan amount of $6,603.82 is displayed in cell B7.<\/p>\n\n\n\n <\/figure>\n\n\n\nConclusion<\/h2>\n\n\n\n This tutorial showed how to calculate the original loan amount in Excel using the PV function. We hope you found the tutorial helpful.<\/p>\n","protected":false},"excerpt":{"rendered":"
A loan has four main elements: the amount, the interest rate, the loan term or the number of periodic payments, and the payment…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[170],"yoast_head":"\n
Calculate the Original Loan Amount in Excel<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n