Question: .Calculate the compound (geometric) average return for the following 3 cashflows Year Cash flows A B C 1 $500 $200 $2,000 2 $600 $300 $2,500
.Calculate the compound (geometric) average return for the following 3 cashflows
| Year |
| Cash flows |
|
|
| A | B | C |
| 1 | $500 | $200 | $2,000 |
| 2 | $600 | $300 | $2,500 |
| 3 | $800 | $400 | $2,600 |
| 4 | $1,000 | $500 | $2,800 |
| 5 | $1,200 | $600 | $3,000 |
| 6 |
| $700 | $3,250 |
| 7 |
| $800 |
|
| 8 |
| $900 |
|
Please do the solution through excel providing the formulas and the answers.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock