Noble Equipment Corp.

Sales (20% collected in month of sale, 80% collected in 1^st month after sale)

Actual 2014:

July 76

August 88

September 266

Projected 2014:

October 125

November 51

December 53

Purchases and COGS (Paid 2^nd month after purchase)

Actual 2014:

July 116

August 122

September 257

Projected:

October 62

November 27

December 26

Salaries & admin, paid monthly = 20

Interest, paid in December = 9

Dividend, paid in December = 15

Depreciation, charged in December = 4

Tax rate = 33%

Debt payment, paid in December = 26

Taxes due in November = 19

Beginning cash October 1^st = 34

Minimum desired cash balance = 15

Using the above financial data and assumptions, construct a monthly cash budget for Noble Equipment Corp. for October 1, 2014-December 31, 2014. Round all answers to the ones place. Enter positive numbers without a sign and negative numbers with a - sign.

Noble Equipment Monthly Cash Budget

October November December

Collection of sales:

During month of sale ___ ___ ___

During 1st month after sale. .. ___ ___ ___

Total cash receipts ___ ___ ___

Cash disbursements:

Payments for purchases . ___ ___ ___

Salaries & admin .. ___ ___ ___

Interest payments . ___

Debt payments ___

Dividends ____

Tax payments ____ .

Total cash disbursements ...

Net cash receipts or disbursements . ___ ___ ___

Cash budget:

Beginning cash .. ___ ___ ___

Net cash receipts or disbursements . . ___ ___ ___

Ending cash ___ ___ ___

Minimum cash desired . ___ ___ ___

Cash surplus or deficit . ___ ___ ____