Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show workings with excel!! Question 1 1/1 point Your client needs to invest about $69,091 more today to meet her goal to accumulate money

Please show workings with excel!!
image text in transcribed
Question 1 1/1 point Your client needs to invest about $69,091 more today to meet her goal to accumulate money for her child's education--but she does not have it now! When your client discovers her saving will still not accomplish her goal she asks you to determine the additional amount she would need to save each at the end of the year to reach the goal if she earns 9 46 percent compounded annually on her money. So the question is, what additional amounts invested at the end of each year for the next 9 years are equivalent to $69,091 invested today? Round the answer to two decimal places. Answer: 11,740.70 Question 2 1/1 point John's son will start college in 12 years. John estimated a today's value of funds to finance college education of his son as $171,000, Assume that after-tax rate of return that John is able to earn from his investment is 6.93 percent compounded annually. He does not have this required amount now. Instead, he is going to invest equal amounts each year at the beginning of the year until his son starts college Compute the annual beginning of-the-year payment that is necessary to fund the estimation of college costs (Please use annual compounding, not simplifying average calculations) Round the answer to two decimal places Answer: 20.058.91

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

Public Finance

Authors: Harvey Rosen

6th International Edition

0071121234, 978-0071121231

More Books

Students also viewed these Finance questions

Question

Assessments should be completed as per your trainer's instructions

Answered: 1 week ago

Question

3. What might be the response of the attorneys to this change?

Answered: 1 week ago