List the results of your Monte Carlo simulation

Reference no: EM132379791

Assignment -

Assume you are 22 years old and graduating from college with no assets and no debt. How will you get to age 65 (retirement) with a net worth of $10 million?

Table 1: In your spreadsheet it will list your assumptions. Make it a "live" table so that you can change the values in the list of assumptions and the results will be reflected in the calculations table.

Table 2: This is the calculations table. Make a table that has one row for each year. The columns in the table are the calculated results of the various assumptions you make. Columns should be things like how your salary increases at a rate that is listed in Table 1. How much you save from your salary should be a column. Each way you invest will be a column in Table 2. The farthest right column in the table will be the sum of your net worth each year.

Table 3: List the results of your Monte Carlo simulation as you change assumptions and iterate your way to a solution that gives you $10 million when you reach age 65.

Reference no: EM132379791

Questions Cloud

ELM535 Classroom Management Assignment Problem : ELM535 Classroom Management assignment help and solutions, Grand Canyon University, assessment help - It is crucial to show students how to take ownership.

What dividend yield and capital gain rate : What is the most you would pay today for Company A's stock? What dividend yield and capital gain rate would you expect at this price?

Prepare a classified balance sheet for vosburgh at december : Deferred revenue represents customer payments for extended service contracts. Eighty percent of these contracts expire in 2019, the remainder in 2020.

Omnicom has three major competitors : Omnicom has three major competitors: RR Donnelly (P/E = 6.0), CDK Global (P/E = 27.7), and Interpublic (P/E = 14.0).

List the results of your Monte Carlo simulation : List the results of your Monte Carlo simulation as you change assumptions and iterate your way to a solution that gives you $10 million when you reach age 65

What is the banks asset utilization ratio : A bank has interest income to total assets ratio of 5.45% and has noninterest income of $45 million and total assets of $700 million.

Investor actual real after tax rate of return : Given that the investment income was subject to a federal tax rate of 28% and a state, and local tax rate of 6%, what was the investor's actual real after tax

How much is the conversion cost per unit if ending work : How much is the conversion cost per unit if ending work in process was 25% complete a nd total conversion costs equaled $100040?

MITS5507 Business Process Management Assignment Problem : MITS5507 Business Process Management Assignment help and solution, Victorian Institute of Technology, prepare a report or critique on an academic paper

User Account

All Pages