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%

 

 

 

 

 

https://www.youtube.com/watch?v=kCnwCplibAk

Subject Mathematics
Due By (Pacific Time) 09/30/2015 12:00 am
Report DMCA
TutorRating
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..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy