Financial Model (Toys & Seasonal) Excel Template
Originally published: 03/07/2018 07:52
Last version published: 15/01/2020 09:14
Publication number: ELQ-38648-11
View all versions & Certificate
certified

Financial Model (Toys & Seasonal) Excel Template

A full example Financial Model of a retail company (Toys & Seasonal) to download and analyse.

Description
The purpose is to calculate, compare, and apply different theories of corporate valuation in order to assess their equivalence by using as a platform a retail company (Jumbo)

A full excel model is provided as well as 1 presentation in PDF format

More precisely the following theories will be considered:
Free Cash Flow to Equity (“FCFE”)
Free Cash Flow to the Firm (“FCFF”)
Dividend Discount Model (“DDM”)
Economic Profit Model (“EP”)
Economic Value Added Model (“EVA”) and
Comparable Companies Multiples (“CCM”)

In order to value Jumbo S.A., several steps will be conducted. The first step consists of a brief overview of the valuation process.

In the second step, corporate valuation theories will be analyzed based on a discussion of advantages and disadvantages through a relevant international literature review which will include a comparison of the various methods.

In the third step, the methodology will consist of three distinct phases:

A) The strategic analysis: the focus will be based on the Company's position within the industry, the level of competition and the Company's strengths, weaknesses, or threats and opportunities as well as the future development of the games, toys & specialty retailers sector.

B) The next phase is the financial statements forecast. The purpose of this phase is to identify trends in order to forecast value drivers and therefore forecast financial statements for the period 2013 - 2017.

C) Regarding the last phase, the discount rates will be calculated (cost of equity - “CoE” and weighted average cost of capital - “WACC”) which will also take into account the country risk premium related to the exposure of the company when operating in emerging and / or distressed markets.

The fourth step will be the presentation of the Company and the justification of its selection based on several criteria.

The fifth step is the results of the various valuation methods which will determine the equity market value of Jumbo S.A. As part of the analysis equity value and share price will be determined, and the results of the various methods will be compared. Additionally, the equity value range of the Company as estimated through sensitivity analysis will be compared to official equity value estimates published by professional analysts, as well as with the actual market price.

Finally we will present the valuation results based on the various methods utilized and a conclusion will be reached in the last step.

This Best Practice includes
1 Excel file and 1 PDF

Acquire business license for $49.00

Add to cart

Add to bookmarks

Discuss

Further information

Provide a tool to perform the valuation of a company using various valuation methods

Company to be valued needs to have some sort of financial statements. Even simple ones


5.0 / 5 (1 votes)

please wait...