top of page
Search

Viswanathan Baskaran
1 day ago6 min read
Calculating Simple Moving Averages for Forecasting Using Dynamic Arrays
Projecting simple moving averages (SMAs) into future forecast periods can be challenging when using dynamic array framework in Microsoft...
18 views0 comments


Viswanathan Baskaran
Dec 2, 20243 min read
Why we discourage DCF for equity valuation?
All equity valuation models, except perhaps the book value approach, involve making a certain amount of assumptions or estimates. And,...
153 views0 comments

Viswanathan Baskaran
Jan 6, 20243 min read
Handling restricted cash flow in FCF computation
Free cash flow is one of the critical metrics in valuation and project finance. However, calculating FCF accurately can be tricky,...
264 views0 comments


Viswanathan Baskaran
Jan 4, 20243 min read
How to build a straightline depreciation model
Calculating depreciation under the straight-line method is fairly easy. But modeling it for forecast purposes is quite tricky. Many...
210 views0 comments

Viswanathan Baskaran
Nov 26, 20234 min read
Days Sales Outstanding (DSO): Going beyond Traditional Formulas
Introduction: Days Sales Outstanding (DSO) serves as a critical metric in financial analysis, reflecting a company's effectiveness in...
334 views0 comments

Viswanathan Baskaran
Feb 27, 20222 min read
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...
374 views0 comments

Viswanathan Baskaran
Feb 23, 20225 min read
Optionally convertible bond: What, why, and how?
company has two sources of capital: (i) Equity and (ii) Debt. But there are certain sources that are in between equity and debt. One such...
1,602 views0 comments


Viswanathan Baskaran
Feb 15, 20225 min read
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...
2,521 views0 comments

Viswanathan Baskaran
Feb 13, 20223 min read
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,321 views0 comments

Viswanathan Baskaran
Feb 7, 20223 min read
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...
1,184 views0 comments


Viswanathan Baskaran
Feb 7, 20225 min read
Monte Carlo method vs Deterministic modelling
Although, in theory, probabilistic modelling techniques such as Monte Carlo method provides better insights over deterministic models,...
195 views0 comments


Viswanathan Baskaran
Feb 7, 20224 min read
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...
61 views0 comments


Viswanathan Baskaran
Feb 6, 20226 min read
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...
44 views0 comments


Viswanathan Baskaran
Feb 6, 20225 min read
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...
323 views0 comments

Viswanathan Baskaran
Feb 6, 20224 min read
Financial modelling vs Machine learning
Machine learning models are essentially a subset of mathematical models in which computer algorithm determines the relationship between...
55 views0 comments


Viswanathan Baskaran
Feb 4, 20224 min read
Is transparency important in financial modeling?
Financial models built in spreadsheet with focus on transparency (white-box models) often lack scalability and creates significant...
17 views0 comments

Viswanathan Baskaran
Feb 4, 20223 min read
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...
56 views0 comments
bottom of page