Reference no: EM13915277
Annette's Accessories had the following stock issued and outstanding at January 1, 2013:
150,000 shares of $1 par common stock
10,000 shares of $50 par, 8%, cumulative preferred stock
On March 5, 2013, Annette's declared a $100,000 cash dividend to be paid March 31 to shareholders of record on March 21.
Required
Set up a spreadsheet to calculate the total amount of dividends to be paid to preferred and common shareholders under the following alternative situations:
a. No dividends are in arrears for preferred shareholders.
b. One year's worth of dividends is in arrears for preferred shareholders.
c. Two years' worth of dividends is in arrears for preferred shareholders.
d. Instead of a $100,000 dividend, Annette's paid a $70,000 dividend and one year of dividends was in arrears.
Spreadsheet Tips
The following spreadsheet provides one method of setting up formulas for all possible alternatives. The spreadsheet also reflects the results of Requirement a.
.png)
Notice the use of the IF function. The IF function looks like =IF (condition, true, false). To use the IF function; first describe a certain condition to Excel. Next indicate the desired result if that condition is found to be true. Finally, indicate the desired result if that condition is found to be false. Notice in cell C4 of the spreadsheet (dividends in arrears distributed to preferred shareholders) that the condition provided is B4.
|
Calculate the payback period and Calculate the NPV
: McGilla Golf has decided to sell a new line of golf clubs. The clubs will sell for $730 per set and have a variable cost of $330 per set. The company has spent $143,000 for a marketing study that determined the company will sell 55,000 sets per year ..
|
|
What was the sales price per share of the
: a. What was the sales price per share of the original stock issue?
|
|
Some debt in its capital structure
: Sometimes, the management of a corporation will waste a firm’s resources on things like lavish office furnishings and a corporate jet. Is this behavior more likely to occur when the firm is 100% equity financed or when it has some debt in its capital..
|
|
N annuity is defined as series of payments of fixed amount
: An annuity is defined as a series of payments of a fixed amount for a specific number of periods. Thus, $100 a year for 10 years is an annuity, but $100 in Year 1, $200 in Year 2, and $400 in Years 3 through 10 does not constitute an annuity. However..
|
|
Set up a spreadsheet to calculate the total amount of divide
: Notice the use of the IF function. The IF function looks like =IF (condition, true, false). To use the IF function; first describe a certain condition to Excel. Next indicate the desired result if that condition is found to be true. Finally, indicate..
|
|
Preparing strategy audit report
: Using the tools and framework learned in class and throughout the program, prepare a 15-page strategy audit of your company with a companion presentation.
|
|
What can we do to build good credit scores
: What can we do to build good credit scores? In the long term and in the very short term? What does not work? What happens when one can’t pay one’s debt? What are the basics of bankruptcy proceedings?
|
|
Abstract and introduction
: Need paper done with 8-10 pages not including cover page or reference. Please include abstract and introduction, that's already two pages out of your 8-10 pages. Please be original but if you do use other work please paraphrase.
|
|
Compare the present value of economic profit
: Samantha Roberts has a job as a pharmacist earning $30,000 per year, and she is deciding whether to take another job as the manager of another pharmacy for $40,000 per year or to purchase a pharmacy that generates a revenue of $200,000 per year.Compa..
|