Create a Mortgage Payment Calculator in Google Sheets
Offered By: Coursera Project Network via Coursera
Course Description
Overview
During this project, we will be working together to create a mortgage payment calculator in Google Sheets. You will be able to create a mortgage payment calculator in Google Sheets. You will learn how to create formulas to include
logical expression, dataset values, IF,COUNTA,PV,and PMT. We will look at the equity at 5-years, and review five different home loan options. This is a great tool to use if you have plans to purchase a home in the future, and want to learn how much you can afford, and if you have room to make additional payments, how quickly you will payoff the mortgage.
Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.
logical expression, dataset values, IF,COUNTA,PV,and PMT. We will look at the equity at 5-years, and review five different home loan options. This is a great tool to use if you have plans to purchase a home in the future, and want to learn how much you can afford, and if you have room to make additional payments, how quickly you will payoff the mortgage.
Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.
Taught by
Leah Louviere
Related Courses
Making Sense of DataGoogle via Independent Introduction to Spreadsheets and Models
University of Pennsylvania via Coursera Comptabilité de gestion et pratique du tableur
Université Montpellier 2 via France Université Numerique The Power of Data in Health and Social Care
University of Strathclyde via FutureLearn Digital Media Analytics: Introduction
Purdue University via FutureLearn