Google Sheets: Make a Loan Calculator With Extra Repayments
What you'll learn
- Learn how to build a loan repayment amortisation schedule Google Sheets
- Build a model that includes extra fixed irregular repayments
- Use beginner to intermediate spreadsheet functions like SUM, EDATE and INDEX/MATCH
- Find out how to use tools such as data validation for extra security
Requirements
- Access to Google Sheets
- Basic knowledge of spreadsheets
Description
Have you always wanted to know how much interest you can save by making extra loan repayments?
Do you want to learn how to build a spreadsheet model in Google Sheets to do exactly that?
Do you want to learn how to use intermediate functions such as EDATE and INDEX/MATCH?
If so, then this course is for you!
---------------------
What will I learn from this course?
In just over an hour, our “Make a Loan Calculator with Extra Repayments” course will teach you how to make a spreadsheet that will show you how much a loan will truly cost over time with and without extra repayments.
During the course, you will learn how to use the PMT function to calculate the regular repayment amount for a standard loan.
You will then learn how to create a basic amortisation schedule so you can see how the numbers work over time.
Then, we will add extra functionality to the model to allow fixed or variable extra repayments.
We will then build a summary table that will show you the “magic number” of exactly how much interest you will save by making extra repayments.
This is the number you’ll want to see!
---------------------
What is the course structure?
We use the free spreadsheet programme Google Sheets to create the models, which will be automatically saved on the cloud in your Google Drive.
Not only will you grow your spreadsheeting skills, you will end up with a model that will belong to you so you can use it however you please!
---------------------
What topics are covered?
This course uses beginner to intermediate functions and tools to build the loan calculator with extra repayments model.
The functions we use include SUM, PMT, EDATE and INDEX/MATCH and we also do some basic calculations by using formulas instead of functions.
We also use several tools such as data validation to enhance the security of the spreadsheet.
After you have completed this course you will have expanded your Google Sheets skills and you will own a fully functioning model.
---------------------
So what are you waiting for? Sign up today and learn how to make a loan calculator with extra repayments model in Google Sheets.
See you on the course!
Who this course is for:
- Students who want to learn beginner to intermediate spreadsheet skills
- Students who want to learn more about Google Sheets
Course content
- Preview01:34
- 00:25Accessing Google Sheets
Instructor
![Mark Cunningham](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.5 Instructor Rating
- 758 Reviews
- 4,548 Students
- 13 Courses
Hi I'm Mark and I'm excited to be your instructor!
During my career as a qualified accountant I have been told many times that I am good at explaining things. I believe this is because I enjoy breaking down big problems into small parts and teaching people from the ground up.
I know from experience that it is always best to teach the basics first. Once my students have a solid foundation to build on, I can move on to the harder lessons. I love watching my students go from complete novices to experts who can confidently use their new skills in real life.
I also know from experience that students learn better when they actively follow tutorials or complete practical tests at the end of each lesson, which is one of the reasons I love Udemy courses.
There is no better way to learn than by doing.
My courses have been designed along those principles to give you the best chance possible of becoming a subject expert.
I hope my courses help you learn what you need to know to reach your full potential.
Happy learning!