Question
I need help solving for December borrowing repayment based off the information to the side. Haas borrows funds, in increments of $1,000, and repays them
I need help solving for December borrowing repayment based off the information to the side. Haas borrows funds, in increments of $1,000, and repays them on the last day of the month. Repayments may be made in any amount available. The company also pays its vendors on the last day of the month. It pays interest of 1 percent per month in cash on the last day of the month. To be prudent, the company desires to maintain a $12,000 cash cushion. Prepare a cash budget. My beginning cash balance is October -0 November -70,660 & December 156,660. Plus cash receipts of October 100,000 November 258,000, December 278,640. Leaving with cash available of October-100,000, November 328,660, December 435, 240. Less my payments giving me a total budget payment October 251,240, November 123,087, December 124,612. This leaves me with a surplus shortage of October -151,340, November 205,573 December 310,628. If my borrowing repayment for October is 222,000, November -48,973 what would my December's be?? **All of the answers have been confirmed they are correct.
g. Haas borrows funds, in increments of $1,000, and repays them on the last day of the month Repayments may be made in any amount available. The company also pays its vendors on the last day of the month. It pays interest of 1 percent per month in cash on the last day of the month. To be prudent, the company desires to maintain a $12,000 cash cushion. Prepare a cash budget. (Any repayments/shortage which should be indicated with a minus sign. Round your answers to nearest whole dollar amount.) Cash Budget October Novomber December 70,660 $ 156,600 278,640 435,240 Beginning cash balance lus: Cash receipts Cash available Less. Payments 258,000 328,660 100,000 100,000 167,614 For inventory purchases For selling and administrative expenses Purchase of store fixtures Interest expense 116,340 (29,000) 164,000 164,167 (43,300) (44,732) 2,220 1,730 Total budgeted payments 251,340 123,087 124,612 Payments minus receipts (151,340) Surplus (shortage) Financing activity 205,573 310,628 (48,973) 70,660 S 156,600 $ 310,628 Borrowing (repayment) 222,000 Ending cash balanceStep 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