Question: begin { tabular } { | c | c | c | c | c | } hline multicolumn { 5 }

\begin{tabular}{|c|c|c|c|c|}\hline \multicolumn{5}{|c|}{Cash Budget}\\\hline & Jan & Feb & Mar & Quarter 1\\\hline \multicolumn{5}{|l|}{Cash Receipts}\\\hline Beginning Cash Balance & \$ 1,250,000 & & & \\\hline + Cash Receipts & 1,535,625 & 2,270,250 & 2,613,375 & 6,419,250\\\hline = Total Cash Available & 2,785,625 & 2,270,250 & 2,613,375 & 6,419,250\\\hline & & & & \\\hline \multicolumn{5}{|l|}{Cash Disbursements}\\\hline Direct materials & 782,452 & 571,695 & 574,219 & 1,928,365\\\hline Direct labor & 701,786 & 595,856 & 615,718 & 1,913,361\\\hline Manufacturing overhead & 543,935 & 468,935 & 482,998 & 1,495,868\\\hline SGA Expenses & 335,635 & 339,060 & 345,910 & 1,020,605\\\hline Dividends & & & 38,500 & 38,500\\\hline Total Cash Disbursements & 2,363,808 & 1,975,546 & 2,057,344 & 6,396,698\\\hline & & & & \\\hline Cash Surplus (Deficit) & 421,817 & 294,704 & 556,031 & 22,552\\\hline & & & & \\\hline \multicolumn{5}{|l|}{Financing:}\\\hline Borrowing (at beginning of month) & 378,183 & & & \\\hline Interest Payment & 1,733 & & & \\\hline \multicolumn{5}{|l|}{Principal Repayment}\\\hline \multicolumn{5}{|l|}{Total borrowing/repayment}\\\hline & & & & \\\hline \multicolumn{5}{|l|}{Ending Cash Balance}\\\hline & & & & \\\hline Outstanding Loan Balance & Jan & Feb & Mar & \\\hline & & & & \\\hline \multicolumn{5}{|l|}{Balance at beginning of month}\\\hline \multicolumn{5}{|l|}{+ Borrowings}\\\hline \multicolumn{5}{|l|}{+ Interest}\\\hline \multicolumn{5}{|l|}{- Principal Repayments}\\\hline \multicolumn{5}{|l|}{= Ending Balance}\\\hline & & & & \\\hline \end{tabular}
\ begin { tabular } { | c | c | c | c | c | } \

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!