Update the cash flow
You will be creating a cash flow for the Grape Debate Wine Company. You should update the red cells B16, B20:B22 with the formulas referencing the Income and Balance Statement sheets.
You will use the Balance Statement to transfer over values. Equipment (B16) should be in the Balance statement (row 9), Debt (B20) to Balance Debt (row 15), and Equity (B21) to Balance Paid Capital (row 21). Subtract 2016 minus 2015.
Cash dividends (B22) should be matched the Income Statement sheet Dividends (row 22) and pick year 2016.
本練習屬於課程
在 Google Sheets 進行財務建模
練習說明
- Add the formulas for rows
16, 20, 21by subtracting Year 2016 - Year 2015 with the appropriate rows in the Balance Statement. - Add the Dividends in row
22by selecting Year 2016 in the Income Statement. - If you have done these correctly, the values will be the same as the currently provided ones.
