Create a Mortgage Payment Calculator in Google Sheets

4.8
별점
39개의 평가
제공자:
Coursera Project Network
학습자는 이 무료 안내 프로젝트에서 다음을 수행하게 됩니다.

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 IF, COUNTA, PMT, and PV formulas to determine the mortgage payment.

인터뷰에서 이 안내형 체험 보여주기

Clock2 hours
Beginner초급용
Cloud다운로드 필요 없음
Video분할 화면 동영상
Comment Dots영어
Laptop데스크톱 전용

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.

요구 사항

Familiarity of Google Sheets or a workbook system and a free Google email account is required for this project.

개발할 기술

Financial ManagementFinancial StatementAccountingData AnalysisProblem-solving Skills

단계별 학습

작업 영역이 있는 분할 화면으로 재생되는 동영상에서 강사는 다음을 단계별로 안내합니다.

  1. Create a mortgage payment calculator spreadsheet in Google Sheets.

  2. Add payment information using logical expression and PMT formulas in Google Sheets.

  3. Add overview information using logical expression and payment period formulas in Google Sheets.

  4. Add payment information using logical expression and future value formulas in Google Sheets.

  5. Add a Doughnut Chart and customize spreadsheet in Google Sheets.

안내형 프로젝트 진행 방식

작업 영역은 브라우저에 바로 로드되는 클라우드 데스크톱으로, 다운로드할 필요가 없습니다.

분할 화면 동영상에서 강사가 프로젝트를 단계별로 안내해 줍니다.

자주 묻는 질문

자주 묻는 질문

궁금한 점이 더 있으신가요? 학습자 도움말 센터를 방문해 보세요.