Calculation and Case Analysis (24 points)

1. (6 points) Today Mr. Raj Jaipur turns into 50 years old. Mr. Raj will retire at the age of 60, and he plans to live until age of 75. He assumes he will have a good health after retirement, and will naturally pass away. His yearly expenses after retirement is approx. 450,000 Baht per year. Expected interest rate during his retirement period is approximately 4%.

1A) How much Raj must have at the age of 60 years old?

1B) From your answer in 1A), if Raj wants to accomplish his retirement goal, and he plans to invest equally each year in RMF (mutual funds for retirement) starting the end of this year. Assume the rate of return on RMF is 7%. How much Raj should invest in RMF each year until he retires?

1C) From your answer in 1A), if Raj wants to accomplish his retirement goal, but he wants to deposit/invest a lump sum amount today, rather than investing each year in RMF. He observes that investing in XT companys stock could provide him approximately 12% return per year, despite the risk from investment. How much Raj should invest in XT companys stock today?

2. (8 points) Case Tim Sandee: Tim has been legally married to Nan for 15 years. On the wedding, Tim gave a 1.0 million Baht to Nan for wedding jewelry as a wedding present. Nan has her luxury jewelry from her parents before married, value 850,000 Baht. They have only one daughter, Nitta, ages 9 years old. Tims parents are both alive, and they live with Times elder sister. Two years after their marriage, Tim and Nan bought a new house on Sukhumvit road, todays value 4.40 Million Baht.

Tim died because of the heart failure last week, his funeral just finished last night. Tims estate is worth 14 million Baht (cash and saving deposit at the bank). In Tims will, he stated his intention to give 500,000 Baht to Siriraj Hospital Foundation, and gives the house to his wife and daughter, and the rest of his estate shall be divided among his statutory heirs.

3. (10 points) Case Ms. Napa: Use Ms. Napa financial statements for analysis.

Ms. Napa Napasri, a 28-year-old senior sales officer, is enjoying her career. This year she got married to Mr. Ross Geller-a 32 year old American entrepreneur. Ms. Napa moved into Mr. Rosss house to live together and she helps with the living expenses. She let her friend rent her condominium to earn some rental income. Ms. Napa still has her car loan and condominium loan. Mr. Rosss business is still in the initiation stage. Because of these financial challenges and the cultural difference, the couple decided not to register for a marriage certificate and delay having their first child. Financial statements for Ms. Napa and Mr. Ross are analyzed separately. Beginning a grown-up life, Ms. Napa would like to know her financial status and pay more attention to her personal financial planning.

Financial statements for Miss Napa are provided.

Baht Miss Napa's Balance Sheet as of December 31, 2020 Assets Baht Liabilities & Net worth Liquid assets Current Liabilities Cash 40,000 Condo loan due within 1 year 140,000 Savings account 200,000 Car loan due within 1 year 100,000 Fixed account 100,000 Charges on credit card balances 34,000 Total liquid assets 340,000 Personal Loan from K-Bank 40,000 Investment assets Total current liabilities 314,000 Common stock 200,000 Long-term liabilities RMF (retirement mutual funds) 100,000 Condo loan, remaining balances 1,900,000 Provident funds 160,000 Car loan, remaining balances 140,000 Savings for future 100,000 Total long term liabilities 2,040,000 Total investment assets 560,000 Total Liabilities 2,354,000 Household assets & possessions Jewelry from wedding 500,000 Net worth 2,546,000 Cars (market value) 600,000 Condominium (market value) Note: * Assume her "loan installment and debt payment 2,900,000 include all items in total liabilities. Total household assets and possessions 4,000,000 Total assets 4,900,000 Total liabilities and net worth 4,900,000 Ms. Napa's Statement of Cash flows for the end of year 2020 Cash inflows Baht Salary and bonus 660,000 Commission 188,000 Business allowance from company 48,000 Interest earned 6,200 Dividends earned 15,000 Rental income 65,000 Total cash inflows (revenues) 982,200 Fixed expenses Condominium loan payment 140,000 instaliment) Management fee for 24,000 condominium Car loan payment installment) 100,000 Give to parents 60,000 Social security 9,000 Total fixed expenses 333,000 Variable expenses Food expense 60,000 Utilities (water, electricity) 36,000 Telephone & Internet 12,000 Recreation /entertainment/trip 70,000 Tax paid 38,320 Socializing (party, sport club) 25,000 Transportation 32,000 Clothing 30,000 Medical expenses 7,000 Donation for temples 3,000 Total variable expenses 313,320 Cash flows for saving/investment Savings & fixed accounts 85,000 RMF mutual funds 100,000 Provident funds 30,000 Total cash flows for savings/investment 215,000 Total cash outflows 861,320 Net cash flows 120,880