Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Risk Management And Financial Institutions

Authors: John Hull

1st Edition

0132397900, 9780132397902

More Books

Students also viewed these Finance questions

Question

=+16.9. 1 Suppose that u (f) Answered: 1 week ago

Answered: 1 week ago

Question

4. Choose appropriate and powerful language

Answered: 1 week ago

Question

2. Choose an appropriate organizational pattern for your speech

Answered: 1 week ago