# Project #83990 - Execl Part 2

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%

Â

Â

Â

Â

Â

 Subject Mathematics Due By (Pacific Time) 09/30/2015 12:00 am
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews