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

step by step instructions no excel
please argunt , thank you
4. ieff = Blank 1 : show in four decimal X = $ Blank 2 Y = $ Blank 3 Z = $ Blank 4
PLEASE ANSWER CORRECTLY ASAP
Please answer fast I will rate for you sure....
Topic: Gradients General Direction: Solve using Given-Required-Solution format. DO NOT USE EXCEL. Provide a Cash Flow Diagram (CFD).
How to turn fractions or percentage of Par- Value into decimals?
ii
Please do not give solution in image format thanku
step by step instructions no excel
A MOVING toO anotner question will save this response. Question 15 You bought a stock for $39 and you received dividends of $4. The stock is now selling for $47. What is your total percentage return? (please answer in decimal numbers, ie., use 0.05 in stead of 5%) A Moving to another question will save this response. P Type here to search 9.
Some recent financial statements for Smolira Golf, Incorporated, follow. Assets Current assets Cash Accounts receivable Inventory Total Fixed assets Net plant and equipment Total assets Sales Cost of goods sold Depreciation EBIT Interest paid Taxable income Taxes 2021 SMOLIRA GOLF, INCORPORATED 2022 Income Statement Net income Dividends Retained earnings $ 6,358 9,248 14,580 $ 30,186 $ 90,361 $ 120,547 Balance Sheets as 2022 $ 16,000 26,459 SMOLIRA GOLF, INCORPORATED of December 31, 2021 and 2022 Liabilities and Owners' Equity Current liabilities Accounts payable Notes payable Other $ 7,866 11,445 29,641 $ 48,952 $ 107,206 $ 156,158 287,318 220, 396 10,913 $ 56,009 2,264 $ 53,745 11, 286 $ 42,459 Total Long-term debt Owners' equity Common stock and paid-in surplus Accumulated retained earnings Total Total liabilities and owners' equity 2021 $ 4,880 3,959 198 $ 9,037 $ 32,100 $ 40,000 39,410 $ 79,410 $ 120,547 2022 $ 5,381 4,479 429 $ 10,289 $ 40,000 $ 40,000 65,869 $ 105,869 $ 156, 158