Question

Saved Help Save & E Assume you work at MW Custom Financial Solutions, and a client wants to invest their small lottery winnin
0 0
Add a comment Improve this question Transcribed image text
Answer #1

To calculate the worth of that amount use the formula of Future Value (FV) in excel

=FV(Rate,nper,pmt,pv)

Where:

Rate = 15.40%/4 = 3.85%

nper = 13*4

pmt = 0

pv = $325,000

=FV(3.85\%,52,0,-\$325,000)

Future Value = \$2,317,508.88

So after 13 year the worth of his $325,000 would be $2,317,508.88

I hope this clear your doubt.

Feel free to comment if you still have any query or need something else. I'll help asap.

Do give a thumbs up if you find this helpful.

Add a comment
Know the answer?
Add Answer to:
Saved Help Save & E Assume you work at MW Custom Financial Solutions, and a client...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • As a financial advisor you have a high wealth client who is thinking about making some...

    As a financial advisor you have a high wealth client who is thinking about making some life changes. Stanley is 50 (today is his birthday), and he want to retire at 65. He wants to put away the same amount of money every birthday (starting today) up to and including his 65th birthday. He then wants to be able to withdraw $100,000 every birthday (starting with his 66th) up to and including his 85th birthday.   He believes he can earn...

  • Please solve using financial calculator only and show work. Thank you. 28. Your brother has asked you to help him with c...

    Please solve using financial calculator only and show work. Thank you. 28. Your brother has asked you to help him with choosing an investment. He has $5,200 to invest today for a period of five years. You identify a bank CD that pays an interest rate of 3.60 percent with the interest being paid quarterly. What will be the value of the investment in five years? 29. Tim has loaned money to his brother at an interest rate of 6...

  • You are an investment advisor who has been approached by a client for help on his...

    You are an investment advisor who has been approached by a client for help on his financial strategy. He has $250,000 in savings in the bank. He is 55 years old and expects to work for 10 more years, making $100,000 a year. (He expects to make a return of 5% on his investments for the foreseeable future. You can ignore taxes) a. Once he retires 10 years from now, he would like to be able to withdraw $80,000 a...

  • 20. You are an investment advisor who has been approached by a client for help on...

    20. You are an investment advisor who has been approached by a client for help on his financial strategy. He has $250,000 in savings in the bank. He is 55 years old and expects to work for 10 more years, making $100,000 a year. (He expects to make a return of 5% on his investments for the foreseeable future. You can ignore taxes) a. Once he retires 10 years from now, he would like to be able to withdraw $80,000...

  • The present value of an annuity is the sum of the discounted value of all future...

    The present value of an annuity is the sum of the discounted value of all future cash flows. You have the opportunity to invest in several annuities. Which of the following 10-year annuities has the greatest present value (PV)? Assume that all annuities earn the same positive interest rate. bevinning of each year An annuity that pays $500 at the end of every six months An annuity that pays $1,000 at the beginning of each year An annuity that pays...

  • please help answer these Financial Analysis Exercise #1 You are the newest Financial Analyst in Investments,...

    please help answer these Financial Analysis Exercise #1 You are the newest Financial Analyst in Investments, you need to demonstrate your prowess in Excel, your outstanding written skills and ability to communicate. Mr. Richards is the Executive Vice President and Chief Investment officer in your new firm. You are being asked to complete a series of “pet” projects for Mr. Richards. You have been told not to try to impress him, just do the work and stick to the facts....

  • Decision #1: Which set of Cash Flows is worth more now? Assume that your grandmother wants...

    Decision #1: Which set of Cash Flows is worth more now? Assume that your grandmother wants to give you generous gift. She wants you to choose which one of the following sets of cash flows you would like to receive: Option A: Receive a one-time gift of $10,000 today. Option B: Receive a $1400 gift each year for the next 10 years. The first $1400 would be received 1 year from today. Option C: Receive a one-time gift of $17,000...

  • Decision #1: Which set of Cash Flows is worth more now? Assume that your grandmother wants...

    Decision #1: Which set of Cash Flows is worth more now? Assume that your grandmother wants to give you generous gift. She wants you to choose which one of the following sets of cash flows you would like to receive: Option A: Receive a one-time gift of $ 10,000 today. Option B: Receive a $1400 gift each year for the next 10 years. The first $1400 would be received 1 year from today. Option C: Receive a one-time gift of...

  • FOCUS ON SHOWING CORRECT TIMELINE! THANKS Problem: Assume you are 32 years old and plan to...

    FOCUS ON SHOWING CORRECT TIMELINE! THANKS Problem: Assume you are 32 years old and plan to retire in 35 years at age 67. You are currently earning $75,000/ year and expect average annual salary increases of 4.0%year over the next 35 years. You have $0 saved for retirement. You are trying to determine how much money to save (invest) each year in your 401(k) Plan to fund your retirement in order to pay yourself 70% of your final salary each...

  • 1. You have $200 to invest. If you put the money into an account earning 4​%...

    1. You have $200 to invest. If you put the money into an account earning 4​% interest compounded​ annually, how much money will you have in 10 years? How much money will you have in 10 years if the account pays 4​% simple​ interest? 2. You have $1,300 to invest today at 5​% interest compounded annually. a.  Find how much you will have accumulated in the account at the end of​ (1) 6 ​            years, (2) 12 years, and​ (3)...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT