Roger Wills & Company Estimates the Following for 2010 The Ending Cash Balance for 2009 Was $200,000

Roger Wills & Company estimates the following for 2010:
$\begin{array}{|l|l|}\hline \text { Sales (all on account) } & \$ 800,000 \\\hline \text { Collections of accounts receivable } & 700,000 \\\hline \text { Proceeds from bond issuance } & 500,000 \\\hline \text { Proceeds from sale of common stock } & 300,000 \\\hline \text { Merchandise bought on credit } & 650,000 \\\hline \text { Payments of accounts payable } & 500,000 \\\hline \text { Cash payments of expenses } & 70,000 \\\hline \text { Cash purchase of equipment } & 140,000 \\\hline \text { Depreciation of equipment } & 15,000 \\\hline \text { Payment on notes payable } & 30,000 \\\hline &\end{array}$
The ending cash balance for 2009 was $200,000.
Prepare a cash budget to determine the ending cash balance for 2010.