Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do you complete this problem in excel? Dranky Movers expects to earn $100,000 this year. Earnings will grow 3% indefinitely if the firm makes

How do you complete this problem in excel?

Dranky Movers expects to earn $100,000 this year. Earnings will grow 3% indefinitely if the firm makes no new investments. The firms discount rate is 10%, and 250,000 shares are outstanding. What is the price per share of stock without the new line, assuming that all of the earnings are paid out as dividends?

Dranky has the opportunity to add a line of computer accessories to the business. The immediate outlay (t = 0) for this opportunity is $75,000 (obtained via a bank loan), and the earnings from the line will begin one year from now (t = 1). The computer accessories business will generate $25,000 in additional earnings at the end of the year (which also take into account the interest necessary to pay back the debt). These earnings will also grow at 3% indefinitely. What is the per-share-value of the growth opportunities (NPV) that the new line offers?

If the computer accessories line is added, what is the current value of the firms stock?

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

Financial Markets and Institutions

Authors: Frederic S. Mishkin, Stanley G. Eakins

8th edition

013342362X, 978-0133423624

More Books

Students also viewed these Finance questions