Dashboard Revenue and Profit Analytics Sub Gain Insight into Your Business Performance

Desciption

Overall Summary:
This dashboard provides a comprehensive view of your business performance with detailed analytics on revenue, gross profit, operating income, and cash flow. The dashboard also provides trend analysis on your balance over the course of the year.

Insights Gained:
• Track your total revenue and gross profit
• Analyze your DSO vs DPO
• Monitor your EBITDA
• Analyze your operating activities
• Track your balance trend over the course of the year
• Monitor your net income
• Analyze your financing activities

Who Can Benefit:
Business owners, executives, and financial analysts can all benefit from using this dashboard. With this dashboard, they can gain a better understanding of their business performance, identify areas of improvement, and make more informed decisions.

Benefits:
• Gain a comprehensive view of your business performance
• Identify areas of improvement
• Make more informed decisions
• Track your revenue and profit over time
• Monitor your cash flow
• Analyze your financing activities
• Monitor your balance trend over the course of the year

Data

Income – All (Jan 2017)
$6,109,623
■■
DSO vs DPO
Total Revenue
$8M
56M $5.2M $5.2M
54M $4.6M $4.7M
Revenue Actual
Gross Profit Actual
50
49.80 51.70
43.40 45.10
-50 6.40 6.60
$6.0M
Revenue vs Gross Profit (2016)
$8.0M
$7.0M
$5.7M
$5.7M
$2M $1.3M $1.3M $1.5M $1.5M
$1.2M $1.3M
SOM
Gross Profit
0.50
$1,810,685
$5.6M
Jan Feb Mar Apr
$6.2M
-0.40
May
Revenue Budget
Gross Profit Budget
$6.6
$5.5M
$2.2M $2.1M $1.9M
$1.9M $1.9M
$1.5M
$1.5M $1.5M $1.6M $1.4M $1.6M $1.6M $1.7M $1.6M $1.5M
-4.10
1.30
DSO vs DPO
6.70
49.50
90-5630 99.00
47,30 54.10
$450 $1.60 46.90 50.00 49.70 49.40 52.10 51.20 48.00 47.80
5
-0.10
$162,218
$8.0M $8.1M
$6.0M $6.3M $6.4M
EBITDA
|!
-6.70
-8.80
Jun Jul Aug Sep
$7.0M
$6.3M
-8.30
Quarter
(All)
-11.20
Oct Nov Dec
0
$6.0M
-5
-10
$129,174
Operating Income
($20,094)
$30.0M
Operating Activities
$20.0M
$10.0M
$0
$0.0M
$71,685
$15.3M
$87,572
Income before Taxes
Cash Flow – Jan 2017
$1,000,000
$2,000,000
Cash Flow
Investing Activities
Balance Trend – 2016
$18.9M
$14.2M
$14.2M$14.1M $15.2M
$17.5M$18.9M
$17.3M$17.0M $18.3M
$32,983
Net Income
$3,237,855
$3,000,000 $4,000,000
Financing Activities
$22.0M$23.2M$22.5M$22.3M
0
50.0M $0.0M $0.1M $0.3M $0.2M $0.5M $0.6M $1.0M $1.3M $1.5M
<>
$34,6M
$20.9M $21.0M $20.8M
$1.5M $1.4M