Please post answer in excel with the formulas.

Budget& Cash Presented are partial October, November, and December cash budgets for Holiday Events: Short-Term Financing HOLIDAY EVENTS Partial Cash Budgets For the Months of October, November, and December October November December Total 35,000 40,000 80,000 ? (50,000) (60,000) (40,000) ? Ending cash before borrowings or replacements 2 New loans. . . . 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. Purchases and Cash Budgets On Jul y l , MTC Wholesalers had a cash balance of $ 175,000 and accounts payable of $99,000. Actual or May and June, and budgeted sales for July, August, September, and October are