Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please provide answer in excel sheet Salwid-Mort, a mortgage broker, has hired you to develop a spreadsheet they will use with their clients. They've noticed
please provide answer in excel sheet
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 $1000, 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 12 rate) 3. The rate of interest for the 30-year mortgage, given by 130 basispoints over CY21 4. The initial loan amount, $1 000 000 5. The fortnightly cash deposit amount of $1000 6. A second, higher than $1000), fortnightly cash deposit amount. 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 $1000, 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 12 rate) 3. The rate of interest for the 30-year mortgage, given by 130 basispoints over CY21 4. The initial loan amount, $1 000 000 5. The fortnightly cash deposit amount of $1000 6. A second, higher than $1000), fortnightly cash deposit amount Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started