Transcribed Image Text
Prepare a monthly cash budget for January through April. Be sureto clearly show the surplus (deficit) of cash.Based on the deficit cash shown on your cash budget, what is thedollar amount that Bond Private Security should have for a line ofcredit over this 4-month period? Note: don’t add a “cushion”, justbase this amount off of the cash budget.Collections during month of sale35%Collections during month after sale50%Collections during second month after sale13%Lease payments$4,600Target cash balance$4,000General and administrative salaries$12,000Depreciation charges$3,500Tax payments (March)$6,500Miscellaneous expenses$2,470Cash on hand January 1$5,500NovemberDecemberJanuaryFebruaryMarchAprilMayOriginal sales estimates$85,000$72,000$68,000$54,000$41,000$30,000$37,000Original labor and raw mat. estimates$51,000$40,500$30,750$22,500$27,750