CHAPTER 5: NEEDS ANALYSIS - HOMEWORK You are a financial consultant who provide financial advices on a fee basis. A client comes to your office to get an appraisal of his financial situation. The client details are extracted and summarised in the application card as follow: Applicant's detail Name Steve Rogers Date of birth/Retirement Age 9 April 1981/60-year-old Marital status Married Dependant(s) / Children) Stanley Rogers and Maira Rogers Amal lucome RM88,800 pa Spouse's details Name Margaret Rogers Date of birth / Retirement Age 11th July 1983 / 55-year-old Annual Income RM62,400 p.a Applicant's Investments and Insurance Details Investment portfolio RM135,000 invested in mutual bonds and savings Insurance RM185,000 life insurance upon maturity Applicant's Needs Education fund for children RM78,000 per child Final burial expense RM21,500 Outstanding personal loans RM64,000 Mortgage on property RM165,000; 15% of the outstanding amount has to be settled in full upon his sudden demise Safety net 70% out of annual income Inflation rate 4.5% pa You are requested to conduct a Needs Analysis for Mt. Steve Rogers based on the information given. Use the table below to assist with your analysis. You are required to attempt this question properly using MS Excel application. Round off all figures to nearest dollar. Needs Analysis for i. Lump-sum needs upou death 11. Income teeds iii. Investment and insurance available iv. Additional life insurance needs CHAPTER 5: NEEDS ANALYSIS - HOMEWORK You are a financial consultant who provide financial advices on a fee basis. A client comes to your office to get an appraisal of his financial situation. The client details are extracted and summarised in the application card as follow: Applicant's detail Name Steve Rogers Date of birth/Retirement Age 9 April 1981/60-year-old Marital status Married Dependant(s) / Children) Stanley Rogers and Maira Rogers Amal lucome RM88,800 pa Spouse's details Name Margaret Rogers Date of birth / Retirement Age 11th July 1983 / 55-year-old Annual Income RM62,400 p.a Applicant's Investments and Insurance Details Investment portfolio RM135,000 invested in mutual bonds and savings Insurance RM185,000 life insurance upon maturity Applicant's Needs Education fund for children RM78,000 per child Final burial expense RM21,500 Outstanding personal loans RM64,000 Mortgage on property RM165,000; 15% of the outstanding amount has to be settled in full upon his sudden demise Safety net 70% out of annual income Inflation rate 4.5% pa You are requested to conduct a Needs Analysis for Mt. Steve Rogers based on the information given. Use the table below to assist with your analysis. You are required to attempt this question properly using MS Excel application. Round off all figures to nearest dollar. Needs Analysis for i. Lump-sum needs upou death 11. Income teeds iii. Investment and insurance available iv. Additional life insurance needs