Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

answers in excel formulas please You have looked at the current financial statements for Reigle Homes, Co. The company has an EBIT of $2.95 million

answers in excel formulas please image text in transcribed
image text in transcribed
You have looked at the current financial statements for Reigle Homes, Co. The company has an EBIT of $2.95 million this year. Depreciation, the increase in net working capital, and capital spending were $235,000, $105,000, and $475,000, respectively. You expect that over the next five years, EBIT will grow at 15 percent per year, depreciation and capital spending will grow at 20 percent per year, and NWC will grow at 10 percent per year. The company has $19.5 million in debt and 400,000 shares outstanding. After Year 5, the adjusted cash flow from assets is expected to grow at 3.5 percent indefinitely. The company's WACC is 9.25 percent, and the tax rate is 22 percent. What is the price per share of the company's stock? $ $ 2,950,000 235,000 105,000 475,000 EBIT Depreciation Change in NWC Capital spending Increase per year EBIT Depreciation Change in NWC Capital spending Value of debt Shares outstanding Terminal growth rate WACO Sheet1 15% 20% 10% 20% 19,500,000 400,000 3.50% 9 259 $ B D E F G H Shares outstanding Terminal growth rate WACC Tax rate 400,000 3.50% 9.25% 22% Complete the following analysis. Do not hard code values in your calculations. P Year 1 Year 2 Year 3 Year 4 Year 5 5 26 27 EBIT Depreciation Taxes Capital spending Change in NWC ACFA 28 29 30 31 32 33 Year 6 ACFA Terminal value 35 Company value 36 37 38 39 40 Value of equity Price per share Sheet1 READY

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

Handbook Of Environmental And Sustainable Finance

Authors: Vikash Ramiah, Greg N. Gregoriou

1st Edition

012803615X, 978-0128036150

More Books

Students also viewed these Finance questions

Question

Types of Interpersonal Relationships?

Answered: 1 week ago

Question

Self-Disclosure and Interpersonal Relationships?

Answered: 1 week ago