******This assignment was already completed, just need help with corrections********* Assignment attached

Faculty comments: Does not describe four key characteristics of stocks and bonds.

?Need four key characteristics of stocks (equity) and bonds (debt) and chart is comparing them.You show understanding of these topics. Consider using these new concepts on your investments sesearch. ?

Demonstrate your understanding of financial concepts by completing the following problems. Where appropriate, show or explain your work. It is recommended that you use Excel and its built-in formulas to work on the problems.

Problem 1.Calculate the future value of $3,500, compounded annually for each of the following:

• 10 years at 7 percent.
• 15 years at 9 percent.
• 20 years at 5 percent.

Problem 2.Calculate the present value for each of the following:

Problem 2. Calculating Present ValuesPresent ValueYearsInterest RateFuture Value54%$15,25087%$30,5501210%$850,4002015%$525,125Problem 3.Calculate the interest rate for each of the following:

Problem 3. Calculating Interest RatesPresent ValueYearsInterest RateFuture Value$2822$325$6076$891$32,60012$142,385$57,43522$463,200Problem 4.Calculate the number of years in each of the following:

Problem 4. Calculating the Number of PeriodsPresent ValueYearsInterest RateFuture Value$7656%$1,385$8459%$4,752$17,20011%$432,664$23,70014%$182,529Problem 5.Refer to the cash flows listed for the Kelly Company investment projects in the table below. The discount rate is 6 percent. Calculate the present value of these cash flows as well as the present value at 12 percent and at 17 percent.

Problem 5. Present Value and Multiple Cash FlowsYearCash Flow1$7502$8403$1,2304$1,470Problem 6.Value the bond Midcorp has issued, with the following characteristics:

• Par: $1,000.
• Time to maturity: 28 years.
• Coupon rate: 7.50 percent.
• Semiannual payments.

Calculate the price of this bond if the yield to maturity (YTM) is each of the following:

• 7.50 percent.
• 9 percent.
• 4 percent.

Problem 7.Calculate the bond yield in the following scenario: Two years ago, Walters Electronics Corporation issued 20-year bonds at a coupon rate of 6.75 percent. The bonds make semiannual payments, and currently sell for 106 percent of par value. Calculate the YTM.

Problem 8.Calculate the stock value in the following scenario: The next dividend payment by RST Incorporated will be $3.45 per share. The dividends are projected to sustain a 6.50 percent growth rate into the future. If RST stock currently sells for $67 per share, what is the required return?

Problem 9.Calculate the stock value in the following scenario:Nickels Corporation will pay a $3.10 per share dividend next year. The company plans to increase its dividend by 4.25 percent per year, indefinitely. How much will you pay for the company's stock today if you require a 12 percent return on your investment?

Problem 10.Provide a three-column table identifying four key characteristics of stocks (equity) and bonds (debt) and comparing them. Briefly discuss why a firm would prefer one over the other as a method of financing.

Problem 1 Year 10 15 20 Problem 2. Present Value $12,534.39 $17,780.38 $270,963.65 $32,085.28 Years 5 8 12 20 Problem 3. Present Value 282 $607.00 $32,600.00 $57,435.00 Years 2 6 12 22 Problem 4. Present Value $765.00 $845.00 $17,200.00 $23,700.00 Years 10.19 20.04 30.90 15.58 Problem 5. Years 1 2 3 4 1 Present Value at Present Value 6% 12% 7% $3,652.25 $3,148.99 $3,560.13 Problem 6 Par Time to maturity Coupon rate Semiannual payments. 1000 28 7.50% Calculate the price of this bond if the YTM is each of the following: YTM Price Bond 7.50% 9.00% 4.00% $1,000.00 $847.50 $1,586.33 Problem 7. YTM 6.19% Problem 8. Reqired Return =D1/p +G 11.65% Problem 9. Price = D1/(ke%-g%) 40.00 2 Rate 7% 9% 5% future value $6,885.03 $12,748.69 $9,286.54 Interest Rate 4% 7% 10% 15% Future Value $15,250.00 $30,550.00 $850,400.00 $525,125.00 Interest Rate Future Value 7.35% $325.00 6.61% $891.00 13.07% $142,385.00 9.95% $463,200.00 Interest Rate 6% 9% 11% 14% Future Value 1,385.00 4,752.00 432,664.00 182,529.00 Cash flow $750.00 $840.00 $1,230.00 $1,470.00 3 4 5 6