IC Simple KPI Dashboard 11613

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 6

SIMPLE KPI DASHBOARD TEMPLATE

Insert data on KPI Data Tab to populate charts.

BUDGET REVENUE
$0 $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000

ITEM 1 ITEM 1

ITEM 2 ITEM 2

ITEM 3 ITEM 3

ITEM 4 ITEM 4

ITEM 5 ITEM 5

ITEM 6 ITEM 6

ITEM 7 ITEM 7

ITEM 8 ITEM 8

ITEM 9 ITEM 9

ITEM 10 ITEM 10

ACTUAL GOAL ACTUAL GOAL

BUDGET TOTAL REVENUE TOTAL


$0 $250,000 $500,000 $750,000 $1,000,000 $1,250,000 $1,500,000 $1,750,000 $2,000,000 $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 $8,000,000 $9,000,000 $10,000,000

$0 $1

$1
$0

ACTUAL GOAL
ACTUAL GOAL

PROFIT MARGINS
100%

90%

80%

70%

60%

50%

40%

30%

20%
ITEM 1 ITEM 2 ITEM 3 ITEM 4 ITEM 5 ITEM 6 ITEM 7 ITEM 8 ITEM 9 ITEM 10

GROSS NET

DEBT TO EQUITY RATIO


$4,000,000

$3,500,000

$3,000,000

$2,500,000

$2,000,000

$1,500,000

$1,000,000

$500,000

$0
2027 2028 2029 2030 2031 2032 2033 2034 2035 2036

DEBT Moving average (DEBT) EQUITY Moving average (EQUITY)


KPI DASHBOARD DATA - DO NOT DELETE
PRODUCTS BUDGET

NO. NAME GOAL ACTUAL REMAINDER

1 ITEM 1 $0 $0 $0

2 ITEM 2 $0 $0 $0

3 ITEM 3 $0 $0 $0

4 ITEM 4 $0 $0 $0

5 ITEM 5 $0 $0 $0

6 ITEM 6 $0 $0 $0

7 ITEM 7 $0 $0 $0

8 ITEM 8 $0 $0 $0

9 ITEM 9 $0 $0 $0

10 ITEM 10 $0 $0 $0

$0 $0 $0

DEBT TO EQUITY RATIO

CALENDAR DEBT EQUITY

2027 $0 $0

2028 $0 $0

2029 $0 $0

2030 $0 $0
2031 $0 $0

2032 $0 $0

2033 $0 $0

2034 $0 $0

2035 $0 $0

2036 $0 $0
ELETE
NET EXPENSES REVENUE PROFIT MARGINS

ADDITIONAL TOTAL GOAL ACTUAL REMAINDER GROSS

$0 $0 $1 $1 $0 100%

$0 $0 $1 $1 $0 100%

$0 $0 $1 $1 $0 100%

$0 $0 $1 $1 $0 100%

$0 $0 $1 $1 $0 100%

$0 $0 $1 $1 $0 100%

$0 $0 $1 $1 $0 100%

$0 $0 $1 $1 $0 100%

$0 $0 $1 $1 $0 100%

$0 $0 $1 $1 $0 100%

$0 $0 $1 $1 $0 100%
PROFIT MARGINS

NET

100%

100%

100%

100%

100%

100%

100%

100%

100%

100%

100%
Any articles, templates, or information provided by Smartsheet on the website are for
reference only. While we strive to keep the information up to date and correct, we make no
representations or warranties of any kind, express or implied, about the completeness,
accuracy, reliability, suitability, or availability with respect to the website or the information,
articles, templates, or related graphics contained on the website. Any reliance you place
on such information is therefore strictly at your own risk.

You might also like