Task 1: Can they afford the loan repayments? Task 2: Will they have a sufficient deposit? In 6 years time, they intend buy a 3 bedroom house in Caulfield to live. They intend to spend $1,260,000 to buy their house. Task 1: The couple have the following conditions and needs of the home loan they will borrow: (not following the conditions given above or below will result in -2 marks deducted for each condition breached. Conditions are given in RED font) The loan has to be from a The loan needs to have a The couple wish to make The loan term is to be They wish to take a They are interested in a The couple want an LVR of Big 4 bank only Redraw facility fornightly repyaments 25 years fully amortising loan 1 year Fixed rate loan 80% (assume all loans researched allow for this repayment) (assume all loans researched can be fully or partly amortising) (use comparison rates to identify the best loan, use the nominal interest rate for repayment calculations) a) Applying their desired LVR, Calculate the amount Mr and Mrs Monash has to borrow. b) Calculate the deposit Mr and Mrs Monash must contribute in the future. c) Apply financial math to calculate the periodic loan repayment Mr and Mrs Monash must pay. (show your Excel working, missing working will result in a -4 mark penalty) d) Today, the couple have a combined total of $5,300.00 of disposable income to service their debt at each loan repayment period. Assuming, their income increases 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? I aSK 2. Given the home deposit needed 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 interest rate) term deposit available in the market. Evidence of your product comparison is required. Bob and Jill have the following conditions for the term deposit you present to them: (if you breach the conditions below, -2 marks will be deducted for each breach) The term deposit is restricted to be from a Credit Union, Building Society or Mutual Bank. The final term of the deposit has to mature when they purchase the house in the future. Deposits of mutiple and different terms can be used to reach period when the deposit is required. Interest to be calculated and paid as specified by the product. (i.e. quarter or annual interest payments etc) To invest today, they have $145,000 to investment today a) Given the money they have available to invest today, apply financial math and calculate the future value of investing in your recommended term deposit, for when they need to buy their house. (show your Excel working, missing working will result in a -4 mark penalty) b) Do they have enough now, to pay for the home deposit required in the future? If yes, by what percentage are they over their deposit. If not, by what percentage are they under their deposit? Teams need to present the results of all tasks in a Business Report format to Mr and Mrs Monash. afford the property. Feel free to see staff in consultation about guidance regarding how to think creatively and how to provide value-add recommendations Task 1: Can they afford the loan repayments? Task 2: Will they have a sufficient deposit? In 6 years time, they intend buy a 3 bedroom house in Caulfield to live. They intend to spend $1,260,000 to buy their house. Task 1: The couple have the following conditions and needs of the home loan they will borrow: (not following the conditions given above or below will result in -2 marks deducted for each condition breached. Conditions are given in RED font) The loan has to be from a The loan needs to have a The couple wish to make The loan term is to be They wish to take a They are interested in a The couple want an LVR of Big 4 bank only Redraw facility fornightly repyaments 25 years fully amortising loan 1 year Fixed rate loan 80% (assume all loans researched allow for this repayment) (assume all loans researched can be fully or partly amortising) (use comparison rates to identify the best loan, use the nominal interest rate for repayment calculations) a) Applying their desired LVR, Calculate the amount Mr and Mrs Monash has to borrow. b) Calculate the deposit Mr and Mrs Monash must contribute in the future. c) Apply financial math to calculate the periodic loan repayment Mr and Mrs Monash must pay. (show your Excel working, missing working will result in a -4 mark penalty) d) Today, the couple have a combined total of $5,300.00 of disposable income to service their debt at each loan repayment period. Assuming, their income increases 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? I aSK 2. Given the home deposit needed 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 interest rate) term deposit available in the market. Evidence of your product comparison is required. Bob and Jill have the following conditions for the term deposit you present to them: (if you breach the conditions below, -2 marks will be deducted for each breach) The term deposit is restricted to be from a Credit Union, Building Society or Mutual Bank. The final term of the deposit has to mature when they purchase the house in the future. Deposits of mutiple and different terms can be used to reach period when the deposit is required. Interest to be calculated and paid as specified by the product. (i.e. quarter or annual interest payments etc) To invest today, they have $145,000 to investment today a) Given the money they have available to invest today, apply financial math and calculate the future value of investing in your recommended term deposit, for when they need to buy their house. (show your Excel working, missing working will result in a -4 mark penalty) b) Do they have enough now, to pay for the home deposit required in the future? If yes, by what percentage are they over their deposit. If not, by what percentage are they under their deposit? Teams need to present the results of all tasks in a Business Report format to Mr and Mrs Monash. afford the property. Feel free to see staff in consultation about guidance regarding how to think creatively and how to provide value-add recommendations