A Spreadsheet Model to Determine the Historical Value Drivers of a Company

17 Pages Posted: 17 Aug 2005

Date Written: August 10, 2005

Abstract

Identifying the historical value drivers of a company proves extremely useful while valuing a company. Knowing why a company has done well (or poorly) in the past is very important to understand how the company is going to perform in the future. In this paper we suggest a spreadsheet model that can help one in identifying the relative importance of the different value drives for any company. Apart from helping one in determining the value drivers of a company, this model can also prove to be extremely useful while doing financial statements analysis. In this paper we develop a simple spreadsheet model and apply it to Titan Industries Limited, a leading watch maker from India, to understand how one can determine the value drivers. We find that operating profit margin is the value driver that has the largest impact on Titan's financial performance. However, sales growth rate has a marginally negative impact on the performance of Titan.

Keywords: Value drivers, EVA, FCF, spreadsheet models

JEL Classification: G12, G30, M40

Suggested Citation

Mohanty, Pitabas, A Spreadsheet Model to Determine the Historical Value Drivers of a Company (August 10, 2005). Available at SSRN: https://ssrn.com/abstract=780864 or http://dx.doi.org/10.2139/ssrn.780864

Pitabas Mohanty (Contact Author)

XLRI Jamshedpur ( email )

C H Area (E)
Jamshedpur, Jharkhand 831001
India
(91)657-2225506 (Phone)
(91)657-2227814 (Fax)

Do you have a job opening that you would like to promote on SSRN?

Paper statistics

Downloads
1,275
Abstract Views
4,983
rank
18,503
PlumX Metrics