Old MathJax webview

please finish question a to d, and provide detailed explanations. Thanks a lot and I will give you a like!!!!

please finish a to c.

Exercise to Calculate the Required Rate of Return for Your Client 1. Paul is a social worker. He lives with his wife in a village in New Territories. He has an outstanding fixed mortgage payment of $15,000 per month for 5 years. The interest morta rate is fixed at 5% p.a. He wishes to advance his mortgage payment by two years by paying a lump sum (i.c. pay at Year 3). Paul and his wife, Pauline have a 10-year old daughter, Polly. They wish to send her ? daughter to a UK university for 4-year study in 8 years' time. It is expected to cost $250,000 for every 6-month in present value terms. Fun Paul intends to make an initial contribution of $800,000. After that, he believes he can make $3,000 regular contribution for every 6-month (starting at t = 0.5) while he is paying the mortgage. This contribution is expected to grow with an inflation rate of 3%. After repayment his mortgage in 3 years' time, he believes he can make an extra contribution of $7,500 per month (or $45,000 for every 6-month (starting at t= 3.5). Again, this contribution is expected to grow with inflation rate. a. Assume there are no extra interest and handling charges, what will be the amount he needs to repay the bank if he wants to repay all his mortgage by 2 years? end of year) (6 marks) Hints: PV Aordinary =(1-1) where c, r and t are periodic payment, periodic interest rate and number of periods respectively. (+r) b. Estimate Paul's daughter education expenses at t = 8.8.5. .... and 11.5. (4 marks) c. Estimate Paul's regular contributions while he is still payment the mortgage at t = 0.5, 1, ... and 3 (3 marks) d. Estimate Paul's regular contributions while he has fully paid the mortgage att = 3.5. 4. .... and 11.5. (3 marks) e. Use the information provided and the answers from a) to d) to complete the below ( Cash Outflow J Daugher's Early repayment Year Initial Investment Regular Contribution Education Cash Flow of mortgage Expense cash flow table. (Cinch Infrow) aret Cash Flow) 0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 B 8.5 9 9.5 10 10.5 11.5 f. Calculate the IRR of the estimate cash flow. (3 marks) Exercise to Calculate the Required Rate of Return for Your Client 1. Paul is a social worker. He lives with his wife in a village in New Territories. He has an outstanding fixed mortgage payment of $15,000 per month for 5 years. The interest morta rate is fixed at 5% p.a. He wishes to advance his mortgage payment by two years by paying a lump sum (i.c. pay at Year 3). Paul and his wife, Pauline have a 10-year old daughter, Polly. They wish to send her ? daughter to a UK university for 4-year study in 8 years' time. It is expected to cost $250,000 for every 6-month in present value terms. Fun Paul intends to make an initial contribution of $800,000. After that, he believes he can make $3,000 regular contribution for every 6-month (starting at t = 0.5) while he is paying the mortgage. This contribution is expected to grow with an inflation rate of 3%. After repayment his mortgage in 3 years' time, he believes he can make an extra contribution of $7,500 per month (or $45,000 for every 6-month (starting at t= 3.5). Again, this contribution is expected to grow with inflation rate. a. Assume there are no extra interest and handling charges, what will be the amount he needs to repay the bank if he wants to repay all his mortgage by 2 years? end of year) (6 marks) Hints: PV Aordinary =(1-1) where c, r and t are periodic payment, periodic interest rate and number of periods respectively. (+r) b. Estimate Paul's daughter education expenses at t = 8.8.5. .... and 11.5. (4 marks) c. Estimate Paul's regular contributions while he is still payment the mortgage at t = 0.5, 1, ... and 3 (3 marks) d. Estimate Paul's regular contributions while he has fully paid the mortgage att = 3.5. 4. .... and 11.5. (3 marks) e. Use the information provided and the answers from a) to d) to complete the below ( Cash Outflow J Daugher's Early repayment Year Initial Investment Regular Contribution Education Cash Flow of mortgage Expense cash flow table. (Cinch Infrow) aret Cash Flow) 0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 B 8.5 9 9.5 10 10.5 11.5 f. Calculate the IRR of the estimate cash flow