Explore BrainMass

Explore BrainMass

    Estimate of the Required Financing

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    With the given calculation as follows what is the estimate of required financing needs for each month during the budget period and how much if any will the company need outside financing base on this assumption?
    Month Sales Collections Costs incurred Payments(raw material) Administrative+lease Depreciation One time investment Income Tx Misc Exp Cash on Hand at month end Min Reqd Financing Reqd Cash on Hand
    March $250,000.00 $25,000.00 $187,500.00 $- $50,000.00 $15,000.00 $10,000.00 ($35,000.00) 50,000 $85,000.00 $50,000.00
    April $276,000.00 $215,100.00 $206,250.00 $187,500.00 $50,000.00 $15,000.00 $10,000.00 ($32,400.00) 50,000 $82,400.00 $50,000.00
    May $320,000.00 $276,500.00 $240,000.00 $206,250.00 $50,000.00 $15,000.00 $10,000.00 $50,000.00 50,000 $- $50,000.00
    June $450,000.00 $326,400.00 $337,500.00 $240,000.00 $50,000.00 $15,000.00 $95,000.00 $55,000.00 $10,000.00 ($73,600.00) 50,000 $123,600.00 $50,000.00
    July $575,000.00 $443,000.00 $431,250.00 $337,500.00 $50,000.00 $15,000.00 $10,000.00 $95,500.00 50,000 $- $95,500.00
    August $700,000.00 $568,750.00 $525,000.00 $431,250.00 $50,000.00 $15,000.00 $10,000.00 $77,500.00 50,000 $- $77,500.00
    September $825,000.00 $693,750.00 $618,750.00 $525,000.00 $50,000.00 $15,000.00 $55,000.00 $10,000.00 $53,750.00 50,000 $- $53,750.00
    October $350,000.00 $758,750.00 $262,500.00 $618,750.00 $50,000.00 $15,000.00 $10,000.00 $80,000.00 50,000 $- $80,000.00
    November $285,000.00 $414,750.00 $262,500.00 $50,000.00 $15,000.00 $10,000.00 $92,250.00 50,000 $- $92,250.00

    Note : only the highlighted portion is asked.
    Cash on hand on May 1 is given as 50,000
    Depreciation is an expense only on paper, it is not a cash flow. So it is not included in the calculations.

    © BrainMass Inc. brainmass.com February 24, 2021, 2:23 pm ad1c9bdddf
    https://brainmass.com/business/finance/estimate-required-financing-18005
    $2.19

    ADVERTISEMENT