Savingforanapartment

From Simulace.info
Revision as of 00:00, 23 January 2023 by Miln02 (talk | contribs)
Jump to: navigation, search

Introduction

Problem definition

Jon has finally graduated to be an engineer and has found his first job. As he is living with his parents and doesn’t own his apartment, he made the decision to start saving so he can buy an apartment in the next 15 years. He already has 100.000 USD that he has saved so far just sitting in his bank account, so he will use that as an initial investment, and after that he will invest a fixed amount of 10.000 USD at the beginning of every year. He now must make a very important decision. Where should he invest his money? After doing some research, he focused on choosing between four different options:

1. Deposit money in the bank.

2. Purchase USA Treasury notes 5Y

3. Invest in NASDAQ.

4. Invest in Tesla.

Method

The problem was solved using Monte Carlo simulation and Excel as an calculation environment. MC was chosen because it's widely used and accepted for solving similar investment problems.

Model

Results

Conclusion

Sources

Code

File:Savingforanapartment.xlsx

Miln02 (talk) 23:01, 22 January 2023 (CET)