Complete the income statement and balance sheet from the following cash budget and instructions. Please show as many steps as possible.

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{9}{|c|}{ Hillard Company } & \\ \hline \multirow{2}{*}{\multicolumn{9}{|c|}{\begin{tabular}{c} Income Statement \\ First Quarter \end{tabular}}} & \\ \hline & & & & & & & & & \\ \hline & & January & & ebruary & & March & & Quarter & \\ \hline Gross sales revenue & $ & 346,750 & $ & 687,500 & $ & 468,750 & $ & 1,503,000 & \\ \hline Less: COGS & & (412,500) & & (275,000) & & (206,250) & & (893,750) & \\ \hline Gross Margin & & (65,750) & & 412,500 & & 262,500 & & 609,250 & \\ \hline SGA & & & & & & & & - & \\ \hline Net Income & $ & (65,750) & $ & 412,500 & $ & 262,500 & $ & 609,250 & Should be $144,500 \\ \hline \end{tabular} Hillard Company Balance Sheet As of March 31 Assets Current Assets Cash Net accounts receiveable Finished Goods Inventory Total current assets Property Plant \& Equipment Buildings and Equipment $0 Less:Accumulated Depreciation Total PPE Total Assets Liabilities and Stockholders Equity Current Liabilities Accounts Payable Total Liabilities Stockholders equity Capital Stock Retained earnings Total Stockholders Equity Total liabilities and stockholders equity Master Budget Excel Assignment; Hillard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the first quarter: b. Actual Sales for December and budgeted sales for the next four months are as follows: c. Sales are 25% for cash and 75% on credit. All payments on credit sales are colected in the month following the sale. The accounts receivable at December 31 are a result of December credit sales. d. The company's gross profit rate is 45% of gross sales. e. Monthly expenses are budgeted as follows: salaries and wages, $75,000 per month; advertising, $55,000 per month; shipping, 5.6% of sales; depreciation, $19,000 per month; other expenses, 3% of sales. f. At the end of each month, inventory is to be on hand equal to 20% of the following month's sales needs, stated at cost. g. 40% of a month's inventory purchases is paid for in the month of purchase; the other 60% is paid for in the following month. h. If required, make necessary assumptions and state them in the answer document