Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Answer the followings. You do not have to copy down the questions, just provide your answers, numbered accordingly. You are a financial consultant who provide
Answer the followings. You do not have to copy down the questions, just provide your answers, numbered accordingly. You are a financial consultant who provide financial advice 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 Lee Yeon Date of birth/Retirement Age 9th April 1982 / 60-year-old Marital status Married Dependant(s)/Child(ren) 2 children Annual Income RM89,500 p.a Spouse's details Name Nam Jia Date of birth / Retirement Age 11'" July 1980 / 56-year-old Annual Income RM63,450 p.a Applicant's Investments and Insurance Details Fixed deposit RM165,000 Life insurance RM185,000 upon maturity Applicant's Needs Education fund for children RM80,000 per child Final burial expense RM20,000 Outstanding car loans RM64,000 Mortgage on house RM485,000; 40% of the outstanding amount has to be settled in full upon his sudden demise Safety net 70% out of annual income Inflation rate 4.25% p.a Ne You are requested to conduct a Needs Analysis for Mr. Lee Yeon 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 upon death ii. Income needs iii. Investment and insurance available iv. Additional life insurance needs Answer the followings. You do not have to copy down the questions, just provide your answers, numbered accordingly. You are a financial consultant who provide financial advice 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 Lee Yeon Date of birth/Retirement Age 9th April 1982 / 60-year-old Marital status Married Dependant(s)/Child(ren) 2 children Annual Income RM89,500 p.a Spouse's details Name Nam Jia Date of birth / Retirement Age 11'" July 1980 / 56-year-old Annual Income RM63,450 p.a Applicant's Investments and Insurance Details Fixed deposit RM165,000 Life insurance RM185,000 upon maturity Applicant's Needs Education fund for children RM80,000 per child Final burial expense RM20,000 Outstanding car loans RM64,000 Mortgage on house RM485,000; 40% of the outstanding amount has to be settled in full upon his sudden demise Safety net 70% out of annual income Inflation rate 4.25% p.a Ne You are requested to conduct a Needs Analysis for Mr. Lee Yeon 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 upon death ii. Income needs iii. Investment and insurance available iv. Additional life insurance needs
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started