Questions
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...

Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page.

A firm that is in the 35% tax bracket forecasts that it can retain $4 million of new earnings plans to raise new capital in the following proportions:

60% from 30-year bonds with a flotation cost of 4% of face value. Their current bonds are selling at a price of 91 (91% of face value), have 4 years remaining, have an annual coupon of 7%, and their investment bank thinks that new bonds will have a 40 basis point (0.40%) higher yield-to-maturity than their current 4-year bonds due to their longer term. Any new bonds will be sold at par.
10% from preferred stock with a flotation cost of 5% of face value. The firm currently has an outstanding issue of $30 face value fixed-rate preferred stock with an annual dividend of $2 per share, and the stock is currently selling at $27 per share. Any newly issued preferred stock will continue with the $30 par-value, and will continue with the $2 dividend.
30% from equity. Their common dividend payout ratio is 60%, they paid a dividend of $1.59 per share yesterday, the dividend is expected to grow to $4.22 in 20 years, and is expected to continue this growth rate into the foreseeable future. The common stock has a current market price of $19, and their investment banker suggests a flotation cost of 7% of market value on new common equity.

Part 1: Calculate the after-tax cost of the new bond financing. ___________


Part 2: Calculate the after-tax cost of the new preferred stock financing. ______


Part 3: Calculate the after-tax cost of retained earnings financing. _______


Part 4: Calculate the after-tax cost of the new common equity financing. ______


Part 5: Calculate the company's WACC using retained earnings as the source of equity. __________


Part 6: Calculate the break point in the cost of capital schedule due to running out of retained earnings. __________


Part 7: Calculate the company's WACC after it substitutes the new common stock issue for retained earnings after it runs out of retained earnings. _________


Part 8: If the bonds had an after tax cost of 5.2% rather than the number you calculated in part #1 above, what would be the WACC using retained earnings as the source of equity?


Part 9: If you have done the calculations above correctly, the after-tax cost of debt for this company is lower than the cost of equity when using retained earnings as the equity source. Explain why raising capital by borrowing is less costly than using your own funds on which you do not have to pay any interest at all.


Part 10: Briefly explain the conceptual difference between the after-tax cost of retained earnings and the after-tax cost of new common stock.

please show how work was done through excel

In: Accounting

Franklin purchases 40 percent of Johnson Company on January 1 for $604,600. Although Franklin did not...

Franklin purchases 40 percent of Johnson Company on January 1 for $604,600. Although Franklin did not use it, this acquisition gave Franklin the ability to apply significant influence to Johnson’s operating and financing policies. Johnson reports assets on that date of $1,518,000 with liabilities of $598,000. One building with a seven-year remaining life life is undervalued on Johnson’s books by $311,500. Also, Johnson’s book value for its trademark (10-year life) is undervalued by $280,000. During the year, Johnson reports net income of $112,000 while declaring dividends of $50,000. What is the Investment in Johnson Company balance (equity method) in Franklin’s financial records as of December 31?

a. $618,200.

b. $600,400.

c. $629,400.

d. $645,200.

In: Accounting

Franklin purchases 40 percent of Johnson Company on January 1 for $601,700. Although Franklin did not...

Franklin purchases 40 percent of Johnson Company on January 1 for $601,700. Although Franklin did not use it, this acquisition gave Franklin the ability to apply significant influence to Johnson’s operating and financing policies. Johnson reports assets on that date of $1,554,000 with liabilities of $582,000. One building with a seven-year remaining life life is undervalued on Johnson’s books by $222,250. Also, Johnson’s book value for its trademark (10-year life) is undervalued by $310,000. During the year, Johnson reports net income of $96,000 while declaring dividends of $40,000. What is the Investment in Johnson Company balance (equity method) in Franklin’s financial records as of December 31?

A) $599,000

B) $637,400

C) $611,700

D) $624,100

In: Accounting

QUESTION 2 Consider the following four--?step assembly operation with quality problems. -The first resource has a...

QUESTION 2

Consider the following four--?step assembly operation with quality problems.

-The first resource has a processing time of 7 minutes per unit and one employee doing the operation

? The second resource has a processing time of 4 minutes per unit.  It also has one employee doing the operation. However, this is a very delicate task and 0.79 of all products have to be scrapped after this step.

? Two workers are staffed for the third resource. No quality problems occur at this resource and the processing time is 17minutes per unit.

? At the fourth and final resource, one operator handles the product. No quality problems exist at this step and the processing time is 12 minutes per unit.

What is the process capacity per hour? (keep two decimal)

In: Operations Management

A statistical program is recommended. A study investigated the relationship between audit delay (Delay), the length...

A statistical program is recommended.

A study investigated the relationship between audit delay (Delay), the length of time from a company's fiscal year-end to the date of the auditor's report, and variables that describe the client and the auditor. Some of the independent variables that were included in this study follow.

Industry A dummy variable coded 1 if the firm was an industrial company or 0 if the firm was a bank, savings and loan, or insurance company.
Public A dummy variable coded 1 if the company was traded on an organized exchange or over the counter; otherwise coded 0.
Quality A measure of overall quality of internal controls, as judged by the auditor, on a five-point scale ranging from "virtually none" (1) to "excellent" (5).
Finished A measure ranging from 1 to 4, as judged by the auditor, where 1 indicates "all work performed subsequent to year-end" and 4 indicates "most work performed prior to year-end."

A sample of 40 companies provided the following data.

Delay Industry Public Quality Finished
62 0 0 3 1
45 0 1 3 3
54 0 0 2 2
71 0 1 1 2
91 0 0 1 1
62 0 0 4 4
61 0 0 3 2
69 0 1 5 2
80 0 0 1 1
52 0 0 5 3
47 0 0 3 2
65 0 1 2 3
60 0 0 1 3
81 1 0 1 2
73 1 0 2 2
89 1 0 2 1
71 1 0 5 4
76 1 0 2 2
68 1 0 1 2
68 1 0 5 2
86 1 0 2 2
76 1 1 3 1
67 1 0 2 3
57 1 0 4 2
55 1 1 3 2
54 1 0 5 2
69 1 0 3 3
82 1 0 5 1
94 1 0 1 1
74 1 1 5 2
75 1 1 4 3
69 1 0 2 2
71 1 0 4 4
79 1 0 5 2
80 1 0 1 4
91 1 0 4 1
92 1 0 1 4
46 1 1 4 3
72 1 0 5 2
85 1 0 5 1

(a)

Develop the estimated regression equation using all of the independent variables. Use x1 for Industry, x2 for Public, x3 for Quality, and x4 for Finished. (Round your numerical values to two decimal places.)

ŷ =

(b)

Did the estimated regression equation developed in part (a) provide a good fit? Explain. (Use α = 0.05. For purposes of this exercise, consider an adjusted coefficient of determination value high if it is at least 50%.)

Yes, testing for significance shows that the overall model is significant and all the individual independent variables are significant.No, the low value of the adjusted coefficient of determination does not indicate a good fit.    Yes, the low p-value and high value of the adjusted coefficient of determination indicate a good fit.No, testing for significance shows that all independent variables except Public are not significant.

(c)

Develop a scatter diagram showing Delay as a function of Finished.

A scatter diagram has 40 points. The horizontal axis ranges from 0 to 5 and is labeled: Finished. The vertical axis ranges from 30 to 100 and is labeled: Delay. All the points fall at either 1, 2, 3, or 4 on the horizontal axis, forming 4 columns of points. Moving from left to right, the top point of the first column of points is located at approximately (1, 94). The top points of all subsequent columns extend downward in a diagonal direction. The bottom points of each column follow this same pattern.

A scatter diagram has 40 points. The horizontal axis ranges from 0 to 5 and is labeled: Finished. The vertical axis ranges from 30 to 100 and is labeled: Delay. All the points fall at either 1, 2, 3, or 4 on the horizontal axis, forming 4 columns of points. Moving from left to right, the top point of the first column of points is located at approximately (1, 92). The top points of the next two columns extend slightly upward in a diagonal direction. The top point of the last column extends downward from the top point of the previous column. Moving from left to right, the bottom point of the first column is located at approximately (1, 54). The bottom point of the next column extends downward. From this point, the bottom two points of the last two columns extend upward in a diagonal direction.

A scatter diagram has 40 points. The horizontal axis ranges from 0 to 5 and is labeled: Finished. The vertical axis ranges from 30 to 100 and is labeled: Delay. All the points fall at either 1, 2, 3, or 4 on the horizontal axis, forming 4 columns of points. Moving from left to right, the top point of the first column of points is located at approximately (1, 94). The top points of the next two columns extend downward in a diagonal direction. The top point of the last column extends upward from the top point of the previous column. The bottom points of each column follow this same pattern.

A scatter diagram has 40 points. The horizontal axis ranges from 0 to 5 and is labeled: Finished. The vertical axis ranges from 30 to 100 and is labeled: Delay. All the points fall at either 1, 2, 3, or 4 on the horizontal axis, forming 4 columns of points. Moving from left to right, the top point of the first column of points is located at approximately (1, 60). The top points of all subsequent columns extend upward in a diagonal direction. The bottom points of each column follow this same pattern.

What does this scatter diagram indicate about the relationship between Delay and Finished?

The scatter diagram suggests no relationship between these two variables.The scatter diagram suggests a linear relationship between these two variables.     The scatter diagram suggests a curvilinear relationship between these two variables.

(d)

On the basis of your observations about the relationship between Delay and Finished, use best-subsets regression to develop an alternative estimated regression equation to the one developed in (a) to explain as much of the variability in Delay as possible. Use x1 for Industry, x2 for Public, x3 for Quality, and x4 for Finished. (Round your numerical values to two decimal places.)

ŷ =

In: Statistics and Probability

Construct a 99% confidence interval for u1 - u2. Two independent samples selected from two populations...

Construct a 99% confidence interval for u1 - u2. Two independent samples selected from two populations

n1=40, x̄ =28.4, s1=4.1

n2=32, x̄= 25.6, s2=4.5

In: Statistics and Probability

Consider two bonds. Each has a face value of $1000 and matures in 5 years. One...

Consider two bonds. Each has a face value of $1000 and matures in 5 years. One has no coupon payment, and the other pays $100 per year. Calculate the present value of each bond if the interest rate is 4 percent and if the interest rate is 8 percent. (Show Work)

In: Finance

business law 8. Marilyn, George, and Christine pool their money to buy land to operate a...

business law

8. Marilyn, George, and Christine pool their money to buy land to operate a vegetable farm from which they plan to sell the produce and share the profits or losses. Are they partners?

a. Yes. They are an association to carry on a for profit business which they own.

b. No. Because they each control the use of the land.

c. Yes. Because if there is a loss in the land's value, they will all share that loss.

d. No. They are merely joint venturers.

9. Mount Pleasant Tires does not have sufficient funds to pay damages for a tort that arose out of the operation of the business. Jess, a business owner, is personally liable if:

a. He is a sole proprietor of the business.

b. The business is a corporation and he is a shareholder.

c. He committed the tort.

d. He is a general partner of the business.

e. Two of the above (a through d)

f. Three of the above (a through d)

10. Sue, Barb, and Carlotta agree to put in $1,000 each to set up a shelter for lost animals. They each work two days a week. Donations fund the day-to-day operations. Do they have a partnership?

a. Yes, since each has control of the operation.

b. Yes, because they are all co-equals in ownership of the shelter.

c. No, because they have made no formal agreement.

d. No, because there is no business for profit.

In: Finance

Exercise 1. The following information is available for company ABC as of 31December N: Land                   500...

Exercise 1. The following information is available for company ABC as of 31December N:

Land                   500
Additional paid in capital (share premium)         150
Advance payments to suppliers (from which for inventories 200)             300
Licenses             50
Customers         600
Prepayments     80
Legal reserve     70
Dividends payable          100
Depreciation of plant and machinery     50
Investments in associates                        700
Issued capital paid in (Share capital paid in)       ??
Sundry debtors               100
Raw materials                 60
Plant and machinery      700
Long term bank loans (of which becoming due in less than one year 150)        525
Write downs of raw materials                 5
Cash at bank     30
Provisions for guarantees to customers               500
VAT payable                   50
Long term receivables   100
Buildings                         300
Development costs (assets recognition criteria are fulfilled)             100
Other reserves                700
Salaries payable             200
Depreciation of buildings           50
Short term bank loans                150
Finished goods               180
Profit for the period       250
Advances received from customer          100
Short term financial investments            150
Suppliers payable           100
Bills of exchange payable            30
Other taxes payable      50
Deferred income (venituri amanate)      100

Required:
a. Draw up the balance sheet
b. Calculate issued capital (paid in capital).

Exercise 2. Using the following elements prepare an income statement by function and by nature (you must obtain the same result with both method.

  1. Personal expenses 650

a.1. for production 400

a.2. for distribution 150

a.3. for administration 100

  1. Interest expenses 40
  2. row material expenses 150
  3. income tax expenses 150
  4. merchandise expenses 10
  5. consumable expenses 300

f.1. for production 200

f.2. for distribution 70

f.3. for administration 30

  1. Finish goods revenues 1.400
  2. Other op expenses.210
  3. Financial expenses 46
  4. Other taxes expenses 20
  5. Finish goods -31.12.N 200
  6. Costs CSS 210:

l.1. for production 130

l.2. for distribution 50

l.3. for administration 30

  1. INTEREST REVENUE 60
  2. Services expenses 10
  3. other financial revenue 10
  4. seles revenue 50
  5. depreciation expenses 250

q.1. for production 180

q.2. for distribution 20

q.3.for administration 50

  1. revenue from dividends 120

In: Accounting

Performing Monohybrid Crosses A monohybrid cross is addressing the inheritance of one gene. Answer the following...

Performing Monohybrid Crosses

A monohybrid cross is addressing the inheritance of one gene. Answer the following questions:

Question 1:

Drosophila melongaster, more commonly known as the fruit fly, can have red or white eyes. You breed a red-eyed fly to a white-eyed fly and get 50 offspring that all have red eyes. Which trait is dominant?

Question 2:

Consider an offspring from the previous question. Its phenotype is red eyes.

What is its genotype? (Circle one of the choices below)

Homozygous dominant, Heterozygous, or Homozygous recessive

Question 3: (2pts)

Next, you perform a cross of two heterozygous, red-eyed flies. They have 100 offspring. How many of these offspring do you predict will have red eyes? Show your work using a Punnett square. [Use letters R and r to designate the alleles]

Question 4:

Suppose you found a fly that had escaped and was flying around your lab. He has red    eyes, but you do not know his genotype. To find out, you cross him with a white eyed fly (since you know her genotype). The result is 50% white eyed and 50% red eyed offspring. What is the escaped fly’s genotype? Explain how you know.

X-linked Inheritance

Consider this imaginary animal, the tree rat. They are usually black, but sometimes they can be purple. The allele for the purple color is X-linked. You manage to capture two of these animals from the same family, a black female and her purple male offspring.

Question 5:

What is the genotype of the black female mother?

Question 6

Do you know the phenotype of the father based on the male offspring? Why or why not?

Question 7: (2pts)

Next you breed the tree rats to each other (inbreeding is acceptable in this case). What percent of the offspring do you expect to be purple? Are any of them female? Use a Punnett square to show your work. [Use the letters B (black) and b (purple) to represent the alleles.]

In: Biology