Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help writing a formula to find the probability that your final withdrawal is below 50% of what you would like to be able to

image text in transcribed

Need help writing a formula to find the probability that your final withdrawal is below 50% of what you would like to be able to withdraw. Any help is appreciated. Thank you.

You just retired with $3,400,000 savings. You plan to withdraw money from your account at the beginning of each year to live on, and would like to withdraw $$156,000 the first year and then increase the withdraw amount enough each year to keep up with inflation. You plan to invest 50% of your funds in a risk free account that will earn 3.9% per year and the rest in a risky portfolio where you expect the returns to follow a lognormal distribution with a mean of 8.1% and a standard deviation of 16.8%. You are concerned that if your risky portfolio underperforms you will run out of money, so you are considering limiting the withdraws to a percentage of the money in your account at the start of the year. Use Monte Carlo simulation to estimate the probability that your final withdraw will be less than half of what you would like to withdraw using different withdraw limits. Assume you will be retired for 26 years. ( 50 points total)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Foundations Of Financial Management

Authors: Stanley Block

8th Canadian Edition

0070965447, 9780070965447

More Books

Students also viewed these Finance questions