You started your investment with an opening deposit of $1,000. Your portfolio grew as follows: Beg Yr...

You started your investment with an opening deposit of $1,000. Your portfolio grew as follows:

Beg Yr 1	Beg Yr 2	Beg Yr 3	Beg Yr 4	Beg Yr 5	Beg Yr 6	Beg Yr 7	Beg Yr 8	Beg Yr 9	Beg Yr 10	End Yr 10
$1,000	$1,268	$1,426	$1,497	$1,579	$995	$1,258	$1,447	$1,478	$1,714	$2,270

Calculate the average return and geometric return for eachyear.
What is the arithmetic average of your returns?

What is your long-term geometric average? (the average at end of year 10

please show me how you calculated using excel

Solutions

Expert Solution

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

jeff jeffy answered 3 weeks ago

Next > < Previous

Related Solutions

You started your investment with an opening deposit of $1,000. Your portfolio grew as follows: Beg...

You started your investment with an opening deposit of $1,000. Your portfolio grew as follows: Beg Yr 1 Beg Yr 2 Beg Yr 3 Beg Yr 4 Beg Yr 5 Beg Yr 6 Beg Yr 7 Beg Yr 8 Beg Yr 9 Beg Yr 10 End Yr 10 $1,000 $1,268 $1,426 $1,497 $1,579 $995 $1,258 $1,447 $1,478 $1,714 $2,270 Calculate the average return and geometric return for each year. What is the arithmetic average of your returns? What is your...

You make a $1,000 deposit to an investment account today. The investment earns 5% p.a compounding...

You make a $1,000 deposit to an investment account today. The investment earns 5% p.a compounding monthly for the first 12 months, then it earns 10%p.a compounding monthly for the next 3 years. At the end of the 4 years the balance in the account is (to the nearest whole dollar; don't use $ sign or commas)

If the rrr = 25% and you deposit $1,000 into your bank account, how much of...

If the rrr = 25% and you deposit $1,000 into your bank account, how much of it will banks have to set aside in their required reserve account (RR)? __________ How much will be left over to place into excess reserves (ER)? __________. Now, once ER changes, how much money can ultimately be created by our banking system? (5 points) Suppose the Fed sets the required reserve ratio at 20% and there are no excess reserves at the time (ER...

You deposit $1,000 in a saving account at 10% compounded annually. How much is your first...

You deposit $1,000 in a saving account at 10% compounded annually. How much is your first year interest? How much is your second year interest? 100, 100 100, 110 100, 120 100, 150

You want to buy a corporate bond for your portfolio. The bond is 10 year, $1,000...

You want to buy a corporate bond for your portfolio. The bond is 10 year, $1,000 par value and makes semi-annual coupon payments. The annual coupon rate is 6%. It has been four years since it was issued. Market interest rates have dropped to 4%. (10 pt.s) What is the price the bond would currently be trading at? Five years after issue the company has run into trouble and its bonds are now trading at 97. What is the yield...

Suppose you are an investment analyst, your supervisor, a portfolio manager asked you to write a...

Suppose you are an investment analyst, your supervisor, a portfolio manager asked you to write a brief report on how will the COVID-19 outbreak affect the stock market and economy in the world and Malaysia, and the report must include detailed analysis from part (1) to part (3) below. Perform a fundamental analysis of the overall market and economy in Malaysia. How will COVID-19 outbreaks across the world affect the Malaysian economy in terms of economic growth rate in 2021?...

You are offered a deal that pays you $1,000/yr (end of year) for 5 years, starting...

You are offered a deal that pays you $1,000/yr (end of year) for 5 years, starting 5 y from today. At a discount rate of 6%, what’s that deal worth right now? (CF’s: 0,0,0,0,0,1000,1000,1000,1000,1000). Nominal annual interest is quoted at 7.50%. With monthly payments, what’s effective annual interest? (1pt) What about daily payments? (1pt) What about payments every other year?

in one year, you will make an initial deposit in the amount of $1,000 in a...

in one year, you will make an initial deposit in the amount of $1,000 in a new savings account. You plan to make additional deposits in the same amount of $1,000 for 19 years after the initial deposit. There will only be these 20 deposits and no withdrawals made to your account. Assume the interest rate you will earn is 5% per year. How much will your account be worth in 20 years?

You have started an investment club with your friend. You identified an account which you think...

You have started an investment club with your friend. You identified an account which you think will pay 8% per year. You are going to invest $1200 per year. Your friend is going to invest $100 per month. You plan to invest for 4 years. All else equal, which of the following is true. A. Your friend’s investment will have the higher future value. B. Both investments will have the same future value C. Your investment will have the higher...

Looney Tuning Company started an extensive investment portfolio in 2015 and purchased the following investments in...

Looney Tuning Company started an extensive investment portfolio in 2015 and purchased the following investments in 2015: Daffy’s Gag Gifts Corp – on January 1, 2015, purchased 20,000 shares of stock. The cost of the shares was $25 per share and a commission of $750 was paid at purchase. W.E. Coyote’s Acme Products Corp. – on January 1, 2015, bonds with a face value of $250,000 purchased for $231,403. (This is “Bond 1” from Assignment #1). P. LePew’s Cologne Company...

Subjects