Immediate help | Business & Finance homework help

To shirk any doubt concerning his business' financing deficiencys at the occasion when such deficiencys may start, Cyrus Brown insufficiencys to expand a specie budget for his remotest venture: Cyrus Brown Manufacturing (CBM). He has estimated the aftercited sales meet for CBM aggravate the contiguous 9 months:

March       $100,000
April          $275,000
May           $320,000
June           $450,000
July            $700,000
August       $700,000
September $825,000
October    $500,000
November  $115,000

He has also gathered the aftercited collation estimates concerning the meet sales:

  • Payment collation among the month of sale = 25%
  • Payment collation the month aftercited sales = 55%
  • Payment collation the assist month aftercited sales = 20%

Payments for plain manufacturing costs love raw materials and strive are made during the month that follows the one in which such costs own been incurred. These costs are estimated as follows:

March    $187,500
April      $206,250
May        $375,000
June       $337,500
July              $431,250
August        $640,000
September $395,000
October $425,000

Additional financial notice is as follows:

  • Administrative salaries obtain closely aggregate to $35,000 a month.
  • Lease payments encircling $15,000 a month.
  • Depreciation charges, $15,000 a month.
  • A one-occasion new establish siege in the aggregate of $95,000 is expected to be incurred and compensated in June.
  • Income tax payments estimated to be encircling $55,000 obtain be due in twain June and September.
  • And finally, miscellaneous costs are estimated to be encircling $10,000 a month.
  • Cash on agency on March 1 obtain be encircling $50,000, and a narrowness specie adjust of $50,000 shall be on agency at all occasions.

To assent-to generous confidence on this assignment, fascinate exhibition all fruit, including formulas and calculations used to enter at the financial values.

Group Project Guidelines

  • As a cluster, provide a monthly specie budget for Cyrus Brown Manufacturing for the 9-month date of March through November.
    • Use Excel to provide the monthly specie budget.
  • Based on your specie budget findings, repartee the aftercited questions:
    • Will the association deficiency any without financing?
    • What is the narrowness cord of confidence that CBM obtain deficiency?
    • What do you conceive of CBM's specie aspect during the budget date? Do you see any concerns for the association in this mind?
    • If you were a bank supervisor, would you insufficiency CBM as your client? Why or why not?
  • It is up to the members of the cluster to part-among the assignment tasks evenly. You obtain be graded on cluster participation