P&L Optimizer Sample Report


P&L Optimizer

Analysis Report for Landscape Company-Demo Date: 6/20/2017

This Financial Report is subject to the information provided by the business client and the accuracy of the information provided. The purpose of this report is to show the strengths and weaknesses of the business by creating a baseline with the oldest year of financial information provided. In this report, 2011 was the earliest year, and compares the trends and patterns, considering both favorable and unfavorable, for the years 2012 through 2014.

Cumulative Growth Increase/Decrease (Ref. Table 1)

This table is designed to compare year over year changes in revenue and expenses, and is read from right to left. 2012 is the first year displayed even though 2011 is considered the baseline because it was the earliest year reported. Looking at the chart below the 2012 Revenue decreased by 10.59 % or $180,358 from 2011. 2013 the Revenue decreased by 2.46 % or $42,910 from 2012. 2014 the Revenue increased by 14.54 % or $297,167 from 2013. Now looking at the expense increase or decrease for the following years, 2012 the expenses decreased by 7.04 % or $119,863 from 2011 for a net increase of 3.55 % or $60,495. 2013 shows a decrease of 4.46 % or $77,937 from 2012 for a net decrease of 2.01 % or ($35,027). For 2014 the expenses decreased or 2.22 % or $45,441 from 2013 for a net increase of 12.32 % or $251,726. The 3 year “Cumulative Net Increase or Decrease” was an increase of 13.86 % or $277,194.

 

Cumulative Growth Increase/Decrease (Ref. Table 1)

 

The Cumulative Growth Increase/Decrease Graph below corresponds with the previous table providing a 3 year overview of the ’s performance. In a perfect scenario, you would see an increase in the blue line from year to year and a gradual decrease or a slower increase with the red line from year to year. This means you want to see the blue line outperforming the red line, and the larger the difference the better. If the red line is above the blue line, expense growth is outpacing revenue growth, an overall unfavorable trend.

 

Cumulative Growth Increase vs Decrease Ref Graph 1

 

Comparison of Revenue, Expenses, Owner Return, and Hidden Pro ts from 2012 – 2014 (Ref. Table 2) (Ref. Graph 2)

This table compares the overall data in each of these categories for the past 3 years.

Comparison of Revenue, Expenses, Owner Return, and Hidden Pro ts from 2012 – 2014 (Ref. Table 2) (Ref. Graph 2)

 

Revenue Sources (Ref. Table 3a)

The following table compares all of the revenue sources related to the daily operations of the company. If the most recent year is displaying red on this table, the revenue source’s percentage of total annual revenue has decreased by comparison from the previous year, showing a potentially unfavorable trend. Green means the revenue source’s percentage has increased, indicating a favorable trend.

Revenue Sources (Ref. Table 3a)

The following tables compare the expense categories for direct, other direct and indirect expenses related to the daily operations of the company. If the most recent year is displaying red on these tables, the expense category’s percentage of total annual revenue has increased by comparison from the previous year, showing a potential unfavorable trend. Green means the expense category’s percentage has decreased, indicating a favorable trend.

Direct Expenses (Ref. Table 3b) Other Direct Expenses (Ref. Table 3c)

 

Indirect Expenses (Ref. Table 3d)

Indirect Expenses (Ref. Table 3d)

Cost of Goods Sold (Ref. Table 3e)

Cost of Goods Sold (Ref. Table 3e)

Payroll (Ref. Table 3f)

Payroll (Ref. Table 3f)

 


 


 

P&L Optimizer

Comparative Expenses and Hidden Profits

The following table includes the data from previous tables (Revenue Sources, Direct, Other Direct and Indirect Expenses), and compares all the expense categories including the totals related to the daily operations of the company. Any category in any year displaying red on this report means the expense category’s percentage of total annual revenue has increased by comparison from the previous year, indicating a potentially unfavorable trend. Green means the expense category’s percentage has decreased, indicating a favorable trend. This table also includes Hidden Profits in each category, and also shows a cumulative total for each year, which is displayed at the bottom of the table.

Comparative Expenses and Hidden Profits (Ref. Table 4)

Hidden Pro ts (Ref. Table 5)

The following table is a breakdown of the Hidden Profits for the most recent year.

Hidden Profits Ref Table 5

 

Hidden Profits (Ref. Graph 3)

The following graph is a breakdown of the Hidden Profits for the most recent year

Hidden Profits (Ref. Graph 3)

Expense Dollars & Percentages (Ref. Table 6)

The following table is a breakdown of the expense categories for the most recent year from the previous Comparative Table. The percentages in the table 8 and graph 4 represent the percentage of revenue for that year.

Expense Dollars & Percentages
(Ref. Table 6)

 

Expense Dollars (Ref. Graph 4)

The following graph is the data from the previous Table and is breakdown of the expense dollar categories for the most recent year.

Expense Dollars (Ref. Graph 4)

Expense Percentages of Revenue (Ref. Graph 5)

The following graph is the data from the previous Table and is a breakdown of the expense percentage categories for the most recent year.

Expense Percentages of Revenue (Ref. Graph 5)

 

Performance Potential Overview (Ref. Graph 6)

The graph below shows the company’s most recent year’s performance and comparing the best performance of the previous 3 year average in 3 categories; Revenue, Expenses and Profit.

Performance Potential Overview (Ref. Graph 6)

 

Performance Potential (Ref. Table 7)

This table compares the company’s most recent year’s performance to an average of the 3 previous years. If any expense category of the company’s 3 year average is less (more favorable) than the current year, it will be high-lighted in green. The difference in percentage of total revenue between the current year and the 3 previous years’ average is converted into current year’s dollars lost for each highlighted category, displayed in red, and totaled at the bottom.

Performance Potential (Ref. Table 7)

 

Performance Potential Overview (Ref. Table 8)

The following table is a condensed version of data from the previous Performance Potential Table, and displays an overview of the company’s performance potential.

Performance Potential Overview
(Ref. Table 8)

 

Balance Sheet Comparison (Ref. Table 9)

This table compares the most recent year to the previous years, displaying green for favorable and red for unfavorable changes in assets, liabilities and equity.

Balance Sheet Comparison (Ref. Table 9)

Liabilities

Balance Sheet Comparison (Ref. Table 9) Liabilities

Equity

Balance Sheet Comparison (Ref. Table 9) Equity

Current Liabilities (Ref. Table 10)

Current Liabilities (Ref. Table 10)

Long Term Liabilities (Ref. Table 11)

Long Term Liabilities (Ref. Table 11)

 


 


 

P&L Optimizer

Budget Builder

This report is designed to create a budget based on an average of the company’s expense categories. This program will average the percentages of the 2 most recent years of history in each category, showing that percentage in the far right-hand column. This report shows the annual and monthly expense totals for each category. This is to be used in part with the Performance Potential Report, along with the company’s projected goals to determine the abilities of potential growth based on past performance. This report is not an absolute but a guideline, and it may need to be adjusted to changing needs of the company.