Answer and explanation.

Assigned Problem 1 James Buchanan Orthotics and Prosthetics is planning to request a line of credit from its bank. The company has produced sales estimates, and these appear in the worksheet below. Collection estimates are as follows: 10 percent within the month of sale, 75 percent in the month following the sale, and 15 percent in the second month following the sale. Labor and supplies estimates also appear in the worksheet below. Payments for labor and supplies are typically made during the month following the one in which these costs have been incurred. General and administrative salaries will amount to approximately $27,000 a month; lease payments under long-term lease contracts will be $9,000 a month; depreciation charges will be $36,000 a month; miscellaneous expenses will be $2,700 a month; income tax payments of $63,000 will be due in both September and December; and a progress payment of $180,000 on a new building must be paid in October. Cash on hand on July 1 will amount to $132,000, and a minimum cash balance of $90,000 will be maintained throughout the cash budget period. What loan will be the company require in October? ANSWER May June July Aug Collections worksheet: 1. Billed charges $180,000 $180,000 $360,000 $5 2. Collections Within 30 days 30-60 days SU 60-90 days SO SO 3. Total collections Supplies worksheet: Amount of labor and supplies $90,000 $90,000 $126,000 S8 4. 5. Payments made for labor and supplies SO Net cash gain (loss): 6. Total collections (line 3) SO 7. Total purchases (line 5) General and administrative salaries -$27,000 -$27,000 -$27,000 18. -$9,000 -$9,000 -$9,000 Lease payments -$2,700 -$2,700 -$2,700 10 Miscellaneous expensesV U @ learn-us-east-1-prod-fleet02-xythos.content.blackboardcdn.com and December; and a progress payment of $180,000 on a new building must be paid in October. Cash on hand on July I will amount to $132,000, and a minimum cash balance of $90,000 will be October? maintained throughout the cash budget period. What loan will be the company require in ANSWER Collections worksheet: May June July August September October November December |January Billed charges Collections $180,000 $180,000 $360,000 $540,000 $720,000 $360,000 $360,000 590,000 $180,080 Within 30 days 30-60 days 60-90 days SO $0 Total collections SO Supplies worksheet: Amount of labor and supplies $90,000 Payments made for labor and supplies $90,000 $126,000 $882,000 $306,000 $234,000 $162,000 $90,000 SO Net cash gain (loss): Total collections (line 3) Total purchases (line 5) SO General and administrative salaries $27,000 -$27,000 -$27,000 -$27,000 -$27,000 -$27,000 -$27,000 -$27,000 -$27,000 Lease payments -$9,000 -$9,000 -$9,000 -$9,000 -$9.000 -$9,000 -$9.000 -$9.000 $9,000 Miscellaneous expenses $2,700 -$2,700 -$2,700 -$2,700 $2,700 -$2,700 -$2,700 -$2,700 $2,700 Taxes -$63,000 -$63.000 Progress payment -$180,000 Total payments Net cash gain(or loss) Borrowing/surplus summary: 15. Cash at beginning with no borrowing $132,000 16. Cash at end with no borrowing (line 14 + 15) $90,000 $90,000 $90,000 $90,000 $90,000 $90,000 $90,000 17 . Target cash balance (given) 18 . Cumulative surplus cash(or loan balance)