Solved

On June 30, 2015, Alpha Company's Cash Balance Is $4,000

Question 71

Multiple Choice

On June 30, 2015, Alpha Company's cash balance is $4,000. Alpha is now preparing their cash budget for the third quarter of 2015. The following data is provided:  Jul  Aug  Sep  Beginning cash balance $4,000$8,000$6,958 Plus: Cash collections 50,00040,00048,000 Cash available $54,000$48,000$54,98 Cash payments:  Purchase of inventory 31,00022,00018,000 Operating expenses 12,0009,00011,600 Capital expenditures 13,00025,0000 Less: Total cash payments $56,000$56,000$29,600 Ending cash balance before financing $2,000$8,000$25,358 Minimum cash balance desired 5,0005,0005,000 Cash excess/(deficiency)  $7,000$13,000$20,358 Financing  Borrowing at end of month 10,00015,000 Principal repayments at end of month $20,000 Interest expense at 5% 42104 Totaleffects of financing 10,00014,95820,104 Ending cash balance $8,000$6,958$5,254\begin{array}{l|r|r|r|}\hline & {\text { Jul }} &{\text { Aug }} & {\text { Sep }} \\\hline \text { Beginning cash balance } & \$ 4,000 & \$ 8,000 & \$ 6,958 \\\hline \text { Plus: Cash collections } & \underline{50,000} & \underline{40,000} & \underline{48,000} \\\hline \text { Cash available } & \$ 54,000 & \$ 48,000 & \underline{\$ 54,98} \\\hline \text { Cash payments: } & & & \\\hline \text { Purchase of inventory } & 31,000 & 22,000 & 18,000 \\\hline \text { Operating expenses } & 12,000 & 9,000 & 11,600 \\\hline \text { Capital expenditures } & \underline{13,000} & \underline{25,000} & \underline{0} \\\hline \text { Less: Total cash payments } & \underline{\$ 56,000} & \$ 56,000 & \underline{\$ 29,600} \\\hline \text { Ending cash balance before financing } & -\$ 2,000 & -\$ 8,000 & \$ 25,358 \\\hline \text { Minimum cash balance desired } & \underline{-5,000} & \underline{-5,000} & \underline{-5,000} \\\hline \text { Cash excess/(deficiency) } & -\$ 7,000 & \underline{\$ 13,000} & \$ 20,358 \\\hline \text { Financing } & & & \\\hline \text { Borrowing at end of month } & 10,000 & 15,000 & \\\hline \text { Principal repayments at end of month } & & & -\$ 20,000 \\\hline \text { Interest expense at 5\% } & & -42 & -104 \\\hline \text { Totaleffects of financing } & 10,000 & 14,958 & -20,104 \\\hline \text { Ending cash balance } & \$ 8,000 & \$ 6,958 & \$ 5,254\\\hline\end{array}

The amount of cash that should be shown in the budgeted balance sheet as on September 30th would be:


A) $6,958.
B) $8,000.
C) $5,254.
D) $4,297.

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents