We will begin to work the problems in Excel that pertain to the learning in Chapter 14, 15, and 17 using excel.Â See the attached spreadsheet for specific instructions.Â You will be working on the same study problems 1-3 that you used to calculate Present Value in Week 7.Â You will use that file to put in your formulas for the NPV and IRR, which we learned in this chapter.

As before, perform the calculations for the NPV, and IRR problems on your calculator, following the instructions and the examples in the attached workbook on this assignment.Â Open both your old file (week 7) and this new file and print them entirely.Â Read them and then work the problems as instructed in the step-by-step instructions:

- Calculator exercise for NPV & IRR: Process the same as before:
- Review the example of Study problem 1.
- Work the Study problems 1-3 using your calculator.
- Then test your answers like you did before by taking the PV and NPV/IRR Problem Quiz that follows in the Assignment Folder.Â Take it as many times as needed until you get the right answers.Â (You will note that I'm giving you "free" points in the quiz for the PV portion again.)Â Once you have achieved a 100% on the quiz, then move onto the Excel formula portion.

- Excel exercise for NPV & IRR.Â Process the same as before:
- Once again the directions are in the first spreadsheet.Â The excel formula instructions are in the third spreadsheet.Â Follow the directions (like before) to do the formulas directly into the Week 7, Excel spreadsheets for all three Study Problems.
- Then submit your Excel file as you did before by following the directions inÂ Assignment folder. Remember, no Excel Formulas, no credit for the assignment.Â

Â

Â

Question 1

Â

Problem 2, What is the Present Value for Year 1?

Â

Â | Â |
4,099,130 |

Â | Â |
4,167,434 |

Â | Â |
4,343,777 |

Â

Â

Â

Â

Â

Â

Question 2

Â

Â

Problem 2, What is the Present Value for Year 2?

Â

Â

Â | Â |
5,356,787 |

Â | Â |
5,820,794 |

Â | Â |
5,674,343 |

Â

Â

Â

Â

Â

Â

Question 3

Â

Â

Â

Problem 2, What is the Present Value for Year 3?

Â

Â

Â | Â |
6,448,967 |

Â | Â |
6,343,876 |

Â | Â |
6,103,066 |

Â

Â

Â

Â

Â

Â

Question 4

Â

Â

Problem 2, What is the Present Value for Year 4?

Â

Â

Â | Â |
4,043,439 |

Â | Â |
4,794,656 |

Â | Â |
4,587,986 |

Â

Â

Â

Â

Question 5

Â

Â

Â

Problem 2, What is the Present Value for Year 5?

Â

Â | Â |
2,676,343 |

Â | Â |
2,894,999 |

Â | Â |
2,616,144 |

Â

Â

Â

Â

Â

Â

Question 6

Â

Â

Problem 2, What is the Net Present Value?

Â

Â

Â | Â |
15,582,573 |

Â | Â |
16,894,656 |

Â | Â |
13,475,999 |

Â

Â

Â

Â

Â

Â

Question 7

Â

Â

Problem 2, What is the Internal Rate of Return?

Â

Â

Â | Â |
78.67% |

Â | Â |
85.12% |

Â | Â |
87.90% |

Â

Â

Â

Â

Â

Â

Question 8

Â

Â

Problem 3, What is the Present Value for Year 1?

Â

Â

Â | Â |
3,440,000 |

Â | Â |
3,332,677 |

Â | Â |
3,546,854 |

Â

Â

Â

Â

Â

Â

Question 9

Â

Â

Problem 3, What is the Present Value for Year 2?

Â

Â

Â | Â |
6,554,874 |

Â | Â |
6,363,705 |

Â | Â |
6,287,903 |

Â

Â

Â

Â

Â

Â

Question 10

Â

Â

Problem 3, What is the Present Value for Year 3?

Â

Â

Â | Â |
7,056,434 |

Â | Â |
7,398,752 |

Â | Â |
7,166,927 |

Â

Â

Â

Â

Â

Â

Question 11

Â

Â

Problem 3, What is the Present Value for Year 4?

Â

Â

Â | Â |
4,887,347 |

Â | Â |
4,654,202 |

Â | Â |
4,934,134 |

Â

Â

Â

Â

Â

Â

Question 12

Â

Â

Problem 3, What is the Present Value for Year 5?

Â

Â

Â | Â |
3,012,943 |

Â | Â |
2,783,267 |

Â | Â |
2,973,117 |

Â

Â

Â

Â

Â

Â

Question 13

Â

Â

Problem 3, What is the Net Present Value?

Â

Â

Â | Â |
16,731,096 |

Â | Â |
16,987,444 |

Â | Â |
16,654,023 |

Â

Â

Â

Â

Â

Â

Question 14

Â

Â

Problem 3, What is the Internal Rate of Return?

Â

Â

Â | Â |
87.34% |

Â | Â |
77.02% |

Â | Â |
65.02% |

Â

Â

Â

Â

Â

https://www.youtube.com/watch?v=kCnwCplibAkSubject | Mathematics |

Due By (Pacific Time) | 09/30/2015 12:00 am |

Tutor | Rating |
---|---|

pallavi Chat Now! |
out of 1971 reviews More.. |

amosmm Chat Now! |
out of 766 reviews More.. |

PhyzKyd Chat Now! |
out of 1164 reviews More.. |

rajdeep77 Chat Now! |
out of 721 reviews More.. |

sctys Chat Now! |
out of 1600 reviews More.. |

sharadgreen Chat Now! |
out of 770 reviews More.. |

topnotcher Chat Now! |
out of 766 reviews More.. |

XXXIAO Chat Now! |
out of 680 reviews More.. |