Economic

Listed below are three projects with their revenues listed per year. For each project, create a MS Excel spreadsheet to determine its Net Present Value and find ALL Internal Rate of Return (IRR) values. Show graphically Interest versus Present Worth. Each project scenario should be on a separate worksheet within the one MS Excel file. You will submit the file electronically on Moodle for Project 2.

Your MARR is 10%. Compare your spreadsheet results with hand calculations (show hand calculations on green engineering paper). Indicate whether each project met your MARR. Hand calculations shall be turned in on the due date.