Question: Excel function please 2. A firm has a market value equal to its book value. Currently, the firm has excess cash of $400 and other

Excel function please

2. A firm has a market value equal to its book value. Currently, the firm has excess cash of $400 and other assets of $2,600. The firm is 100% financed through equity. The firm has 300 shares of stock outstanding. a. What is the stock price per share at the beginning, assuming the market value equal to book value? b. If the firm decides to spend all of its excess cash on a share repurchase program. How many shares of stock will be outstanding after the stock repurchase is completed? What will be the stock price per share? c. If the firm decides to spend all of its excess cash on a cash dividend program. How many shares of stock will be outstanding after the dividend is paid? What will be the stock price per share? 2. A firm has a market value equal to its book value. Currently, the firm has excess cash of $400 and other assets of $2,600. The firm is 100% financed through equity. The firm has 300 shares of stock outstanding. a. What is the stock price per share at the beginning, assuming the market value equal to book value? b. If the firm decides to spend all of its excess cash on a share repurchase program. How many shares of stock will be outstanding after the stock repurchase is completed? What will be the stock price per share? c. If the firm decides to spend all of its excess cash on a cash dividend program. How many shares of stock will be outstanding after the dividend is paid? What will be the stock price per share

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

2. A firm has a market value equal to its book value. Currently, the firm has excess cash of $600 and other assets of $5,400. Equity is worth $6,000. The firm has 400 shares of stock outstanding and...

2. A firm has a market value equal to its book value. Currently, the firm has excess cash of $400 and other assets of $2,600. The firm is 100% financed through equity. The firm has 300 shares of...

2. A firm has a market value equal to its book value. Currently, the firm has excess cash of $400 and other assets of $2,600. Equity is worth $3,000. The firm has 300 shares of stock outstanding....

1) It has been shown that in the absence of taxes and other market imperfections firm value will be unaffected by dividend policy. Explain the logic behind this conclusion. Next, describe three...

A firm has a market value equal to its book value. Currently, the firm has excess cash of $600 and other assets of $5,400. Equity is worth $6,000. The firm has 500 shares of stock outstanding and net...

(please fast!) A firm has a market value equal to its book value. Currently, the firm has excess cash of $500 and other assets of $7,000. Equity is worth $7,500. The firm has 750 shares of stock...

1)A firm has a market value equal to its book value. Currently, the firm has excess cash of $900, other assets of $5,100, and equity of $6,000. The firm has 600 shares of stock outstanding and net...

1. The Spartan Co. has an unlevered cost of capital of 11%, a cost of debt of 8%, and a tax rate of 25%. What is the target debt-equity ratio if the targeted cost of equity is 12%?* (2 Points) 00: 2....

1. Which one of the following is a capital budgeting decision? A. determining how much debt should be borrowed from a particular lender *B. deciding whether or not to open a new store C. deciding...

2. A firm has a market value equal to its book value. Currently, the firm has excess cash of $300 and other assets of $1,700. The firm is 100% financed through equity. The firm has 200 shares of...

Which function definition will run correctly? int sum(int a, int b) return (a + b); Both (a) and (b) int sum(a, b) return (a + b); int sum(int a, int b) { return (a + b); }

Repeat Prob. 6.13 except for y = x2 + 1, y = 2 cos x

Various types of accounting changes can affect the auditor s report. a . Briefly describe the rationale for having accounting changes affect the auditor s report and the auditor s responsibility in...

Urgente- Pulgares arriba por la respuesta Burlington Wholesale Inc. tuvo las siguientes transacciones de inventario durante un mes. La empresa utiliza un sistema perpetuo y FIFO. Todas las compras y...