Calculate Auto Loan Payments Using Microsoft Excel - PowerPoint PPT Presentation

About This Presentation
Title:

Calculate Auto Loan Payments Using Microsoft Excel

Description:

It is very important to know how the auto loans payments are calculated .They can be calculated in different methods.One among those method is using Microsoft Excel. – PowerPoint PPT presentation

Number of Views:28
Slides: 9
Provided by: brianfremont
Category: Other

less

Transcript and Presenter's Notes

Title: Calculate Auto Loan Payments Using Microsoft Excel


1
Calculate Auto Loan Payments Using Microsoft
Excel
2
PMT function to calculate the monthly payment
3
Open the MS Excel and enter the following
description
4
Enter the values in column B
5
Apply PMT(B1/12,B2,B3,B4) in a cell below the
numbers
6
Press the Enter key and the formula will be
replaced with the monthly payment
7
Alter the payment
8
  • GetCar.ca are the most popular dealers
    specialized in providing all types of bad credit
    auto loans. With their credit recovery program
    even with bad credits, GetCar.ca helps you in
    getting the loans. http//www.getcar.ca
Write a Comment
User Comments (0)
About PowerShow.com