A pleasant gentleman has advised you via email that you are entitled to a $1 million inheritance. Putting specifics aside, you start to ponder the retirement nest-egg this could help you accumulate over the next 30 years. As a diligent finance student you do some research and find that the money can be invested into an account paying a fixed 4% rate, compounded quarterly. How much retirement money would be in the account after 30 years? (round to nearest dollar)  Answer in written and excel

Q: Michael is updating his estate plan for himself and his family. He would like to provide an income…

A: It is assumed that, 10.5 years from now.

Q: Your finance professor suggests that you should have $2,500,000 in your retirement portfolio before…

A: To open the "PV function" window - MS-Excel --> Formulas --> Financials -->PV.

Q: Holly Krech is planning for her retirement, so she is setting up a payout annuity with her bank. She…

A: Given: Holly Krech is planning for her retirement, so she is setting up a pay-out annuity with her…

Q: Using the Time Value of Money for Retirement Planning. Carla Lopez deposits $3,400 a year into her…

A: Given: Annual deposit = $3,400 Interest rate = 9% Number of years = 40 Value of the retirement…

Q: Your rich uncle bequests to you a continuous, constant income stream of $9000 per year for the next…

A: Hi There, thanks for posting the question. But as per Q&A guidelines, we must answer the first…

Q: Nick has calculated his retirement needs.  He would like to receive $1,000 per month for 20 years…

A: The present value of the annuity is the current worth of a cash flow series at a certain rate of…

Q: Planning to give his son a car as a gift when he graduates from college 2 years from now, Adam…

A: 2 years from now , Monthly Payment = 21500 Time Period = 3 years × 12 = 36 months Interest Rate =…

Q: Your brother has asked you to help him with choosing an investment. He has $4,500 to invest today…

A: Future Value: It refers to the value of any investment or asset in a specified future date.

Q: Mr. Lau is updating his estate plan for himself and his family. He would like to provide an income…

A: Life insurance provides financial coverage provided by insurance companies after the death of…

Q: Upon retirement, your goal is to spend 6 years traveling around the world. To travel in the style to…

A: Given Information: Periodic payment = $225,000 Rate of interest = 9% compound annually Period = 24…

Q: A pleasant gentleman has advised you via email that you are entitled to a $1 million inheritance.…

A: The inheritance amount of $1 million is the present value (PV) and we will calculate the future…

Q: A pleasant gentleman has advised you via email that you are entitled to a $1 million inheritance.…

A: MS-Excel --> Formulas --> Financials --> FV Therefore, the future value of retirement is…

Q: Morgan Jennings, a geography professor, invests $83,000 in a parcel of land that is expected to…

A: The question is based on the concept of Annuity and Future value

Q: An engineer who is saving for her retirement plans to deposit $500 every semiannually, starting…

A: Semi Annual Deposit = 500 End of period deposits Nominal Rate = 12℅ Quarterly Compounding N = 25…

Q: You want to retire soon. When you finally retire, you want your investments to provide you with an…

A: Retirement needs: 150,00 means 15,000 15,000 each year for next 40 years N = 40 Annual Interest…

Q: How much money will they have accumulated 30 years from now

A: Let us first determine how much we will save in the first 10 years of the saving plan. T =…

Q: Suppose you are 30 years old and would like to retire at age 60. ​Furthermore, you would like to…

A: Annuity means a series of finite number of payments which are equal in size and made in equal…

Q: A rich relative has bequeathed you a growing perpetuity. The first payment will occur in one year…

A: Growing perpetuity: These are the cashflows that grow forever and doesn't remain fixed. They keep…

Q: As part of your financial planning and to supplement your retirement, you decided to save $3000 at…

A: Future value is the expected value of the current amount at a future date at a given specific rate…

Q: You’ve landed your first job after graduation. Although retirement may seem like a long way off, you…

A: contribution =$7000 per year  interest rate =6% Period =35 Future value FACTOR =(1+r)n-1/r…

Q: How much should you deposit at the end of each month into an investment account that pays 8.5%…

A: The interest amount is calculated as the future value of annuity minus the total deposits made over…

Q: You decide to make monthly payments into a retirement fund earning 4.75% compounded monthly.  Note:…

A: Honor code: Since you have asked multiple questions, we will solve the first question for you. If…

Q: A client wants to retire in 20 years and expects to enjoy retirement for at least 25 years. They…

A: As per the time value of money, a dollar is worth more today than the same dollar in the future.…

Q: You have just inherited $100,000 as a lump-sum amount from your distant aunt. After depositing the…

A: In order to find the number of years taken to withdraw the amount one can use excel and in excel…

Q: you are trying to determine how much you should save fc you can spend now. For retirement, you will…

A: You need to calculate present value of all objectives on given date.

Q: A pleasant gentleman has advised you via email that you are entitled to a $1 million inheritance.…

A: The field "Type" in excel formula, represent the time of payment, whether it is made at the…

Q: 1)A young couple wants to have a college fund that will pay $30,000 at the end of each half-year for…

A: PV is the current worth of cash flows that are expected to occur in the future.

Q: Suppose a woman has decided to retire as soon as she has saved $800,000. Her plan is to put $950…

A: Given: Future value =$800,000 Deposits per month = $950 Annual interest rate =2.4% So, monthly rate…

Q: You decide to make monthly payments into a retirement fund earning 4.75% compounded monthly.  Note:…

A: We will apply the formula for calculating the future value of the money so that we can calculate the…

Q: You deposit $5000 each year into your retirement account, starting in one year. If these funds earn…

A: Answer:   Following information are given:   Annual deposit = $5000 Rate = 5% Time ( no of periods)…

Q: You have finished your time at Kelley and need to start thinking about retirement. You plan on…

A: Given: amount required after retirement at every six months = $75,000 Period of service = 30 years…

Q: Suppose you are 40 years old and plan to retire in exactly 20 years. 21 years from now you will need…

A: Hi There, Thanks for posting the questions. As per our Q&A guidelines, must be answered only one…

Q: After completing your Bachelor of Business (Accounting) degree, suppose you secure a permanent…

A: Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: Michael is updating his estate plan for himself and his family. He would like to provide an income…

A: Solution- Present value of future withrawal ason 10.5 years=Monthly withdrawal ×Present value…

Q: Your friend already has $20,000 in an investment account. In addition to this amount, she is…

A: Given Information: Amount in investment account - $20,000 Additional amount invested at the end of…

Q: Your brother has asked you to help him with choosing an investment. He has $7,700 to invest today…

A: Future value represents the value of the investment in the future date of the company.

Q: Mr. White is updating his estate plan for himself and his family. He would like to provide an income…

A:

Q: a pleasnat gentlemen has advised you via email that you are getting $1 million inheritance.  You can…

A: Calculate the retirement amount as follows:

Q: A couple wants to set up a college savings account for their grandchild. If the account earns 4.4%…

A: We need to calculate Present value of $50000, using time value of money formulae.

Q: A pleasant gentleman has advised you via email that you are entitled to a $1 million inheritance.…

A: Note: Future value is taken as $3300386.89457367, no intermediate rounding is done. With a future…

Q: Suppose you want to use this fund to buy a $279,000 houseboat when you retire in 40 years. How much…

A: Future Value = $279,000 Interest Rate = 4.75% Time Period = 40 Years

Q: tarting 10.5 years from now and continuing for the next 20 years. He has started his account with an…

A: Annuity is a concept of uniform series of equal payment throughout the given time period. It can be…

Q: ou decide to make monthly payments into a retirement fund earning 4.75% compounded monthly. Note:…

A: The question is based on the concept of Annuities. Annuity refers to the series of equal payments or…