70.2K

Verified Solution

Link Copied!

Debra is a true accountant: she not only likes knowing where every dollar is going, she is obsessed with it$.$ So she is happy to take on the

cash budget for this small company. She wants to go back through the fourth$-$quarter plan with a fine$-$toothed comb before working on

the following calendar year's cash budget. After reviewing many notes from the management team, she has the following information.

Addition information:

Line of credit withdrawals must be made on the first of the month in $$1,000$ increments.

Line of credit payments must be made on the last day of the month in $$1,000$ increments.

$,$ Credit line balance, September $30,$$$2,000.$

Annual loan interest rate, $6\%,$ with monthly interest payments required.

$,$ Minimum monthly cash account balance, $$10,000.$

$,$ Cash balance, September $30,$$$10,500.$

Complete the fourth$-$quarter cash budget for Debra, reporting amounts for each month and for the quarter overall. $($Round

answers to $2$ decimal places, e$.$g$.15\mathrm{.}25.$ Enter negative amounts using either a negative sign preceding the number e$.$g$.-45$ or

parentheses e$.$g$.(45).)$

October

$\backslash$table$[[10500,$$$,11000,$$$,,$$$,],[54200,,56800,,55600,,166600],[64700,,67800,,,,],[51700,,62600,,53600,,167900],[13000,,5200,,,,],[10000,,10000,,,,],[3000,,-4800,,,,],[2000,,0,,5000,,2000],[-2000,,5000,,-2000,,2000],[0,,5000,,3000,,3000],[-10,,25,,,,],[11000,$$$,,$$$,,$$$,]]$

Answer & Explanation Solved by verified expert

See Answer