Set$-2-$Exercise $7-13$A $($Static$)$ Preparing a cash budget LO $7-5$

The accountant for Jean's Dress Shop prepared the following cash budget. Jean's desires to maintain a cash balance of $$10,000$ at the end of each month. Funds are assumed to be borrowed and repaid on the last day of each month. Interest is charged at the rate of $1$ percent per month.

Required

a$.$ Complete the cash budget by filling in the missing amounts.

b$.$ Determine the amount of net cash flows from operating activities Jean's will report on the third quarter pro forma statement of cash flows.

c$.$ Determine the amount of net cash flows from financing activities Jean's will report on the third quarter pro forma statement of cash flows.

Required a$.$

Complete the cash budget by filling in the missing amounts.

Note: Any shortages or repayments should be indicated with a minus sign. Round your answers to the nearest whole dollar amount.

$\backslash$table$[[$Co the nearest whole dollar amount.,July,August,September$],[$Section $1$: Cash receipts,,,$],[$Beginning cash balance,$$25,000,,],[$Add cash receipts,$90,000,100,000,120,300],[$Total cash available,$115,000,,],[$Section $2$: Cash payments,,,$],[$For inventory purchases,$82,750,70,115,87,076],[$For S&A expenses,$27,250,30,280,30,716],[$For interest expense,$0,,],[$Total budgeted disbursements,$110,000,,],[$Section $3$: Financing activities,,,$],[$Surplus $($shortage$),5,000,,],[$Borrowing $($repayments$),5,000,,],[$Ending cash balance,$$10,000,$$$10,000,$$$10,00$

How to calculate interest expense