Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You started your investment with an opening deposit of $1,000. Your portfolio grew as follows: Beg Year 1 Beg Year 2 Beg Year 3 Beg
- You started your investment with an opening deposit of $1,000. Your portfolio grew as follows:
Beg Year 1 | Beg Year 2 | Beg Year 3 | Beg Year 4 | Beg Year 5 | EndYear 5 |
$1,000 | $1,074 | $1,201 | $1,109 | $1,175 | $1,214 |
- What was your average return? (Arithmetic average)
- What was your actual return? (Geometric average)
- Use the TVOM to calculate the Rate (R) using the End year 5 as your Future Value.
PLEASE SHOW HOW THIS IS DONE IN EXCEL
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started