Question

In: Finance

Use excel and show both the numbers and the formulas so I can learn how to...

Use excel and show both the numbers and the formulas so I can learn how to do it

If I want to invest $1200 a year for 20 years and then stop investing for 10 years, to pay for my slacker child to get a doctorate, how much will I need to invest a year in my final 10 years of work to get my $2,000,000 to make me really happy at 12% interest?

Solutions

Expert Solution

Amount to be invested per annum in final 10 years of work = $66440.87

STEP 1
Annual investment 1200
Term 20 years
Rate 12%
FV of amount after 20 years $86,462.93
STEP 2
PV of amount at T=20 $86,462.93
Term 10 years
Rate 12%
FV of amount at T=30 $268,540.74
STEP 3
PV of amount at T=30 $268,540.74
Term 10 years
Rate 12%
FV required at T=40 2000000
Annual investment required $66,440.87

WORKINGS

jeff jeffy answered 7 months ago
Next > < Previous

Related Solutions

Use excel and please show both formulas and numbers. Answer this: Now if I were investing...
Use excel and please show both formulas and numbers. Answer this: Now if I were investing my $1200 a year at 12% with no children and I win the lottery at year 30 and win $1,000,000 cash, how much money can I blow today (at year 30) and still have the $2,000,000 when I retire at year 40. not sure but it might be a continuation of - If I want to invest $1200 a year for 20 years and...
Please show how you got the answers so that I can learn how to do this!...
Please show how you got the answers so that I can learn how to do this! 200.00mL of 2.00 M solution of a weak acid is mixed with 300.00 mL of a 2.00 M solution containing its conjugate base. 50.000 g of the slightly soluble salt silver acetate (AgC2H3O2) is added to this buffer solution. After thorough mixing, the solution is assumed to be saturated. To determine the amount of the solid which remains undissolved, the solution is filtered, and...
Please use EXCEL to answer and show all formulas. I can't understand the answer if I...
Please use EXCEL to answer and show all formulas. I can't understand the answer if I can't see the formulas for each field. Thank you very much. Newman manufacturing is considering a cash purchase of the stock of Grips Tool. During the year just​ completed, Grips earned $4.25 per share and paid cash dividends of ​$2.55 per share ​(D0=$2.55). Grips' earnings and dividends are expected to grow at 25​% per year for the next 3​ years, after which they are...
Show work (excel if possible but show formulas you used in excel): If I buy a...
Show work (excel if possible but show formulas you used in excel): If I buy a new car and pay $399 a month for 5 years and the maintenance costs are $50 the first year and increase by $200 a year for each year after that, how much money would I have to barrow today at a nominal interest rate of 9% to cover my monthly payment and my yearly maintenance bill?
Show work (excel if possible but show formulas you used in excel): If I buy a...
Show work (excel if possible but show formulas you used in excel): If I buy a new car and pay $399 a month for 5 years and the maintenance costs are $50 the first year and increase by $200 a year for each year after that, how much money would I have to barrow today at a nominal interest rate of 9% to cover my monthly payment and my yearly maintenance bill?
what are the formulas for each column so i can understand where the numbers are coming...
what are the formulas for each column so i can understand where the numbers are coming from. refer to Question: Historical data indicate that a student's income for any month...part of the answer has been posted on Chegg but the formulas are needed.Thanks! Assuming the student begins the school year with a balance of $1200, use Excel to simulate 12 months of activity and to predict the position of the student at the end of the year. Historical data indicate...
Can you please post the excel answers and post the (SHOW FORMULAS) button as well so...
Can you please post the excel answers and post the (SHOW FORMULAS) button as well so I can see how you solved the question The Air Marshal Co. has recently completed a $10,000,000 two-year marketing study.  Based on the results of this study, Air Marshal has estimated that 800 units of its new security electro-optical human scanning hardware, known as "Marshal Dillon," could be sold annually over the next 12 years, at a price of $110,000 the first year with an...
Can you please post the excel answers and post the (SHOW FORMULAS) button as well so...
Can you please post the excel answers and post the (SHOW FORMULAS) button as well so I can see how you solved the question The Air Marshal Co. has recently completed a $10,000,000 two-year marketing study.  Based on the results of this study, Air Marshal has estimated that 800 units of its new security electro-optical human scanning hardware, known as "Marshal Dillon," could be sold annually over the next 12 years, at a price of $110,000 the first year with an...
Can you please post the excel answers and post the (SHOW FORMULAS) button as well so...
Can you please post the excel answers and post the (SHOW FORMULAS) button as well so I can see how you solved the question The Air Marshal Co. has recently completed a $10,000,000 two-year marketing study.  Based on the results of this study, Air Marshal has estimated that 800 units of its new security electro-optical human scanning hardware, known as "Marshal Dillon," could be sold annually over the next 12 years, at a price of $110,000 the first year with an...
Can you please post the excel answers and post the (SHOW FORMULAS) button as well so...
Can you please post the excel answers and post the (SHOW FORMULAS) button as well so I can see how you solved the question The Air Marshal Co. has recently completed a $10,000,000 two-year marketing study.  Based on the results of this study, Air Marshal has estimated that 800 units of its new security electro-optical human scanning hardware, known as "Marshal Dillon," could be sold annually over the next 12 years, at a price of $110,000 the first year with an...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT