Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using Google Sheets or Excel can you show me please how to do the following in a table. Salwid-Mort, a mortgage broker, has hired you

Using Google Sheets or Excel can you show me please how to do the following in a table.

image text in transcribed

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. 1. The declining outstanding balance of a traditional principle and interest loan over a year of loan's operation. 2. As above, but with an interest offset facility, tracking fortnightly savings of $800. 3. As above, but the client puts a stream of fortnightly savings of $1600 (i.e., double the above) in their interest offset account. To achieve these objectives, you have been asked to develop the following. Develop a spreadsheet with at least three sheets. One sheet, titled 'Inputs' consists of the following. 1. The Salwid-Mort logo. 2. CY22, the Australian 10-year government bond yield for calendar year 2022 (i.e., the 10-year government bond yield on 31 December 2022, a j2 rate).* 3. The rate of interest for the 30 -year mortgage, given by 205 basis points over CY22. 4. The initial loan amount, $1000000. 5. The fortnightly cash deposit amount of $800. 6. A second, higher ( $1600), fortnightly cash deposit amount

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The 3 Signal The Investing Technique That Will Change Your Life

Authors: Jason Kelly

1st Edition

0142180955, 978-0142180952

More Books

Students also viewed these Finance questions