Google Sheets: Make a Loan Calculator With Extra Repayments
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Build a loan calculator in Google Sheets with extra repayments using INDEX/MATCH, data validation, formatting and more.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!
Requirements
- Requirements
- Access to Google Sheets
- Basic knowledge of spreadsheets
Google Sheets: Make a Loan Calculator With Extra Repayments
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Build a loan calculator in Google Sheets with extra repayments using INDEX/MATCH, data validation, formatting and more. If so, then this course is for you!...
