Step 7 only please. Thank you! Introduction You are a financial planner and a new client,...

Step 7 only please. Thank you!

Introduction

You are a financial planner and a new client, Kristina came to your office with the following question: How much should she save annually given her goals?

Kristina is saving for two goals: one is to fund her child Katryna’s college education and the other is to retire.
Katryna will begin college in exactly 18 years, and Kristina will retire on the same day.
College costs for state institutions are currently running at $6,000 per year, and have historically increased at a rate of 5% per year.
Kristina will pay for a 4-year undergraduate education.
Kristina estimates she will live 30-year past her retirement, during which time she would like to pay herself a $60,000 per year salary (first payment occurs at the end of year 18, or beginning of year 19).
On the day she retires, Kristina would like to pay cash for a BMW Z4 convertible or whatever similar model BMW produces at that time. A Z4 cost $55,000 and BMW has increased price at a rate of 7% per year.
Kristina will save annually beginning in exactly one year—18 equal payments spread over time.
The date of the last savings installment coincides with the first tuition payment (and the day of Kristina retirement).
Kristina estimates an 8% expected return on all investments over the period.
How much does she have to save each year to accomplish the above goals?

Step 1: What will be the value of the Z4 of equivalent at the time of purchase? 10 points

Step 2: What will be the value of the 4 annual tuition payments? 15 points

Step 3: What will be the present value of the 4 annual tuition payments? 10 points

Step 4: What will be the present value of the 30 years of salary payments? 10 points

Step 5: What will be the value of Kristina’s savings when she retires? 10 points

Step 6: How much does Kristina need to save every year? 10 points

Step 7: Create a table showing all the additions and subtraction to the savings accounts and the value at the end of each year. (Hint: the value should be close to zero at the end) 25 points

Expert Solution

ekkarill92 answered 9 months ago

please do it step by step with the use of formulas , thank you.. The following...

please do it step by step with the use of formulas , thank you.. The following are monthly percentage price changes for four market indexes. Month DJ SP500 1 0.03 0.02 2 0.07 0.06 3 −0.02 −0.01 4 0.01 0.03 5 0.05 0.04 6 −0.06 −0.04 Russ500 Nicky 0.04 0.04 0.10 −0.02 −0.04 0.07 0.03 0.02 0.11 0.02 −0.08 0.06 (17 points) Compute the following. a. Average monthly rate of return for each index b. Standard deviation for each index...

A financial planner wants to design a portfolio of investments for a client. The client has...

A financial planner wants to design a portfolio of investments for a client. The client has $300,000 to invest and the planner has identified four investment options for the money. The following requirements have been placed on the planner. No more than 25% of the money in any one investment, at least one third should be invested in long-term bonds which mature in seven or more years, and no more than 25% of the total money should be invested in...

You are a financial planner and your private client has given you $10,000,000 to invest for...

You are a financial planner and your private client has given you $10,000,000 to invest for them. Your task is to study the current economic and geopolitical conditions and to invest his money for the highest return. What sector(s) do you think will provide the greatest return and what stocks or other investments within those sectors would you invest in?

You are a graduate financial planner and have been sitting on client interviews with a more...

You are a graduate financial planner and have been sitting on client interviews with a more Senior Financial Planner. As part of this process you have been recording notes and collaborating on any strategy development with the Senior Financial Planner. David & Karen Rubble are new clients and have come to you early in the financial year seeking your advice in regards to their pending retirement. After a fact-finding session you uncover that David is 61 years old and is...

Suppose you work as a financial planner and have a client, Ms. Vanessa Ives, who was...

Suppose you work as a financial planner and have a client, Ms. Vanessa Ives, who was born in 1980 and wants to retire at age 60. Mortality tables indicates that Ms. Ives should expect to live to age 85. Ms. Ives wants a fixed retirement income that has the same purchasing power at the time she retires as $50,000 has today (2018).(You understand that the real value of his retirement income will decline annually after she retires, but consider that...

Please show work step by step, NO EXCEL. Thank you! The investment is $1,000,000, which is...

Please show work step by step, NO EXCEL. Thank you! The investment is $1,000,000, which is depreciated straight line to a zero salvage value over a 10 year life. The asset will be worthless in 10 years. The project will generate, annually, revenues of $800,000, cash operating expenses of $500,000, and depreciation of $100,000. The tax rate is 30%, and the cost of capital is 10%. a. what are the annual cash flow and the NPV? b. what would be...

Could you please give me step-by-step on how to solve this. Thank you! I believe that...

Could you please give me step-by-step on how to solve this. Thank you! I believe that the population proportion for 50% of the people who live in my neighborhood drive a mini van. I surveyed 40 people/houses in my neighborhood and found that only 19 drive mini vans. Use the significance level .10 to test the hypothesis.

Hello can someone please explain the AS AD curve step by step to me? Thank you

Please do step by step clear and show eqations used. Thank you A rocket designed to...

Please do step by step clear and show eqations used. Thank you A rocket designed to place satellites into orbit is carried to a cruising altitude. When the plane is flying in a straight line and at a constant speed of 850 km/h, the rocket is dropped. After the drop the plane continues to fly at the same pseed and in a straight line. The rocket falls for a bried time, and then its propulsion starts. Once the propulsion starts...

Please show work step by step, and no Excel. Thank you! Fei Meng, Incorporated has a...

Please show work step by step, and no Excel. Thank you! Fei Meng, Incorporated has a project with the after-tax cash flows shown below. The required return (cost of capital) on the investment is 10%. Compute the: Year 0 1 2 3 4 Cash flow -70,000 30,000 30,000 30,000 20,000 Payback Discounted payback NPV Profitability index IRR MIRR

Question