Profit & Loss statement
Horizontal Analysis
2013 2012 Change in $ Change in %
Sales Revenue
Product/Service 1 45,000 30,000 15,000 50.00%
Product/Service 2 3,000 3,000 0 0.00%
Product/Service 3 30,000 25,000 5,000 20.00%
Product/Service 4 30,000 43,000 -13,000 -30.23%
Product/Service 5 6,000 5,000 1,000 20.00%
Total Sales Revenue 114,000 106,000 8,000 7.55%
Cost of Sales
Product/Service 1 300 1,000 -700 -70.00%
Product/Service 2 2,500 2,400 100 4.17%
Product/Service 3 500 500 0 0.00%
Product/Service 4 400 200 200 100.00%
Product/Service 5 200 300 -100 -33.33%
Total Cost of Sales 3,900 4,400 -500 -11.36%
Gross Profit 110,100 101,600 8,500 8.37%
Operating Expenses
Sales and Marketing
Advertising 450 300 150 50.00%
Direct Marketing 3,000 3,000 0 0.00%
Other expenses (specify) 120 250 -130 -52.00%
Other expenses (specify) 5,000 4,300 700 16.28%
Other expenses (specify) 4,000 5,000 -1,000 -20.00%
Total Sales and Marketing Expenses 12,570 12,850 -280 -2.18%
Research and Development
Technology licence 450 300 150 50.00%
Patents 3,000 3,000 0 0.00%
Other expenses (specify) 120 250 -130 -52.00%
Other expenses (specify) 5,000 4,300 700 16.28%
Other expenses (specify) 4,000 5,000 -1,000 -20.00%
Total Research and Development Expenses 12,570 12,850 -280 -2.18%
General and Administrative
Wages and Salaries 450 300 150 50.00%
Outside services 3,000 3,000 0 0.00%
Supplies 120 250 -130 -52.00%
Meals and Entertainment 5,000 4,300 700 16.28%
Rent 4,000 5,000 -1,000 -20.00%
Telephone 100 100 0 0.00%
Utilities 5,000 5,000 0 0.00%
Depreciation 450 300 150 50.00%
Insurance 3,000 3,000 0 0.00%
Repairs and maintenance 120 250 -130 -52.00%
Other expenses (specify) 5,000 4,300 700 16.28%
Other expenses (specify) 4,000 5,000 -1,000 -20.00%
Total General and Administrative Expenses 30,240 30,800 -560 -1.82%
Total Operating Expenses 55,380 56,500 -1,120 -1.98%
Income from Operations 54,720 45,100 9,620 21.33%
Other Income 2,000 1,300 700 53.85%
Taxes
Income Taxes 450 300 150 50.00%
Payroll Taxes 3,000 3,000 0 0.00%
Real estate Taxes 120 250 -130 -52.00%
Other Taxes (specify) 5,000 4,300 700 16.28%
Other Taxes (specify) 4,000 5,000 -1,000 -20.00%
Total Taxes 12,570 12,850 -280 -2.18%
Net Profit 44,150 33,550 10,600 31.59%
Page 1
Profit & Loss statement
Instructions – Horizontal Analysis Calculator
This is a tool that helps perform horizontal analysis of the Balance Sheet and Profit and Loss ©Andrew Grigolyunovich, CFA
statement for your company. The template is designed primarily for a private company, although AG Capital
public companies might use it as well. www.cfotemplates.com
The structure of the P&L sheet:
All of the information that needs to be filled out will be available in P&L statements of your
company.
Column B – P&L positions. Some positions are already inserted; others will have to be filled
out manually. You should put the name for each position in the appropriate row.
Column C – value of each position for the current year. These are the numbers that will be
plugged in for the P&L statement for the current year. Please, fill in all the cells that contain
blue numbers.
Column D – value of each position for the previous year. Same as before, but you will need
to use the information provided for the previous year. Please, fill in all the cells that contain
blue numbers.
If you wish to change something
Column E – Difference between the current and previous year in dollars. The column will be
needs at
[email protected] calculated automatically and does not require any changes. This column will show you
whether or not a certain position brings in the same amount of money to the company (for To order customization:
revenue and income) or whether any of the expenses have gone up.
Think about changes tha
Column F – Difference between the current and previous year in percentage. Same as before, only the change Send your requests and o
is shown in percentage. The colors will indicate whether or not the situation with a specific position has We will estimate the num
changed for the better. Blue indicates a positive change, red – negative. The column will calculate its results we will send you a price
using the information filled in in columns C and D. Proceed to customization
All of the above will help you identify whether one of the positions started using up too
much money and is in need of alterations.
Years can also be changed.
Page 2
Profit & Loss statement
©Andrew Grigolyunovich, CFA
AG Capital
www.cfotemplates.com
If you wish to change something in this template, just order customization to your
needs at [email protected].
To order customization:
Think about changes that need to be made to your new template;
Send your requests and other comments to [email protected].
We will estimate the number of hours needed to customize your template and
we will send you a price quote.
Proceed to customization link at www.cfotemplates.com/Customization.htm.
Page 3
Assets
2013 2012 Change in $ Change in %
Fixed Assets
Intangible Assets Goodwill 10,500 14,000 (3,500) -25.00%
Patents & Licenses 5,000 3,000 2,000 66.67%
Tangible Assets Land & Buildings 155,450 100,000 55,450 55.45%
Plant and Equipment 6,850 2,050 4,800 234.15%
Vehicles 17,500 1,000 16,500 1650.00%
Computer Equipment 12,200 20,000 (7,800) -39.00%
Long Term Shares in Associated
Investments Companies 1,500 45,000 (43,500) -96.67%
Total Fixed Assets 209,000 185,050 23,950 12.94%
Current Assets
Inventories (stocks) Raw Materials 12,000 27,500 (15,500) -56.36%
Work In Progress 48,000 30,500 17,500 57.38%
Finished Goods 59,543 10,000 49,543 495.43%
Total Inventories 119,543 68,000 51,543 75.80%
Accounts Receivable (debtors) 58,450 10,400 48,050 462.02%
Cash (includes bank accounts) 1,028 24,000 (22,972) -95.72%
Prepayments / Deposits 1,500 1,300 200 15.38%
Total Current Assets 180,521 103,700 76,821 74.08%
Total Net Assets
389,521 288,750 100,771 34.90%
Liabilities/Equity
2013 2012 Change in $ Change in %
Equity
Issued Common Stock 100,000 100,000 0 0.00%
Capital Reserves Revaluation Reserve 4,353 2,000 2,353 117.65%
Share Premium Account 5,000 5,000 0 0.00%
Foreign Exchange Reserve 4,720 1,200 3,520 293.33%
Revenue Reserves Retained Earnings 122,500 61,000 61,500 100.82%
Total Equity 236,573 169,200 67,373 39.82%
Long Term Liabilities
Bank Term Loan 11,500 35,000 (23,500) -67.14%
Bonds in Issue 10,000 5,000 5,000 100.00%
Mortgages 65,000 17,000 48,000 282.35%
Total Long Term Liabilities 86,500 57,000 29,500 51.75%
Current Liabilities
Accounts Payable (creditors) 48,950 39,000 9,950 25.51%
Short Term Loans - Bank Overdraft 4,000 5,000 (1,000) -20.00%
Taxation and Social Security 9,500 10,000 (500) -5.00%
Dividends Due 2,000 3,000 (1,000) -33.33%
Accruals 1,998 5,550 (3,552) -64.00%
Total Current Liabilities 66,448 62,550 3,898 6.23%
Total Net Liabilities / Equity
389,521 288,750 100,771 34.90%
