Solved

Auto lease amortization

Posted on 2014-02-18
4
333 Views
Last Modified: 2014-02-19
I want to create an amortization schedule for a auto lease
0
Comment
Question by:Markvic
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

This collection of functions covers all the normal rounding methods of just about any numeric value.
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
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…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

773 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