hello, i have another home work again please check the file for the home work and please show all calculation in Excel form. thank you and please take your time with this homeworkalso need a good job on this paper.

"only forbettchalo 1. Your bank is offering you an account that will pay 30 % interest in total for a two-year deposit. Determine the equivalent discount rate for a period length of: a. Six months. b. One year. c. One month. (Round to two decimal places.) 2. Which do you prefer: a bank account that pays 5 % per year (EAR) for three years or: a. An account that pays 2.5 % every six months for three years? b. An account that pays 7.5 % every 18 months for three years? c. An account that pays 0.5 % per month for three years? (Round to five decimal places.) 3. You have found three investment choices for a one-year deposit: 9 % APR compounded monthly, 10 % APR compounded annually, and 10 % APR compounded daily. Compute the EAR for each investment choice. (Assume that there are 365 days in the year.) For the case of 9 % APR compounded monthly the EAR is ______%. (Round to three decimal places.) 4. A 10-year bond payments. with a face value of $ 1,000 has a coupon rate of 5.50 %, with semiannual a. What is the coupon payment for this bond? b. Enter the cash flows for the bond on a timeline. (Round to the nearest cent.) 5. Suppose a 10-year, $ 1,000 bond with a 8 % coupon rate and semiannual coupons is trading for a price of $ 964.53. a. What is the bond's yield to maturity (expressed as an APR with semiannual compounding)? b. If the bond's yield to maturity changes to 9 % APR, what will the bond's price be? (Round to two decimal places.) 6. Suppose a 5-year, $ 1,000 bond with annual coupons has a price of $ 800 and a yield to maturity of 6 %. What is the bond's coupon rate? The coupon rate is ______%. (Round to two decimal places.) 7. Suppose a seven-year, $1,000 bond with a 4.13 % coupon rate and semiannual coupons is trading with a yield to maturity of 1.54 % . a. If the yield to maturity of the bond rises to 2.01 % (APR with semiannual compounding), at what price will the bond trade? (Round to two decimal places.) 8. Assume Evco, Inc., has a current stock price of $ 37 and will pay a $ 2.25 dividend in one year; its equity cost of capital is 17 %. What price must you expect Evco stock to sell for immediately after the firm pays the dividend in one year to justify its current price? The expected price is $________ (Round to the nearest cent.) 9. Anle Corporation has a current price of $ 24, is expected to pay a dividend of $ 2 in one year, and its expected price right after paying that dividend is $ 25. a. What is Anle's expected dividend yield? b. What is Anle's expected capital gain rate? c. What is Anle's equity cost of capital? (Round to two decimal places.) 10. Summit Systems will pay a dividend of $ 1.68 one year from now. If you expect Summit's dividend to grow by 5.5 % per year, what is its price per share if its equity cost of capital is 11.1%? The price per share is $_______ (Round to the nearest cent.) 11. Colgate-Palmolive Company has just paid an annual dividend of $ 1.01. Analysts are predicting a(n) 10.3 % per year growth rate in earnings over the next five years. After that, Colgate's earnings are expected to grow at the current industry average of 5.7 % per year. If Colgate's equity cost of capital is 7.6 % per year and its dividend payout ratio remains constant, what price does the dividend-discount model predict Colgate stock should sell for? The price per share is $________ (Round to two decimal places.)