Cutting financial reports down to size.Information that really tells the story. Have you ever attended a meeting of corporate brass brass, alloy having copper (55%–90%) and zinc (10%–45%) as its essential components. The properties of brass vary with the proportion of copper and zinc and with the addition of small amounts of other elements, such as aluminum, lead, tin, or nickel. where the CFO See Chief Financial Officer. read the income statement line by line and every so often someone asked for an explanation? Although the information conveyed is important, such meetings can be interminable in·ter·mi·na·ble adj. 1. Being or seeming to be without an end; endless. See Synonyms at continual. 2. Tiresomely long; tedious. in·ter . If you tallied the total per-hour compensation of the attendees, you might wonder whether there's a better--and much cheaper--way to communicate this information. The good news: There is. The better news: The solution is simple and fast and adds no cost to finance department operations. Even better news: Each person at the meeting will come away with information he or she really needs--no more, no less. LESS DATA, MORE INFORMATION If you're you're Contraction of you are. you're you are you're be the CFO or the staff person who prepares the financial report for that meeting, ask yourself: What kinds of information do the meeting's attendees really need? In my experience, most managers need only summarized financial data. Details can be provided separately for those who need them. However--and this is critical--just because the information is summarized, don't don't 1. Contraction of do not. 2. Nonstandard Contraction of does not. n. A statement of what should not be done: a list of the dos and don'ts. assume you can take shortcuts See Win Shortcuts. in preparing the statements. In fact, you also should prepare a thorough comparison of monthly expenses. That data should be compared with forecasts and then distilled into a brief, informative presentation focused on significant indicators: pretax pre·tax adj. Existing before tax deductions: pretax income. pretax adj [profit] → vor (Abzug der) Steuern net income, key operating information (each company has its own set of key data), sales, costs and variances from budget. Determining which indicators to break out is the art of designing a key indicator report. A typical financial summary report would contain balance sheet and income statement summaries, a break-even analysis Break-even analysis An analysis of the level of sales at which a project would make zero profit. , charts of key ratios and the following key financial information:
Pretax net income: current month $--
Pretax net income: year to date $--
Cash $--
Line of credit: balance $--
Line of credit: available $--
Retained earnings $--
In addition, the report would include variances from
budget such as
Amount Comments
Bonus accrual $--
Trade show $--
Depreciation $-- Year-to-date
adjustment due
to purchase of
And it would include data on trends and comments--for example * Packaging supplies are trending up. * Gross profit is down by -- % for two months--need to evaluate. * Monthly net sales Net Sales The amount a seller receives from the buyer after costs associated with the sale are deducted. Notes: This amount is calculated by subtracting the following items from gross sales: merchandise returned for credit, allowances for damaged or missing goods, freight level is $ -- over (under). * Monthly gross profit is up (down) -- %. * Resulting gross profit is $ -- over (under). * Expenditures that are over budget: Travel and entertainment are over by $ --. The summarized income statement and balance sheet each should take no more than one sheet of paper. The break-even calculation is especially helpful to growing companies because they have a tendency to pick up overhead easily. Use graphs This partial list of graphs contains definitions of graphs and graph families which are known by particular names, but do not have a Wikipedia article of their own. For collected definitions of graph theory terms that do not refer to individual graph types, such as and ratios to highlight significant information. Taken together, these data provide a clear financial picture that's easy to understand without being overly technical. But more important, the report keeps everyone focused on the big picture without being distracted dis·tract·ed adj. 1. Having the attention diverted. 2. Suffering conflicting emotions; distraught. dis·tract by the details. Any significant variances or trends can be addressed separately. THE GAAP GAAP See: Generally Accepted Accounting Principles GAAP See generally accepted accounting principles (GAAP). GAP GAAP financial statements are uniform and therefore provide a level playing field See net neutrality. for the users of financial information such as bankers or investors. Because of our training, we accountants may feel strange preparing statements that aren't aren't Contraction of are not. See Usage Note at ain't. aren't are not aren't be strictly in accordance Accordance is Bible Study Software for Macintosh developed by OakTree Software, Inc.[] As well as a standalone program, it is the base software packaged by Zondervan in their Bible Study suites for Macintosh. with GAAP. Corporate managers, however, find such reports useful because they focus primarily on trends. Take employee compensation in a manufacturing company as an example. Such expenses are spread throughout the income statement, generally in each of the cost areas: direct and indirect, selling and marketing, indirect labor and general and administrative. Compensation may be broken down further into officer, supervisory and staff compensation. In a typical report, such costs get buried bur·y tr.v. bur·ied, bur·y·ing, bur·ies 1. To place in the ground: bury a bone. 2. a. To place (a corpse) in a grave, a tomb, or the sea; inter. b. within the overall costs for the respective departments. Likewise for rent expense, which typically is coded to the respective profit center or location and allocated among various departments. In both cases, the big picture is hidden. From management's point of view, the more departments, the more complex the statements and the more key information is buried. FLUCTUATING fluc·tu·ate v. fluc·tu·at·ed, fluc·tu·at·ing, fluc·tu·ates v.intr. 1. To vary irregularly. See Synonyms at swing. 2. To rise and fall in or as if in waves; undulate. v. COSTS Suppose some marketing expenses are subject to large year-to-year fluctuations while most of them stay the same. Instead of analyzing these fluctuations each period, why not just make them line items on a summary income statement? The expenses that don't fluctuate significantly can be grouped together. Using that strategy provides an income statement that highlights larger categories of expense--those that fluctuate greatly--and manageable expenses. Of course, a summarized report doesn't does·n't Contraction of does not. replace a GAAP income statement, but it provides additional information that's very useful to managers of the business. Below is a sample of such a report. Cost of goods sold Cost of goods sold The total cost of buying raw materials, and paying for all the factors that go into producing finished goods. cost of goods sold , the general and administrative figures and selling and marketing categories are shown net of compensation, payroll taxes Payroll Tax Tax an employer withholds and/or pays on behalf of their employees based on the wage or salary of the employee. In most countries, including the U.S., both state and federal authorities collect some form of payroll tax. , fringe benefits fringe benefits, n.pl the benefits, other than wages or salary, provided by an employer for employees (e.g., health insurance, vacation time, disability income). and rent. Assume that compensation is the largest expense other than materials and that overtime Overtime is the amount of time someone works beyond normal working hours. Normal hours may be determined in several ways:
In sum, business entities--especially growing companies--need cost-effective cost-effective, n the minimal expenditure of dollars, time, and other elements necessary to achieve the health care result deemed necessary and appropriate. operational and financial data that focus less on details and more on key indicators and exception reporting. This approach is advantageous for CFOs in two ways: * It takes very little extra effort to prepare the summarized reports. * It reinforces what only the finance department can provide corporate leaders: a sure-fire sure-fire or sure·fire adj. Informal Bound to be successful or perform as expected: a sure-fire solution to the problem. tool to help them fulfill ful·fill also ful·fil tr.v. ful·filled, ful·fill·ing, ful·fills also ful·fils 1. To bring into actuality; effect: fulfilled their promises. 2. their main responsibility--keeping their eyes trained on the big picture. EXECUTIVE SUMMARY * MOST MANAGERS get inundated in·un·date tr.v. in·un·dat·ed, in·un·dat·ing, in·un·dates 1. To cover with water, especially floodwaters. 2. at meetings (and elsewhere) with so much financial data that they lose sight of the big picture. It would be better to provide them with financial data in summary or highlighted form. If managers need details, that data can be provided separately. * PRESENTING INFORMATION in summary form doesn't mean you can take shortcuts when preparing financial statements. * SUMMARY PRESENTATIONS should focus on significant indicators such as: pretax net income, key operating information, sales, costs and variances from budget. * DETERMINING WHICH IMPORTANT expenses to break out is the art of designing an effective key indicator report. Analyze an·a·lyze v. 1. To examine methodically by separating into parts and studying their interrelations. 2. To separate a chemical substance into its constituent elements to determine their nature or proportions. 3. variances in the P&L by comparing several periods and then decide on the items to segregate seg·re·gate v. seg·re·gat·ed, seg·re·gat·ing, seg·re·gates v.tr. 1. To separate or isolate from others or from a main body or group. See Synonyms at isolate. 2. on the report. * SUCH SUMMARIES are especially helpful for growing companies, which need to focus on key indicators and exception reporting. * THIS KIND OF financial information and the commentary on notable items, trends and variances from the forecast provide a clear financial picture that's easy to understand. And it keeps everyone focused on the big picture. Significant variances or trends can be addressed separately.
Standard Income Statement Format
1/31/98
Net sales $445,000 100.00%
Cost of goods sold 284,900 64.02%
Gross profit 160,100 35.98%
Selling and marketing
expenses 103,200 23.19%
General and administrative
expenses 57,464 12.91%
Net income from operations (564) -0.13%
Other income and expenses 0 0.00%
Net income before taxes (564) -0.13%
State income taxes (40) -0.01%
Federal income taxes (178) -0.04%
Net income ($346) -0.08%
2/28/98
Net sales $418,500 100.00%
Cost of goods sold 238,220 56.92%
Gross profit 180,280 43.08%
Selling and marketing
expenses 70,000 16.73%
General and administrative
expenses 59,228 14.15%
Net income from operations 51,052 12.20%
Other income and expenses 0 0.00%
Net income before taxes 51,052 12.20%
State income taxes 3,574 0.85%
Federal income taxes 16,143 3.86%
Net income $31,336 7.49%
3/31/98
Net sales $565,500 100.00%
Cost of goods sold 327,400 57.90%
Gross profit 238,100 42.10%
Selling and marketing
expenses 105,600 18.67%
General and administrative
expenses 66,464 11.75%
Net income from operations 66,036 11.68%
Other income and expenses 0 0.00%
Net income before taxes 66,036 11.68%
State income taxes 4,622 0.82%
Federal income taxes 20,880 3.69%
Net income $40,533 7.17%
Three-month total
Net sales $1,429,000 100.00%
Cost of goods sold 850,520 59.52%
Gross profit 578,480 40.48%
Selling and marketing
expenses 278,800 19.51%
General and administrative
expenses 183,157 12.82%
Net income from operations 116,523 8.15%
Other income and expenses 0 0.00%
Net income before taxes 116,523 8.15%
State income taxes 8,157 0.57%
Federal income taxes 36,845 2.58%
Net income $71,522 5.01%
Key Indicator Income Statement Format(*)
1/31/98
Sales $500,000 100.00%
Sales returns 25,000 5.00%
Sales incentives 30,000 6.00%
Cost of goods sold--
materials 270,300 54.06%
Cost of goods sold--
indirect 1,200 0.24%
Selling and marketing
expenses 13,300 2.66%
General and administrative
expenses 15,041 3.01%
Other income and expenses 0 0.00%
Key expenses broken out:
Compensation 82,500 16.50%
Payroll taxes and fringes 8,223 1.64%
Rent 7,000 1.40%
Trade shows 30,000 6.00%
Travel and entertainment 18,000 3.60%
Net income before taxes ($564) -0.11%
2/28/98
Sales $450,000 100.00%
Sales returns 18,000 4.00%
Sales incentives 13,500 3.00%
Cost of goods sold--
materials 219,300 48.73%
Cost of goods sold--
indirect 3,240 0.72%
Selling and marketing
expenses 13,400 2.98%
General and administrative
expenses 15,074 3.35%
Other income and expenses 0 0.00%
Key expenses broken out:
Compensation 91,000 20.22%
Payroll taxes and fringes 9,434 2.10%
Rent 7,000 1.56%
Trade shows 5,000 1.11%
Travel and entertainment 4,000 0.89%
Net income before taxes $51,052 11.34%
3/31/98
Sales $650,000 100.00%
Sales returns 39,000 6.00%
Sales incentives 45,500 7.00%
Cost of goods sold--
materials 306,000 47.08%
Cost of goods sold--
indirect 2,300 0.35%
Selling and marketing
expenses 13,600 2.09%
General and administrative
expenses 19,041 2.93%
Other income and expenses 0 0.00%
Key expenses broken out:
Compensation 107,500 16.54%
Payroll taxes and fringes 11,023 1.70%
Rent 7,000 1.08%
Trade shows 22,000 3.38%
Travel and entertainment 11,000 1.69%
Net income before taxes $66,036 10.16%
Three-month total
Sales $16,00,002 100.00%
Sales returns 82,000 5.12%
Sales incentives 89,000 5.56%
Cost of goods sold--
materials 795,601 49.73%
Cost of goods sold--
indirect 6,740 0.42%
Selling and marketing
expenses 40,300 2.52%
General and administrative
expenses 49,157 3.07%
Other income and expenses 0 0.00%
Key expenses broken out:
Compensation 281,000 17.56%
Payroll taxes and fringes 28,680 1.79%
Rent 21,000 1.31%
Trade shows 57,000 3.56%
Travel and entertainment 33,000 2.06%
Net income before taxes $116,523 7.28%
(*) Percentages may not total 100% due to rounding. Which income statement tells you more about the company--the top report or the bottom one? The bottom report focuses on the key indicators that affect the operation of the business. [ILLUSTRATION OMITTED] JACK L. OTTENHEIMER, CPA (Computer Press Association, Landing, NJ) An earlier membership organization founded in 1983 that promoted excellence in computer journalism. Its annual awards honored outstanding examples in print, broadcast and electronic media. The CPA disbanded in 2000. , is vice-president--finance and CFO of ABL Electronics Corp., Hunt Valley, Maryland Maryland (mâr`ələnd), one of the Middle Atlantic states of the United States. It is bounded by Delaware and the Atlantic Ocean (E), the District of Columbia (S), Virginia and West Virginia (S, W), and Pennsylvania (N). . He is a past chairman of the management of an accounting practice committee of the Maryland Association of CPAs The Maryland Association of Certified Public Accountants is a statewide professional association that provides leadership, training, advocacy and resources for its nearly 10,000 CPA members, who are employed in private practice, industry, government and education. . His e-mail address See Internet address. e-mail address - electronic mail address is jotten@charm.net. |
|
||||||||||||||||||

Printer friendly
Cite/link
Email
Feedback
Reader Opinion