Question

Question 1 2 pts Crane Company is preparing a cash summary budget using the data below. They have already prepared their cash receipts and cash payments budget so that data is provided: October November Beginning Cash Balance $16000 Expected Cash Receipts $63000 $95000 Expected Cash Payments $45000 $76000 Management always wants to maintain a $39,343 minimum cash balance at the end of every month. If there is an expected cash shortfall in the budget they will be proactive and borrow money at the first day of the month. That way they will not risk having too of a balance during the month. They can borrow any amount of money needed. They may not pay loans back in installments. They have to pay them back all at once. The interest rate is 12%. Assume if they pay back money, they pay it back on the last day of the month. What is the ending cash balance for November after all loan repayments of principle and interest? Round your answer to the nearest whole dollar.

Answer 1

4soco computation of Ending cash balance for november october ($) November in $). Opening Cash $ 1600 39343 t receipts 63000 asoo Total Cash available 79000 134343 - Cash payments 76000 o interest payment (5343 X127.X2) surplus (shortages) $34000 $582314 76000 Financing actrities Boooowings (39343-34000) 5343 Repayments (5343) Ending cash balance $39.343 $ $2893.14 106.86 29004500), They 134343- ... Ending cash balance for November = $52,893.14