Computation Using Excel Spreadsheet Discussion

The primary theme of the paper is Computation Using Excel Spreadsheet Discussion in which you are required to emphasize its aspects in detail. The cost of the paper starts from $99 and it has been purchased and rated 4.9 points on the scale of 5 points by the students. To gain deeper insights into the paper and achieve fresh information, kindly contact our support.

Computation Using Excel Spreadsheet Discussion

INSTRUCTIONS:

Using Excel spreadsheet one can easily compute the NPV of a stream. Place the initial investment number in cell A1(using a negative, such as -1000 ), and then the cash flow that emanates from the investment in cells B1, C1 and so on (or you may chose to list the amounts vertically). Then use the NPV function to compute the NPV (be sure you place the rate and values in the correct place) . Consider the following example: Investment of 1000 (now), followed by net cash flow of 580 in one year and another 580 in two years. consider a cost of capital or a discount rate of 0.08 (8%). Use the Excel spreadsheet to compute the NPV of the investment. Then please use a simple calculator to do the same computation. Show your work. Do you get the same result? Are you sure? Tell me what you think of this little exercise.

CONTENT:

Computation Using Excel Spreadsheet Discussion Name: Subject Date of Submission Investment of 1000 (now), followed by net cash flow of 580 in one year and another 580 in two years. Consider a cost of capital or a discount rate of 0.08 (8%). I entered the initia

...

Computation Using Excel Spreadsheet Discussion