What-if scenario – Mortgage Calculator

In this recipe, we will create a what-if scenario dashboard. The purpose of the dashboard is to calculate and show the monthly payments and the total cost of a mortgage, based on a set of adjustable variables.

We will use techniques from the following chapters and recipes:

• Chapter 1, Staying in Control
• The Using sliders to create a what-if scenario recipe from Chapter 3, From a Static to an Interactive Dashboard
• The Selecting your data from a list recipe from Chapter 3, From a Static to an Interactive Dashboard
• The Illustrating single values recipe from Chapter 2, Data Visualization
• The Using a pie chart recipe from Chapter 2, Data Visualization
• Chapter 7, Dashboard Look and Feel

Getting ready

As we are starting from scratch, you only have to open a new SAP BusinessObjects Dashboard file.

How to do it...

1. The dashboard will contain four variables: Mortgage amount, Mortgage term in years, Yearly interest rate, and a variable that states whether the mortgage...