ACST201 Financial Modelling Group Spreadsheet Task 3 S2 2017 Group spreadsheet task 3 Today is 1/1/2017. Joe is a 65-year-old retired financial...

Part(b) Based on the Joe's predicted interest rates, use functions or formulae to calculate the current present values of the net costs to a resident in RF and HV, if Joe would only stay in the retirement village for 2 years, 4 years and 10 years. The net costs include ingoing fees, ongoing fees and outgoing fees, and subtract the return of ingoing fees. 

Part(c) Based on the Joe's predicted interest rates and your results in part b, calculate the equivalent monthly net cost (paid at the end of each month) to resident in RF and HV, if Joe would only stay in the retirement village for 2 years, 4 years and 10 years. Use a bar chart or column chart to plot your results.