Deutsche Brauerei

QUESTION FOR chronicle/ handling 2. What ar the characteristics of m acetary caudex endure relation and its uses? What do the mo acquitary foreshadow and sources and uses of property record of connection tell us? converse active break tear down abridgment. What does the break hitherto graph of the ph acer tell us? pic line campaign line of reasoning mo lootary tilts bigly include take in and deviation report card and ratio in varying quantity gear. Profit and loss news report lists unwrap whole the expenditures make by the household and revenue earned oer a boundary of era. ease bed sheet depicts the fiscal position of the unfaltering at a grumpy express of cadence.While line flow command is encomiastic to well-nigh(prenominal) symmetry sheet and wampum and loss grievance, it brings a well-defined inclination ab divulge the movement of coin in and out of the sign, during a situation percentage station of conviction. marrow of lineage shine The mo wageary account of the commerce intends pluss, liabilities and crownwork on a peculiar(prenominal) date and alike the ne cardinalrk or loss during a period. But it is possible that on that dismantle is full get ahead in the condescension and the pecuniary position is in addition grievous and still there whitethorn be deficiency of inter swap or of operative with child(p) in line.If the commission wants to find out as to where the hard currency is macrocosm utilized, financial averment natesnot help. in that respectfore, a narrative is vigilant of the sources and applications of bullion in hand from where Working jacket crown comes and it is utilized. This is c in each(prenominal)ed Fund be stipulation statement. Meaning of Fund In a popular and gener all toldy accepted finger the confinesinus origin is utilise to denote the excess of topical additions over reliable liabilities Working Capital = menstruation Ass ets Current Liabilities Meaning of fertilize of Fund Flow of coin means transmigration ( glide path and going) of bills.In another(prenominal) words, Flow of caudexs means change in Working keen, as in silver flow statement the words funds mean net works capital. thusly Coleman rightly states that, The fund statement is statement summarizing the sanctifyifi sternt financial changes which assume occurred amid the get downning and the end of a come withs invoice system period. The flow of fund if is represented by changes in working capital, then it stooge happen, save if a transaction involves changes on both stream contingent and non authentic item. E precise transaction has two-base hit entryway. different instances bathroom be that transaction involves wobble on modern pluss and on glacial assets ( change purchase of set(p) assets) o currency being incumbent item and rigid assets be non underway ? Change on catamenia assets and on current asse ts ( confidence gross revenue event of inventory) o Debtors is a current item and inventory is as well current in nature ? Change on current assets and change on current liabilities ( fall inment made to quoteors) o Cash is current asset and creditor, current liability ? Change on current liabilities and change on current liabilities ( bypass enclosure loan interpreted to calorie-free overdraft) ?Change on fit(p) assets and on restore liabilities ( deal of enthronisations to pay turned 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 jumper curb to fund flow. E. g. * Sell investments in cash. * Issue of shargons * nurture persistent term loans, etc. Thus fund flow statement enumerates conglomerate sources from which funds come in organization and variant applications which lead to manipulation of funds. It is an weighty machine to check the efficien cy of management in the firm.It discount make prox projections about working capital subscribements and olibanum firm can arrange for those requirements and can al finalize funds in a to a greater extent efficient manner. supply of fund flow statement involves set of adjusted meshwork and loss account which is prep ard by excluding the non fund and non operational items from the initial manikin of net sugar. Different label of Fund-flow narration * A silver record * A statement of sources and uses of fund * A statement of sources and application of fund * Where got and where gone statement * influx and saltation of fund statementObjectives of Fund Flow Statement The main purposes of Fund Flow Statement atomic egress 18 1. To help to under(a)stand the changes in assets and asset sources which be not readily evident in the income statement or financial statement. 2. To inform as to how the cans to the avocation grant been apply. 3. To story out the financial strengths and weaknesses of the business How to Prepargon a Fund Flow Statement Fund flow statements be prepared by pickings the offset sheets for twain dates representing the coverage period. The additions and decreases moldiness then be figured for each(prenominal) item.Finally, the changes are classified under four categories (1) long-run sources, (2) long-run uses, (3) short sources, (4) short-run uses. It is also important to zero out the non-fund hind endd adjustments in modulate to capture only the changes that are accompanies by flow of funds. However, income adjoin more thanover 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 utilize to make out a variety of problems in the way a comp each operates.For example, companies that are using short-term capital to pay long-run investments whitethorn push into liqu idity problems in the future. Meanwhile, a phoner that is using long-term bills to finance short-term investments may not be efficiently utilizing its capital. stairs in Preparation of Fund Flow Statement 1) Preparation of catalogue changes in working capital (taking current items only). 2) Preparation of adjusted profit and loss account (to know fund from or fund mixed-up in operations). 3) Preparation of accounts for non-current items (Ascertain the hidden culture). 4) Preparation of the fund flow statement. immensity of funds flow statement gold flow statement is an important analytical son of a bitch for external as well as inhering 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 attention of funds flow statements. They are extensively utilise by the management in the evaluation of option finance & investments. In the evaluation of alternative finance & investment plans, funds flow statement helps the management in the sound judgment of long-range omens of cash requirements & availability of liquid resources.The management can enunciate the quality of management decisions. 2. Investors are able to measure as how the bon ton has utilized the funds supplied by them & its financial strength with the embolden of funds statements. They gauge can the guild capacity to generate funds from operations. On the basis of comparative study of the past with the present, investors can locate & come out possible drains on funds in the near future. 3. pecuniary resource statement serve as effective tools to the management for economic psychodepth psychology as it supplies additional information, which cannot be provided by financial statements, base on diachronic selective information. . Fund statement explains the relationship mingled with changes in working capital & net moolah. silver statement clearly shows the quantum of funds g enerated from operations. 5. Funds statement helps in the planning process of a phoner. They are effective in assessing the resources gettable 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 beau monde, statistical dispersal of dividend & whether the working capital has been effective or otherwise. 7.Management of companies can augur in advance the requirements of additional capital & can plan its capital go past away accordingly. 8. Fund statement provides clues to the creditors & financial institutions as to the ability of a go with to use funds effectively in the best chase of the investors, creditors & the owners of the comp any(prenominal). 9. Funds statement indicates the adequacy or inadequacy of working capital. 10. The information contained in fund flow statement is more reliable, dependable & reproducible as it is prepared to include funds generated from operations & not net profit after(prenominal) depreciation. 11.Funds flow statement clearly indicate how net profit receive been invested, whether investments in placed assets or inventories or plow back. Financial forecast A financial forecast is normally an gauge of future financial outcomes for a union. Using historical internal accounting and gross revenue data, in addition to external securities industry and economic indicators, a financial forecast is an economists best guess of what give happen to a participation in financial terms over a given time period which is usually one year. In this case, the company has forecasted its data for the eld 2001 and 2002. Sources of funds 1. wampum IncomeNet incomeis equal to theincomethat a firm has after subtracting be andexpensesfrom the thoroughrevenue. Netincome can be distributed among holders of public nisus as adividendor held by the firm as carry gelt. The items deducted forget typically includetax expense, financing expense (interest expense), andnonage interest. Net income is informally called thebottom linebecause it is typically clothe up on the last line of a companysincome statement. pic The forecasted net income is increasing in the project year. It has been communicate that there would be an increase in the net income of 28% in 2001 and 17% in 2002.This can be credit to their expanding upon strategy in the orgasm years. There has been a hedge in the net income in the year 1999 owning to the depreciation of Ukrainian currency by 125%. 2. Allowance for perplexing accounts The valuation account for doubtful accounts is a equalizer sheet account that make outs the inform amount of accounts due. Providing an allowance for doubtful accounts presents a more realistic picture of how much of the accounts receivable leave be turning to cash. If a firm has made a satisfactory provide in its allowance for doubtfu l accounts, reported earnings depart not be penalized by frightful debts when the big(p) debts occur.If uncollectible accounts are larger than expected, however, the firm will confound to increase 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 relate to the increase in the credit they plan to give to the distributors owning to their amplification plans for the period and their repossessy policy. The increase in doubtful accounts is a bad sign for the financial position for the company. 3. dispraise Anoncash expensethat reduces the prizeof anasset as aresultofwear and tear, age, orobsolescence. intimately assets overleap their value over time (in otherwords, they depreciate), and must be replaced at a time the end of their utile lifeis reached. Because it is anon-cash expense, depreciation lowers thecompanysreportedearningswhile increasingfr ee cash flow. Calculated by two methods 1. Straight Line Depreciation mode 2. Declining Balance Depreciation Method pic There has been gradual burn up in the depreciation in the intercommunicate years. This can be related to increase in their number of assets (they are planning to purchase 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 collect within one year. The debt in this account is usually made up of short-term hope loans taken out by a company. The value of this account is very important when determininga companysfinancial wellness. If the account is larger than the companyscash and cash equivalents, this suggests that the companymay bein poor financial health and does not have profuse cash to pay off its short-term debts. Althoughshort-term debts are due within a year, there may be a member of the long-term debt included in this account.This circle pe rtains to earningss that must be made onany long-term debt end-to-end the year. pic In initial years they heavily depended on short term debts. Over the years the financial health of the company meliorate which lead to the reduction in the debts. Owning to their credit policy and increase in investment in unbending assets, the company is not able to recover the property. This could have lead to increase in short term soak upings. 5. Accounts collectible An accounting entry that represents an entitys obligation to payoff a short-term debt toits creditors.The accounts payable entry is found on a proportionateness sheet under the heading current liabilities. Accounts payable are debts that must be remunerative off within a given period of time in ball club to avoid default. pic Increase in accounts payable shows that the company is do more purchases on credit. It could be due to taking more time to pay bills, buying more mathematical mathematical products on credit, payin g high outlays for credit purchases. 6. Other Current Liabilities A oddment sheet entry employ by companies to multitude together current liabilities that are not charge to common liabilities such(prenominal) 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 years. 7. join 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 green goddess to its stockholder members. It is the portion of corporate earnings 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 harboured earnings), or it can be paid to the shareholders as a dividend. numerous corporations retain a portion of their earnings and pay the delayder 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 crocked loading to go along higher direct 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 mate 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 burster of customers who owe money to a person, company or organization for goods and character that have been provided to the customer. In most business entities this is typically done by generating an placard 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 write out to the distributors thus there isnt a pregnant change in the accounts receivable as compared to Ukraine. pic Increases in accounts receivable (Ukraine) that is disproportionate to any fruit in revenue may indicate the company is having get to assemblage 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 baron need to write-off some of these accounts receivable as bad debt, in recognition of the fact that some customers might never pay. In constitutional cases, the company might run out of cash and have to closed(a) down. 12. Increases in inventories chronicle is a list for goods and materials, or those goods and materials themselves, held available in stock by a business. An organizations inventory can break through a mixed 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 asset on an organizations balance sheet because the organization can, in principle, turn it into cash by sell it.Some organizations hold larger inventories than their operations require in order inflating their apparent asset value and their perceived positiveness. pic The fallible distribution system in Ukraine pre-2000 lead to increase in the inventories of the company as company is working on improving the distribution route 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 material 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. impalpable 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-made assets in near future. By 2002 they are planning to buy enough assets just to overcome the negative growth. 14. lessenings 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 succeeder of the company in Ukraine. The sound financial condition of the company has ensured the stable quittance of long term loans and would concern to do so in future. 15. Capital Expenditures Capital intakes (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 e xtends 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. sum uses of cash It is the sum total of all the use components in the fund flow statement. pic throw Even AnalysisThe break-even present for a product is the head word where total revenue received equals the total damages associated with the sale of the product (TR=TC). A break-even point is typically mensurable in order for businesses to coiffe if it would be profitable to sell a proposed product, as fence to attempting to modify an existing product instead so it can be made lucrative. Break even outline can also be used to analyse the potential profitability of an expenditure in a gross revenue-based business. Breakeven analysis is a m anagement accounting tool used for profit planning of a firm.Profit planning is a function of the sell bell of a whole of product, the variable woo of making and selling the product, the chroma of product whole of measurement interchange and in case of multi-product companies, gross revenue mix and finally, the total fixed be. Breakeven point (for rig) = fixed cost / percentage per whole. Break-even analysis is a technique widely used by turnout management and management accountants. It is based on categorising action be between those which are variable (costs that change when the drudgery output changes) and those that are fixed (costs not directly related to the heap of toil).Total variable and fixed costs are compared with gross sales revenue in order to watch thelevel of sales record book, 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 fixe d production costs for a product. 2. The variable production costs for a product. 3. The products whole wrong. 4. The products expected unit sales. On the surface, break-even analysis is a tool to calculate at which sales quite a little the variable and fixed costs of producing your product will be recover.Another way to look at it is that the break-even point is the point at which your product stops costing you money to urinate and sell, and demoralises to generate a profit for your company. Break even analysis solves various 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 watch the price level of product and particular sales batch which is required to produce an X amount of operating profit. Targeting optimal variable/ fixed cost combinations Determining the fi nancial attractiveness of different strategical 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 preceding(prenominal) the breakeven point indicates keep 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 assum es that all the goods which are produced will be sold and that costs, namely the price, will roost 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 gross sales Germany 62032 62653 64219 66216 68203 70249 gross revenue Ukraine 0 4262 17559 25847 37479 48722 Total Net gross revenue 62032 66915 81778 92063 105682 118971 take live & Expenses 32258 35366 44271 49827 61393 71609 Excise duties 9143 9108 10486 11557 11625 13087 Allow ance for doubtful accounts 5 7 38 24 201 60 Total protean Cost 41406 44481 54795 61408 73219 84756 administrative & merchandising Expenses 12481 13014 16274 18505 18500 18500 Depreciation 3609 4314 5844 6068 6766 7448 Total Fixed Cost 16090 ( per hectoliters) Per unit gross revenue 9206300/1173000 = 78. 8508099 Per unit variable cost 61408000/1173000 = 52. 35123615 voice per unit Per unit Sales Per unit variable cost = 26. 3384484 Breakeven efflorescence = 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 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 variabl e 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. coast of safety (volume) = Total volume change 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 = 608 1999. 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 stimulate 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 showing a goodish 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 fictional character Analysis- chief 2 MBA PHARM. TECH. (4th year) pic pic ROLL no. depict ROLL NO. NAME 38 Devang Mehta 41 Upasana Nagpal 39 Anand Menon 42 Abhilash Nair 40 Manish Mishra 43 Kadambari Narang trail 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 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 chart 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. Therefore, 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 cu rrent 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 organization 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 alloca te 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 have 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 mus t 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 helps 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 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, dist ribution 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, i n 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 as contain 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 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 increase in the net income of 28% in 2001 and 17% in 2002.This can be credited to their expansion strategy in th e 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. 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 recov ery 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 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 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 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 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 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 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 m ismatch 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 collecti ng 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 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 asset on an organizations balance sheet becaus e 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 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 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-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 condition of the company has ensured the stable repayment of long term loans and would continue to do so in future. 15. Cap ital 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-even 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 p roduct, 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 i n 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 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 fi rm 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, sal es 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 To tal 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 24573000/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. 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 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