Scribd Logo
Upload

Welcome to Scribd!

  • 32 views

    Financial Valuation Ratios Excel Template

    Uploaded by

    Naoufel Frouja
    This document contains financial projections for a company over the period 2020-2024. It includes assumptions about the company's fiscal year end and currency. It then shows monthly projections for 2020 of the company's stock price, shares outstanding, equity, cash flow, earnings, sales, dividends and various valuation ratios. It also contains lookup tables for things like months and displayed periods.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Financial Valuation Ratios Excel Template

    Uploaded by

    Naoufel Frouja
    32 views5 pages
    This document contains financial projections for a company over the period 2020-2024. It includes assumptions about the company's fiscal year end and currency. It then shows monthly projections for 2020 of the company's stock price, shares outstanding, equity, cash flow, earnings, sales, dividends and various valuation ratios. It also contains lookup tables for things like months and displayed periods.

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains financial projections for a company over the period 2020-2024. It includes assumptions about the company's fiscal year end and currency. It then shows monthly projections for 2020 of the company's stock price, shares outstanding, equity, cash flow, earnings, sales, dividends and various valuation ratios. It also contains lookup tables for things like months and displayed periods.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    32 views5 pages

    Financial Valuation Ratios Excel Template

    Uploaded by

    Naoufel Frouja
    This document contains financial projections for a company over the period 2020-2024. It includes assumptions about the company's fiscal year end and currency. It then shows monthly projections for 2020 of the company's stock price, shares outstanding, equity, cash flow, earnings, sales, dividends and various valuation ratios. It also contains lookup tables for things like months and displayed periods.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 5

    Company Name

    Time Series

    Setup Assumptions
    Financial Year End, Month name December
    First Financial Year 2020
    Model Start Date 1-Jan-20
    Model End Date 31-Dec-24
    Denomination 1,000
    Model Currency $

    Built with finmodelslab.com template Time Series 12/06/2023


    Company Name

    Financial Figures ($'000) and Valuation Ratios - 2020


    Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
    Stock Price 0.050 0.052 0.054 0.056 0.059 0.060 0.061 0.063 0.064 0.066 0.071 0.076
    Outstanding Shares 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000
    Total Shareholder Equity 500.0 500.0 500.0 500.0 500.0 500.0 500.0 500.0 500.0 500.0 500.0 500.0
    Operating Cash Flow 100.0 105.0 109.2 117.9 120.3 129.9 135.1 140.5 146.1 152.0 155.0 158.1
    Earnings 50.0 52.0 54.1 56.2 58.5 60.8 62.0 64.5 67.8 71.1 74.7 80.7
    Earnings Per Share (EPS) Growth 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0%
    Net Sales 180.0 189.0 192.8 200.5 210.5 223.1 229.8 234.4 239.1 246.3 258.6 269.0
    Dividends 10.0 10.8 11.7 11.8 12.6 13.6 14.4 14.6 15.2 15.9 16.4 16.9

    Price to Book Ratio (PB) 0.10 0.10 0.11 0.11 0.12 0.12 0.12 0.13 0.13 0.13 0.14 0.15
    Price to Cash Flow Ratio (PCF) 0.50 0.50 0.50 0.48 0.49 0.46 0.45 0.45 0.44 0.44 0.46 0.48
    Price to Earnings Ratio (PE) 1.00 1.00 1.00 1.00 1.01 0.99 0.98 0.98 0.94 0.93 0.95 0.94
    Price to Earnings to Growth Ratio (PEG) 0.33 0.33 0.33 0.33 0.34 0.33 0.33 0.33 0.31 0.31 0.32 0.31
    Price to Sales Ratio (PS) 0.28 0.28 0.28 0.28 0.28 0.27 0.26 0.27 0.27 0.27 0.27 0.28
    Dividend Yield 0.20 0.21 0.22 0.21 0.21 0.23 0.24 0.23 0.24 0.24 0.23 0.22

    Valuation Ratios Chart


    Price to Book Ratio (PB) Price to Cash Flow Ratio (PCF) Price to Earnings Ratio (PE)
    Price to Earnings to Growth Ratio (PEG) Price to Sales Ratio (PS) Dividend Yield
    1.20

    1.00

    0.80

    0.60

    0.40

    0.20

    0.00
    Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

    Built with finmodelslab.com template Financial Ratios 12/06/2023


    Time Series
    Company Name
    Go to Table of Contents

    Time Series - Lookups

    Month Days Names

    Month Day LU_TS_Mth_Days


    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29

    710727440.xlsx
    TS_LU Page 4 of 5
    Printed: 17:15:57 on 12/06/2023
    Outputs & Other
    Company Name
    Go to Table of Contents

    Financial Statements Summary - Lookups

    First Displayed Periods Names

    First Displayed Period LU_FS_Sum_First_Disp_Per


    2020
    2021
    2022
    2023
    2024

    Top Revenue - Lookups

    First Displayed Periods Names

    First Displayed Period LU_Top_Rev_First_Disp_Per


    2020
    2021
    2022
    2023
    2024

    Displayed Periods Names

    Displayed Period LU_Top_Rev_Dis_Pers


    2020
    2021
    2022
    2023
    2024

    710727440.xlsx
    OO_LU Page 5 of 5
    Printed: 17:15:57 on 12/06/2023

    You might also like