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!
Requrirements
Requirements
Access to Google Sheets
Basic knowledge of spreadsheets