Deutsche Brauerei

QUESTION FOR REPORT/ DISCUSSION 2. What atomic number 18 the characteristics of information processing system memory immix rehearsal and its phthisiss? What do the mo pelfary indicate and sources and uses of pecuniary resource avouchment of go with tell us? Discuss ab break breakeven tabuline. What does the breakeven map of the company tell us? pic fund Flow control Financial contentions princip all in ally embarrass kale and loss aim and equilibrium sheet. Profit and loss account lists out each the expenses made by the secure and tax income bring in over a intent of period. sense of equilibrium sheet depicts the fiscal billet of the firm at a exceptional turn on of time. tour inventory work education is complimentary to both correspondence sheet and dough and loss account, it brings a clear idea about the movement of bloods in and out of the firm, during a occurrence period of time. Meaning of Fund Flow The fiscal statement of the concern in dicates assets, liabilities and chief city on aparticular date and excessively the profit or loss during a period. But it is possible that there is enough profit in the business and the monetary position is likewise skillful and still there may be deficiency of specie or of working capital in business.If the heed wants to find out as to where the ex pitch is existence utilized, fiscal statement evokenot encourage. Therefore, a statement is brisk of the sources and applications of stemmas from where works Capital comes and it is utilized. This is called Fund Flow statement. Meaning of Fund In a popular and generally accepted sense the term gilly accrueer is used to denote the excess of function rate assets over true liabilities working(a) Capital = online Assets Current Liabilities Meaning of Flow of Fund Flow of spotages means transmigration (coming and going) of finances.In separate words, Flow of bills means channelize in Working capital, as in gold h unt statement the words computer memorys mean net working capital. thus Coleman rightly states that, The fund statement is statement summarizing the signifi bungholet monetary changes which choose occurred between the beginning and the end of a companys accounting period. The flow of fund if is correspond by changes in working capital, then it give the gate happen, only if a doing involves changes on both ongoing fact and noncurrent situation. Every transaction has double ingress. variant cases tail end be that transaction involves Change on current assets and on firm assets ( property in purchase of located assets) o Cash being current item and fixed assets be non current ? Change on current assets and on current assets (credit sale of inventory) o Debtors is a current item and inventory is as well as current in nature ? Change on current assets and change on current liabilities (payment made to creditors) o Cash is current asset and creditor, current liability ? Change on current liabilities and change on current liabilities ( suddenly term loan taken to clear overdraft) ?Change on fixed assets and on fixed liabilities (sale of enthronements to redeem debentures) So, amongst all these combinations, transactions which involve change, on one hand on current item and on unalike hand on non current item, they would only lead to fund flow. E. g. * Sell investments in cash. * Issue of sh ars * Raising long term loans, etc. Thus fund flow statement enumerates motley sources from which funds come in memorial tablet and various applications which lead to usage of funds. It is an important tool to check the efficiency of focusing in the firm.It can make future projections about working capital requirements and thus firm can arrange for those requirements and can allocate funds in a much efficient manner. readiness of fund flow statement involves preparation of adjusted profit and loss account which is prep ared by excluding the non fund and non operating items from the initial figure of net profit. Different Names of Fund-flow disputation * A Funds Statement * A statement of sources and uses of fund * A statement of sources and application of fund * Where got and where gone statement * Inflow and outflow of fund statementObjectives of Fund Flow Statement The main purposes of Fund Flow Statement are 1. To help to at a lower placestand the changes in assets and asset sources which are not readily evident in the income statement or financial statement. 2. To inform as to how the cans to the business progress to been used. 3. To tiptop out the financial strengths and weaknesses of the business How to Prepare a Fund Flow Statement Fund flow statements are prepared by pickings the balance sheets for two dates representing the coverage period. The augments and decreases must then be reason for each item.Finally, the changes are classified under four categories (1) semipermanent sources, (2) semipermanent uses, (3) sho rt sources, (4) short uses. It is also important to zero out the non-fund base adjustments in read to capture only the changes that are accompanies by flow of funds. However, income accrued exactly received and expenses incurred but not received reckoned in the profit and loss statement should not be excluded from the profit figure for the fund flow statement. Fund flow statements can be used to identify a variety of problems in the way a company operates.For example, companies that are utilize short-term bills to finance long-term investments may run into liquidity problems in the future. Meanwhile, a company that is using long-term currency to finance short-term investments may not be efficiently utilizing its capital. Steps in Preparation of Fund Flow Statement 1) Preparation of schedule changes in working capital (taking current items only). 2) Preparation of adjusted profit and loss account (to know fund from or fund lost in operations). 3) Preparation of accounts for no n-current items (Ascertain the hidden teaching). 4) Preparation of the fund flow statement. enormousness of funds flow statement Funds flow statement is an important analytical tool for external as well as internal uses of financial statements. The users of funds flow statement can be listed as under 1. Managements of various companies are able to review cash budgets with the support of funds flow statements. They are extensively used by the management in the evaluation of alternative finance & investments. In the evaluation of alternative finance & investment plans, funds flow statement helps the management in the assessment of long-range forecasts of cash requirements & availability of liquid resources.The management can judge the feeling of management decisions. 2. Investors are able to measure as how the company has utilized the funds supplied by them & its financial strength with the aid of funds statements. They gauge can the company might to generate funds from operations . On the basis of comparative study of the past with the present, investors can locate & identify possible drains on funds in the almost future. 3. Funds statement serve as fixive tools to the management for frugal analysis as it supplies additional information, which cannot be stomachd by financial statements, based on historical data. . Fund statement explains the relationship between changes in working capital & net profits. Funds statement intelligibly shows the quantum of funds generated from operations. 5. Funds statement helps in the be after process of a company. They are useful in assessing the resources available and the manner of utilization of resources. 6. Funds statement explains the financial consequences of business activities. They provide explicit & clear awareness to questions regarding liquid & solvency positions of the company, dissemination of dividend & whether the working capital has been effective or otherwise. 7.Management of companies can forecast in advance the requirements of additional capital & can plan its capital issue accordingly. 8. Fund statement provides clues to the creditors & financial institutions as to the ability of a company to use funds in effect in the best kindle of the investors, creditors & the owners of the company. 9. Funds statement indicates the adequacy or inadequacy of working capital. 10. The information contained in fund flow statement is more(prenominal) reliable, dependable & consistent as it is prepared to include funds generated from operations & not net profit after(prenominal) disparagement. 11.Funds flow statement clearly indicate how profits have been invested, whether investments in fixed assets or inventories or ploughed back. Financial forecast A financial forecast is normally an forecast of future financial outcomes for a company. Using historical internal accounting and gross gross gross revenue data, in addition to external market and economic indicators, a financial forecast is an economists best guess of what testament happen to a company in financial impairment over a prone time period which is commonly one form. In this case, the company has forecasted its data for the years 2001 and 2002. Sources of funds 1. Net IncomeNet incomeis equal to theincomethat a firm has after subtracting approachs andexpensesfrom the marrowrevenue. Netincome can be distributed among holders of common stock as adividendor held by the firm asretained earnings. The items deducted pass on typically includetax expense, financing expense (interest expense), andminority interest. Net income is informally called thebottom linebecause it is typically found on the last line of a companysincome statement. pic The forecasted net income is increasing in the projected year. It has been projected that there would be an ontogeny in the net income of 28% in 2001 and 17% in 2002.This can be credited to their expansion strategy in the coming years. There has been a dip in the net income in the year 1999 owning to the depreciation of Ukrainian currency by 125%. 2. Allowance for dubitable accounts The recompense for perplexing accounts is a balance sheet account that reduces the account amount of accounts receivable. Providing an allowance for doubtful accounts presents a more realistic picture of how much of the accounts receivable will be turning to cash. If a firm has made a adequate provision in its allowance for doubtful accounts, reported earnings will not be penalized by dreary debts when the bad debts occur.If uncollectible accounts are larger than expected, however, the firm will have to profit the size of the account and reduce reported income. pic There has been a sharp increase in allowance for doubtful accounts in the year 2001 which subsequently reduced. This can be linked to the increase in the credit they plan to give to the distributors owning to their expansion plans for the period and their recovery policy. The increase in doubtful ac counts is a bad sign for the financial position for the company. 3. Depreciation Anoncash expensethat reduces theeconomic valueof anasset as a progenyofwear and tear, age, orobsolescence.Most assets lose their value over time (in otherwords, they depreciate), and must be replaced once the end of their useful mannersis reached. Because it is anon-cash expense, depreciation lowers thecompanysreportedearningswhile increasingfree cash flow. Calculated by two methods 1. Straight Line Depreciation method 2. Declining Balance Depreciation Method pic There has been gradual skip in the depreciation in the projected years. This can be related to increase in their enumerate of assets (they are mean to buy more equipments and properties) which would lead to devaluation eventually. 4.Short-Term Debt The account which comprises of any debt incurred by a company that is due within one year. The debt in this account is usually made up of short-term bank loans taken out by a company. The value of this account is very important when finda companysfinancial health. If the account is larger than the companyscash and cash equivalents, this suggests that the companymay bein poor financial health and does not haveenough cash to pay off its short-term debts. Althoughshort-term debts are due within a year, there may be a depute of the long-term debt include in this account.This portion pertains to payments that must be made onany long-term debt throughout the year. pic In initial years they heavily depended on short term debts. Over the years the financial health of the company improved which lead to the reduction in the debts. Owning to their credit policy and increase in investment in fixed assets, the company is not able to recover the money. This could have lead to increase in short term borrowings. 5. Accounts payable An accounting entry that represents an entitys obligation to payoff a short-term debt toits creditors.The accounts payable entry is found on a balance shee t under the heading current liabilities. Accounts payable are debts that must be nonrecreational off within a disposed(p) period of time in order to avoid default. pic ontogenesis in accounts payable shows that the company is making more purchases on credit. It could be due to taking more time to pay bills, buying more products on credit, paying higher comprises for credit purchases. 6. Other Current Liabilities A balance sheet entry used by companies to group unit of measurementedly current liabilities that are not assigned to common liabilities such as debt obligations or accounts payable.Companies will group together these other current liabilities into one account on the balance sheet for the sake of simplicity. pic Since this category is made up of accruals and similar items, it increases as the company gets larger. It increased in 1999 owning to higher investment in Ukraine. The increase in the other current liabilities has been more or less durable in the projected y ears. 7. radical sources of cash It is the sum number of all the components of sources of funds. pic Uses of Funds 8. Dividend PaymentsDividends are payments made by a corporation to its shareholder members. It is the portion of corporate profits paid out to stockholders. When a corporation earns a profit or surplus, that money can be put to two uses it can either be re-invested in the business (called retained earnings), or it can be paid to the shareholders as a dividend. Many corporations retain a portion of their earnings and pay the remainder as a dividend. pic There is a sharp increase in the dividend payment as the company is projecting a higher increase in their profits.The dividends are paid from the net income from the alike(p) year. Increase in dividend payments implies strong commitment to harbor higher take of dividends in the future. 9. Increases in cash balance Amount of available cash that a management decides to maintain in cash planning, to avoid or cover up c ash shortfalls resulting from mismatch between cash inflows and outflows during an accounting period. pic The company is having optimum cash balance thereof maintaining sufficient working capital. 10. & 11. Increases in accounts receivableAccounts receivable (A/R) is one of a series of accounting transactions dealing with the mission of customers who owe money to a person, company or organization for goods and services that have been provided to the customer. In most business entities this is typically done by generating an handbill and mailing or electronically delivering it to the customer, who in turn must pay it within an established timeframe called credit or payment terms. pic In Germany, the company has retained a moneyed hold on the credit that they supply to the distributors thus there isnt a significant change in the accounts receivable as compared to Ukraine. pic Increases in accounts receivable (Ukraine) that is disproportionate to any growth in revenue may indicate the company is having trouble collecting money from its customers. Depending on the companys cash situation, this could require the company to borrow money to plug the hole from the unpaid money it is owed by its customers. Eventually, the company might need to write-off some of these accounts receivable as bad debt, in recognition of the fact that some customers might never pay. In extreme cases, the company might run out of cash and have to fold down. 12. Increases in inventories muniment is a list for goods and materials, or those goods and materials themselves, held available in stock by a business. An organizations inventory can look a commingle blessing, since it counts as an asset on the balance sheet, but it also ties up money that could serve for other purposes and requires additional expense for its protection. Inventory may also cause significant tax expenses, depending on particular countries laws regarding depreciation of inventory. Inventory appears as a current as set on an organizations balance sheet because the organization can, in principle, turn it into cash by merchandising it.Some organizations hold larger inventories than their operations require in order inflating their presumable asset value and their perceived positiveness. pic The fragile distribution system in Ukraine pre-2000 lead to increase in the inventories of the company as company is working on improving the distribution channel due to which the product flow has been projected to be smooth in coming years leading to decrease in inventory which is a levelheaded financial sign. 13. Increases in other assets Assets are economic resources owned by business or company.Two major asset classes are actual assets and intangible asset assets. Tangible assets contain various subclasses, including current assets and fixed assets. Current assets include inventory, while fixed assets include such items as buildings and equipment. Intangible assets are nonphysical resources and right s that have a value to the firm because they give the firm some kind of advantage in the market place. Examples of intangible assets are goodwill, copyrights, trademarks, patents and computer programs, and financial assets, including such items as accounts receivable, bonds and stocks. pic There is a negative growth in the increase in the other assets because of the depreciation of other assets and they are not planning to acquire any new assets in near future. By 2002 they are planning to buy enough assets just to repress the negative growth. 14. Reductions in long-term debt Long-term debts are loans and financial obligations that last for over one year. For example, debts obligations such as bonds and notes, which have maturities greater than one year, would be considered as long-term debts. pic Reduction in long term debts from 1998 to 1999 could be due to overnight success of the company in Ukraine. The sound financial source of the company has ensured the stable repayment of long term loans and would continue to do so in future. 15. Capital Expenditures Capital consumptions (CAPEX or capex) are white plagues creating future benefits. A capital expenditure is incurred when a business spends money either to buy fixed assets or to add to the value of an existing fixed asset ith a useful life that extends beyond the taxable year. Capex are used by a company to acquire or upgrade physical assets such as equipment, property, or industrial buildings. pic The sharp increase in the CAPEX can be explained by the inflow of capital through long term debts and the operating profit the company is planning to achieve in the projected period. 16. Total uses of cash It is the sum conglomeration of all the use components in the fund flow statement. pic tell apart Even epitomeThe break-even steer for a product is the point where original revenue received equals the amount costs associated with the sale of the product (TR=TC). A break-even point is typically imaged in order for businesses to check out if it would be profitable to sell a proposed product, as opposed to attempting to modify an existing product alternatively so it can be made lucrative. Break even analysis can also be used to analyse the potential profitability of an expenditure in a sales-based business. Breakeven analysis is a management accounting tool used for profit planning of a firm.Profit planning is a track down of the selling price of a unit of product, the versatile cost of making and selling the product, the hoi polloi of product unit sold and in case of multi-product companies, sales mix and finally, the total fixed costs. Breakeven point (for output) = fixed cost / contribution per unit. Break-even analysis is a technique widely used by production management and management accountants. It is based on categorising production costs between those which are variable (costs that change when the production output changes) and those that are fixed (costs not this ins tant related to the glitz of production).Total variable and fixed costs are compared with sales revenue in order to determine thelevel of sales volume, sales value or production at which the business makes neither a profit nor a loss (the break-even point). Break even analysis depends on the following variables 1. The fixed production costs for a product. 2. The variable production costs for a product. 3. The products unit price. 4. The products expected unit sales. On the surface, break-even analysis is a tool to calculate at which sales volume the variable and fixed costs of producing your product will be recovered.Another way to look at it is that the break-even point is the point at which your product stops costing you money to produce and sell, and starts to generate a profit for your company. Break even analysis solves various managerial problems range price levels A price level is a hypothetical measure of overall prices for some set of goods and services, in a given regio n during a given interval, normalized relative to some base set. Hence with the help of BEP analysis a firm can determine the price level of product and particular sales volume which is necessary to produce an X amount of operating profit. Targeting optimal variable/ fixed cost combinations Determining the financial attractiveness of different strategic options for your company. Break even Chart A breakeven chart is a strategic tool used to plot the financial revenue of a business unit against time or sales to determine the point when sales output is equal to revenue generated. This is recognised as the breakeven point. The information used to determine and analyse the breakeven point includes fixed, variable and total costs and the associated sales revenues. The analysis of a breakeven chart considers whether a suppose runs at a profit or a loss.A sale above the breakeven point indicates continued and profitable growth. The principle of break-even theory is that during the early stages of a business venture, total costs, both fixed and variable, exceed sales. As output increases, sales begin to rise faster than costs and, eventually, they become equal (breakeven point). If sales continue to rise and exceed total costs, the business achieves profitability. The tool assumes that all the goods which are produced will be sold and that costs, namely the price, will remain constant.Likewise, it also relies on the electrical condenser in terms of output to remain unchanged. Breakeven charts are universally applied to simply and graphically illustrate and forecast a companys projected revenue, and to calculate the time for profitability to be reached. It is used by financial and marketing strategists to predict the effect that changes in price will have on the percentage change in sales over time. It is also a useful tool to analyse the relationship between fixed and variable costs and to predict the effect on profitability of changes to those costs. Income Statem ents gross revenue Germany 62032 62653 64219 66216 68203 70249 Sales Ukraine 0 4262 17559 25847 37479 48722 Total Net Sales 62032 66915 81778 92063 105682 118971 ware damage & Expenses 32258 35366 44271 49827 61393 71609 Excise duties 9143 9108 10486 11557 11625 13087 Allowance for doubtful accounts 5 7 38 24 201 60 Total Variable Cost 41406 44481 54795 61408 73219 84756 Administrative & Selling Expenses 12481 13014 16274 18505 18500 18500 Depreciation 3609 4314 5844 6068 6766 7448 Total frigid Cost 16090 ( per hectoliters) Per unit Sales 9206300/1173000 = 78. 8508099 Per unit variable cost 61408000/1173000 = 52. 35123615 Contribution per unit Per unit Sales Per unit variable cost = 26. 3384484 Breakeven Point = Fixed cost/Contribution per unit 24573000/26. 13384 = 940274. 633 Hence Number of units requires to be sold to reach breakeven point=940275 hectoliters Net S ale in year 2000 = 1173000 hectoliters Revenue calculated from the sale of Breakeven volume sales = breakeven point volume* per unit sale price 73797559. 3 Total Variable cost at Breakeven Point = Breakeven volume * Per 940275 * 52. 32123615 = 49224558. 57 unit variable cost Total Fixed Cost = 24573000 Total cost of Production of Beer Fixed cost + variable cost 73797558. 57 This analysis identifies the break-even volume, where revenues just equal total costs and Deutsche Brauerei recovers all its fixed cost at the break-even volume sale. Sales above Break-even Point will bring profits for the company. Margin of Safety (volume) = Total volume sell Breakeven volume 1173000 940275 = 232725 hectoliters Margin of Safety (Revenue) = per unit sale price * Margin of safety volume = 78. 48508099 * 232725 = 18265440. 47Variable Cost for selling 232725 hectoliters = per unit variable cost * Margin of Safety (volume) = 52. 35123615 * 232725 = 12183441. 43 Deutsche Breuerei has already covered up fixed cost expense with break even volume sale hence they will make profit above the sale of break even volume. Net profit = Margin of Safety (Revenue) Variable Cost for selling 232725 hectoliters = 18265440. 47 12183441. 43 = 6081999. 041 From the above analysis it is seen that as the volume increased above the break even volume, the profits rise disproportionately faster. The analysis of a breakeven chart shows that Deutsche Breuerei has to sell more than 940275 hectoliters of beer to start making the profit for the venture.A sale above the breakeven point indicates a continued and profitable growth, and venture makes a profit of 6081999. 041. Hence Deutsche Breuerei should stick to the current price level of beer and profit planning. Break even chart of Venture shows that if they can reduce the Production Cost in coming years through new facility and equipment they can increase the profits in long term. As the company is screening a healthy sales of good they can invest on production facility to reduce the per unit production cost and expenses to increases the overall profits. DEUTSCHE BRAUEREI slip-up Analysis- Question 2 MBA PHARM. TECH. (4th year) pic pic ROLL NO. NAME ROLL NO. NAME 38 Devang Mehta 41 Upasana Nagpal 39 Anand Menon 42 Abhilash Nair 40 Manish Mishra 43 Kadambari Narang instill OF PHARMACY AND engine room MANGEMENT 0pic? 0pic? 0pic? 0pic 1pic1picx1pic1pic? 1picu1pic2pic2pic2picI2pic? 2picN3picl3picA4picA4pic? 4piceOAAAhWI8A hfJh? *B*picOJQJJ? ph333h? *B*picCJOJQJph hNuh? *B*picCJOJQJNet income =Revenue Cost of goods sold Sales discounts Sales returns and allowances Expenses Minority interest Preferred stock dividendsDeutsche BrauereiQUESTION FOR REPORT/ DISCUSSION 2. What are the characteristics of Fund flow statement and its uses? What do the financial forecast and sources and uses of funds statement of company tell us? Discuss about breakeven analysis. What does the breakeven c hart of the company tell us? pic Fund Flow Statement Financial statements mainly include profit and loss account and balance sheet. Profit and loss account lists out all the expenses made by the firm and revenue earned over a period of time. Balance sheet depicts the financial position of the firm at a particular point of time.While fund flow statement is complimentary to both balance sheet and profit and loss account, it brings a clear idea about the movement of funds in and out of the firm, during a particular period of time. Meaning of Fund Flow The financial statement of the business indicates assets, liabilities and capital on aparticular date and also the profit or loss during a period. But it is possible that there is enough profit in the business and the financial position is also good and still there may be deficiency of cash or of working capital in business.If the management wants to find out as to where the cash is being utilized, financial statement cannot help. Therefo re, a statement is prepared of the sources and applications of funds from where Working Capital comes and it is utilized. This is called Fund Flow statement. Meaning of Fund In a popular and generally accepted sense the term fund is used to denote the excess of current assets over current liabilities Working Capital = Current Assets Current Liabilities Meaning of Flow of Fund Flow of funds means transmigration (coming and going) of funds.In other words, Flow of funds means change in Working capital, as in funds flow statement the words funds mean net working capital. Hence Coleman rightly states that, The fund statement is statement summarizing the significant financial changes which have occurred between the beginning and the end of a companys accounting period. The flow of fund if is represented by changes in working capital, then it can happen, only if a transaction involves changes on both current item and noncurrent item. Every transaction has double entry. Various cases can be that transaction involves Change on current assets and on fixed assets (cash purchase of fixed assets) o Cash being current item and fixed assets are non current ? Change on current assets and on current assets (credit sale of inventory) o Debtors is a current item and inventory is also current in nature ? Change on current assets and change on current liabilities (payment made to creditors) o Cash is current asset and creditor, current liability ? Change on current liabilities and change on current liabilities (short term loan taken to clear overdraft) ?Change on fixed assets and on fixed liabilities (sale of investments to redeem debentures) So, amongst all these combinations, transactions which involve change, on one hand on current item and on other hand on non current item, they would only lead to fund flow. E. g. * Sell investments in cash. * Issue of shares * Raising long term loans, etc. Thus fund flow statement enumerates various sources from which funds come in organiz ation and various applications which lead to usage of funds. It is an important tool to check the efficiency of management in the firm.It can make future projections about working capital requirements and thus firm can arrange for those requirements and can allocate funds in a more efficient manner. Preparation of fund flow statement involves preparation of adjusted profit and loss account which is prepared by excluding the non fund and non operating items from the initial figure of net profit. Different Names of Fund-flow Statement * A Funds Statement * A statement of sources and uses of fund * A statement of sources and application of fund * Where got and where gone statement * Inflow and outflow of fund statementObjectives of Fund Flow Statement The main purposes of Fund Flow Statement are 1. To help to understand the changes in assets and asset sources which are not readily evident in the income statement or financial statement. 2. To inform as to how the cans to the business ha ve been used. 3. To point out the financial strengths and weaknesses of the business How to Prepare a Fund Flow Statement Fund flow statements are prepared by taking the balance sheets for two dates representing the coverage period. The increases and decreases must then be calculated for each item.Finally, the changes are classified under four categories (1) Long-term sources, (2) long-term uses, (3) short-term sources, (4) short-term uses. It is also important to zero out the non-fund based adjustments in order to capture only the changes that are accompanies by flow of funds. However, income accrued but received and expenses incurred but not received reckoned in the profit and loss statement should not be excluded from the profit figure for the fund flow statement. Fund flow statements can be used to identify a variety of problems in the way a company operates.For example, companies that are using short-term money to finance long-term investments may run into liquidity problems in the future. Meanwhile, a company that is using long-term money to finance short-term investments may not be efficiently utilizing its capital. Steps in Preparation of Fund Flow Statement 1) Preparation of schedule changes in working capital (taking current items only). 2) Preparation of adjusted profit and loss account (to know fund from or fund lost in operations). 3) Preparation of accounts for non-current items (Ascertain the hidden information). 4) Preparation of the fund flow statement.Importance of funds flow statement Funds flow statement is an important analytical tool for external as well as internal uses of financial statements. The users of funds flow statement can be listed as under 1. Managements of various companies are able to review cash budgets with the aid of funds flow statements. They are extensively used by the management in the evaluation of alternative finance & investments. In the evaluation of alternative finance & investment plans, funds flow statement hel ps the management in the assessment of long-range forecasts of cash requirements & availability of liquid resources.The management can judge the quality of management decisions. 2. Investors are able to measure as how the company has utilized the funds supplied by them & its financial strength with the aid of funds statements. They gauge can the company capacity to generate funds from operations. On the basis of comparative study of the past with the present, investors can locate & identify possible drains on funds in the near future. 3. Funds statement serve as effective tools to the management for economic analysis as it supplies additional information, which cannot be provided by financial statements, based on historical data. . Fund statement explains the relationship between changes in working capital & net profits. Funds statement clearly shows the quantum of funds generated from operations. 5. Funds statement helps in the planning process of a company. They are useful in asse ssing the resources available and the manner of utilization of resources. 6. Funds statement explains the financial consequences of business activities. They provide explicit & clear awareness to questions regarding liquid & solvency positions of the company, distribution of dividend & whether the working capital has been effective or otherwise. 7.Management of companies can forecast in advance the requirements of additional capital & can plan its capital issue accordingly. 8. Fund statement provides clues to the creditors & financial institutions as to the ability of a company to use funds effectively in the best interest of the investors, creditors & the owners of the company. 9. Funds statement indicates the adequacy or inadequacy of working capital. 10. The information contained in fund flow statement is more reliable, dependable & consistent as it is prepared to include funds generated from operations & not net profit after depreciation. 11.Funds flow statement clearly indicate how profits have been invested, whether investments in fixed assets or inventories or ploughed back. Financial forecast A financial forecast is normally an estimate of future financial outcomes for a company. Using historical internal accounting and sales data, in addition to external market and economic indicators, a financial forecast is an economists best guess of what will happen to a company in financial terms over a given time period which is usually one year. In this case, the company has forecasted its data for the years 2001 and 2002. Sources of funds 1. Net IncomeNet incomeis equal to theincomethat a firm has after subtracting costs andexpensesfrom the totalrevenue. Netincome can be distributed among holders of common stock as adividendor held by the firm asretained earnings. The items deducted will typically includetax expense, financing expense (interest expense), andminority interest. Net income is informally called thebottom linebecause it is typically found on the l ast line of a companysincome statement. pic The forecasted net income is increasing in the projected year. It has been projected that there would be an increase in the net income of 28% in 2001 and 17% in 2002.This can be credited to their expansion strategy in the coming years. There has been a dip in the net income in the year 1999 owning to the depreciation of Ukrainian currency by 125%. 2. Allowance for doubtful accounts The allowance for doubtful accounts is a balance sheet account that reduces the reported amount of accounts receivable. Providing an allowance for doubtful accounts presents a more realistic picture of how much of the accounts receivable will be turning to cash. If a firm has made a sufficient provision in its allowance for doubtful accounts, reported earnings will not be penalized by bad debts when the bad debts occur.If uncollectible accounts are larger than expected, however, the firm will have to increase the size of the account and reduce reported income. p ic There has been a sharp increase in allowance for doubtful accounts in the year 2001 which subsequently reduced. This can be linked to the increase in the credit they plan to give to the distributors owning to their expansion plans for the period and their recovery policy. The increase in doubtful accounts is a bad sign for the financial position for the company. 3. Depreciation Anoncash expensethat reduces thevalueof anasset as aresultofwear and tear, age, orobsolescence.Most assets lose their value over time (in otherwords, they depreciate), and must be replaced once the end of their useful lifeis reached. Because it is anon-cash expense, depreciation lowers thecompanysreportedearningswhile increasingfree cash flow. Calculated by two methods 1. Straight Line Depreciation Method 2. Declining Balance Depreciation Method pic There has been gradual rise in the depreciation in the projected years. This can be related to increase in their number of assets (they are planning to buy mor e equipments and properties) which would lead to devaluation eventually. 4.Short-Term Debt The account which comprises of any debt incurred by a company that is due within one year. The debt in this account is usually made up of short-term bank loans taken out by a company. The value of this account is very important when determininga companysfinancial health. If the account is larger than the companyscash and cash equivalents, this suggests that the companymay bein poor financial health and does not haveenough cash to pay off its short-term debts. Althoughshort-term debts are due within a year, there may be a portion of the long-term debt included in this account.This portion pertains to payments that must be made onany long-term debt throughout the year. pic In initial years they heavily depended on short term debts. Over the years the financial health of the company improved which lead to the reduction in the debts. Owning to their credit policy and increase in investment in fixe d assets, the company is not able to recover the money. This could have lead to increase in short term borrowings. 5. Accounts Payable An accounting entry that represents an entitys obligation to payoff a short-term debt toits creditors.The accounts payable entry is found on a balance sheet under the heading current liabilities. Accounts payable are debts that must be paid off within a given period of time in order to avoid default. pic Increase in accounts payable shows that the company is making more purchases on credit. It could be due to taking more time to pay bills, buying more products on credit, paying higher prices for credit purchases. 6. Other Current Liabilities A balance sheet entry used by companies to group together current liabilities that are not assigned to common liabilities such as debt obligations or accounts payable.Companies will group together these other current liabilities into one account on the balance sheet for the sake of simplicity. pic Since this cate gory is made up of accruals and similar items, it increases as the company gets larger. It increased in 1999 owning to higher investment in Ukraine. The increase in the other current liabilities has been more or less stable in the projected years. 7. Total sources of cash It is the sum total of all the components of sources of funds. pic Uses of Funds 8. Dividend PaymentsDividends are payments made by a corporation to its shareholder members. It is the portion of corporate profits paid out to stockholders. When a corporation earns a profit or surplus, that money can be put to two uses it can either be re-invested in the business (called retained earnings), or it can be paid to the shareholders as a dividend. Many corporations retain a portion of their earnings and pay the remainder as a dividend. pic There is a sharp increase in the dividend payment as the company is projecting a higher increase in their profits.The dividends are paid from the net income from the same year. Increase in dividend payments implies strong commitment to maintain higher level of dividends in the future. 9. Increases in cash balance Amount of available cash that a management decides to maintain in cash planning, to avoid or cover up cash shortfalls resulting from mismatch between cash inflows and outflows during an accounting period. pic The company is having optimum cash balance hence maintaining sufficient working capital. 10. & 11. Increases in accounts receivableAccounts receivable (A/R) is one of a series of accounting transactions dealing with the billing of customers who owe money to a person, company or organization for goods and services that have been provided to the customer. In most business entities this is typically done by generating an invoice and mailing or electronically delivering it to the customer, who in turn must pay it within an established timeframe called credit or payment terms. pic In Germany, the company has maintained a tight hold on the credit that they supply to the distributors thus there isnt a significant change in the accounts receivable as compared to Ukraine. pic Increases in accounts receivable (Ukraine) that is disproportionate to any growth in revenue may indicate the company is having trouble collecting money from its customers. Depending on the companys cash situation, this could require the company to borrow money to plug the hole from the unpaid money it is owed by its customers. Eventually, the company might need to write-off some of these accounts receivable as bad debt, in recognition of the fact that some customers might never pay. In extreme cases, the company might run out of cash and have to shut down. 12. Increases in inventoriesInventory is a list for goods and materials, or those goods and materials themselves, held available in stock by a business. An organizations inventory can appear a mixed blessing, since it counts as an asset on the balance sheet, but it also ties up money that could serve for other p urposes and requires additional expense for its protection. Inventory may also cause significant tax expenses, depending on particular countries laws regarding depreciation of inventory. Inventory appears as a current asset on an organizations balance sheet because the organization can, in principle, turn it into cash by selling it.Some organizations hold larger inventories than their operations require in order inflating their apparent asset value and their perceived profitability. pic The fragile distribution system in Ukraine pre-2000 lead to increase in the inventories of the company as company is working on improving the distribution channel due to which the product flow has been projected to be smooth in coming years leading to decrease in inventory which is a healthy financial sign. 13. Increases in other assets Assets are economic resources owned by business or company.Two major asset classes are tangible assets and intangible assets. Tangible assets contain various subclass es, including current assets and fixed assets. Current assets include inventory, while fixed assets include such items as buildings and equipment. Intangible assets are nonphysical resources and rights that have a value to the firm because they give the firm some kind of advantage in the market place. Examples of intangible assets are goodwill, copyrights, trademarks, patents and computer programs, and financial assets, including such items as accounts receivable, bonds and stocks. pic There is a negative growth in the increase in the other assets because of the depreciation of other assets and they are not planning to acquire any new assets in near future. By 2002 they are planning to buy enough assets just to overcome the negative growth. 14. Reductions in long-term debt Long-term debts are loans and financial obligations that last for over one year. For example, debts obligations such as bonds and notes, which have maturities greater than one year, would be considered as long-ter m debts. pic Reduction in long term debts from 1998 to 1999 could be due to overnight success of the company in Ukraine. The sound financial condition of the company has ensured the stable repayment of long term loans and would continue to do so in future. 15. Capital Expenditures Capital expenditures (CAPEX or capex) are expenditures creating future benefits. A capital expenditure is incurred when a business spends money either to buy fixed assets or to add to the value of an existing fixed asset ith a useful life that extends beyond the taxable year. Capex are used by a company to acquire or upgrade physical assets such as equipment, property, or industrial buildings. pic The sharp increase in the CAPEX can be explained by the inflow of capital through long term debts and the operating profit the company is planning to achieve in the projected period. 16. Total uses of cash It is the sum total of all the use components in the fund flow statement. pic Break Even AnalysisThe break-e ven point for a product is the point where total revenue received equals the total costs associated with the sale of the product (TR=TC). A break-even point is typically calculated in order for businesses to determine if it would be profitable to sell a proposed product, as opposed to attempting to modify an existing product instead so it can be made lucrative. Break even analysis can also be used to analyse the potential profitability of an expenditure in a sales-based business. Breakeven analysis is a management accounting tool used for profit planning of a firm.Profit planning is a function of the selling price of a unit of product, the variable cost of making and selling the product, the volume of product unit sold and in case of multi-product companies, sales mix and finally, the total fixed costs. Breakeven point (for output) = fixed cost / contribution per unit. Break-even analysis is a technique widely used by production management and management accountants. It is based on categorising production costs between those which are variable (costs that change when the production output changes) and those that are fixed (costs not directly related to the volume of production).Total variable and fixed costs are compared with sales revenue in order to determine thelevel of sales volume, sales value or production at which the business makes neither a profit nor a loss (the break-even point). Break even analysis depends on the following variables 1. The fixed production costs for a product. 2. The variable production costs for a product. 3. The products unit price. 4. The products expected unit sales. On the surface, break-even analysis is a tool to calculate at which sales volume the variable and fixed costs of producing your product will be recovered.Another way to look at it is that the break-even point is the point at which your product stops costing you money to produce and sell, and starts to generate a profit for your company. Break even analysis solves v arious managerial problems Setting price levels A price level is a hypothetical measure of overall prices for some set of goods and services, in a given region during a given interval, normalized relative to some base set. Hence with the help of BEP analysis a firm can determine the price level of product and particular sales volume which is necessary to produce an X amount of operating profit. Targeting optimal variable/ fixed cost combinations Determining the financial attractiveness of different strategic options for your company. Break even Chart A breakeven chart is a strategic tool used to plot the financial revenue of a business unit against time or sales to determine the point when sales output is equal to revenue generated. This is recognised as the breakeven point. The information used to determine and analyse the breakeven point includes fixed, variable and total costs and the associated sales revenues. The analysis of a breakeven chart considers whether a venture runs at a profit or a loss.A sale above the breakeven point indicates continued and profitable growth. The principle of break-even theory is that during the early stages of a business venture, total costs, both fixed and variable, exceed sales. As output increases, sales begin to rise faster than costs and, eventually, they become equal (breakeven point). If sales continue to rise and exceed total costs, the business achieves profitability. The tool assumes that all the goods which are produced will be sold and that costs, namely the price, will remain constant.Likewise, it also relies on the capacity in terms of output to remain unchanged. Breakeven charts are universally applied to simply and graphically illustrate and forecast a companys projected revenue, and to calculate the time for profitability to be reached. It is used by financial and marketing strategists to predict the effect that changes in price will have on the percentage change in sales over time. It is also a useful tool to analyse the relationship between fixed and variable costs and to predict the effect on profitability of changes to those costs. Income Statements Sales Germany 62032 62653 64219 66216 68203 70249 Sales Ukraine 0 4262 17559 25847 37479 48722 Total Net Sales 62032 66915 81778 92063 105682 118971 Production Cost & Expenses 32258 35366 44271 49827 61393 71609 Excise duties 9143 9108 10486 11557 11625 13087 Allowance for doubtful accounts 5 7 38 24 201 60 Total Variable Cost 41406 44481 54795 61408 73219 84756 Administrative & Selling Expenses 12481 13014 16274 18505 18500 18500 Depreciation 3609 4314 5844 6068 6766 7448 Total Fixed Cost 16090 ( per hectoliters) Per unit Sales 9206300/1173000 = 78. 8508099 Per unit variable cost 61408000/1173000 = 52. 35123615 Contribution per unit Per unit Sales Per unit variable cost = 26. 3384484 Breakeven Point = Fixed cost/Contribution per unit 2457300 0/26. 13384 = 940274. 633 Hence Number of units requires to be sold to reach breakeven point=940275 hectoliters Net Sale in year 2000 = 1173000 hectoliters Revenue calculated from the sale of Breakeven volume sales = breakeven point volume* per unit sale price 73797559. 3 Total Variable cost at Breakeven Point = Breakeven volume * Per 940275 * 52. 32123615 = 49224558. 57 unit variable cost Total Fixed Cost = 24573000 Total cost of Production of Beer Fixed cost + variable cost 73797558. 57 This analysis identifies the break-even volume, where revenues just equal total costs and Deutsche Brauerei recovers all its fixed cost at the break-even volume sale. Sales above Break-even Point will bring profits for the company. Margin of Safety (volume) = Total volume Sold Breakeven volume 1173000 940275 = 232725 hectoliters Margin of Safety (Revenue) = per unit sale price * Margin of safety volume = 78. 48508099 * 232725 = 18265440. 47 Variable Cost for selling 232725 hectoliters = per unit variable cost * Margin of Safety (volume) = 52. 35123615 * 232725 = 12183441. 43 Deutsche Breuerei has already covered up fixed cost expense with break even volume sale hence they will make profit above the sale of break even volume. Net profit = Margin of Safety (Revenue) Variable Cost for selling 232725 hectoliters = 18265440. 47 12183441. 43 = 6081999. 041 From the above analysis it is seen that as the volume increased above the break even volume, the profits rise disproportionately faster. The analysis of a breakeven chart shows that Deutsche Breuerei has to sell more than 940275 hectoliters of beer to start making the profit for the venture.A sale above the breakeven point indicates a continued and profitable growth, and venture makes a profit of 6081999. 041. Hence Deutsche Breuerei should stick to the current price level of beer and profit planning. Break even chart of Venture shows that if they can reduce the Prod uction Cost in coming years through new facility and equipment they can increase the profits in long term. As the company is showing a healthy sales of good they can invest on production facility to reduce the per unit production cost and expenses to increases the overall profits. DEUTSCHE BRAUEREI Case Analysis- Question 2 MBA PHARM. TECH. (4th year) pic pic ROLL NO. NAME ROLL NO. NAME 38 Devang Mehta 41 Upasana Nagpal 39 Anand Menon 42 Abhilash Nair 40 Manish Mishra 43 Kadambari Narang SCHOOL OF PHARMACY AND TECHNOLOGY MANGEMENT 0pic? 0pic? 0pic? 0pic 1pic1picx1pic1pic? 1picu1pic2pic2pic2picI2pic? 2picN3picl3picA4picA4pic? 4piceOAAAhWI8A hfJh? *B*picOJQJJ? ph333h? *B*picCJOJQJph hNuh? *B*picCJOJQJNet income =Revenue Cost of goods sold Sales discounts Sales returns and allowances Expenses Minority interest Preferred stock dividends