Posts

Showing posts from January, 2024

WACC Modelling

Image
WACC (Weighted Average Cost of Capital) modeling involves calculating the average cost of a company's debt and equity, weighted by their respective proportions in the capital structure. This figure is used to discount future cash flows in financial valuation, helping determine a company's intrinsic value and assisting in investment decision-making. Data source for creating Model: Yahoo finance Industry: Automotive  *This is only for the educational purpose.

Beta drifting - TVS Motors Ltd.

Image
  This Model explains the drifting of beta with the help of TVS Motors Ltd. example.

Value at Risk Model - Mahindra and Mahindra Ltd.

Image
  Value at Risk (VAR) is a statistical measure used in finance to quantify the potential loss on a portfolio of assets over a specific time horizon and with a certain level of confidence. It helps risk managers assess and manage the potential downside risk of their investments, informing decision-making. I have explained VAR through two approaches: 1. Historical Approach 2. Monte-Carlo Simulation  * This is for the Educational Purpose only.

Three-Statement Model - MRF Ltd.

Image
  Three Statement Model provides a comprehensive view of a firm's financial performance, depicting its operational results, financial position, and cash flows, facilitating thorough analysis for investors, analysts, and decision-makers. I have create Three-Statement Model on MRF Ltd. *This is for educational purpose only.

DUPONT ANALYSIS MODEL - ITC Ltd.

Image
DuPont Analysis is a financial performance measurement that breaks down return on equity (ROE) into three components: profitability, efficiency, and leverage. By examining these factors separately, it provides insights into the sources of a company's ROE, aiding in assessing its overall financial health and identifying areas for improvement. I have explained the DuPont Analysis with the help of making of DuPont Model on Excel of ITC Ltd. *This is for educational purpose only.

Bond Valuation

Image
 This model calculates the value of bond and modified duration of the bond  and also explains the relationship between the bond price and Yield to Maturity with the help of graph and table. Further it explains which bond is better out of two.