Sensitivity Analysis

 This model based on sensitivity analysis shows how the weighted average cost of capital changes as the beta changes and its impact on the Net present value and Internal rate of return of the project. Below is the snapshot of the model.




Comments

Post a Comment

Popular posts from this blog

Power BI Dashboard

 The Dashboard explains the sales, cost of good sold and profit of the every product companies sold. Further it explains, which product has the highest sales and product every month. In the other words, dashboard gives brief overview about the product which is most profitable in last 12 months.
Read more

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.
Read more