Creating an Amortization Schedule in Excel

Learn to build a customized amortization schedule in Microsoft Excel 2016 from scratch
4.2 (41 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,316 students enrolled
Instructed by James Raymond Business / Finance
Start Learning Now
  • Lectures 14
  • Length 30 mins
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2016 English

Course Description

Financial analysts, accountants, students, and many others are often tasked with creating an amortization schedule. However, not everyone has been taught the proper way to build one from scratch. In this step by step course, I will walk you though building your very own amortization schedule in Microsoft Excel from scratch. The course is packed with information that will help you answer popular questions relating to loans and mortgages.

This course is designed for the beginner Excel user, however the information moves fast enough to keep the attention of more experienced users.

This course is pretty quick, and should be completed in just 30 minutes.

If you want to learn how to calculate a car loan or mortgage, and build an amortization schedule, this course is for your.

What are the requirements?

  • It is best suited for those that have a working knowledge of Microsoft Excel

What am I going to get from this course?

  • Create an amortization schedule from scratch and use the information to make better decisions

What is the target audience?

  • Beginners and above. It is best if you have at least a basic understanding of Microsoft Excel

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Start Here

This is the course introduction. This lecture explains what an amortization schedule is, and why someone would need this information. This video also explains the course objectives.

Data Entry

Building the table

Building the Table - Continued
Building the Table - Final
Section 2: Putting it All Together
Scenario 1- Description
Scenario 1 - Calculation
Scenario 2 - Description
Scenario 2 - Calculation
Scenario 3 - Description
Scenario 3 - Calculation
Scenario 4 - Description
Scenario 4 - Calculation

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

James has nearly twenty years experience using Microsoft Excel. He is experienced in the field of investment management and corporate finance. James' uses his vast experience to help others learn Microsoft Excel, and apply their learning to real-world problems. His conversational teaching style is a great fit for the beginner or intermediate user.

Ready to start learning?
Start Learning Now