Eskimo Pie Case

Satisfactory Essays
Mazen Saeed AlGhamdi 200736930
The company have also poorly forecasted sales from January to August ($11.9) with actual sales amounting to $8.7m. The company wants to borrow more money because it wants to buy new machinery at a cost of $350k and this is due to no machinery being replaced because of the economic downturn.
The company purchased $420k worth of raw materials, which it will use by the end of the year. There was a substantial backlog of orders amounting to $16.5m on 31st August. There was a missing piece of electronic equipment to finish some machines valued at $1,320,000, which was due to arrive and then the orders can be finished. The company needs to stay cash positive on a daily basis in order to finance its operations and business expansion. Based on the information in the case, prepare a projected cash budget for the four months September through December 1979, a projected income statement for the same period, and a pro forma balance sheet as of December 31, 1979.
See attached excel spreadsheet below.

| | | | | | | | | | | | Pro Forma Statements | | | | | | | | (thousands of dollars) | | | | | | | | | | | | Pro Forma | | June | July | Aug. | Sept. | Oct. | Nov. | Dec. | Net sales | $1,620 | $723 | $507 | $2,163 | $1,505 | $1,604 | $2,265 | Purchases | | | | $600 | $600 | $600 | $600 | WIP inventory reduction | | | | $1,320 | $0 | $0 | $0 | Raw materials reduction | | | | $105 | $105 | $105 | $105 | Cost of goods sold | | | | $2,025 | $705 | $705 | $705 | Depreciation | | | | $10 | $10 | $14 | $14 | Other expenses | | | | $400 | $400 | $400 | $400 | Cost of sales and other expenses | $1,327 | $597 | $342 | $2,435 | $1,115 | $1,119 | $1,119 | EBIT | $293 | $126 | $165 | -$272 | $390 | $486 | $1,147 | Interest expense | $15 | $15 | $15 | $15 | $15 | $20 | $20 | Net income before taxes | $278 | $111 | $150 | -$287 | $375 | $466 |

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Hampton Case study

    • 736 Words
    • 2 Pages

    The cash budgets and statement of sources and uses yield negative results concerning the principal payment of the loan for December, based on Mr. Cowins’ plan. This analysis is based on projected sales, dividend payments and tax payments. Consequently, the sales projects and accounts receivables are 30 days net; if not paid on time, then this could change the results significantly by putting the company in more of a financial bind. Based on our forecasts it seems that Mr. Cowins is incorrect about being able to repay the loan in December, but Hampton should be able to repay in January with more precise planning.…

    • 736 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Riley Supply Case

    • 426 Words
    • 2 Pages

    Yet, despite the fact that profits were also growing, the company experienced continued cash flow problems. As a result, Riley finds that an increasing amount of his time is being devoted to dealing with the cash flow problems. The company has normally relied on bank loan financing secured by accounts receivable and inventory. However, in 2006 the company was unable to reduce its bank loan during the seasonal slowdown period. Furthermore, the company's manufacturer suppliers were becoming unhappy. Some had even started to demand payment on delivery rather than offer the 2/10, n/30 terms standard in both the manufacturer and wholesaler markets. Riley is not sure what he should do. He expects that 2007 sales will be 30% higher than the prior year and that there will be continued strength in sales in the following years. Furthermore, his co-investor is becoming increasingly bothersome so Riley would like to buy back the 40% ownership in the company that he does not now control.…

    • 426 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    On the basis of the following data for Seller Co. for 2008 and the preceding year ended December 31, 2007, prepare a statement of cash flows. Use the indirect method of reporting cash flows from operating activities. Assume that equipment costing $125,000 was purchased for cash and equipment costing $85,000 with accumulated depreciation of $65,000 was sold for $15,000; that the stock was issued for cash; and that the only entries in the retained earnings account were net income of $51,000 and cash dividends declared of $13,000.…

    • 618 Words
    • 6 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Case 9-30 Partial Answer

    • 376 Words
    • 2 Pages

    65,000 100,000 50,000 $10 $650,000 Correct! Requirement 1b. Schedule of expected cash collections: February sales $26,000 March sales 280,000 April sales 130,000 May sales June sales Total cash collections $436,000 Correct! Requirement 1c. Merchandise purchases budget: Budgeted unit sales 65,000 100,000 Add desired ending inventory 40,000 Total needs 105,000 Less beginning inventory 26,000 Required purchases in units 79,000 Unit cost $4 Required dollar purchases $316,000 Correct! Requirement 1d. Budgeted cash disbursements for merchandise purchases: Accounts payable 100,000 April purchases 158,000 158,000 May purchases June purchases Total cash disbursements $258,000 Correct!…

    • 376 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Uhura Company

    • 798 Words
    • 4 Pages

    InstructionsPrepare a revised balance sheet given the available information. Assume that the accumulated depreciation balance for the buildings is $160,000 and for the office equipment, $105,000. The allowance for doubtful accounts has a balance of $17,000. The pension obligation is considered a long-term liability.…

    • 798 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    The final problem, difficulty in predicting cash flow costs, should be resolved by asking your sale assistants, doing market research or asking an experienced accountant for guidance. You should ask your sale assistants because they are the people on the ground floor and know what’s going on, what the customers like and what products fly off the shelf. They have first hand knowledge on the company as they process the day to day dealings whereas a manager might not always be around. Doing market research will help to find the average prices of all products or services such as insurance, this will ensure you will get the best quote and avoid under predicting the costs for that month. Just to be certain, you can then go and ask an accountant for guidance as…

    • 1287 Words
    • 6 Pages
    Good Essays
  • Better Essays

    expenses the company expects to pay out over the same time frame. The issues surrounding budgetary…

    • 904 Words
    • 5 Pages
    Better Essays
  • Satisfactory Essays

    Eskimo Pie

    • 835 Words
    • 4 Pages

    1. What is your estimate of the value of Eskimo Pie Corporation as a stand alone company?…

    • 835 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    Required 1. Prepare each of the following for June: a. Revenues budget b. Production budget in units c. Direct material usage budget and direct material purchases budget in both units and dollars; round to dollars d. Direct manufacturing labor cost budget e. Manufacturing overhead cost budgets for processing and setup activities f. Budgeted unit cost of ending finished goods inventory and ending inventories budget g. Cost of goods sold budget h. Marketing and general administration costs budget 2. Borkenstick’s balance sheet for May 31 follows. Use it and the following information to prepare a cash budget for Borkenstick for June. Round to dollars. All sales are on account; 60% are collected in the month of the sale, 38% are collected the following month, and 2% are never collected and written off as bad debts. All purchases of materials are on account. Borkenstick pays for 80% of purchases in the month of purchase and 20% in the following month. All other costs are paid in the month incurred, including the declaration and payment of a $10,000 cash dividend in June. Borkenstick is making monthly interest payments…

    • 1389 Words
    • 6 Pages
    Good Essays
  • Satisfactory Essays

    Preparing a Master Budget

    • 692 Words
    • 3 Pages

    The policy is to acquire enough inventory each month to equal the following month’s projected cost of goods sold. All purchases are paid for in the month following purchase. Salaries, wages, and commissions average 20% of sales; all other variable expenses are 4% of sales. Fixed expenses for rent, property taxes, and miscellaneous payroll and other items are $55,000 monthly. Assume that these variable and fixed expenses require cash disbursements each month. Depreciation is $2,500 monthly. In June, $55,000 is going to be disbursed for fixtures acquired and recorded in furniture and fixtures in May. The May 31 balance of accounts…

    • 692 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    Financial Ratios

    • 7027 Words
    • 29 Pages

    Each student, as a member of a group, is required to complete the Financial Reporting Problem. You may self-select your group for this assignment; groups may have no more than four (4) members. Each group will submit one project, but each group member is responsible for the quality of the work submitted. You may work only with your group members on this assignment. The use of projects from prior semesters or other sources and consultation with third parties, other than the instructor of this course, are not permitted.…

    • 7027 Words
    • 29 Pages
    Powerful Essays
  • Powerful Essays

    Short Term 531 Week 1 Quiz

    • 2106 Words
    • 9 Pages

    No cash accounting transactions are ignored.\ Which of the following is an Assumption of financial statements? Perodicity, Going Concern, Accrual Basis\ principle dictates that companies record assets at their historical cost principle dictates that companies record assets at their historical cost\ The materiality constraint Relates to a financial statement item's impact on a company's overall financial condition and operations. Size is a big factor.\ Revenues - COGS - Admin Expense = Earnings\ Cash + Inventory + A/R = Current Assets\ Accounts Payable + Short term N/P = Current Liabilities\ Working Capital = current assets – current liabilities\ Net Operating Working Capital = Current assets - Current liabilities - Notes Payable\ Net Operating Working Capital takes into consideration the interest bearing loans. Notes paying interest also have an impact on the financial statements and company performance because of the interest costs. NOWC show what would be leftover to operating with if these loans were paid.\ Earnings…

    • 2106 Words
    • 9 Pages
    Powerful Essays
  • Satisfactory Essays

    Butler Lumber Case

    • 359 Words
    • 2 Pages

    2.I do agree with Butler’s estimate of the loan amount in order to expand his business and eliminate his trade debt. He might not need to borrow $465,000 just for this quarter. When considering the majority of his revenue is from the second and third quarters the extra money would be used in the first and last quarters of the year.…

    • 359 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Adms2510

    • 1797 Words
    • 8 Pages

    C. Calculate the balances for the three accounts: Cost of Goods Sold, Work-in-Process Inventory at 31st October 2011 and Finished Goods inventory at 31st October 2011. (Use the chart below to summarize your totals.) (3 marks)…

    • 1797 Words
    • 8 Pages
    Good Essays
  • Good Essays

    Gögn

    • 943 Words
    • 4 Pages

    The Board of Dumbellow Ltd are meeting on the 23rd January to discuss the draft budget for 2000/1, some two months before the start of that year. The company produces three industrial valves which are incorporated into equipment used in the Oil and Gas industry. The draft income statement is as follows: Product X £k Sales 100k units at £15 80k units at £25 120k units at £10 Materials Labour Overheads Profit/(Loss) 300 700 225 1225 275 400 800 360 1560 440 1500 2000 1200 480 750 330 1560 (360) 4700 1180 2250 915 4345 355 Product Y £k Product Z £k Total £k…

    • 943 Words
    • 4 Pages
    Good Essays