Discounted Payback Method

discounted payback method which is the time needed to pay back the original investment in terms of discounted future cash flows. Define the technique in detail.

• Discuss the difference between the two methods.
• Analyze the numbers in the problem using an excel spreadsheet.
• Use a 10% discount rate.
• You must use Excel formulas which are on the ribbon in Excel marked Fx to make your calculations whenever possible. Do not write your own formulas unless absolutely necessary.
• All information must be in Excel (Word documents will not be read and you will not get credit).
• Remember to carry out your answers at least two decimal places.
• Add a new tab on your original excel file and submit this project