Three Statement & Ratios Financial Excel Model Template
  • Three Statement & Ratios Financial Excel Model Template
  • Three Statement & Ratios Financial Excel Model Template
  • Three Statement & Ratios Financial Excel Model Template
  • Three Statement & Ratios Financial Excel Model Template
  • Three Statement & Ratios Financial Excel Model Template
  • Three Statement & Ratios Financial Excel Model Template
Originally published: 04/01/2019 13:38
Last version published: 11/01/2019 16:56
Publication number: ELQ-80203-2
View all versions & Certificate
certified

Three Statement & Ratios Financial Excel Model Template

3 Financial Statements Excel Model, Customizable to your Business.

Description
An easy to use and customize, historical data three statement model with ratios, that consists of 5 sheets:

-Cover Page with contents from witch the user can navigate through the rest of the excel sheets.
- Statement of Profit or Loss with formulas, hardcoded cells for data inputs (in blue color) and YoY percentage change of Net Income for year after year monitoring of the company's performance.
-Statement of Financial Position with formulas, hardcoded cells for data inputs (in blue color) and check section.
-Statement of Cash Flows with formulas, hardcoded cells for data inputs (in blue color), YoY percenatge change of Free Cash Flow, Cash at End of Year for year after year monitoring of the progression of the company's liquidity and finally check section.
-Ratios sheet with some basic ratios in place such as Liquidity, Leverage and Efficiency ratios, followed by the corresponding formulas.
V2; You can find a new version with volumes, horizontal analysis, margins and graphs

At the top of each of the three statement sheets, the user can insert a company name and the currency.

This model saves time from data input and calculations procedure. It is simple, easy to modify and easy to manage.

Please feel free to mention any malfunctions or difficulties in the use of the model.
Enjoy!

This business tool includes
1 Excel Financial Model template

Efstratios Tsitsivos offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Further information

A simple tool for quick data input and ratios calculation

This toll is ideal for beginners in financial modeling and for those who need a basic tool for further development

Reviews


keyboard_arrow_leftkeyboard_arrow_right

Any questions on Three Statement & Ratios Financial Excel Model Template?

The user community and author are here to help. Go ahead!

please wait...