How to shrink the IF function
I was reviewing one of the financial models (in MS Excel) that used a lot of the IF construct. Although I generally recommend users to...
top of page
Search
Viswanathan Baskaran
- Feb 23, 2022
- 5 min
Optionally convertible bond: What, why, and how?
A company has two sources of capital: (i) Equity and (ii) Debt. But there are certain sources that are in between equity and debt. One...
396 views0 comments
Viswanathan Baskaran
- Feb 15, 2022
- 5 min
Valuation of insurance companies using Embedded value
One of the key equity valuation metrics for most industries is the Price to EPS or the PE ratio. All else held constant, the company with...
881 views0 comments
Viswanathan Baskaran
- Feb 13, 2022
- 3 min
EBIT vs EBITDA
The net profit reported by a company often carries noises that are driven by certain accounting and funding choices, which makes it very...
2,266 views0 comments
Viswanathan Baskaran
- Feb 7, 2022
- 3 min
Calculating implied volatility using Lambda in MS Excel
Volatility is one of the important risk measures used in finance. In the context of financial instruments, historical volatility is...
703 views0 comments
Viswanathan Baskaran
- Feb 7, 2022
- 5 min
Monte Carlo method vs Deterministic modelling
Although, in theory, probabilistic modelling techniques such as Monte Carlo method provides better insights over deterministic models,...
67 views0 comments
Viswanathan Baskaran
- Feb 7, 2022
- 4 min
How to use Lambda function in Microsoft Excel
Lambda function lets users create custom made function right inside MS Excel. This is especially very useful while working with array...
34 views0 comments
Viswanathan Baskaran
- Feb 6, 2022
- 6 min
Why you should build models using dynamic arrays?
Most models go wrong later in their life due to poor update and maintenance practices. Dynamic array models almost eliminate the need for...
34 views0 comments
Viswanathan Baskaran
- Feb 6, 2022
- 5 min
M&A vs LBO modelling
In this blog, we argue that distinguishing between an M&A model and LBO model is patently wrong, as LBO is also essentially an...
40 views0 comments
Viswanathan Baskaran
- Feb 6, 2022
- 4 min
Financial modelling vs Machine learning
Machine learning models are essentially a subset of mathematical models in which computer algorithm determines the relationship between...
32 views0 comments
Viswanathan Baskaran
- Feb 4, 2022
- 4 min
Is transparency important in financial modeling?
Financial models built in spreadsheet with focus on transparency (white-box models) often lack scalability and creates significant...
11 views0 comments
Viswanathan Baskaran
- Feb 4, 2022
- 3 min
What is financial modeling?
A financial model is a mathematical representation of a financial phenomenon such as a business performance or pay off of a contract that...
43 views0 comments
bottom of page