This assignment focuses on calculating the Net Present Value of a contract with multiple payment schedules. The assignment is set up for multiple submissions. Submission one should be your answers using the attached Word doc. Submission two should be your excel spreadsheet file (or pdf if converted) or the calculations you did by hand to arrive at your answers.
It is highly recommended that you watch the Calculating NPV in Excel video in BB and use excel for this assignment. Submitting both your answer sheet (404 Week 6 Activity F24) and a copy of the work you did to arrive at your answers is required.
- Read and review Net Present Value section of Learning Module Eight: Time Value of Money in BB
- Watch the Calculating NPV in Excel Video in Week 6 Videos folder of BB. Use Chrome browser.
- Complete the calculations and answer the questions for the NPV scenario provided in the attached Word document.
- You are required to upload your Excel Spreadsheet (Excel or pdf file). If you choose not to use excel, you must submit your manual (by hand) calculations to show your work.
