all u need to do is construct a 3hundred word introduction for this assignment, thats it. I am only showing you this to give u an idea, please just construct a 3hundred word thing to introduce the topic

Assignment Topic

Your bespoke team data is to be applied to the following topic; it is strongly recommended that you see staff in consultation for guidance if you are unclear about any part of this assignment.

Bob and Jill are a couple who have hired your team of financial planners to consult on their intention tobuy their next home. You need to identify whether they can meet the two mortgage requirements (Task 1 and Task 2) necessary to facilitate their purchase, having sufficient disposable income to pay for the periodic loan prepayments and having a sufficient deposit to cover the balance of the property price that the mortgage will not cover. Both these conditions have to be met to allow the purchase to move forward. Once you have evaluated their ability to meet these conditions, you are required to conclude your report with recommendations about what Bob and Jill can do, given the outcome that they cannot afford the property or given the outcome that they can afford the property.

The time frame and house price are specified in your team data. Assume the mortgage rates today are reflective of mortgage rates in the future time frame of the purchase and to be used for calculation purposes.

Task 1:

Find and present in a business report the cheapest (lowest interest rate) home loan in the market thatmeets Bob and Jill's conditions specified in your team data.

You are required to show evidence of your comparison. The requirement for evidence would be providing screenshots either in the main assignment body or in an appendix, comparing your recommended product with at least two other loan products that match all the conditions stated in your team data. Screenshot evidence requires the inclusion of the filters used to apply the product conditions below. Any screenshots are to be referenced by footnotes or endnotes. Examples of such evidence is provided on pg. 9-10 of this document.No evidence nor sourcing of the loan comparison will result in a -3 mark penalty.

Use comparison rates to select the appropriate product but loan interest rates for financial math calculations. i.e. do not use comparison rates for financial math calculation. Applying their desired LVR, Calculate the amount Bob and Jill has to borrow.

A. Calculate the deposit Bob and Jill must contribute in the future time of house purchase (asspecified by your team's unique data).

Apply financial math to calculate the periodic loan repayment Bob and Jill must pay.(show your Excel working as screenshots, no evidence of working will be penalised -3 marks)

Assuming Bob and Jill's income(given in your team data) changes by the current rate of annual inflation, will they be able to afford the periodic loan repayment needed for the loan? If not, by what nominal annual percentage will they have to grow their disposable income available to service the loan in the future when they buy their house? If their future income is greater than the loan repayment required, by what percentage is their income greater than the loan payment required?

Task 2:

Given the deposit Bob and Jill must pay in the future, they also task you with finding a good investment to help them save. Find and present in your business report the best (highest EAR) term depositavailable in the market that meets Bob and Jill's conditions specified in your team data.

You are required to show evidence of your comparison. The requirement for evidence would be providing screenshots either in the main assignment body or in an appendix, comparing your recommended product with at least two other term deposit products that match all the conditions stated in your team data and showing EAR comparisons. Any screenshots are to be referenced by footnotes or endnotes. Follow the style of screenshot evidence as provided for Task 1.No evidence or sourcing of the comparison will result in a -3 mark penalty.

Given what Bob and Jill have available to invest today (given in your team data), apply financial math and calculate the future value of investing in your recommended term deposit today, for when Bob and Jill need to buy their house.(show your Excel working as screenshots, evidence of working will be penalised -2 marks)

Can the couple invest enough to pay for their house deposit in the future? If yes, by what percentage are they over their deposit. If not, by what percentage are they under their deposit?

Completing only Task 1 and 2 correctly will at most earn you a Credit. The objective of Task 1 and 2 is to provide the evidence for conclusions of whether the couple can afford their desired property or not and subsequent recommendations. For a higher grade,in your report conclusion and executive summary, Teams need to provide financial recommendations (supported by financial math) to Bob and Jill about what they can do if they either cannot afford the property or if they can afford the property. Feel free to see staff in consultation about guidance regarding how to think creatively and how to provide value-add recommendations.

Understanding your team data.

Bob and Jill's house purchasing plan in terms of timing and house price is providedfor each team...

."Inyears time, Bob and Jill intend to buy a 3-bedroom house in Caulfield to live in. They intend to spend $to buy their house."

Bob and Jill's conditions and needs of the loan:

Financial Institution:"The loan has to be from a"Your team can be given one of the following institutions in your data:

i.A non-bank financial institution:any lender that is neither in APRA'sregister of ADIs (https://www.apra.gov.au/register-of-authorised-deposit-taking-institutions) nor a subsidiary of any ADIs (big-4 and non-big-4). Do market research to identify subsidiaries of ADIs, following list is not complete but can help. (https://www.apra.gov.au/list-of-authorised-deposit-taking-institutions- covered-under-financial-claims-scheme)

ii.A Credit Union, Building Society or Mutual Bank:any customer-owned financial institution (https://www.customerownedbanking.asn.au/about-coba/list-of-our-members) also listed on the APRA register ADIs.

A non-Big Four bank:any ADI listed on the APRAs register is not a Credit Union, Building Society, Mutual Bank. A non-big 4 bank is not CBA, ANZ, Westpac or NAB. Subsidiaries of ADIs (big-4 and non-big-4) like St George, Bank of Melbourne, Ubank, BankWest, tic:toc are allowed in this category. Bank-bankedplatforms, which claim they are not a "bank" clearly would not existotherwise, so for the purposes of our assignment are placed within this bank classification.

Big Four bank only:either CBA, Westpac, ANZ or NAB only. Subsidiaries of the Big Four like St George, Bank of Melbourne, Ubank, BankWest are not allowed in this category.

Markers will check the websites of the institutions provided in the reference to ensure compliance with this requirement.

Loan facility:"The loan has to havefacilities." You can be given either theOffsetfacility or theRedrawfacility in your data.

Repayment frequency:"Mr and Mrs Monash wish to makerepayments"You can be givenweeklyorfortnightly,ormonthlyrepayments in your data.

The loan term:"They wish to borrow money for years."You can be given20 yearsor25 years,or30 yearsin your data.

Loans are eitherfully amortisingorpartly amortising.Know how to calculate loan repayments for either. See staff in consultation if you are unsure.

Fixed or Variable rate:"They are interested in aloan" You are given a1-year fixed-rate loanor a2-year fixed-rate loan,or avariable rate loanin your data.

LVR ratio:"Bob and Jill desire an LVR (Loan-to-value Ratio) of" The LVR can be60%to80%in your data. Assume the property value matches the price.

Bob and Jill's disposable income:"Today, Bob and Jill have $of disposableincome to pay for the loan repayment each period."

Bob and Jill's conditions and needs of the term deposit:

Financial Institution:"The term deposit is to be from a "

Your team can be given one of the following institutions in your data:

A Credit Union, Building Society or Mutual Bank:anycustomer-ownedfinancial institution listed

on the APRAsregisterof ADIs.

A non-Big Four bank:any ADI listed on the APRAs register that is not a Credit Union, Building

Society, Mutual Bank. A non-big 4 bank is not CBA, ANZ, Westpac or NAB. Subsidiaries of the Big

Four like St George, Bank of Melbourne, Ubank, BankWest are allowed in this category.

Big Four bank only:either CBA, Westpac, ANZ or NAB only. Subsidiaries of the Big Four like St

George, Bank of Melbourne, Ubank, BankWest are not allowed in this category.

Markers will check the websites of the institutions provided in the reference to ensure compliance with this requirement.

The final term of the deposit has to mature when they purchase the house in the future. Deposits of multiple and different terms can be used to reach the period when the deposit is required.

Interest compounding frequency:Interest to be calculated and paid as specified by the product.