[brian08]

Company A has a $200000 line of credit from its bank. The bank requires the company to keep minimum of $8200 in the checking account at the end of each month, the bank automatically extends line of credit in multiples of $1000 so that the checking account balance is at least $8200 at month end.
When the company borrows, it repay in multiples of $1000 plus 2% monthly interest on entire balance.Interest and principal are paid at the end of the month following the loan. There is currently none outstanding. These Receipts and disbursements apply to the 4th quarter of current calender year:

Estimated beginning balance $8800
Estimated cash sales:
Oct $14000
Nov 29000
Dec 44000
Sales on Account:
Jul (actual) $130000
Aug (actual) 104000
Sep (actual) 128000
Oct (estimate) 135000
Nov (estimate) 142000
Dec (estimate) 188000

Projected cash collection of sales on account is estimated to be 70% in the month following sale, 20% in the 2nd month following sale and 6% in the 3rd month. The 4% beyond the 3rd month is determined to be uncollectible. The company is schedule to receive $13000 cash on a note receivable in Oct.

All inventory purchases are made on account. The following info regarding purchases is available:
Sept (actual) $120000
Oct (estimate) 112000
Nov (estimate) 128000
Dec (estimate) 95000

Cash disbursements for inventory are made in the month following purchase using an average cash discount of 3% for mtimely payment. Monthly cash disbursements for opertaing expenses during Oct, Nov, and Dec are estimated to be $38000, $41000 and $46000 respectively.

1. Prepare cash budget for Oct, Nov and Dec showing all receipts, disbursments and credit line activity.

[pready]

Use your textbook to work this problem yourself, then if you have a specific question we will try to help you.

WE ARE NOT HERE TO DO YOUR WORK FOR YOU!!

[brian08]

This is what I work out for the Cash budget
Receipts April May June Total
Cash Sales 14000 17000 18000 49000
Credit Sales 48000 56000 68000 172000
Total Sales 62000 73000 86000 221000

Payments
Purchases 40650 48300 49350 138300
Wages 7500 7500 7500 22500
Freight 4200 5100 5400 14700
Advertising 6000 6000 6000 18000
Equipment 19750 0 0 19750
Dividend 0 0 4000 4000
Other expenses 2800 3400 3600 9800
Total payments 80900 70300 75850 227050

Summary
Net inflow (outflow) -18900 2700 10150 -6050
Balance b/f 9000 8000 8000
Loan 17900 0 0 17900
Principal 0 -2521 -9996 -12517
Interest 0 -179 -154 -333
Balance c/f 8000 8000 8000 8000

I think I need some help with the budgeted income statement.