can someone explain and give me the right answer
Motors Corporation manufactures motors for dirt bikes. The company requires a minimum $30,000 cash balance at each month-end. If necessary, the company borrows to meet this requirement at a cost of 3% interest per month (paid at the end o each month). Any preliminary cash balance above $30,000 at month-end is used to repay loans. The cash balance on July 1 $25,000, and the company has no outstanding loans. Budgeted cash receipts and budgeted cash payments (other than for interest on the loan and loan activity) follow. Prepare a cash budget for July, August, and September. Note: Negative balances and Loan repayment amounts (if any) should be indicate / with minus sign. Round your final answers to the nearest whole dollar. \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{ MOTORS CORPORATION } \\ \hline \multicolumn{4}{|c|}{ Cash Budget } \\ \hline & July & August & September \\ \hline Beginning cash balance & $25,000 & $30,000 & 30,000 \\ \hline Add: Cash receipts & 76,000 & 102,000 & 141,000 \\ \hline Total cash available & 101,000 & 132,000 & 171,000 \\ \hline \multicolumn{4}{|l|}{ Less: Cash payments for } \\ \hline Interest on loan & 00 & 990 & 6870 \\ \hline All items excluding interest & 104,000 & 90,900 & 118,400 \\ \hline Total cash payments & 104,000 & 91,890 & 119,087 \\ \hline Preliminary cash balance & (3,000) & 40,110 & 51,913 \\ \hline Additional loan (loan repayment) & 33,000 & (10,110) & (21,913) \\ \hline Ending cash balance & $30,000 & $30,000 & 30,000 \\ \hline \multicolumn{4}{|l|}{ Loan activity } \\ \hline Loan balance, beginning of Month & 02 & $33,000 & 22,890 \\ \hline Additional loan (loan repayment) & 33,000 & (10,110) & (21,913) \\ \hline Loan balance, end of month & $33,000 & $22,890 & 977 \\ \hline \end{tabular} Motors Corporation manufactures motors for dirt bikes. The company requires a minimum $30,000 cash balance at each month-end. If necessary, the company borrows to meet this requirement at a cost of 3% interest per month (paid at the end o each month). Any preliminary cash balance above $30,000 at month-end is used to repay loans. The cash balance on July 1 $25,000, and the company has no outstanding loans. Budgeted cash receipts and budgeted cash payments (other than for interest on the loan and loan activity) follow. Prepare a cash budget for July, August, and September. Note: Negative balances and Loan repayment amounts (if any) should be indicate / with minus sign. Round your final answers to the nearest whole dollar