Auto Loan Payment Example


A car is financed using a three-year loan. The loan has a 8% nominal annual interest rate, compounded monthly. The price of the car is 7,000, and a deposit of 2,000 is paid in cash. Calculate the monthly auto loan payments, assuming that the payments start one month after the purchase.


The value of the loan is the price of the car less the initial deposit (7,000 – 2,000 = 5,000) (PV). This loan is repaid using monthly installments, so one period is one month, and the term of the loan is 3 years or 36 months (n). The interest rate has been quoted as an annual rate so the periodic (monthly) rate is 8%/12 per month (i)

As the auto loan payments (Pmt) are made at the end of each period, and we know the present value, the problem is solved using the annuity payment formula PV as follows:

Auto loan payment = PV x i / (1 - 1 / (1 + i)n)
PV = Value of the auto loan 5,000
n = number of months = 3 x 12 = 36
i = nominal rate = 8%/12 per month
Auto loan payment = 5000 x (8%/12) / (1 - 1 / (1 + 8%/12)36)
Auto loan payment = 156.68 

Auto Loan Payment Explanation

For the auto loan balance to be cleared at the end of 36 payments, the present value of the payments must be equal to the present value of the auto loan.

The solution to this problem simply uses the present value of an annuity formula to find the 36 payments which, at a discount rate of 8%/12, will give a present value of the auto loan of 5,000.

Auto Loan Payment Example November 6th, 2016Team

You May Also Like

Related pages

online equation rearrangerannuity payment calculatorreceivables turnover ratio industry averageaccounts receivable calculatorinvoice discounting accountingperpetual inventory accountingaccounting period costsbond computations straight-line amortizationbank overdraft liabilitieswhat is difference between margin and markupmeaning of account payable and receivabledebit memo journal entrycalculate reducing balance depreciationdirect labor examplesprepaid expenses accounting definitionoperating versus capital leasebookkeeping cheat sheetblank inventory sheetmarkup vs gross marginsales ledger control account formatexpenses claim templatereceivable turnover formulafactored invoicefv of annuity tablefv annuity formulafixed asset register excelselling inventory journal entryaging of accounts receivable method formuladeclining balance interest calculatorbond discount amortizationjournal entry for car loanformula for annual depreciationvertical analysis exampleperpetual inventory system formulamaterials requisitioned journal entrynotes receivablesequity method of accounting for joint venturesformula of inventory turnover ratioaccounts receivable turnover in dayshow to calculate receivable daysconsignment agent meaningretained earning examplereceived cash for services performed journal entryannuity function in excelunrealized gain loss accountingpv of a growing annuityhow to record accrued interest journal entryunearned revenue accountingdouble entry bookkeeping excel templatedays sales outstanding exampleamortisation and depreciationtreasury stock on balance sheet exampleannuity cash flows calculatorexcel ledger templatescash ledger book formatdefine deferred incomehow to calculate leverage ratio from balance sheetdouble declining depreciation method formulahow to compute contribution margin ratiogeneral entries general ledger examplesdiminishing balance method depreciationcomparative and common size balance sheetfuture value annuity factortime sheet sampleunearned credithow to calculate markup from cost and selling pricefinancial statement worksheet templateexcel template accounting small businessexcel accounting system templatecost of good sold formula manufacturingannuities formulaspurchase method of accounting exampleexcel pv formula examplecalculate pv in exceldeferred expenses journal entryrent payable journal entryconsignment inventory sheetdiscount on bonds payable balance sheetjournal entry for deferred tax assetdebt to asset ratio calculatorexamples of bank reconciliation problems