Question: Hello! So I'm currently making and using a Monte Carlo Simulation in excel to calculate the probability an individuals savings will last beyond his 85th

Hello! So I'm currently making and using a Monte Carlo Simulation in excel to calculate the probability an individuals savings will last beyond his 85th birthday (which is on December 31st). I've made the simulation, but struggling on how to calculate the probability. Is there an intuitive way to solve this problem? Specifically, the question is phrased "If the professor puts 50% of his savings in stocks, and draws income of $65,000 per year, what is the probability that his savings will last beyond his 85th birthday (which is on December 31st)?"

Is I'm not being clear enough or you need more information to point me in the right direction please let me know! I guess what I'm really wondering is what equation do I use on excel. Thank you in advance!

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 Mathematics Questions!

Hello! So I'm currently making and using a Monte Carlo Simulation in excel to calculate the probability an individuals savings will last beyond his 85th birthday (which is on December 31st). I've...

Hello. we have big question about a finance data. Re-sample returens & portfolio value Summary Stats Year Stocks T-Bills inflation (CPI) Real Gross Portfolio Return Age Return Wealth Path Sim# Final...

Read Chapter 6 of the book "How to measure anything". Now, write a letter to Mr. Williams, starting with the following statement: "Mr. Williams, currently you work with categorical risk metrics...

Attached is the assignment requirement and 2 previous assignments as example 1- the assignment should be zero plagiarism and similarity (no copy ans paste is accepted) 2- should be completed in the...

What is automation and fosbuvir projects? Introduction: You are the senior financial analyst for Fosbeck Generic Drug Co (Fosbeck). The firm manufactures and sells generic over-the-counter drugs in...

NASA/SP-2011-3422 Version 1.0 November 2011 NASA Risk Management Handbook NASA/SP-2011-3422 Version 1.0 NASA Risk Management Handbook National Aeronautics and Space Administration NASA Headquarters...

CASE 10: Increasing the Federal Cigarette Excise Tax When the Congressional Budget Office (2012) published Raising the Excise Tax on Cigarettes: Effects on Health and the Federal Budget, its stated...

1. Texas Roadhouse (TXRH) is rapidly expanding into new markets and had sales of $1,263M in 2012. Suppose you expect sales to grow at a 15% rate in 2013, but this rate will slow by 2% per year to a...

Financial Impacts of Climate Change: Invest or Not? It was a sunny Friday afternoon in downtown Denver, CO, and Skylar Morrisoni was enjoying a muchneeded break in the common area of her venture...

In a three-class, two-dimensional problem the feature vectors in each class are normally distributed with covariance matrix 1.2 0.4 0.4 1.8 The mean vectors for each class are [0.1,0.1], [2.1, 1.9],...

On 1 July 2019, Sage Ltd. purchased land $400,000 and buildings $250,000 paying $200,000 cash with the balance being financed by a bank loan. The estimated useful life of the buildings was 40 years,...

Further evaluating the top project for Roberto, what is the anticipated IRR for the project? 1 3 . 0 2 % 1 1 . 8 % 1 2 . 4 5 % 1 4 . 4 9 %

Prepare a multiple-step income statement for Music Warehouse. Prepare a statement of changes in stockholder's equity for Music Warehouse. Music Warehouse Adjusted Trial Balance December 31, 2008...