If you can please help in excel for this part be I have attached part A as it is a camuliative question part A i have correct but I need help with part B b. Calculate the present value of each of the anticipated dividends at a discount rate of 22 percent. (Do not round intermediate calculations. Round the final answers to 3 decimal places.) PV ofdividends D1$ D2 D3 Total$ Hunter Petroleum Corporation pald a $5 dividend last year. The dividend is expected to grow at a constant rate of 8 percent forever.The required rate of return is 22 percent (this will also serve as the discount rate in this problem). (Use a Financlal calculator to arriveat the answers.)a. Compute the anticipated value of the dividends for the next three years. (Do not round Intermediate calculations. Round the finalanswer to 3 decimal places.)AnticipatedvalueD2D3Anticipatedvalue1=5.00*1.085.45D15.45D25.892=5.45*1.085.89D36.4213=5.89*1.086.42

The question is based on the concept of Financial Management.

If you can please help in excel for this part be I have attached part A as it is a camuliative question part A i have correct but I need help with part B b. Calculate the present value of each of the anticipated dividends at a discount rate of 22 percent. (Do not round intermediate calculations. Round the final answers to 3 decimal places.) PV of dividends D1 $ D2 D3 Total $

If you can please help in excel for this part be I have attached part A as it is a camuliative question part A i have correct but I need help with part B b. Calculate the present value of each of the anticipated dividends at a discount rate of 22 percent. (Do not round intermediate calculations. Round the final answers to 3 decimal places.) PV of dividends D1 $ D2 D3 Total $

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Your consulting firm will produce cash flows of $190,000 this year, and you expect cash flows thereafter to keep pace with any increase in the general level of prices. The interest rate currently is 5.2%, and you anticipate inflation of about 1.2%. a. What is the present value of your firm's cash flows for years 1 through 5? Note: Do not round intermediate calculations. Round your answer to 2 decimal places. Present value b. How would your answer to (a) change if you anticipated no growth in cash flow? Note: Do not round intermediate calculations. Round your answer to 2 decimal places. Present value
You plan to invest in an account which pays 3.5% compounded continuously. If the investment period is for 12 years, then A(P) = P e 0.035 · 12 = P e 0.42 gives the total balance of P dollars. Find a formula for A'(P). Find and interpret A'(4000). Compare the approximation to the actual change. a. b. С. a. A'(P) =| (Type an exact answer in terms of e.) b. A'(4000) = %3D (Round to the nearest cent as needed.) Interpret A'(4000) = 1.52 O A. The future value of a 13 year investment of $4001 will be $ more than the future value of a 13 year investment of $4000. O B. The future value of a 13 year investment of $4000 will be $ more than the future value of a 13 year investment of $4000. O C. The future value of 12 year investment of $4000 at 4.5% will be $ more than the future value of a 12 year investment of $4000 at 3.5%. O D. The future value of a 12 year investment of $4001 will be $ more than the future value of a 12 year investment of $4000. c. A(4001) – A(4000) = dollars per year.…
d. What is the rate of return on your margined position (assuming again that you invest $30,000 of your own money) if XTel is selling after one year at (i) $56; (ii) $50; (iii) $44? (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.)
An investment offers $6,600 per year, with the first payment occurring one year from now. The required return is 5 percent. a. What would the value be today if the payments occurred for 10 years? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What would the value be today if the payments occurred for 35 years? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c. What would the value be today if the payments occurred for 65 years? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) d. What would the value be today if the payments occurred forever? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)
Suppose that a 10-year T-note is purchased with a face value of $20,000 and a coupon rate of 3.4% (a) What is the total return of this investment? (b) What is the average rate of retum? (a) The total return is $ (Simplity your answer.) (b) The average rate of return is%. (Simplify your answer. Round to two decimal places as needed.)
An investment offers $9,200 per year for 17 years, with the first payment occurring one year from now. Assume the required return is 12 percent. a. What is the value of the investment today? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What would the value be if the payments occurred for 42 years? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c. What would the value be if the payments occurred for 77 years? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) d. What would the value be if the payments occurred forever? (Do not round
Your consulting firm will produce cash flows of $145,000 this year, and you expect cash flows thereafter to keep pace with any increase in the general level of prices. The interest rate currently is 6.9%, and you anticipate inflation of about 2.9%. a. What is the present value of your firm's cash flows for years 1 through 5? Note: Do not round intermediate calculations. Round your answer to 2 decimal places. Present value $ Present value 279,013.75 b. How would your answer to (a) change if you anticipated no growth in cash flow? Note: Do not round intermediate calculations. Round your answer to 2 decimal places.
Assume that at the beginning of the year, you purchase an investment for $7,200 that pays $100 annual income. Also assume the investment's value has decreased to $6,800 by the end of the year. (a) What is the rate of return for this investment? (Input the amount as a positive value. Enter your answer as a percent rounded to 2 decimal places.) Rate of return % (b) Is the rate of return a positive or negative number? Positive O Negative
Your company has an opportunity to invest in four companies. You are trying todetermine which of these investments make sense. Your company has a 9% cost ofcapital. It will invest in these companies and receive an annual cash dividend eachyear starting one year after the investment. At the end of the term of investment, theinvestment will be scrapped with no salvage value. (a) Determine the internal rate ofreturn for each investment. Round off to the nearest integer discount rate, withdetailed calculation process. (b)Which investments would you recommend yourcompany make?
An investment offers $6,800 per year for 20 years, with the first payment occurring one year from now. a. If the required return is 7 percent, what is the value of the investment today? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What would the value today be if the payments occurred for 45 years? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c. What would the value today be if the payments occurred for 70 years? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) d. What would the value today be if the payments occurred forever? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) a. Present value b. Present value C. Present value d. Present value
ok Assume the returns from holding an asset are normally distributed. Also assume the average annual return for holding the asset a period of time was 15.4 percent and the standard deviation of this asset for the period was 33.3 percent. Use the NORMDIST function in Excel to answer the following questions. a. What is the approximate probability that your money will double in value in a single year? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 3 decimal places, e.g., 32.161. b. What is the approximate probability that your money will triple in value in a single year? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 8 decimal places, e.g., 32.16161616. ences a. Probability b. Probability % %
What will price be in 1 year? c. What do you expect to happen to price in the following year? (Round your dollar value to 2 decimal places.) d. What is your estimate of DEQS’s intrinsic value per share if you expected DEQS to pay out only 10% of earnings starting in year 6? (Do not round intermediate calculations. Round your answer to 2 decimal places.)