Simulate Amanda's portfolio over the next 30 years and determine how much she can expect to have in her account at the end of that period. At the beginning of each year, compute the beginning balance in Amanda's account. Note that this balance is either 0 (for year 1) or equal to the ending balance of the previous year. The contribution of $5,000 is then added to calculate the new balance. The market return for each year is given by a normal random variable with the parameters above (assume the market returns in each year are independent of the other years). The ending balance for each year is then equal to the beginning balance, augmented by the contribution, and multiplied by (1+Market return). What is the standard deviation of the ending balance? What does the distribution look like? What should Amanda infer from this?
Correct Answer:
Verified
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q1: A key objective in cash flow models
Q6: A tornado graph lets us see which
Q9: In investment models,we typically must simulate the
Q14: In financial simulation models,we are typically more
Q23: A @RISK output range allows us to
Q24: In marketing and sales models,the primary source
Q25: The @RISK function RISKUNIFORM (0,1)is essentially equivalent
Q52: Simulate Amanda's portfolio over the next 30
Q55: Simulate Amanda's portfolio over the next 30
Q57: Simulate Amanda's portfolio over the next 30
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents