Question: Assumption: Interests are compounded annually Answer to 13 from the Instructions file: Answer to 13b from the intructions file: a. Given the above portfolio, how

Assumption: Interests are compounded annually Answer to 13 from the Instructions file: Answer to 13b from the intructions file: a. Given the above portfolio, how many years do you need to invest to have at least $1 million in your bank accounts? Type your answer next to the top highlighted cell which is L14. - If the future values do not add up to over $1 million, adjust the "number of years" of your investment (B4) until they do. Use a realistic amount you can afford to set aside in each year. b. Now reset the value of B4 to 10 . Following the same procedure, try to answer: What's the "amount per period" do you need to invest in order to have exactly $1 million (accurate to 41 decimal places or more) in exactly 10 years? Type your answer next to the bottom highlighted cell which is L15
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
