1 / 4

Fixed Term Loans

Learn how to calculate and manage fixed term loans when buying a car using amortization. Use Microsoft Excel's payment function to determine regular payments on a loan with a fixed interest rate, considering factors such as APR, loan length, additional fees, and total cost of credit.

mackpruitt
Télécharger la présentation

Fixed Term Loans

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Fixed Term Loans Buying a Car

  2. Amortization – The process of calculating a loan so that all payments are the same In Microsoft Excel use the payment function to determine the payments on a fixed term loan with a fixed interest rate. =PMT (interest rate, # of periods, amt borrowed)

  3. Terms of the loan • Annual percentage rate – APR • Length of the loan - # of years or months • Any additional fees or charges • Total cost of credit

  4. Major factors considered to qualify for a loan • Collateral – what assets are going to be pledged as security? • Capacity – what income is to be used to repay the loan? • Character – includes things like past credit history, legal problems, etc. • Cosigner – requiring a third party to “guarantee” repayment

More Related