Financial Accounting problems done in xcel worksheet.
Instructions
NAME: | |
To complete the homework assignments in the templates provided: | |
1. | The question is provided for each problem. You may need to refer to your textbook for additional information in a few cases. |
2. | You will enter the required information into the shaded cells. |
3. | The cells are coded: |
a) | T |
b) | C |
c) F requires a number only. In some problems, a “Step 1” is added to help you solve the problem. | |
d) Formula requires a written formula, not the numbers. For example, the rate of return = [(1 + nominal)/ (1+inflation)]-1, or D (debt) + E (equity) = V (value). | |
4. | Name your assignment file as “lastnamefirstinitial-FINC600-Week#”, and submit by midnight ET, Day 7. |
P12-6
Problem 12-6 | ||||
Here are key financial data for House of Herring, In | c. | |||
Earnings per share for 2015 | $5.50 | |||
Number of shares outstanding | 40 million | |||
Target payout ratio | 50% | |||
Planned dividend per share | $2.75 | |||
Stock price | $130 | |||
House of Herring plans to pay the entire dividend early in January 2016. All corporate and personal taxes were repealed in 2014. | a. | b. | ||
Answers: | ||||
Calculation | ||||
$127.25 | ||||
$130.00 | ||||
Shares repurchased | 846154 | |||
Ex-dividend price | $124.50 | |||
Shares needed | 883534 |
Instructions: Please refer to your book for assistance with your homework. Post your work in the worksheet. Highlight your final answer.
Principles of Corporate Finance, Concise, 2nd Edition
P12-12
Problem 12-12 | ||
Respond to the following comment: “It’s all very well saying that I can sell shares to cover cash needs, but that may mean selling at the bottom of the market. If the company pays a regular cash dividend, investors avoid that risk.” | ||
Answer: | ||
Instructions: Please refer to your book for assistance with your homework. Post your work in the worksheet. Highlight your final answer.
P13-11
Problem 13-11 | ||
Executive Chalk is financed solely by common stock and has outstanding 25 million shares with a market price of $10 a shar | e. | d. |
The announcement will make the price go up. | ||
The original share holders will gain as the possibility of the stocks going up. |
Instructions: Please refer to your book for assistance with your homework. Post your work in the worksheet. Highlight your final answer.
P13-14
Problem 13-14 | |
“MM totally ignore the fact that as you borrow more, you have to pay higher rates of interest.” Explain carefully whether this is a valid objection. | |
Valid Objection – Yes or | No |
This is not a valid objection. MMs Proposition II explicitly allows for the rates of return for both debt and equity to increase as the proportion of debt in the capital structure increases. The rate for debt increases because the debt-holders are taking on more of the risk of the firm; the rate for common stock increases because of increasing financial leverage. |
Instructions: Please refer to your book for assistance with your homework. Post your work in the worksheet. Highlight your final answer.