Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can someone show me what this looks like in Excel? Thank you The firm paid total dividend amount is S3,600,000 Net Income is $10,800,000 Earnings

can someone show me what this looks like in Excel? Thank youimage text in transcribed

The firm paid total dividend amount is S3,600,000 Net Income is $10,800,000 Earnings growth rate in the year 2013 is 10% In the year 2014 the eamings are expected to jmp to S14,400,000 and the firm expects to have profitable investment opportunities of S8,400,000 After 2014, the company will retum to its previous 10% growth rate. The firm's target capital structure is 40% debt and 60% equity Policies: eamings Total dividends paid in 2014-[S3,600,000x1.10 $3.960.000 It continues the 2013 dividend payout ratio Dividend Payout Ratiogo $10,800,000 S3,600,000 -0.3333(or) 33.33% Dividend paind in 2014-[S14,400,000x0.3333 -$4,799,520 Therefore, the Fim's total divdidens paid in 2014th year is $4,799,520

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Bitcoin Cash What You Need To Know About Bch

Authors: Alexander O. M.

1st Edition

1976721229, 978-1976721229

More Books

Students also viewed these Finance questions