Requirements 1. Using an Excel spreadsheet: Find the NPV and the IRR of Dummont's project using...

Transcribed Image Text:

Requirements 1. Using an Excel spreadsheet: Find the NPV and the IRR of Dummont's project using the pro forma financial . statement method to determine cash flows. Enter the input variables in cells of their own at the top of the spreadsheet (so it is easier to do sensitivity calculations). Set up the necessary equations by referencing to the input variable cells. The spreadsheet must be formula driven; do not put any numbers in equations, only cell references. Use Excel's built-in functions wherever possible (e.g. PV and IRR functions). Requirements 1. Using an Excel spreadsheet: Find the NPV and the IRR of Dummont's project using the pro forma financial . statement method to determine cash flows. Enter the input variables in cells of their own at the top of the spreadsheet (so it is easier to do sensitivity calculations). Set up the necessary equations by referencing to the input variable cells. The spreadsheet must be formula driven; do not put any numbers in equations, only cell references. Use Excel's built-in functions wherever possible (e.g. PV and IRR functions).