Question: Having an issue putting this problem in excel. If you could show the answer in excel that would be awesome. The Clause Solution, Inc., a

Having an issue putting this problem in excel. If you could show the answer in excel that would be awesome.

The Clause Solution, Inc., a residential window and door manufacturer, has the following historical record of earnings per share (EPS) from 2013 to 2017:

The companys payout ratio has been 60% over the last five years and the last quoted price of the firms stock was $10. Flotation costs for new equity will be 7%. The company has 30,000,000 common shares outstanding and a debt-equity ratio of 0.50.

	2017	2016	2015	2014	2013
EPS	$1.10	$1.05	$1.00	$0.95	$0.90

If dividends are expected to grow at the same arithmetic average growth rate of the last five years, what is the dividend payment in 2018?
Calculate the firms cost of retained earnings and the cost of new common equity using the constant growth dividend discount model.
If the Clause Solutions after-tax cost of debt is 9%, what is the WACC with retained earnings? With new common equity?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Please fill out excel sheet with excel formulas showing to see step by step answer please 1. The Clause Solution, Inc., a residential window and door manufacturer, has the following historical record...

The Clause Solution, Inc., a residential window and door manufacturer, has the following historical record of earnings per share (EPS) from 2013 to 2017: The companys payout ratio has been 60% over...

The Clause Solution, Inc., a residential window and door manufacturer, has the following historical record of earnings per share (EPS) from 2013 to 2017: 2017 2016 2015 2014 2013 EPS $1.10 $1.05...

Hi, I need help with my finance homework.Thisis kind of a short notice as we have been given asmall windowto complete. It is due today. Please see attached and let me know if you can help. Please...

See page 129- 137 on attachment for more details there are five steps to the project. Step 1: Create the loan amortization schedule for the property. Step 2: Create the depreciation schedule. Step 3:...

SOMEONE PLEASE HELP ME GIVE ALL THE ANSWERS!!!!! MY EXAM IS ON 13th MORNING! SO PLEASEEEEE!!!!! 2. An investment is expected to pay the following: C 1 = $2,300, C 2 = $2,600, C 3 = $2,900, and then...

SHOW WORK on EXCEL and EXPLAIN ANSWERS on all problems. You are thinking of buying a miniature golf course to operate. It is expected to generate cash flows of $45,000 per year in years one through...

SHOW YOUR WORK on EXCEL and EXPLAIN ANSWERS on all problems. 1)You are thinking of buying a miniature golf course to operate. It is expected to generate cash flows of $45,000 per year in years one...

I need help with these finance questions and see attachment below for the documents Finance questions Provide work on excel sheet and give explanations where necessary. You are thinking of buying a...

I need a solution for City of Smithville Chapter 1-4 Instructions City of Smithville Full Version Computerized Cumulative Problem For use with McGraw-Hill/Irwin Accounting for Governmental &...

What is the purpose of having a shear angle on a punch?

Water is flowing at the rate of 10 Kg/min in a pipe having an inside diameter I.D. of 2.067 ft. calculate the Reynolds number and show the type of flow (dynamic viscosity =8.007 x 104 Pa.s),...

A positive cash flow to stockholders indicates which one of the following with certainty? The amount of sale of common stock accessed the amount of dividends paid

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...