Salwid-Mort, a mortgage broker, has hired you to develop a spreadsheet they will use with their clients. They’ve noticed that thirty-year loans with an interest offset facility are popular with their clients. They want a spreadsheet that demonstrates some of the characteristics of this type of loan to their clients. Broadly, they’d like to show their clients a graph with three curves on it: one, the declining outstanding balance of a traditional principle and interest loan, two, as above, but with an interest offset facility, tracking fortnightly savings of $1 000, and three, as above, but the client gives a fortnightly savings amount greater than $1 000. To achieve these objectives, you have been asked to develop the following. Develop a spreadsheet with at least two sheets

One sheet, titled ‘Inputs’ consists of the following.

1. The Salwid-Mort logo

2. CY21, the Australian 10-year government bond yield for calendar year 2021 (i.e., the 10-year government bond yield on 31 December 2021, a j2 rate)∗

3. The rate of interest for the 30-year mortgage, given by 130 basis points over CY21

4. The initial loan amount, $1 000 000

5. The fortnightly cash deposit amount of $1 000 6. A second, higher (than $1 000), fortnightly cash deposit amount.

Answer rating: 100% (QA)

The spreadsheet that needs to be developed consists of two sheets The first sheet titled Inputs should include the SalwidMort logo the Australian 10year government bond yield for calendar year 2021 ie ... View the full answer