Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Foyert Corporation requires a minimum $6,400 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid at the end of each
Foyert Corporation requires a minimum $6,400 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid at the end of each month). Any preliminary cash balance above $6,400 is used to repay loans at month-end. The cash balance on October 1 is $6,400, and the company has an outstanding loan of $2,400. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. Prepare a cash budget for October, November, and December. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar. \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ FOYERT CORPORATION } \\ \hline \multicolumn{5}{|c|}{ Cash Budget } \\ \hline & \multicolumn{2}{|c|}{ October } & \multirow[t]{2}{*}{ November } & \multirow[t]{2}{*}{ December } \\ \hline Beginning cash balance & $ & 6,400 & & \\ \hline & & & & \\ \hline \multicolumn{5}{|l|}{ Total cash available } \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline \multicolumn{5}{|l|}{ Total cash payments } \\ \hline \multicolumn{5}{|l|}{ Preliminary cash balance } \\ \hline \multicolumn{5}{|l|}{ Loan activity } \\ \hline \\ \hline \multicolumn{5}{|l|}{ Ending cash balance } \\ \hline \multicolumn{5}{|c|}{ Loan balance } \\ \hline Loan balance - Beginning of month & $ & 2,400 & & \\ \hline \multicolumn{5}{|l|}{ Additional loan (loan repayment) } \\ \hline Loan balance - End of month & & & & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started