Preview

Bright Paint Case I M Panday

Satisfactory Essays
Open Document
Open Document
347 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Bright Paint Case I M Panday
Bright paint limited
Bright paint limited, situated in Punjab, is a large wholeseller of industrial paints. The company sells paints mostly to small retailer in cities and towns of northern states. About 10 % of sales are made directly to the public on case basis. For meeting its working capital requirement, the company has a cash credit limit from state bank of India. However, it has been recently facing a liquidity problem. In its cash credit amount, the company has an overdraft balance of Rs.24 lakh at the end of march 2009. The managing director of the company is quite concerned about its adverse cash position. He discussed the matter with his finance manager, and asked him to make an assessment of the company’s cash situation for the next 6 months. The finance manager’s staff made the following estimates of revenues and expenditures for the next 6 months:
(Rs. Lakh) | April | May | June | July | Aug. | Sep. | Expected sales | 1000 | 1400 | 1750 | 2180 | 2400 | 2700 | Purchases | 1250 | 1700 | 2000 | 1800 | 1700 | 1700 | Advertising | 170 | 190 | 220 | 250 | 350 | 380 | Rent | 50 | 50 | 50 | 50 | 50 | 50 | Depreciation | 12 | 12 | 12 | 12 | 12 | 12 | Wages | 180 | 180 | 180 | 180 | 190 | 190 | Sundry expenses | 260 | 260 | 260 | 270 | 280 | 280 |

The company has a plan to bye two delivery vans in june for Rs. 8 lakh. It will pay taxes in june and September. The corporate tax rate is 35%. The company sells to retailers on 2 months credit terms. Debtors at end of march are Rs. 500 lakh. The company will make more purchases in the months of april, may and june for high demands in the next 3 months. Suppliers extend 1 month’s credit to the company. At the binning of march, creditors were Rs. 630 lakh.

Discussion Question:- 1. Prepare a case flow forecast for bright paints limited for the six months. What are the benefits of preparing a case flow forecast to the company? 2. What do you think are the problems for the company

You May Also Find These Documents Helpful

  • Better Essays

    Midterm Comm293

    • 5099 Words
    • 21 Pages

    Required: (a) Determine the amount of revenue and gross profit that Brigante would record in each of the four years using the Completed Contract method. (4 marks) (b) Determine the amount of revenue and gross profit that Brigante would record in each of the four years using the Percentage of Completion method. Please round to the nearest million. (10 marks) Part B Costless Ltd. is a nationwide wholesaler who sells directly to consumers through its warehouse stores. While customers generally pay cash at the time of sale for most purchases, Costless sells some of its more expensive items (e.g., televisions) on “layaway”. Under a layaway arrangement, an individual contractually agrees to make a down payment equal to 20% of the purchase price. The customer then pays the remaining 80% two months later.…

    • 5099 Words
    • 21 Pages
    Better Essays
  • Good Essays

    conducted on the topic. The reports mentions and evaluates various aspects, pertaining to the working capital management of the company.…

    • 14851 Words
    • 60 Pages
    Good Essays
  • Good Essays

    Based on our findings, it appears that the company will need to borrow a total of $220,750 from outside sources. The amount of cash borrowed, will then be paid off with any surplus cash that is produced in the following months. Without the repayment within a short period, the cash deficit will most likely increase due to the amount borrowed plus the interest payments on the borrowed funds.…

    • 807 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Case 9

    • 645 Words
    • 3 Pages

    However, the cash account in Horniman Horticulture balance sheet went down dramatically from 2002 to 2005. In 2005, the company only held 9.4 thousand dollar as cash. As a result, it seems that Horniman Horticulture might not have enough cash to pay for operating expenditure and the liquidity risk may be higher. It would affect the operating activities and profitability of the company negatively. Additionally, there was a continuous increase in accounts receivable and receivable days, respectively, from 90.6 to 146.4 thousand dollars and from 41.9 to 50.9 days during these 4 years. That means much money was paid on credit by the consumers. Consequently, it is possible that the investment was relatively inefficient due to the higher accounts receivable and accounts receivable days.…

    • 645 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Coke vs. Pepsi

    • 782 Words
    • 4 Pages

    The two companies are difficult to distinguish as both companies have made investments however the method in which they have made those investments differ. Coke has approximately 45% of its total assets through investments made in the bottling industry. Pepsi has consolidated financial statements taking into account Frito Lay as a subsidiary. It would appear that Pepsi is the larger company because their total amount of assets is greater due to the consolidation of Pepsi and Frito Lay. However this in turn leads to Pepsi carrying significantly more debt in its financial structure compared to Coke ($4,028 vs. $687)…

    • 782 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    In the first year, equity is not given. Therefore, we must calculate equity as a plug variable. Since total liabilities & equity is equal to total assets, equity can be calculated as:…

    • 652 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    The auditor can use this form to document the performance and evaluation of ratio analysis in connection with analytical procedures performed in an audit. The form is only a guide and is not a substitute for professional judgment. The form may be modified by adding or omitting certain ratio analysis.…

    • 517 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Doug Moodie is the president of Garden Products Limited. Over the last 5 years, his vice president of marketing has been providing the sales forecast using his special “focus” forecasting technique. The actual sales for the past ten years and the forecasts from the vice president of marketing are given below.…

    • 1119 Words
    • 5 Pages
    Good Essays
  • Satisfactory Essays

    Adeline Koh Case Summary

    • 770 Words
    • 4 Pages

    Star River’s current ratio from 1998 to 2001 is less than one, which means that total current asset is less than total liabilities. Therefore, Star River has short- term liquidity problem to meet is current liabilities. For the quick ratio, it is even lower which deducted from the inventories which are considered as not easy to liquid, therefore, it can be significantly that Star River has big short- term liquidity problem.…

    • 770 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    Is Management

    • 495 Words
    • 2 Pages

    Brockman Guitar Company is in the business of manufacturing top-quality, steel-string folk guitars. In recent years the company has experienced working capital problems resulting from the procurement of factory equipment, the unanticipated buildup of receivables and inventories, and the payoff of a balloon mortgage on a new manufacturing facility. The founder and president of the company, Barbara Brockman, has attempted to raise cash from various financial institutions, but to no avail because of the company’s poor performance in recent years. In particular, the company’s lead bank, First Financial, is especially concerned about Brockman’s inability to maintain a positive cash position. The commercial loan officer from First Financial told Barbara, “I can’t even consider your request for capital financing unless I see that your company is able to generate positive cash flows from operations.” Thinking about the banker’s comment, Barbara came up with what she believes is a good plan: With a more attractive statement of cash flows, the bank might be willing to provide long-term financing. To “window dress” cash flows, the company can sell its accounts receivables to factors and liquidate its raw materials inventories. These rather costly transactions would generate lots of cash. As the chief accountant for Brockman Guitar, it is your job to tell Barbara what you think of her plan. Answer the following questions.…

    • 495 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    Initial financing required of the company is 4,00,00,000 taka loan to be paid off over five years from Prime Bank Ltd. This debt will cover office space, office equipment, and for supplies two leased vans, advertising and selling cost. The Directors provided 11,00,00,000 taka jointly. So, the total cost of the project estimated at 15,00,00,000 taka.…

    • 4273 Words
    • 18 Pages
    Powerful Essays
  • Powerful Essays

    Abington Hill Toys Essay

    • 933 Words
    • 4 Pages

    After reviewing the financial condition of the firm, it is evident that the firm has been under horrible management over the previous years, and is not worth direct investment. The firm does have the ability to generate growth as evidenced by the return on total assets ratio. However, the firm’s ability to grow is overshadowed by the debt risk the firm is burdened…

    • 933 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    Clarkson Lumber Company

    • 405 Words
    • 2 Pages

    CLC’s current ratio (formula 1) has deteriorated which led to a shortage of funds while still being profitable. The company’s average collection period (formula 2) and debt ratio (formula 3) have increased which also signals problems. CLC buys its inventory in large quantities from the suppliers in order to take advantage of a 2% trade discount but has been unable to receive the discount due to the increasing average collection period and inventory turnover.…

    • 405 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    Cadbury Vrio

    • 840 Words
    • 4 Pages

    The total cash and cash equivalents of the firm stood at around Rs. 271.5 Crores in the year ended March 2009 (before merger with Kraft). Liquidity is important for a business to factor in for unforeseeable events. The ideal cash reserve requirement can be calculated by taking into account and listing possible unfavorable events and assigning probabilities to them.…

    • 840 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    2. Kamal Copies (KC) may buy a high volume machine that sells widgets. The machine costs $100,000 and will be depreciated straight line over five years to a salvage value of $25,000. KC anticipates that the machine can actually be sold in five years for $36,000. The machine will generate sales of $75,000 in year1 and sales will decline by $5,000 a year until year 5. Expenses are 58% of sales. The working capital position in the balance sheet is $10,000 in year 0, $12,000 in year 1, $16,000 in year 2 till the end of year 4. The working capital will be released at the end of the project. The marginal tax rate is 35% and the discount rate is 10%.…

    • 577 Words
    • 2 Pages
    Good Essays