For what value of S will the FV of the series of cash flows be zero at 10% per period interest rate? please show work using excel functions(goal seek) if possible
Year |
Cash Flow |
|||
0 |
$62,500 |
|||
1 |
-4S |
|||
2 |
12S |
|||
3 |
-10S |
|||
4 |
8S |
|||
5 |
-6S |
|||
6 |
$14,200 |
|||
7 |
-56S |
|||
8 |
152S |
|||
$1,198 |
||||
$1,245 |
||||
$1,541 |
||||
$1,652 |
Get Answers For Free
Most questions answered within 1 hours.