Benson borrows funds, in increments of $1,000, and repays them on the last day o
ID: 2396138 • Letter: B
Question
Benson 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 $14,000 cash cushion. Prepare a cash budget. (Any repayments/shortage which should be indicated with a minus sign.)
Can someone tell me what I'm doing wrong here? Thanks!
Required A Required BRequired C Required D Required E Required FRequired G Benson 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 $14,000 cash cushion. Prepare a cash budget. (Any repayments/shortage which should be indicated with a minus sign.) Show less Cash Budget October November Beginning cash balance Add: Cash receipts Cash available Less: Payments December S14,952 14,640 49,001 179,760 194,400 149.800 49,000 164,752 56,448 99,322 993113,7 For inventory purchases For selling and administrative expenses36,56038,632 Interest expense Purchase of store fixtures 2,2302,110 173,200 257,048 138,112 154,506 Total budgeted payments Payments minus receipts (208,048) 39,894 Surplus (shortage) Financing activity 26,640 223,0002,000 Borrowing (repayment) Ending cash balance (25,000) 14,894 $ 14,952 S 14,640Explanation / Answer
Answer
This point has basically led to the mistakes that you have committed.
Oct
Nov
Dec
Beginning
$ -
$ 14,952.00
$ 14,000.00
Cash receipt
$ 49,000.00
$ 149,800.00
$ 179,760.00
Cash Available
$ 49,000.00
$ 164,752.00
$ 193,760.00
Less: Cash Payments
Inventory purchased
$ 56,448.00
$ 99,322.00
$ 113,764.00
Selling & Admin
$ 27,400.00
$ 36,560.00
$ 38,632.00
Interest expense
$ -
$ 2,230.00
$ 2,104.00
Store fixtures
$ 173,200.00
$ -
$ -
Budgeted Payments
$ 257,048.00
$ 138,112.00
$ 154,500.00
Payments minus receipts
Surplus (shortage)
$ (208,048.00)
$ 26,640.00
$ 39,260.00
Financing activity:
Borrowing (repayment)
$ 223,000.00
$ (12,640.00)
$ (25,260.00)
Ending Cash Balance
$ 14,952.00
$ 14,000.00
$ 14,000.00
---Surplus of Cash before Financing activity in the month of November was $ 26,640
---Minimum requirement of Ending Cash Balance = $ 14,000
---Hence, maximum amount that can be repaid will be 26640 – 14000 = $ 12,640 (not $ 12,000)
---Also note that ‘repayments’ are to be shown within “( )”
---Amount borrowed in Oct = $ 223,000
---Correct amount repaid in Nov = $ 12,640
---Remaining amount of loan = 223000 – 12640 = $ 210,360
---Correct Interest expense for December month = 210360 x 1% = $ 2103.60 = $ 2,104
---Correct Surplus of Cash before financing activity in Dec month = $ 39,260
---Minimum requirement of Ending Cash Balance = $ 14,000
---Hence, maximum amount that can be repaid will be 39,260 – 14000 = $ 25,260 (not $ 25,000)
Oct
Nov
Dec
Beginning
$ -
$ 14,952.00
$ 14,000.00
Cash receipt
$ 49,000.00
$ 149,800.00
$ 179,760.00
Cash Available
$ 49,000.00
$ 164,752.00
$ 193,760.00
Less: Cash Payments
Inventory purchased
$ 56,448.00
$ 99,322.00
$ 113,764.00
Selling & Admin
$ 27,400.00
$ 36,560.00
$ 38,632.00
Interest expense
$ -
$ 2,230.00
$ 2,104.00
Store fixtures
$ 173,200.00
$ -
$ -
Budgeted Payments
$ 257,048.00
$ 138,112.00
$ 154,500.00
Payments minus receipts
Surplus (shortage)
$ (208,048.00)
$ 26,640.00
$ 39,260.00
Financing activity:
Borrowing (repayment)
$ 223,000.00
$ (12,640.00)
$ (25,260.00)
Ending Cash Balance
$ 14,952.00
$ 14,000.00
$ 14,000.00
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.