{"id":74,"date":"2015-02-08T15:32:06","date_gmt":"2015-02-08T15:32:06","guid":{"rendered":"http:\/\/viennaadvantage.com\/blog\/?p=74"},"modified":"2017-09-19T09:55:07","modified_gmt":"2017-09-19T09:55:07","slug":"4-connections-in-the-financial-reports-that-every-manager-should-know","status":"publish","type":"post","link":"https:\/\/onfinity.io\/blog\/business-hacks\/4-connections-in-the-financial-reports-that-every-manager-should-know\/","title":{"rendered":"4 Connections in the financial reports that every manager should know"},"content":{"rendered":"<p>Every business manager should use his \/ her income statement to evaluate profit performance and to ask profit-oriented questions like:<\/p>\n<ul>\n<li>Did sales revenue meet the goals and objectives for the period?<\/li>\n<li>Why did sales revenue increase compared with latest period?<\/li>\n<li>Which expenses increased more or less than expected? And many similar questions\u2026<\/li>\n<\/ul>\n<h2><span style=\"color: #437bd0;\"><strong>PROFIT ISN\u2019T EVERYTHING<\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\">A good manager can\u2019t stop at the end of the above questions!<\/p>\n<p style=\"text-align: justify;\">Beyond profit analysis, business managers should move on to financial condition analysis and cash flow analysis. They should have a close look at the three basic financial reports, income statement, balance sheet and cash flows statement, and see how they interlock with one another.<\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #437bd0;\"><strong><a href=\"http:\/\/sourceforge.net\/projects\/erp-crm-advant\/files\/Other%20Files\/Financial-Management-ERP-Core-Module-Brochure.pdf\/download\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\" alignleft wp-image-75\" src=\"http:\/\/viennaadvantage.com\/blog\/wp-content\/uploads\/VA_Financial-Management-Module.png\" alt=\"Vienna Advantage_Financial Management Module (Financial Reports)\" width=\"323\" height=\"215\" srcset=\"https:\/\/onfinity.io\/blog\/wp-content\/uploads\/VA_Financial-Management-Module.png 600w, https:\/\/onfinity.io\/blog\/wp-content\/uploads\/VA_Financial-Management-Module-300x200.png 300w\" sizes=\"(max-width: 323px) 100vw, 323px\" \/><\/a><\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><em>\u201cVIENNA Advantage Financial Management Module, includes complete external accounting process, as well as management accounting, controlling different posting types, and allow multi-dimensional view on your corporate finance trough different financial reports.\u201d <\/em><\/p>\n<p><em>For more information download our <a title=\"Vienna Advantage Finance Management Brochure\" href=\"http:\/\/sourceforge.net\/projects\/erp-crm-advant\/files\/Other%20Files\/Financial-Management-ERP-Core-Module-Brochure.pdf\/download\" target=\"_blank\" rel=\"noopener\">Financial Management Brochure<\/a>,<\/em><em> or go to our <a title=\"Vienna Advantage ERP &amp; CRM\" href=\"http:\/\/viennaadvantage.com\/erp-crm-overview.php\" target=\"_blank\" rel=\"noopener\">ERP &amp; CRM<\/a> business solution page.<\/em><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"color: #437bd0;\"><strong>SALES REVENUE &amp; ACCOUNTS RECEIVABLE <\/strong><\/span><\/h2>\n<p><span style=\"color: #437bd0;\">How Sales Revenue Drives Accounts Receivable?<\/span><\/p>\n<p style=\"text-align: justify;\">Every company has a mix of quick, regular, and slow-paying customers. Extending credit to customers will lead to creating a cash inflow lag. The accounts receivable balance is the amount of this lag. At year-end the amount the balance in this asset account is the amount of uncollected sales revenue.<\/p>\n<p>Let\u2019s have a look at the following example:<\/p>\n<ul>\n<li>Sales Revenue for the year (Income Statement) = $52,000,000<\/li>\n<li>Accounts Receivable at End of Year (Balance Sheet) = $5,000,000<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">\u00a0The relationship between annual sales revenue and the ending balance of accounts receivable, can be expressed through the <strong>average sales credit period<\/strong> \u2013 determines the size of accounts receivable. The longer the average sale credit period, the larger the accounts receivable amount.<\/p>\n<p>In order to determine the average sales credit period we should first calculate the following ratio:<\/p>\n<blockquote>\n<p style=\"text-align: center;\"><strong><em>$52,000,000 Sales Revenue <span style=\"color: #437bd0;\">\/<\/span> $ 5,000,000 Accounts receivable <span style=\"color: #437bd0;\">=<\/span> 10.4 Times<\/em><\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify;\">This calculation gives the <strong>accounts receivable turnover ratio<\/strong>. If we want to know the <strong>average sales credit period (in weeks) <\/strong>we should divide the ratio in 52 weeks:<\/p>\n<blockquote>\n<p style=\"text-align: center;\"><strong>52 Weeks<span style=\"color: #437bd0;\"> \/<\/span> 10.4 Accounts Receivable Turnover Ratio<span style=\"color: #437bd0;\"> =<\/span> 5 Weeks<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify;\">Time is the essence of the mater. What interests the business manager, and the company\u2019s creditors and investors as well, is how long it takes on average to turn accounts receivable ratio into cash. (In our example the company needs 5 Weeks, on average).<\/p>\n<p style=\"text-align: justify;\">The manager in charge has to decide whether the average credit period is getting out of hand. The manager can shorten credit terms, shut off credit to slow payers, or step up collection efforts.<\/p>\n<p style=\"text-align: justify;\">To make an important point here assume that without losing any sales the company\u2019s average sales credit period has been shortened to 4 weeks, instead of 5 weeks. In this scenario, the company\u2019s ending accounts receivable balance would have been $1,000,000 less, or $4,000,000 in total. In this way the company would have collected $1,000,000 more cash during the year!<\/p>\n<p style=\"text-align: justify;\"><em>VIENNA Advantage Financial management module provides you versatile reporting &amp; report creation features that allow both, a top-down review of financial information as well as drill-down to individual accounts and review specific transactions. Find out more <a title=\"Vienna Advantage Finance Management Brochure\" href=\"http:\/\/sourceforge.net\/projects\/erp-crm-advant\/files\/Other%20Files\/Financial-Management-ERP-Core-Module-Brochure.pdf\/download\" target=\"_blank\" rel=\"noopener\">here<\/a> or <a title=\"Vienna Advnatage Contact Us Page\" href=\"http:\/\/viennaadvantage.com\/aboutus-contacts.php\" target=\"_blank\" rel=\"noopener\">contact us<\/a> for more detailed information.<\/em><\/p>\n<h2><span style=\"color: #437bd0;\"><strong>COST OF GOODS SOLD EXPENSE AND INVENTORY<\/strong><\/span><\/h2>\n<p><span style=\"color: #437bd0;\">Holding products in Inventory before they are sold<\/span><\/p>\n<p style=\"text-align: justify;\"><strong>Cost of goods sold<\/strong> expense means just that- the cost of all products sold to customers during the year. For manufacturing companies, this is by far the largest expense in the company\u2019s income statement.<\/p>\n<p style=\"text-align: justify;\">To sell products, most companies must keep a stock of products on hand, which is called <strong>inventory.<\/strong> The inventory asset is reported at cost in the balance sheet, not at its sales value. The inventory asset account accumulates the cost of the products purchased or manufactured. Acquisition cost stays in an inventory asset account until the products are sold to customers. At this time, the cost of the products is removed from inventory and charged out to cost of goods sold expense.<\/p>\n<p style=\"text-align: justify;\">The size of the inventory is determined by the <strong>average inventory holding period. <\/strong>Suppose we did not know the company\u2019s average inventory holding period, we can determine it using the following information from its financial statements:<\/p>\n<ul>\n<li>Cost of Goods Sold Expense (Income Statement) = $33,800,000<\/li>\n<li>Inventory (Balance Sheet) = $8,450,000<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">The longer the manufacturing and warehouse holding period, the larger is the inventory amount. Business managers prefer to operate with the lowest level of inventory possible, without causing lost sales due to products being out of stock when customers want to buy them.<\/p>\n<p style=\"text-align: justify;\">In order to determine the average inventory holding period we should first calculate the inventory turnover ratio:<\/p>\n<blockquote>\n<p style=\"text-align: center;\"><strong>$33,800,000 Cost of Goods Sold Expense<span style=\"color: #437bd0;\"> \/<\/span> $8,450,000 Inventory <span style=\"color: #437bd0;\">=<\/span> 4 Times<\/strong><\/p>\n<\/blockquote>\n<p>Dividing this ration into 52 weeks gives the <strong>average inventory holding period<\/strong> expressed in number of weeks:<\/p>\n<blockquote>\n<p style=\"text-align: center;\"><strong>52 Weeks <span style=\"color: #437bd0;\">\/<\/span> 4 Inventory Turnover Ratio <span style=\"color: #437bd0;\">=<\/span> 13 Weeks<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify;\">What interests the managers, as well as the company\u2019s creditors and investors, is how long the company holds inventory before products are sold. If the holding period is longer than necessary, too much capital is being tied up in inventory. Or, the company may be cash poor because it keeps too much money in inventory and not enough in the bank.<\/p>\n<p>In summary, if inventory holding period is too long, capital is being wasted, if too short profit opportunities are being missed.<\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"color: #437bd0;\"><strong>INVENTORY AND ACCOUNTS PAYABLE<\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\">The company\u2019s inventory holding period is much longer than its purchase credit period (which is typical for most businesses). In other words, accounts payable are paid much sooner than inventory is sold.<\/p>\n<p style=\"text-align: justify;\">Based on its experience and policies, a business knows the average purchase credit period for its production-related purchases, and can easily calculate the average inventory holding period. From here we can easily calculate the year-end balance of accounts payable for inventory-related purchases.<\/p>\n<p><strong><span style=\"text-decoration: underline;\">Accounts Payable for inventory-related purchases:<\/span><\/strong><\/p>\n<blockquote>\n<p style=\"text-align: center;\"><strong>[Average purchase credit period for production-related purchases <span style=\"color: #437bd0;\">\/<\/span> Average inventory holding period] <span style=\"color: #437bd0;\">x<\/span> Inventory<\/strong><\/p>\n<\/blockquote>\n<h2><span style=\"color: #437bd0;\"><strong>OPERATING EXPENSES AND ACCOUNTS PAYABLE<\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\">Operating expenses (Selling, General and Administrative Expenses) include all business expenses except: cost of goods sold, interest, depreciation and income tax expenses.<\/p>\n<p style=\"text-align: justify;\">Based on its experience, a business should know the average time it takes to pay its short term accounts payable arising from unpaid operating expenses.<\/p>\n<p style=\"text-align: left;\"><strong><span style=\"text-decoration: underline;\">Account Payable (for operating expenses):<\/span><\/strong><\/p>\n<blockquote>\n<p style=\"text-align: center;\"><strong>[Average credit period (in Weeks) <span style=\"color: #437bd0;\">\/<\/span> 52 Weeks] <span style=\"color: #437bd0;\">x<\/span> Operating Expenses for Year<\/strong><\/p>\n<\/blockquote>\n<p><a href=\"http:\/\/sourceforge.net\/projects\/erp-crm-advant\/files\/Other%20Files\/Financial-Management-ERP-Core-Module-Brochure.pdf\/download\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\" aligncenter wp-image-79\" src=\"http:\/\/viennaadvantage.com\/blog\/wp-content\/uploads\/VA_BENEFITS_Financial-Management-Module_.png\" alt=\"VA_BENEFITS_Financial Management Module (Financial Reports)\" width=\"423\" height=\"254\" srcset=\"https:\/\/onfinity.io\/blog\/wp-content\/uploads\/VA_BENEFITS_Financial-Management-Module_.png 500w, https:\/\/onfinity.io\/blog\/wp-content\/uploads\/VA_BENEFITS_Financial-Management-Module_-300x180.png 300w\" sizes=\"(max-width: 423px) 100vw, 423px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\"><em>VIENNA Adv<\/em><em>antage presents a versatile financial accounting module, packed with features to help you deal with all aspects of your business, be it, Anticipation, Acquisition, Allocation, Appropriation, Assessment or Audit. <\/em><a title=\"Vienna Advantage Finance Management Brochure\" href=\"http:\/\/sourceforge.net\/projects\/erp-crm-advant\/files\/Other%20Files\/Financial-Management-ERP-Core-Module-Brochure.pdf\/download\" target=\"_blank\" rel=\"noopener\">Download brochure<\/a> <em>or go to our <a title=\"Vienna Advantage ERP &amp; CRM\" href=\"http:\/\/viennaadvantage.com\/erp-crm-overview.php\" target=\"_blank\" rel=\"noopener\">ERP &amp; CRM<\/a> business solution page.<\/em><\/p>\n<ul>\n<li>Make informed business decisions based on up to date information &amp; historical records<\/li>\n<li>Ascertain the effectiveness &amp; efficiency of your business operations<\/li>\n<li>Versatile reporting &amp; financial report creation features allow both, a top-down review of financial information as well as drill-down to individual accounts and review specific transactions<\/li>\n<li>In addition to balance sheets, income statements and cash flow statements, create your own financial reports with our report writer<\/li>\n<li>Set up budget and analyze budget versus actual<\/li>\n<li>Closely track account receivables and account payables<\/li>\n<li>Manage cash-flow and trade credit; both crucial to the health of your business<\/li>\n<li>Manage tax calculation &amp; declarations<\/li>\n<li>Supports accounting standards of all countries<\/li>\n<li>Maintains separate document and ledger level posting<\/li>\n<li>Standard and alternate reporting hierarchies<\/li>\n<li>Dimensions-based reporting such as projects, sales regions, products, campaigns and more<\/li>\n<li>Manage cost-centers, multiple organizations, multiple currencies and currency-rate adjustments<\/li>\n<li>Automated postings for your convenience<\/li>\n<li>Enhanced approvals and alerts<\/li>\n<li>IFRS Compliance<\/li>\n<li>Comprehensive fixed assets &amp; asset-depreciation module<\/li>\n<li>Performance analysis<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><em>References: How to read financial report, John A. Tracy<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Every business manager should use his \/ her income statement to evaluate profit performance and to ask profit-oriented questions like: Did sales revenue meet the goals and objectives for the period? Why did sales revenue increase compared with latest period? <a href=\"https:\/\/onfinity.io\/blog\/business-hacks\/4-connections-in-the-financial-reports-that-every-manager-should-know\/\"> Read more&#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":85,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-74","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-hacks"],"_links":{"self":[{"href":"https:\/\/onfinity.io\/blog\/wp-json\/wp\/v2\/posts\/74"}],"collection":[{"href":"https:\/\/onfinity.io\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onfinity.io\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onfinity.io\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/onfinity.io\/blog\/wp-json\/wp\/v2\/comments?post=74"}],"version-history":[{"count":13,"href":"https:\/\/onfinity.io\/blog\/wp-json\/wp\/v2\/posts\/74\/revisions"}],"predecessor-version":[{"id":1124,"href":"https:\/\/onfinity.io\/blog\/wp-json\/wp\/v2\/posts\/74\/revisions\/1124"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/onfinity.io\/blog\/wp-json\/wp\/v2\/media\/85"}],"wp:attachment":[{"href":"https:\/\/onfinity.io\/blog\/wp-json\/wp\/v2\/media?parent=74"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onfinity.io\/blog\/wp-json\/wp\/v2\/categories?post=74"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onfinity.io\/blog\/wp-json\/wp\/v2\/tags?post=74"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}