You have a project with the following CFs and a discount rate of 9.5%: 9 yr 6. 12 yr 11 yr 10 yr 8 yr 7 yг б уг 5 yr 4 yr З yг 2 yr 1 yr Today -10,000 1,313 1,797 1,968 1,724 1,7521,802 2,263 1,859...


Need help figuring this out and setting up in Excel with formulas.


You have a project with the following CFs and a discount rate of 9.5%:<br>9 yr<br>6.<br>12 yr<br>11 yr<br>10 yr<br>8 yr<br>7 yг<br>б уг<br>5 yr<br>4 yr<br>З yг<br>2 yr<br>1 yr<br>Today<br>-10,000<br>1,313 1,797 1,968 1,724 1,7521,802 2,263 1,859 1,900 1,486<br>899<br>548<br>What is the payback period for this investment?<br>а.<br>What is the discounted payback period for this investment?<br>b.<br>

Extracted text: You have a project with the following CFs and a discount rate of 9.5%: 9 yr 6. 12 yr 11 yr 10 yr 8 yr 7 yг б уг 5 yr 4 yr З yг 2 yr 1 yr Today -10,000 1,313 1,797 1,968 1,724 1,7521,802 2,263 1,859 1,900 1,486 899 548 What is the payback period for this investment? а. What is the discounted payback period for this investment? b.

Jun 03, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?