Question: Do it on excel please Q1. Your parents will retire 20 years from now. By then, in $ today (PV), they need a lump sum

Do it on excel please

Q1. Your parents will retire 20 years from now. By then, in $ today (PV), they need a lump sum of $2,000,000. The annual rate of inflation for the next 20 years is 5% compounded semi- annually. There is an investment opportunity with a yield of 10% annually compounded monthly. Adjusted for inflation, what is the total fund they need by the year they become retired?

Q2. To achieve their retirement goal, how much should they deposit every month for the next 20 years? Ignore the effect of taxes

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Reconsider the overall distance data for golf balls in Exercise 10-29. Is there evidence to support the claim that the standard deviation of overall distance is the same for both brands of balls (use...

using the imcome statement, balance sheet, and cash flow statements where do i find total debts & stock price? also, im not sure where to begin with the excel charts below. any help would be...

ASSIGNMENT #1 The purpose of this assignment is to solidify your understanding on the applications of the time value of money. The scores of this assignment will help in assessing the following...

Can i get some help with this problem? AutoSum Recently Financial Edgka Insert Time Reference Trig Used Function Function Library C16 F E B 3 trving to decide how much to save for retirement. Assume...

The company is Johnson & Johnson the first picture is the prompt and the others are the slides that needs to be filled in. i am stuck on the monthly and annual slides. Here is the information for...

1) Common-sized balance sheets A) show data for companies in the same industry. B) show data for companies with approximately the same amount of assets. C) show each balance sheet account as a...

5) Jones, Inc. has a current ratio equal to 1.40. Which of the following transactions will increase the company's current ratio? A) The company collects $500,000 of its accounts receivable. B) The...

Course Textbook Lasher, W. R. (2011). Practical financial management (6th ed.). Mason, OH: South-Western. question1 1) Valuation options The following information refers to a six-month call option on...

Can someone help me decipher the answer I received? ANSWER BELOW FOR EXCEL: E M N 1 Year 1 F H Time Value of Money - Annual Compounding 2 3 4 5 6 7 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 00 9 2 Rate of...

For Johnson and Johnson, I need help determining the PV and NPV based off the end of Q1 of 2022 and Q1 of 2021 for the same company. Below are the tables. Thanks! Time Value of Money - Present Value...

Build a working spreadsheet to answer this question: Xenia wins the lottery! She has a choice between Option A: $21,000,000.00 received today. Option B: 24 payments of $1,737,119.56 at the start of...

A famous and anonymous axiom about quality is: We never have time to do it right the first time but, we always have time to do it over. How and where in the project plan, would you build into your...

A bank agrees to buy 1 million at 1 = $1.41 in one year, i.e., the bank buys 1 million with a forward contract. The euro and dollar interest rates are 5% and 3% respectively. (a) Calculate the delta...

When talking about the risk that is related to farm business borrows money and creates an obligation and to repary debt, we call that financial risk. True False

A company issues 1,050 shares of its common stock for $33,600 cash. Prepare journal entries to record this event under each of the following separate situations.