Solved

Auto lease amortization

Posted on 2014-02-18
4
335 Views
Last Modified: 2014-02-19
I want to create an amortization schedule for a auto lease
0
Comment
Question by:Markvic
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 19

Expert Comment

by:regmigrant
ID: 39869916
If you do File, New, search for templates and type amortization you will find many examples like the attached. Is there something special about auto leasing that these don't take care of?
Loan-amortization-schedule1.xlsx
0
 
LVL 13

Expert Comment

by:akb
ID: 39869927
Have a look at the following link from Microsoft:

http://office.microsoft.com/en-au/ctndirectdownload.aspx?AssetID=TC010073881&Application=XL&Version=12&Result=2#

This is an Excel spreadsheet which may provide you with what you are looking for. If you are looking for something different, please specify what it is you are after and we will try to help.
0
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 39870608
As regmigrant notes above, assuming your loan is a typical self-amortizing loan with a fixed interest rate, then there are an abundance of suitable templates out there.

You may want to have a look at the template I provide here: http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_3331-Fixed-Rate-Loan-Amortization-Schedule-with-Optional-Extra-Principal-Payments.html

The examples I use are mortgage-related, but you can just as easily use this for an auto loan.  My template also allows you to test the impact of many different extra-payment scenarios.
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
My experience with Windows 10 over a one year period and suggestions for smooth operation
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question