Spreadsheet moduling - calculation of IRR, & NPV for annual cash.
Spreadsheet modeling for Comprehensive Example.
Your job is to fill out the partially completed Excel spreadsheet template. A Comprehensive Example using the handout provided in class.
All of the data required to compute the ATCF is given in the handout. You simply need to set up it up properly in Excel. This is a useful exercise before we begin our case study.