Stay Fresh Company is a merchandising company that sells plastic food containers. The president and chief financial officer of the company want to approach Stay Fresh s bank about short-term financing for the coming year, 2014. The bank stated that loans are given only after reviewing proper cash budgeting information. The loan officer is requesting a detailed cash budget that shows the quarters in which financing will be needed, as well as the amounts that will be needed and the quarters in which repayments can be made.
The following information has been assembled to assist in preparing the cash budget for 2010:
a. Budgeted sales and merchandise purchases for 2014, as well as actual sales and purchases for the last quarter of 2013 are as follows:
Merchandise
Sales Purchases
2013:
Fourth quarter actual $ 600,000 $360,000
2014:
First quarter estimated $ 800,000 $520,000
Second quarter estimated $1,000,000 $620,000
Third quarter estimated $1,200,000 $740,000
Fourth quarter estimated $ 960,000 $480,000
b. The company generally collects 40% of a quarter s sales before the quarter ends and the
remaining 60% in the following quarter.
c. 30% of a quarter s merchandise purchases are paid for within the quarter. The remainder is paid in the following quarter.
d. Operating expenses for 2014 are budgeted at $200,000 per quarter plus 10% of sales. Of the fixed amount, $20,000 each quarter is depreciation.
e. The company will pay $10,000 in cash dividends each quarter.
f. Equipment purchases will be made as follows: $100,000 in the second quarter and $135,000 in the third quarter.
g. The cash balance on December 31, 2013 is $40,000. The company must maintain a minimum cash balance of at least $36,000.
h. The company has an agreement with a local bank that allows the company to borrow in increments of $10,000 at the beginning of each quarter, up to a total loan balance of $200,000. The interest rate on these loans is 1% per month, and for simplicity, we will assume that interest is not compounded. The company would, as far as able, repay the loan plus accumulated interest at the end of the year.
i. At present, the company has no loans outstanding.
Instructions
1. Prepare the following, by quarter and in total, for 2014:
a. A schedule of expected cash collections on sales.
b. A schedule of expected cash disbursements for merchandise purchases;
2. Compute the expected cash disbursements for operating expenses, by quarter and in total, for
2014.
3. Prepare a cash budget by quarter and in total for 2014.