Scribd Logo
Upload

Welcome to Scribd!

  • 90 views

    Dashboard Template 2 - Complete: Strictly Confidential

    Uploaded by

    Knightspage

    Copyright:

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

    Dashboard Template 2 - Complete: Strictly Confidential

    Uploaded by

    Knightspage
    90 views2 pages

    Original Title

    Dashboard-Template-2-Complete

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

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

    Dashboard Template 2 - Complete: Strictly Confidential

    Uploaded by

    Knightspage

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 2

    Dashboard Template 2 - Complete Strictly Confidential

    Table of Contents
    #VALUE!

    Notes
    This Excel model is for educational purposes only and should not be used for any other reason.
    All content is Copyright material of CFI Education Inc.
    https://corporatefinanceinstitute.com/

    © 2019 CFI Education Inc.


    All rights reserved.  The contents of this publication, including but not limited to all written material, content layout, images, formulas, and code, are protected under international copyright and trademark laws.  
    No part of this publication may be modified, manipulated, reproduced, distributed, or transmitted in any form by any means, including photocopying, recording, or other electronic or mechanical methods,
    © Corporate Finance Institute

    DASHBOARD TEMPLATE

    Business Unit Revenue ($000) Profit Margin ($000)


    $140,000 20%
    Business 3 Business 2 Business 1 Consolidated Historical Forecast 18%
    $490,923 $120,000 126070.0403050
    $463,226 35 16%
    $434,741 107712.0605543
    $415,488 $100,000 14%
    $393,016 7
    $80,000 89178.28971978
    86965.275206 12%
    77615.1402 10%
    $60,000 $70,081
    $64,068 8%
    $40,000 6%
    $43,380
    $34,177 4%
    $20,000 $26,063
    2%
    $- 0%
    2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
    2014 2015 2016 2017 2018

    2018 Cumulative Revenue ($000) Expenses ($000)

    This chart isn't available in your version of Excel. $250,000 Interest Depreciation & Amortization
    Rent and Overhead Salaries and Benefits
    Editing this shape or saving this workbook into a different file
    format will permanently break the chart. $200,000

    $150,000

    $100,000

    $50,000

    $-
    2014 2015 2016 2017 2018 2019 2020 2021 2022 2023

    Five-Year Performance Summary Income Statement FY 2018


    5-Yr Average Trend Actual Plan Variance Var%

    Revenue $439,479 Revenue $490,923 $475,000 $15,923 3.4%

    COGS $220,508 COGS $243,130 $238,000 $5,130 2.2%

    Expenses $171,417 Expenses $177,712 $186,000 ($8,288) (4.5%)

    Profit Margin $47,554 Profit Margin $70,081 $73,500 ($3,419) (4.7%)

    Profit Margin (%) 10.8% Profit Margin (%) 14.3% 15.5% (1.2%) (7.7%)

    P&L Summary 2018 Balance Sheet Summary 2018


    Revenue $490,923 Assets
    COGS $243,130 Current Assets $395,685
    Expenses Non-current Assets $589,610
    Salaries and Benefits $85,735 Total Assets $985,295
    Rent and Overhead $39,236 Liabilities
    Depreciation & Amortization $48,241 Current Liabilities $135,374
    Interest $4,500 Long-term Liabilities $384,962
    Total Expenses $177,712 Shareholders' Equity $464,959
    Net Operating Profit $70,081 Total Liabilities & Shareholders' Equity $985,295

    You might also like