Create a spreadsheet model

Assignment Help Finance Basics
Reference no: EM13940217

Case

A friend of yours is the CEO of a company called CSR delivering corporate social responsibility solutions. The company has grown quickly and it is since the 1st of January 2015 noted on the Stockholm Stock Exchange. Your friend knows you are a finance specialist and therefore consults you to analyze whether or not the company shall pay yearly dividends or not to its shareholders.

General

• The company has until now made yearly earnings before interest and taxes (EBIT) of $1.5million.

• Growth in EBIT is expected to be 4% annually.

• The corporate tax rate is expected to be 25% per year forever.

• The Company's current re, cost of equity capital, is 12%.

• The company expects to make profits for the next 10 years and then make zero profits forever.

• Today is the 1st of January 2015. Dividends and shares

• The total number of shares outstanding is 1 000 and the number is expected to remain fixed forever.

• The company considers paying no dividends at all, paying dividends of $100 per share and year or paying dividends of $200 per share and year.

Cost of dividends

• The transaction cost for issuing dividends amounts to $5 per share and dividend.

• There are no legal costs associated with dividends.

Your task

Your task is to create a spreadsheet model (using Microsoft Excel) showing your friend which alternative is to prefer. In particular your friend wants you to show her the following in the spreadsheet model:

a) Show by calculation what would be the price per share today for each of the three dividend alternatives (no dividend, $100 dividend, $200 dividend). Also, given the information above, explain which of the three alternatives the company (CSR) should choose in order to maximize company value.

b) Now assume that instead of paying dividends for years 2015 and 2016 the company can choose to invest today the amount equivalent to those two dividend payouts. The investment opportunity implies putting money into a financial security that will yield a 12% return per year for the next 10 years. Should the company make the investment or not in order to maximize company value? Show by computation!

c) Now assume a perfect capital market (according to Modigliani & Miller). The company considers repurchasing 100 shares today, January 1st 2015, instead of using that amount of money to pay dividends. Should the company repurchase shares or pay out dividends in order to maximize company value? Show by computation.

Reference no: EM13940217

Questions Cloud

Make for economy to sustain economic growth : What recommendations, i.e. future strategic direction, would you make for the economy (country) to sustain economic growth? Word limit 1000 words.  Learning Outcome: 4 & 5
What is the market value oft he firm after the recap : All equity business has 100 million shares outstanding selling for $20 a share. Management believes interest rates are unreasonably low and decides to execute a leverages recapitalization. It will raise $1 billion in debt and repurchase 50 million sh..
Momentum in business and public debate : Corporate Responsibility (or CSR) has gained unprecedented momentum in business and public debate and has become a strategic issue crossing discipline boundaries and affecting the way in which a company does business.
Geographic markets are the companies : What geographic markets are the companies located in? When did they invest in these markets? Did they follow any specific patterns when entering these markets?
Create a spreadsheet model : Your task is to create a spreadsheet model (using Microsoft Excel) showing your friend which alternative is to prefer. In particular your friend wants you to show her the following in the spreadsheet model: Show by calculation what would be the p..
The dividend projected to be growing : Shares of SoHot Donuts common stock are currently selling for $15. Next year’s dividend is expected to be $1.50 per share and the market rate of return is 10%. At what rate is the dividend projected to be growing?
Explain concept of decoupled organization as it relates : Large organizations face the threat of becoming decoupled. Explain the concept of a decoupled organization as it relates to a criminal justice agency. Discuss some of the challenges that decoupling presents and strategies utilized by criminal just..
Equity prior to the announcement is expected gain or loss : FARO Technologies, whose products include portable 3D measurement equipment, recently had 17 million shares outstanding trading at $42 a share. Suppose the company announces its intention to raise $200 million by sell new shares. What do market signa..
Draft compliance matrix and compliant proposal to rfp : Create a compliance matrix and prepare a FAR-compliant proposal in response to the RFP from Assignment 2. Note: You may create and /or assume all necessary assumptions needed for the completion of this assignment.

Reviews

Write a Review

Finance Basics Questions & Answers

  How much will rocky pay in tuition his first year of school

In two years Rocky plans to enroll at Whatsamatta U., a prestigious university in Frostbite Falls, MN. If the current tuition is $23,500 per year and is expected to increase at a rate of 6% per year, how much will Rocky pay in tuition his first ye..

  What rate of return is required to meet his goal

Assuming no additional deposits, if he currently has $6,000 in an intermediate-term bond fund earning a 5 percent yield, will he reach his goal? If not, what rate of return is required to meet his goal?

  Computation of price of the bonds

Computation of Price of the bonds and What is an estimate of the price of the annual coupon bond

  Show items considered capital expenditures for the new

show items considered capital expenditures for the new business startup.do research to evaluates costs of these capital

  The primary weakness of ebit-eps analysis is that

The primary weakness of EBIT-EPS analysis is that

  If she can earn 65 percent compounded annually on her

maria addaihas been offered a future payment of 750 two years from now. if she can earn 6.5 percent compounded

  The process of industrialization was one of the most

the process of industrialization was one of the most transformational series of events in human

  What are the four chief categories of real

what are the four chief categories of real

  The project costs 1000 and returns a rate of return of 8

your borrowing rate is 10year. your lending rate is 4year. the project costs 1000 and returns a rate of return of 8.

  What is amc share price after the repurchase if its

Suppose AMC waits until after the news comes out to do the share repurchase. What is AMC’s share price after the repurchase if its enterprise value goes up? What is AMC’s share price after the repurchase if its enterprise value declines?

  Determine the value of the position at expiration and the

consider a bond selling for 98 per 100 face value. a call option selling for 8 has an exercise price of 105. answer

  What is the amount of free trade credit that langley obtains

what is the amount of free trade credit that langley obtains from Consolidated Services?(assume 360 days per year throughout this problem)

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd