Preview

Hampton Machine Tool Case

Best Essays
Open Document
Open Document
498 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Hampton Machine Tool Case
CASH BUDGET for HAMPTON MACHINE TOOL(000 $) CURRENT September October November December Receipts: A/R Collection(assumes 30-day;Oct& Nov. less advances of $840 and $726, respectively) Bank Loan Total Cash Inflow Expenditures: A/P Payment(paid in 30 days) Other Op. Outlays CAPITAL EXPENDITURE Taxes Interest Loan Principal Dividends Total Cash Outflow Beginning Cash Net Monthly Cash Flow ENDING CASH 684.000 2243.000 1323.000 2022.000 779.000 350.000 2136.000 1604.000 2369.750

January

Sales -Advances 2265.000 Entire Credit 1933.500 sales for November
600.000 400.000

948.000 400.000 181.000 15.000

600.000 400.000

600.000 400.000 350.000 20.250

600.000 400.000 181.000 20.250 1350.000 150.000 2701.250 765.750 -331.500

15.000
…show more content…
CASH BUDGET for HAMPTON MACHINE TOOL(000 $) Early Repayment without divid September October Receipts: A/R Collection(assumes 30-day;Oct& Nov. less advances of $840 and $726, respectively) Bank Loan Total Cash Inflow Expenditures: A/P Payment(paid in 30 days) Other Op. Outlays CAPITAL EXPENDITURE Taxes Interest Loan Principal Dividends Total Cash Outflow Beginning Cash Net Monthly Cash Flow ENDING CASH

684.000 2243.000

1323.000 1822.000

948.000 400.000 181.000 15.000 200.000 1744.000 1559.000 499.000

600.000 400.000

12.000 100.000 1112.000 499.000 710.000

$) Early Repayment without dividends November December

January

779.000 350.000 1839.000

1604.000 2077.250

2265.000 2095.500

Sales Advances Entire Credit sales for November

600.000 400.000 350.000

You May Also Find These Documents Helpful

  • Satisfactory Essays

    2. $5000 in equipment is received, with $1000 paid in cash, and $4000 billed through Accounts Payable…

    • 683 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Acct 505 Week 1

    • 966 Words
    • 4 Pages

    Accumulated depreciation of equipment: Ending balance based on tax as at 31 December 2011 was $25,000.…

    • 966 Words
    • 4 Pages
    Satisfactory Essays
  • Powerful Essays

    Ac505 Course Project a

    • 3135 Words
    • 13 Pages

    The beginning cash balance for April, is the cash from March 31 in the Asset section of the balance sheet. In the merchandise purchases budget, in April, we need 50% of March purchases (that amount is also given to us 3/31 Accounts payable of $100,000 on page 415). Therefore, Total cash disbursements for April is (50% x $316,000 April purchases) + ($100,000 remaining March purchases to be paid) = $258,000.…

    • 3135 Words
    • 13 Pages
    Powerful Essays
  • Satisfactory Essays

    7/31 5,400 07/20 2,000 Common Stock 07/31 290 07/01 12,000 07/31 600 Bal. 7/31 12,000 Bal. 7/31 5,410 Equipment Accounts Receivable…

    • 446 Words
    • 24 Pages
    Satisfactory Essays
  • Good Essays

    Course Projectb Acct. 505

    • 636 Words
    • 3 Pages

    ACCT505 Part B Capital Budgeting problem Data: Cost of new equipment Expected life of equipment in years Disposal value in 5 years Life production - number of cans Annual production or purchase needs Initial training costs Number of workers needed Annual hours to be worked per employee Earnings per hour for employees Annual health benefits per employee Other annual benefits per employee-% of wages Cost of raw materials per can Other variable production costs per can Costs to purchase cans - per can Required rate of return Tax rate…

    • 636 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Available for Use | 33,000.00 | | | Ending Direct Materials Inventory | 2,000.00 | | | Direct Materials Used | | 31,000.00 | | Direct Labor | | 22,000.00 | | Manufacturing Overhead: | | | | Indirect Materials | 1,700.00 | | | Indirect Labor | 800.00 | | | Depreciation – Plant and Equipment | - | | | Plant Utilities, Insurance, and Property Taxes | 1,600.00 | | | Total Manufacturing Overhead | | 4,100.00 | | Total Manufacturing Costs Incurred During the Year | | | 57,100.00 | Total Manufacturing Costs to Account For | | | 70,500.00 |…

    • 687 Words
    • 3 Pages
    Powerful Essays
  • Better Essays

    Waltham Motors Case

    • 863 Words
    • 4 Pages

    1. Using budget data, how many motors would have to be sold for Waltham Motors Division to break even?…

    • 863 Words
    • 4 Pages
    Better Essays
  • Satisfactory Essays

    Acct 505 Project A

    • 281 Words
    • 2 Pages

    $650,000 $1,000,000 $500,000 $2,150,000 b. Schedule of expected cash collections: February sales (10%)... $ 26,000 $ 26,000 March sales (70%, 10%) ............. 280,000 $ 40,000 320,000 April sales (20%, 70%, 10%) .... 130,000 455,000 $ 65,000 650,000 May sales (20%, 70%) ............. 200,000 700,000 900,000 June sales (20%) ......... 100,000 100,000…

    • 281 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    E3-2

    • 717 Words
    • 3 Pages

    Week 2 Geronimo CompanyTrial BalanceApril 30, 2012 | | Debit | Credit | Cash | $2,100 | | Accounts Receivable | 2,750 | | Prepaid Insurance | 1,700 | | Equipment | 8,000 | | Accounts Payable | | $ 3,500 | Property Tax Payable | | 560 | Geronimo, Capital | | 11,200 | Service Revenue | | 6,690 | Salaries Expense | 4,200 | | Advertising Expense | 1,400 | | Property Tax Expense | 1,800 | | | $ 21,950 | $ 21,950 | E3-2 P3-4 (a) Nov. 30 Store Supplies Expense………………1,500 Store Supplies………………… 1,500 30 Depr.…

    • 717 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Chester & Wayne

    • 987 Words
    • 4 Pages

    The company will acquire equipment costing $250,000 cash in November. Dividends of $45,000 will be paid in…

    • 987 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Week 5 Acct 420

    • 886 Words
    • 4 Pages

    EQUIPMENT & FURNITURE 12600 CASH 5000 CONTRIBUTIONS—UNRESTRICTED 7600 SOLVE GENERAL JOURNAL Debits Credits 6. TELEPHONE EXPENSE 5200 PRINTING & POSTAGE EXPENSE 12000 SUPPLIES EXPENSE 2100 CASH 15700 ACCOUNTS PAYABLE 3600 7. NO TRANSACTION IS RECORDED – NO SPECIALIZED SKILL IS REQUIRED. 8.…

    • 886 Words
    • 4 Pages
    Satisfactory Essays
  • Powerful Essays

    Comprehensive QB Problem

    • 339 Words
    • 5 Pages

    Bill date Vendor Pay Amount 11-17-2017 Hamby Distributors 2,465.00 (apply credit if available) 10-17-2017 Larson Peripherals 2,063.00 (apply credit if available) 12-15-2017 Larson Peripherals 3,000 (billed for 4,545.00) (apply credit if available) 12-15-2017 Lucchini Computers 840.00 4. Record Receipts from the following Customers Receipt Date Customer Amount Method Invoice 12-18-2017 Jones Law Office $8,000.00 Check 41893 2007-108 (full amount) 2007-113 (the rest here) 12-19-2017 Smith, Lee $400.00 Cash 2007-1041 5. Record the following Deposits on the December 20, 2017 Name Amounts Oliveri, Tom $3,078.28 Jones Law Office $8,000.00 Smith, Lee $400.00 6.…

    • 339 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    Elis Printing Case

    • 492 Words
    • 2 Pages

    International Accounting Prof. William Hancock Ellis printing Case Ellis printing Case 1. Prepare Ellis printing Company’s cash budget for the 1st half of 2007 | | | Jan-07 | Feb-07 | Mar-07 | Apr-07 | May-07 | Jun-07 | I. Cash Input | | | | | | | | | Receipt, 1% discount, Month (1st -20th ) | 6,600 | 9,240 | 11,220 | 13,200 | 9,240 | 6,600 | | Receipt, 1% discount, Month+1 (21st - 30th ) | 2,640 | 3,300 | 4,620 | 5,610 | 6,600 | 4,620 | | Receipt, Month+30days | 28,000 | 35,000 | 49,000 | 59,500 | 70,000 | 49,000 | | | Receipt, Month+60days | 2,500 | 4,000 | 5,000 | 7,000 | 8,500 | 10,000 | | | Total Cash Input | | 39,740 | 51,540 | 69,840 | 85,310 | 94,340 | 70,220 | | | | | | | | | | | | II. Cash Output | | | | | | | | | material(10% of M+2 sales) | 8,500 | 10,000 | 7,000 | 5,000 | 2,500 | 2,000 | | | material(10% of M+1 sales) | 7,000 | 8,500 | 10,000 | 7,000 | 5,000 | 2,500 | | | labor(20% of M+2 sales) | 17,000 | 20,000 | 14,000 | 10,000 | 5,000 | 4,000 | | | labor(20% of M+1 sales) | 14,000 | 17,000 | 20,000 | 14,000 | 10,000 | 5,000 | | | G&A expenses | | 8,000 | 8,000 | 8,000 | 8,000 | 8,000 | 8,000 | | | Lease fee | | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | | | Miscellaneous expense | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | | | Interest expense paid | 5,000 | | | | | | | | Purchasing a machine | | | | | | 50,000 | | | Tax | | | | | 75,000 | | 75,000 | | | Total Cash Output | 65,000 | 69,000 | 64,500 | 124,500 | 36,000 | 152,000 | | | | | | | | | | | | III.…

    • 492 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    The beginning balance of cash is $45,000. What is the budgeted ending balance of cash?…

    • 1099 Words
    • 5 Pages
    Good Essays
  • Better Essays

    Collaborative

    • 736 Words
    • 3 Pages

    The project will cost $921,885.71 and the most expensive activity is the equipment rehab at $254,400. The cash flow statement tells me that the costs were not distributed very evenly over the life span of the project.…

    • 736 Words
    • 3 Pages
    Better Essays