Loan Amortization in Spreadsheets

via

DataCamp

Course Features

Duration

4 hours

Delivery Method

Online

Available on

Limited Access

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Teaching Type

Self Paced

Video Content

4 hours

Course Description

It seems that only financial traders and bankers would use the loan amortization schedule. Wrong! This course will explain the financial formulas that you can use in Google Sheets for your loan analysis. These can be student loans, auto loans, car loans, mortgages and car loans. We'll make a Google Sheets dashboard to impress finance managers. It uses visualizations, conditional calculations and other tools to create presentation-ready spreadsheets.

Course Overview

Virtual Labs

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Financial Modeling in Spreadsheets

What You Will Learn

In this course, we'll be looking at the key financial formulas in Google Sheets that you can use to investigate your own loans, like student loans, car loans, and mortgages

Learn how to build an amortization dashboard in spreadsheets with financial and conditional formulas

We'll build up a dashboard in Google Sheets which uses visualizations and conditional formulas to produce presentation-ready spreadsheets which will impress any finance manager!

Course Content

Expand all sections

Module 1: Introduction to Financial Concepts in Google Sheets

Module 2: Creating an Amortization Schedule

Module 3: Making a Loan Amortization Dashboard

Module 4: Non-standard amortization schedules

Course Instructors

Brent Allen

Financial Spreadsheets Specialist

Brent has held a wide variety of roles across a wide array of businesses ranging from world-class banking institutions to local real estate companies. With over 20 years of experience in spreadsheets...