Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterty basis. The following data have been assembled to assist in preparation of the master budget for the first quarter: a. As of December 31 (the end of the prior quarter), the company's general ledger showed the following account balances: b. Actual sales for December and budgeted sales for the next four months are as follows: c. Sales are 20% for cash and 80% on credit. All payments on crecit sales are collected in the month following soie. The accounts receivable at December 31 are a result of December credit sales. d. The company's gross margin is 40% of sales. e. Monthly expenses are budgeted as follows: salarles and wages, $25,000 per month, advertising, \$71,000 per month; shipping, 5% of sales; depreciation, $12,000 per month; other expenses, 3% of sales. t At the end of each month, invertory is to be on hand equal to 25% of the following month's sales needs, stated at cost. g. One-half of a month's inventory purchases are paid for in the month of purchase; the other half are paid for in the following month. h. During February, the company will purchase a new copy machine for $1,300 cash. During March, other equipment will be purchased for cash at a cost of $85,500. 1. During January, the company will declare and pay $47,000 in cash dividends. 1. The company must maintain a minimum cash balance of $30,000. An open line of credit is avallable at a local bank for any borrowing that may be needed duting the quarter. All borrowing is done at the beginning of a month, and ali repayments are made at the end of a month. Borrowings and repayments of principal must be in multiples of $1,000. Interest is paid only at the time of payment of principal. The annual interest rate is 12%. (Figure interest on whole months, e.9. 112,2/2 ) \begin{tabular}{|l|l|} \hline & HILLYRD COMPANY \\ Balance Sheet \\ As of March 31 \\ \hline Assets \\ \hline & \\ \hline & \\ \hline Total current assets assets \\ \hline Liabilities and Shareholders' Equity \\ \hline Total assets & \\ \hline Current liabilities & \\ \hline Total shareholders' equity & \\ \hline \end{tabular}