Question

In: Finance

Consider the following for a portfolio: Year Beginning value Dividend Ending value 1 $100 $1.46 $110...

Consider the following for a portfolio:

Year Beginning value Dividend Ending value
1 $100 $1.46 $110
2 $110 $1.12 $112
3 $112 $1.27 $115

What is the geometric mean annual return?

Solutions

Expert Solution

Step-1, Calculation of Return for each of 3 years

Return for Year 1 (r1)

Return for Year 1 = [{(Ending Value – Beginning Value) + Dividend} / Beginning Value] x 100

= [{($110 - $100) + $1.46} / $100] x 100

= [($10 + $1.46) / $100] x 100

= [$11.46 / $100] x 100

= 11.46%

Return for Year 2 (r2)

Return for Year 2 = [{(Ending Value – Beginning Value) + Dividend} / Beginning Value] x 100

= [{($112 - $110) + $1.12} / $110] x 100

= [($2 + $1.12) / $110] x 100

= [$3.12 / $110] x 100

= 2.84%

Return for Year 3 (r3)

Return for Year 3 = [{(Ending Value – Beginning Value) + Dividend} / Beginning Value] x 100

= [{($115 - $112) + $3.00} / $112] x 100

= [($3 + $1.27) / $112] x 100

= [$4.27 / $112] x 100

= 3.81%

Step-2, Calculation of Geometric Mean Annual Return

Geometric Mean Annual Return = [(1 + r1) x (1 + r2) x (1 + r3)]1/n – 1

= [(1 + 0.1146) x (1 + 0.0284) x (1 + 0.0381)]1/3 – 1

= [1.1145 x 1.0284 x 1.0381]1/3 – 1

= [1.18992694]1/3 – 1

= 1.05967682 – 1

= 0.05967682 or

= 5.97% (Rounded to 2 decimal place)

“Hence, the Geometric Mean Annual Return will be 5.97%”


Related Solutions

$100 is received at the beginning of year 1, $200 is receivedat the beginning of...
$100 is received at the beginning of year 1, $200 is received at the beginning of year 2, and $300 is received at the beginning of year 3. If these cash flows are invested at 12 percent, what will their future value be at the end of year 3?What is the present value of a $25,000 perpetuity be if the discount rate (required rate of return) is 14 percent? (HINT: Excel does not have a built-in formula for perpetuity. You...
Beginning on March 1, 2013 and ending on June 1, 2016 monthly payments of $100 were...
Beginning on March 1, 2013 and ending on June 1, 2016 monthly payments of $100 were deposited into an account which earns 12% compounded monthly. Then, beginning on July 1, 2016 and ending on September 1, 2017 monthly payments of $200 were deposited. Determine the balance of the account on February 1, 2019. please show work
What is the value of Accounts Receivable, Gross at the beginning and the ending of the...
What is the value of Accounts Receivable, Gross at the beginning and the ending of the current fiscal year? Any examples?
Consider: (a) Stock trades for $100; (b) Calls with exercise prices of $90, $100, and $110...
Consider: (a) Stock trades for $100; (b) Calls with exercise prices of $90, $100, and $110 trade at prices of $17.03, $10.38, and $6.50 respectively. If a person buys a $90 call, writes two $100 calls, and buys a $110 call, what is the magnitude of her maximum loss? The answer is 2.77, how do you solve? Type or paste question here
Consider: (a) Stock trades for $100; (b) Calls with exercise prices of $90, $100, and $110...
Consider: (a) Stock trades for $100; (b) Calls with exercise prices of $90, $100, and $110 trade at prices of $17.11, $10.69, and $6.10 respectively. If a person buys a $90 call, writes two $100 calls, and buys a $110 call, what is her higher break-even point? The answer is 108.17, how do you solve this?
Consider: (a) Stock trades for $100; (b) Calls with exercise prices of $90, $100, and $110...
Consider: (a) Stock trades for $100; (b) Calls with exercise prices of $90, $100, and $110 trade at prices of $17.78, $11.06, and $6.74 respectively. If a person buys a $90 call and writes a $110 call, what is her profit if the stock price is 92.63 at maturity? The answer is 8.41, how do you solve this?
Consider the following financial statement information for the Mediate Corporation:      Item Beginning Ending   Inventory $...
Consider the following financial statement information for the Mediate Corporation:      Item Beginning Ending   Inventory $ 4,880         $ 6,310            Accounts receivable 2,963         3,831            Accounts payable 4,018         5,195              Credit sales $ 50,484         Cost of goods sold 30,640        Required: (a) Calculate the operating cycles. (Do not round your intermediate calculations.) (Click to select)42.09days91.21days94.86days36.34days87.56days (b) Calculate the cash cycle. (Do not round your intermediate calculations.)
Suppose the following: Beginning Inventory = 11202 Ending Inventory= 12259 Beginning Receivables = 6123 Ending Receivables...
Suppose the following: Beginning Inventory = 11202 Ending Inventory= 12259 Beginning Receivables = 6123 Ending Receivables = 6623 Beginning Payables = 8425 Ending Payables = 8827 Credit Sales = 91254 Cost of Goods Sold = 72320 Calculate the following (round final answers to 2 decimal places): Operating Cycle =   days Cash Cycle =  days
Suppose the following: Beginning Inventory = 11141 Ending Inventory= 12245 Beginning Receivables = 6450 Ending Receivables...
Suppose the following: Beginning Inventory = 11141 Ending Inventory= 12245 Beginning Receivables = 6450 Ending Receivables = 6825 Beginning Payables = 8304 Ending Payables = 8758 Credit Sales = 91199 Cost of Goods Sold = 73243 Calculate the following (round final answers to 2 decimal places): Operating Cycle = days Cash Cycle = days
Consider the following five lottery tickets: l1 = ($100, .5; $10, .5); l2 = ($110, .5;...
Consider the following five lottery tickets: l1 = ($100, .5; $10, .5); l2 = ($110, .5; $10, .5); l3 = ($55, 1); l4 = ($110, .5; $0, .5); l5 = ($100, .7; $10, .3). (a) If you know that an individual is an expected utility maximizer (who likes money), but you do not know more about this person, what can you say about how this individual ranks the lotteries? (You should conclude that one/some comparison(s) are unclear, but one/some can...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT