Kyle Tamara and Adrienne Unit 5 Individual Project 1.xlsx - Cyrus Brown Manufacturing Company Cash Budget Sales Cash On Hand DMC Admin Salaries Lease

Kyle Tamara and Adrienne Unit 5 Individual Project 1.xlsx -...

This preview shows page 1 - 2 out of 2 pages.

Cyrus Brown Manufacturing Company Cash Bud March April May June July August Sales $100,000 $275,000 $320,000 $450,000 $700,000 $700,000 Cash On Hand $50,000 $50,000 $50,000 $50,000 $50,000 $243,750 DMC $187,500 $206,250 $375,000 $337,500 $431,250 $640,000 Admin Salaries $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 Lease Payments $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 Depreciation $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 Plant Investment 0 0 0 $95,000 0 0 Miscellaneous $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 Cash Surplus (Deficit) ($112,500) $43,750 ($80,000) ($7,500) $243,750 $228,750 1. For the months of March, May, and June CBM will need outside financing. 2. The minimum line of credit required will be $112,500 because that is the largest deficit throughout th 3. The $50,000 that is on hand at all times gives the company the ability to have a small deficit for the fi
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Fall '19
  • months of March, Cyrus Brown Manufacturing Company

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture