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

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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