Calculate the ending balance for the month of May. The desired minimum required cash balance is...

Transcribed Image Text:

Calculate the ending balance for the month of May. The desired minimum required cash balance is $75,000. Balance at the begining of January is $80,000. (Just write the numbers. Do not use any punctuation marks or $ sign) March April May Cash Budget Total cash receipts Total cash payments Net cash flow $235,600 $270,800 $305,200 246,000 268,000 295,300 -10,400 2,800 9,900 Beginning cash balance 80,000 75,000 75,000 Cumulative cash balance 69,600 77,800 84,900 Monthly loan or (repayment) 5,400 -2,800 Cumulative loan balance 5,400 2,600 Ending cash balance $75,000 $75,000 $ ? Numeric Response Calculate the ending balance for the month of May. The desired minimum required cash balance is $75,000. Balance at the begining of January is $80,000. (Just write the numbers. Do not use any punctuation marks or $ sign) March April May Cash Budget Total cash receipts Total cash payments Net cash flow $235,600 $270,800 $305,200 246,000 268,000 295,300 -10,400 2,800 9,900 Beginning cash balance 80,000 75,000 75,000 Cumulative cash balance 69,600 77,800 84,900 Monthly loan or (repayment) 5,400 -2,800 Cumulative loan balance 5,400 2,600 Ending cash balance $75,000 $75,000 $ ? Numeric Response