Old MathJax webview

please include the formulas for the cell boxes

please help me with the cell formulas

Below are the two most recent balance sheets and most recent income statement for CCB Construction Co. 1. Type in your name above for Student Name. 2. You must compute net income on the income statement below and follow the 3 steps for creating a cash flow w 3. You MUST use cell references for your answers and format all currency as US \$ with zero decimal places. Ther 4. Be creative! Examples: Change the font size/style, use additional color and or shading \& borders; make your sp 5. You must also rename and give a descriptive title to 'Sheet 1 located at the bottom of the spreadsheet that look Make sure the title reflects the nature of the assignment that someone outside of this class would understand! lost recent income statement for CCB Construction Co. statement below and follow the 3 steps for creating a cash flow worksheet (the section below labeled OUTP ers and format all currency as US \$ with zero decimal places. There should be NO numbers simply typed inl /style, use additional color and or shading \& borders; make your spreadsheet look aesthetically pleasing. title to 'Sheet 1 ' located at the bottom of the spreadsheet that looks like this. assignment that someone outside of this class would understand! 22 23 Additional Input Data for 2021: 24 Effective Tax rate 25 Cash dividends paid \begin{tabular}{|ll|} \hline & 20.00% \\ \hline & 65,000 \\ \hline \end{tabular} \begin{tabular}{l|c} \hline 37 & Total Assets \\ \hline 38 & \\ \hline 39 & Liabilities \& Stockholders' Equity: \end{tabular} 40 Accounts Payable 41 Accrued Expenses 42 Long-term Bonds Payable Below are the two most recent balance sheets and most recent income statement for CCB Construction Co. 1. Type in your name above for Student Name. 2. You must compute net income on the income statement below and follow the 3 steps for creating a cash flow w 3. You MUST use cell references for your answers and format all currency as US \$ with zero decimal places. Ther 4. Be creative! Examples: Change the font size/style, use additional color and or shading \& borders; make your sp 5. You must also rename and give a descriptive title to 'Sheet 1 located at the bottom of the spreadsheet that look Make sure the title reflects the nature of the assignment that someone outside of this class would understand! lost recent income statement for CCB Construction Co. statement below and follow the 3 steps for creating a cash flow worksheet (the section below labeled OUTP ers and format all currency as US \$ with zero decimal places. There should be NO numbers simply typed inl /style, use additional color and or shading \& borders; make your spreadsheet look aesthetically pleasing. title to 'Sheet 1 ' located at the bottom of the spreadsheet that looks like this. assignment that someone outside of this class would understand! 22 23 Additional Input Data for 2021: 24 Effective Tax rate 25 Cash dividends paid \begin{tabular}{|ll|} \hline & 20.00% \\ \hline & 65,000 \\ \hline \end{tabular} \begin{tabular}{l|c} \hline 37 & Total Assets \\ \hline 38 & \\ \hline 39 & Liabilities \& Stockholders' Equity: \end{tabular} 40 Accounts Payable 41 Accrued Expenses 42 Long-term Bonds Payable