custom writing services

Need help: Write an email to our support staff or

whatsapp us

order order
Average score 4.97 out of 5 based on 836 opinions

Can some good pro* help me with my questions. Case 1 resit


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 2013 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.



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


·         Growth in EBIT is expected to be 3% annually.


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


·         The Company’s current re, cost of equity capital, is 10%.


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


·         Today is the 1st of January 2013.


Dividends and shares


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

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


Cost of dividends


·         The transaction cost for issuing dividends amounts to $10 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 2013 and 2014 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 2013, 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.

Finally, since your friend wants to be able to use this spreadsheet in the future as well you need to use cell references in the formulas (for a, b and c above).



Need an answer from similar question?Click here and get a solution now

order You have just landed to the most confidential, trustful essay writing service to order the paper from. We have a dedicated team of professional writers who will assist you with any kind of assignment that you have. Your work is handled confidentially with a specific writer who ensures you are satisfied. Be assured of quality, unique and price friendly task delivered in good time when you place an order at our website. banner We have a team of dedicated writers with degrees from all spheres of study. We readily accept all types of essays and we assure you of content that will meet your expectations. Our staff can be reached  via live chat, email or by phone at any given time with prompt response.  

Prices starting at:

High school
Undergrad.(yrs 1-2)
Undergrad.(yrs 3-4)
$10 / page
$10/ page
$12/ page
$15 / page
$17/ page

Note: The prices in the table above are applicable to orders completed within 14 days. Kindly see the full price table for more prices..

We urge you to provide as much information as possible to avoid many revisions. Set your deadline, choose your level, give payment information and relax while you track your work. We will deliver your paper on time. Are you in a quagmire and you are unable to complete your assignments? Do you doubt yourself on the quality of the essay you have written?  is here to assist you. We will offer you unmatched quality that is plagiarism free. Place an order at  for guaranteed  high grades. order download

we offer gifts to our paper help customersPayment Methods

you can request our services and pay via paypal

we offer gifts to our paper help customersOur Guarantees

  1. Zero plagiarism.
  2. 100% confidentiality.
  3. FREE Reference page
  4. High Quality papers
  5. 24/7 Customer support

Our Testimonials Testimonials

I ordered a 7 page college essay and was delivered on time. Thank you guys I will definitely order again!

, FL

Our statisticsOur Statistics

  • Orders Completed todate 72387

  • Number of writers 500

  • Satisfied customers 99.7%

  • Returning customers 92.3%

  • Orders placed today 87