Excel File – Converting Monthly to Annual Cash Flows
Excel File – Converting Monthly to Annual Cash Flows
1405 Downloads
- Companion Excel file to video tutorial on how to convert monthly cash flows to annual cash flows in Excel
- Two techniques demonstrated:
- SUMIF Function
- SUM Function combined with OFFSET Function
- Also can act as module to include in your own models to quickly roll up monthly cash flows