Provide an income statement for the month of April. You must use cell references when possible and a formula/calculation in the cell for any totals.

Clint's Beverage Co produces bottled water and has provided the following information for the month of April: Units Sold during April: Finished Goods Inventory, April 1: Salary of CFO: Finished Goods Inventory, April 30: Commissions: Advertising: Research and development: Cost of Goods Manufactured: Depreciation on corporate office: Unit price per sold item \begin{tabular}{|rr|} \hline & 82,200 \\ \hline$ & 75,000.00 \\ \hline$ & 175,000.00 \\ \hline$ & 70,000.00 \\ \hline$ & 200,000.00 \\ \hline$ & 750,000.00 \\ $ & 120,000.00 \\ \hline$ & 1,640,000.00 \\ \hline$ & 60,000.00 \\ \hline$ & 45.00 \\ \hline \end{tabular}