?
Solved

Auto lease amortization

Posted on 2014-02-18
4
Medium Priority
?
337 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 93

Accepted Solution

by:
Patrick Matthews earned 2000 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

752 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