FINANCE
I ran Monte Carlo Simulation of DCF cashflows with uncertainty in inputs :
-
Investment cost
-
Year 1 revenue
-
Annual Fixed & Variable Cost
-
Annual revenue growth rate
I ran a simulation for analyzing a portfolio containing 4 stocks HDFC, RIL, YES BANK & INDUSIND by considering historical data of the past 10 years. This model takes into account the uncertainty in returns.
In this model, I calculated Minimum Variance, Efficient Frontier, & Distribution of Returns of a 6-stock Portfolio.
-
Stocks - Havells, RIL, Berger Paints, Sun Pharma, ITC and TATA Motors
-
From Date - 20th May 2020
-
To Date - 22nd January 2021
-
Type - Closing Prices
My friend Ankur Bhargava and I worked as information analysts on a case study for Future Cars Inc. We analyzed financial, sales, and operations data across various economic and fuel price scenarios to recommend the best product strategy between hybrid electric and fuel-cell technologies. Our conclusion favored Fuel Cell technology under both high and low economic conditions.
