Foyert Corp. requires a minimum $6,500 cash balance. Loans taken
to meet this requirement cost 2% interest per month (paid monthly).
Any excess cash is used to repay loans at month-end. The cash
balance on October 1 is $6,500 and the company has an outstanding
loan of $2,500. Forecasted cash receipts (other than for loans
received) and forecasted cash payments (other than for loan or
interest payments) follow.
October | November | December | |||||||
Cash receipts | $ | 22,500 | $ | 16,500 | $ | 20,500 | |||
Cash payments | 24,750 | 15,500 | 15,500 | ||||||
Prepare a cash budget for October, November, and December.
(Negative balances and Loan repayment amounts (if any)
should be indicated with minus sign. Round your final answers to
the nearest whole dollar.)
|
FOYERT CORP. | |||
Cash Budget | |||
For October, November, and December | |||
October | November | December | |
Beginning cash balance | $ 6,500 | $ 6,500 | $ 6,500 |
Add: Total Cash Receipts | $ 22,500 | $ 16,500 | $ 20,500 |
Total Cash Available | $ 29,000 | $ 23,000 | $ 27,000 |
Less:Total Cash Payments | $ 24,750 | $ 15,500 | $ 15,500 |
Less: Interest on bank loans | $2,500*2% = $50 | $4,800*2% = $96 | $3,896*2% = 78 |
Preliminary cash balance | $ 4,200 | $ 7,404 | $ 11,422 |
Additional loan (loan repayment) | $ 2,300 | $ (904) | $ (3,896) |
Ending cash balance | $ 6,500 | $ 6,500 | $ 7,526 |
Loan Balance | |||
Loan balance - Beginning of the month | $ 2,500 | $ 4,800 | $ 3,896 |
Additional loan (Loan repayment) | $ 2,300 | $ (904) | $ (3,896) |
Loan balance - End of month | $ 4,800 | $ 3,896 | $ - |
You can reach me over comment box if you have any doubts. Please
rate this answer
Foyert Corp. requires a minimum $6,500 cash balance. Loans taken to meet this requirement cost 2%...
Foyert Corp. requires a minimum $6,300 cash balance. If necessary, loans are taken to meet this requirement at a cost of 2% interest per month (paid monthly). Any excess cash is used to repay loans at month-end. The cash balance on October 1 is $6,300 and the company has an outstanding loan of $2,300. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for loan or interest payments) follow. Cash receipts Cash payments October $22,300...
Foyert Corp. requires a minimum $7,500 cash balance. Loans taken to meet this requirement cost 2% interest per month (paid monthly). Any excess cash is used to repay loans at month-end. The cash balance on October 1 is $7,500 and the company has an outstanding loan of $3,500. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for loan or interest payments) follow. October November December Cash receipts $ 23,500 $ 17,500 $ 21,500 Cash...
oyert Corp. requires a minimum $6,800 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid monthly). Any excess cash is used to repay loans at month-end. The cash balance on October 1 is $6,800 and the company has an outstanding loan of $2,800. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for oan or interest payments) follow. Cash receipts Cash payments October $22,880 25,200 November $16,899 15,899 December $20,800...
7 3 points Foyert Corp. requires a minimum $7.900 cash balance. Loans taken to meet this requirement cost 2% Interest per month (paid monthly. Any excess cash is used to repay loans at month-end. The cash balance on October 1 is $7.900 and the company has an outstanding loan of $3.900. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for loan or interest payments) follow. October November December Cash receipts $23,900 $17,900 $21,900 Cash...
Check my work Foyert Corp. requires a minimum $7.700 cash balance. If necessary, loans are taken to meet this requirement at a cost of 2% interest per month (paid monthly). Any excess cash is used to repay loans at month-end. The cash balance on October 1 is $7.700 and the company has an outstanding loan of $3,700. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for loan or interest payments) follow. Cash receipts Cash...
Karim Corp. requires a minimum $9,300 cash balance. Loans taken to meet this requirement cost 2% interest per month (paid monthly). Any excess cash is used to repay loans at month-end. The cash balance on July 1 is $9,700, and the company has no outstanding loans. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for loan or interest payments) follow. Cash receipts Cash payments July $25,300 29,950 August $33,300 31,300 September $41,300 33,300 Prepare...
Karim Corp. requires a minimum $8,000 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid monthly). Any excess cash is used to repay loans at month-end. The cash balance on July 1 is $8,400, and the company has no outstanding loans. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for loan or interest payments) follow. Cash receipts Cash payments July $20,000 28,000 August $26,000 30,000 September $40,000 22,000 Prepare...
7 Karim Corp. requires a minimum $8.900 cash balance. Loans taken to meet this requirement cost 2% interest per month (paid monthly). Any excess cash is used to repay loans at month-end. The cash balance on July 1 is $9,300, and the company has no outstanding loans. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for loan or interest payments) follow. Cash receipts Cash payments July $ 24,900 29,350 August $32,900 30,9 September $40,900...
Karim Corp. requires a minimum $8,000 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid monthly Any excess cash is used to repay loans at month-end. The cash balance on July 1 is $8,400, and the company has no outstanding loans. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for loan or interest payments) follow August $26,000 30,000 September $40,000 22,000 July $20,000 28,000 Cash receipts Cash payments s0...
Karim Corp. requires a minimum $10,000 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid monthly). Any excess cash is used to repay loans at month-end. The cash balance on July 1 is $10,400, and the company has no outstanding loans. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for loan or interest payments) follow. July August September Cash receipts $ 26,000 $ 34,000 $ 42,000 Cash payments 31,000...