Create a Home Affordability Worksheet in Google Sheets

Offered By
Coursera Project Network
In this Guided Project, you will:

You will learn a step-by-step approach to build a Google Sheets spreadsheet and add a doughnut chart.

You will learn to analyze data and learn SUM, PMT, MIN, and PV formulas to determine the home affordability.

Clock2 hours
BeginnerBeginner
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

During this project, we will be working together to create a home affordability worksheet in Google Sheets. You will learn how to create formulas to include interest rates on multiple debt items, and show the timeline it will take to payoff the debt. 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. 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.

Skills you will develop

Financial ManagementFinancial Data AnalysisAccountingProblem SolvingData Analysis

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  1. Create Google Sheets income and monthly debts

  2. Create Google Sheets monthly housing expenses

  3. Create Google Sheets available funds

  4. Create Google Sheets financing options

  5. Create Google Sheets home affordability chart

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.