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.
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
- HW1-C.xlsx