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.
Latihan ini adalah bagian dari kursus
Financial Modeling in Google Sheets
Petunjuk latihan
- 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.
Latihan interaktif praktis
Ubah teori menjadi tindakan dengan salah satu latihan interaktif kami.
Mulai berolahraga