70.2K

Verified Solution

Link Copied!

bers are in dollars.

	January	February	March
Beginning cash balance
Add: Cash receipts		187,500	255,000
Total cash available	262,500
Less: Cash needs	------	-----	-----
For inventory purchases	127,500	112,500	118,500
For S&A expenses		67,500	69,000
To purchase assets	37,500	37,500	37,500
Total cash payments	240,000	217,500	225,000
Add: Desired cash cushion		7,500	7,500
Total cash needed		225,000	232,500
Surplus (shortage) of cash	15,000		30,000
Financing activity:	-----	-----	-----
Amount borrowed (repaid)
Interest expense
Ending cash balance

The company desires a minimum cash balance of $7,500 at the end of each month, and this requirement was met at the beginning of this calendar year. In any month in which there is an expected cash deficiency, the company's bank will extend it a loan equal to the expected shortage amount. The loan is assumed to have been made on the last day of the month. Any time the company has a cash surplus, it must repay as much of the outstanding loans as possible. The bank charges monthly interest of 1% on any outstanding loan balance. Any money in excess of the desired minimum cash balance is invested elsewhere.

Complete the monthly cash budget above and find the missing numbers in the table (except where you see "-----").

Answer & Explanation Solved by verified expert

See Answer