top of page


In this case study, my friend Ankur and I :

1) Prepared and Analyzed the Financial, Sales and Operations data.

2) Recommended which designs were the best based on the reports generated

3) Also prepared a brief report with recommendations

Financial Data

A bond price calculator has the following inputs: 

  • Required Rate of Return & Coupon Rate

  • Settlement & Maturity Date

  • Frequency (Annual, Half-Yearly & Quarterly)

  • Face Value

  • Par Value per 100

  • Time Calculation Method

Monitoring market fluctuations

I ran Monte Carlo Simulation of DCF cashflows with uncertainty in inputs : 

  1. Investment cost

  2. Year 1 revenue

  3. Annual Fixed & Variable Cost

  4. Annual revenue growth rate

Financial Report

I made an excel model which consists of 22 Option Chain Strategy Demos. 

Stock Ticker Board

I made a bond immunization model which focuses mainly on Duration & Immunization.


Black Scholes model helps us to find out the ideal put price and call price for an underlying equity based on holding period, volatility, current price and strike price (exercise price).

In this model, I have also added sensitivity analysis for call price and strike with reference to changes in stock price and its volatility.

Financial Graphs

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

Financial Data

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.

Monitoring market fluctuations

This project focuses on sensitivity analysis in capital budgeting.

Financial Report

I made a simple stock portfolio dashboard on Microsoft Excel.

Stock Market

Power BI Report focused on Finance Metrics, What-If Analysis & Time Intelligence

Bar Chart

I computed Theta & Delta (Greeks) for the Options of a stock. For this, I used Merton model (continuously dividend-paying stock) to compute the option prices with given inputs such as stock price, time, exercise price, volatility, risk free rate etc.

Stock Market Graph
bottom of page