E9-27. Cash Budget & Short-Term Financing

Presented are partial October, November, and December cash budgets for Holiday Events:

PLEASE SHOW YOUR WORK IN EXCEL WITH THE FORMULAS SHOWING.

Cash Budget & Short-Term Financing Presented are partial October, November, and December cash budgets for Holiday Events: 0.27, E9-27 HOLIDAY EVENTS Partial Cash Budgets For the Months of October, November, and December October November December Total ons . (50,000) (60,000) (40,000) ? Ending cash before borrowings or replacements Repayments.. Loans are obtained in increments of $1,000 at the start of each month to maintain a minimum end- of-month balance of $12,000. Interest is one percent simple interest (no compounding) per month, payable when the loan is repaid. Repayments are made as soon as possible, subject to the minimum end-of-month balance. Required Complete the short-term financing section of the cash budget