After all these years in the corporate finance domain, I have come across a very frequent question from finance aspirants: “How to learn financial modeling?” Since an understanding of the financial model is one of the key tasks involved in any finance profile, every aspiring investment banker, financial analyst, or any finance professional, should know …
Financial Modeling Using Excel and VBA: Automation is the buzz word in today’s corporate world. Whether it is the manufacturing industry or the service industry, all businesses are aiming to reduce the human element for critical processes and tasks to improve efficiency and output. As a finance aspirant, you will see this trend in finance …
In this post, we are going to see Sensitivity Analysis in Excel. Discounted Cash flow is probably the commonest way of valuation of a company. This method involves amongst other things analyzing the impact of factors like cost of equity or change in risk-free rate on the price of a company’s share. It is but …
In this article, I’m going to explain how to calculate one of the most famous ratios, among financial analysis, to measure risk in Microsoft Excel: the Sharpe Ratio Excel. The Nobel laureate William F. Sharpe developed the Sharpe Ratio. According to Investopedia: “The Sharpe ratio is calculated by subtracting the risk-free rate from the return of the portfolio …
The work profile of a financial modeler involves constructing a financial representation of some or all aspects of a company or any particular security. In-depth calculations are done to develop the financial model and deliver recommendations. In this article, we will discuss the possibilities of building your own practice in freelance financial modeling. Who Are …
Financial health analysis (FHA), as the word says, is how to determine the financial health of a company. The analysis is primarily performed by the management of companies to assess the business sustainability of its suppliers. The overall health of a supplier sheds light on how well it will do in the short term and …
The last time when I shared the super-actionable post, How to Analyze the Financial Health of a Company in 6 Easy Steps, I got emails from readers asking how to build a revenue model. So, I decided to write not ONE but FOUR approaches to the revenue projection model and take a real case in …