Difference between revisions of "Savingforanapartment"

From Simulace.info
Jump to: navigation, search
Line 15: Line 15:
 
=Method=
 
=Method=
  
The problem was solved using Monte Carlo simulation and Excel as an calculation environment.  
+
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=
 
=Model=
 +
 +
 +
 +
  
 
=Results=
 
=Results=
  
 
=Conclusion=
 
=Conclusion=
 +
 +
=Sources=
 +
 +
* https://finance.yahoo.com/quote/TSLA
 +
 +
* https://finance.yahoo.com/quote/%5EFVX
 +
 +
* https://finance.yahoo.com/quote/%5EIXIC
  
 
=Code=
 
=Code=

Revision as of 00:00, 23 January 2023

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)