Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For context, I am working of excel, doing financial analysis. ( textbook question ) I need to calculate the GEOMEAN for the % change in
For context, I am working of excel, doing financial analysis. textbook question
I need to calculate the GEOMEAN for the change in dividends paid, which isn't difficult, however I am confused. So we are given the dividends, which is paid semiannually in the first year, annually in the second year, semiannually again in the third and fourth year, then annually in the fifth year. we are asked to calculate the compound quarterly growth rate of the dividends using the GEOMEAN function on EXCEL, which is also fine, understand how to use the function.
My question is how should get the compound quarterly growth rate, do I annualise everything to get the quarterly change? it just doesn't make sense that way.
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