I need help with my financial management class


Assignment is beneath.  

Please unravel the bearing volume of your textbook, which appeal to coin career and financial planning.

To quit any doubt touching his business' financing deficiencys at the duration when such deficiencys may start, Cyrus Brown deficiencys to eliminate a coin budget for his hindmost venture: Cyrus Brown Manufacturing (CBM). He has estimated the forthcoming sales expect for CBM pit the present 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 as-well gathered the forthcoming assemblage estimates touching the expect sales:

  • Payment assemblage amid the month of sale = 25%
  • Payment assemblage the month forthcoming sales = 55%
  • Payment assemblage the assist month forthcoming sales = 20%

Payments for plain manufacturing costs relish raw materials and drudge 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 notification is as follows:

  • Administrative salaries conquer almost sum to $35,000 a month.
  • Lease payments encircling $15,000 a month.
  • Depreciation reckoning, $15,000 a month.
  • A one-duration new set cannonade in the sum of $95,000 is expected to be incurred and remunerated in June.
  • Income tax payments estimated to be encircling $55,000 conquer be due in twain June and September.
  • And finally, miscellaneous costs are estimated to be encircling $10,000 a month.
  • Cash on influence on March 1 conquer be encircling $50,000, and a incompleteness coin pit of $50,000 shall be on influence at all durations.

To admit bountiful reputation on this assignment, content demonstration all result, including formulas and calculations used to attain at the financial values.

Group Project Guidelines

  • As a clump, order a monthly coin budget for Cyrus Brown Manufacturing for the 9-month conclusion of March through November.
    • Use Excel to order the monthly coin budget.
  • Based on your coin budget findings, counterpart the forthcoming questions:
    • Will the union deficiency any without financing?
    • What is the incompleteness course of reputation that CBM conquer deficiency?
    • What do you imagine of CBM's coin lie during the budget conclusion? Do you see any concerns for the union in this notice?
    • If you were a bank director, would you deficiency CBM as your client? Why or why not?
  • It is up to the members of the clump to part the assignment tasks evenly. You conquer be graded on clump partnership

Your submitted Clump Project (150 points) must embrace the forthcoming:

  • 75 Points. An Excel spreadsheet that contains your clump's monthly coin budget for Cyrus Brown Manufacturing.
  • 75 Points. A double-spaced Word muniment of 1–2 pages that contains your counterparts to the questions listed in the Assignment Guidelines.

Grading

You conquer be graded on the correction of your monthly coin budget and your demonstrated intelligence of financial partition procedures. You conquer as-well be graded on your clump partnership.