Using excel template for calculation of average retin from
2012-2015 period
A | B | |
1 | Year | Return |
2 | 2012 | 17.90% |
3 | 2013 | 32.50% |
4 | 2014 | 13.50% |
5 | 2015 | 1.30% |
Average | 16.30% | |
Excel formula | Average(B2:B5) |
Alternate method using formula =(Return 2012+ Return 2013+Return
2014+Return 2015)/Number of Years
=(17.90%+32.50%+13.50%+1.30%)/4=16.30%
Your answer is incorrect. Try again Robert invested $1,000 in large US stocks at the beginning...
Question 12 Gary invested $1,000 in large U.S. stocks at the beginning of 2012. This investment earned 15.05 percent in 2012, 33.35 percent in 2013, 11.50 percent in 2014, and 2.10 percent in 2015. What return did he earn in the average year during the 2012-2015 period? (Round answer to 2 decimal places, e.g. 1.52.) Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values....
ames invested $1,000 in large U.S. stocks at the beginning of 2012. This investment earned 15.00 percent in 2012, 30.00 percent in 2013, 11.00 percent in 2014, and 1.00 percent in 2015. What return did he earn in the average year during the 2012–2015 period? (Round answer to 2 decimal places, e.g. 1.52.) Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using...
Charles invested $1,000 in large U.S. stocks at the beginning of 2012. This investment earned 15.25 percent in 2012, 31.60 percent in 2013, 12.95 percent in 2014, and 1.00 percent in 2015. What return did he earn in the average year during the 2012–2015 period? (Round answer to 2 decimal places, e.g. 1.52.) Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using...
Matthew invested $1,000 in large U.S. stocks at the beginning of 2012. This investment earned 17.30 percent in 2012, 31.10 percent in 2013, 13.50 percent in 2014, and 2.50 percent in 2015. What return did he earn in the average year during the 2012–2015 period?
Find B & C Investment is $2900 Your answer is partially correct. Try again. Find the future value of an investment of $2,900 made today for the following rates and periods: Il you solve this problem with algebra round Intermediate calculations to 4 decimal places in all cases round your answers to the nearest penny.) Excel Template (Note: This template Includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values....
Pharoah, Inc., has outstanding bonds that will mature in six years and pay an 8 percent coupon semiannually. If you paid $1,041.55 today and your required rate of return was 6.5 percent. (Round intermediate calculations to 5 decimal places, e.g. 1.25145 and final answer to 2 decimal places, e.g. 15.25.) Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy...
Question 15 Find the future value of a five-year $115,000 investment that pays 8.50 percent and that has the following compounding periods: (Do not round Intermediate calculations, round final answers to 2 decimal places, e.g. 15.25.) Excel Template (Note: This template Includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this screen for easy reference to the values you've been...
Question 8 View Policies Show Attempt History Your answer is correct. The Wilson family is buying a new 3,500-square-foot house in Muncie, Indiana, and will borrow $243,700 from Bank One at a rate of 6.084 percent for 15 years. What will be their monthly loan payment? (Round factor values to 4 decimal places, eg. 1.5212 and final answer to 2 decimal places, eg. 15.25.) Excel Template (Note: This template includes the problem statement as it appears in your textbook. The...
Problem 5.02 (Excel Video) Donald Martin is investing $9,500 in a bank CD that pays a 10 percent annual interest. How much will the CD be worth at the end of five years? (Do not round intermediate calculations and round your final answer to the nearest penny.) Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement...
Problem 8.09 (Excel Video) Helen Martin is looking to invest in a three-year bond that makes semi-annual coupon payments at a rate of 5.775 percent. If these bonds have a market price of $981.68, what yield to maturity can she expect to earn? (Round intermediate calculations to 5 decimal places, e.g. 1.25145 and final answer to 2 decimal places, e.g. 15.25%.) Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to...