Normalize the following data by:

a) identifying the functional dependencies,

b) stating your assumptions, \

c) creating relations, and

d) identifying primary and foreign keys.

Customer Number| First Name |Last Name |Phone | Invoice Number| Date |Item Type |Quantity Item Price

Hillside issues $2,700,000 of 7%, 15-year bonds dated January 1, 2019, that pay interest semiannually on June 30 and December 31. The bonds are issued at a price of $2,333,101. Required: 1. Prepare the January 1 journal entry to record the bonds’ issuance. 2(a) For each semiannual period, complete the table below to calculate the cash payment. 2(b) For each semiannual period, complete the table below to calculate the straight-line discount amortization. 2(c) For each semiannual period, complete the table below to calculate the bond interest expense. 3. Complete the below table to calculate the total bond interest expense to be recognized over the bonds' life. 4. Prepare the first two years of a straight-line amortization table. 5. Prepare the journal entries to record the first two interest payments.

Prepare the January 1 journal entry to record the bonds’ issuance.

Record the issue of bonds with a par value of $2,700,000 cash on January 1, 2019 at an issue price of $2,333,101.

For each semiannual period, compute (a) the cash payment, (b) the straight-line discount amortization, and (c) the bond interest expense.

Complete the below table to calculate the total bond interest expense to be recognized over the bonds' life.

Prepare the first two years of a straight-line amortization table.

Record the first interest payment on June 30.

Hillside issues $1,000,000 of 6%, 15-year bonds dated January 1, 2019, that pay interest semiannually on June 30 and December 31. The bonds are issued at a price of $864,113. Required: 1. Prepare the January 1 journal entry to record the bonds’ issuance. 2(a) For each semiannual period, complete the table below to calculate the cash payment. 2(b) For each semiannual period, complete the table below to calculate the straight-line discount amortization. 2(c) For each semiannual period, complete the table below to calculate the bond interest expense. 3. Complete the below table to calculate the total bond interest expense to be recognized over the bonds' life. 4. Prepare the first two years of a straight-line amortization table. 5. Prepare the journal entries to record the first two interest payments.

Record the issue of bonds with a par value of $1,000,000 cash on January 1, 2019 at an issue price of $864,113.

For each semiannual period, compute (a) the cash payment, (b) the straight-line discount amortization, and (c) the bond interest expense.

Complete the below table to calculate the total bond interest expense to be recognized over the bonds' life.

Prepare the first two years of a straight-line amortization table.

Prepare the journal entries to record the first two interest payments.

The price of a bottle of beer is $1 and the price of a pizza is $10. The MRS of bottles of beer for pizza expressed by Karl is 5. Has Karl chosen the optimal amount of beer? How do you know? If Karl is not maximizing, what should he do to improve his situation? (Hint: what is the MRS at the consumer optimum point?)

*PLEASE PROVIDE ALL SOLUTIONS USING MICROSOFT EXCEL WITH ANY RELEVANT FORMULAS, thank you!*

You are an analyst in charge of valuing common stocks. You have been asked to value two stocks. The first stock AB Inc. just paid a dividend of $4.50. The dividend is expected to increase by 60%, 40%, 30% and 10% per year respectively in the next four years. Thereafter the dividend will increase by 4% per year in perpetuity.

The second stock is CD Inc. CD will pay its first dividend of $8 in 5 years. The dividend will increase by 40% per year for the following 3 years after its first dividend payment. Thereafter the dividend will increase by 3% per year in perpetuity.

Both stocks have a required rate of return of 25% per year for the next 2 years, and thereafter the required rate of return will be 10%.

1. Calculate AB’s expected dividend for t = 1, 2, 3, 4, and 5.
2. What is the current price of AB?
3. Calculate CD’s expected dividend for t = 1, 2, 3, 4, 5, 6, 7, 8 and 9.

What is the current price of CD?

Perform an EPS/EBIT Analysis for the Hershey Company

Problem Statement:

Hershey needs to raise $1Bn to build four new manufacturing plants outside the United States to implement their strategic plan. The Board of Directors and Executive Leadership team are evaluating how best to raise this capital. Complete an analysis to determine the best solution.

Currently, Hershey has the following input for the analysis:

Interest Rate:           3%

Tax Rate:           34%

Stock Price (January 2015)   $106

# of Shares Outstanding:   220Mn

EBIT in 2014 was $1.3Bn so evaluate options based on $1.0Bn and $2.0Bn. For the evaluation, they will consider 100% stock, 100% debt and 50/50 combination.

Prepare an EPS/EBIT analysis for Hershey using the above information.

What recommendation would you give the Board on the source of the capital required?

What recommendation would you give the Board for financing this project?

37. Suppose there is a competitive market for e-bikes that is in the long-run. If firms in the
e-bike market are not identical, then an increase in cost will
A) shift marginal cost to the right.
B) push the most inefficient firms out of the market.
C) push the most efficient firms out of the market.
D) There is not enough information to answer.
38. Suppose the company E-bikes R US is the sole supplier of e-bikes and produces 100
e-bikes. E-Bikes R US faces MC = 15 and MR = 17. If E-bikes R US produces 101 e-bikes,
then MC = 16 and MR = 15. To maximize profits, E-Bikes R US
A) should produce 100 units.
B) should produce 101 units.
C) The firm cannot maximize profits.
D) The firm is not a monopoly.
39. Suppose the company E-bikes R US is the sole supplier of e-bikes and faces the following
inverse demand: p = 100 - 2Q. Profit maximization
A) is achieved when 25 units are produced.
B) is achieved by setting price equal to 25.
C) is achieved only by shutting down in the short run.
D) cannot be determined solely from the information provided.
40. Suppose the company E-bikes R US is the sole supplier of e-bikes. The more elastic the
demand curve faced by E-bikes R US, the monopolist
A) will have a larger Lerner Index.
B) will face a lower marginal cost.
C) will earn more profit.
D) will lose more sales as it raises its price.
41. Suppose the company E-bikes R US is the sole supplier of e-bikes. As other e-bike firms
enter the market, the market power of E-bikes R US
A) is unaffected.
B) declines.
C) increases.
D) increases according to the Lerner Index but decreases according to the price/marginal cost
ratio.
42. Suppose the company E-bikes R US is the sole supplier of e-bikes and faces the following
inverse demand function: p = 100 - 2Q, and total cost is given by TC = 16q + 2. The
deadweight loss from E-bikes R US equals
A) $21.
B) $441.
C) $882.
D) $1,764.

Suppose the market is monopoly. The market demand function is Q subscript d equals 60 - 0.5 P, where p is the price. The firm has no fixed cost, and the marginal cost MC = 30. a. Write down the marginal revenue of this firm. b. Calculate the profit-maximizing monopolistic price and quantity. c. Calculate the profit of the firm. d. Calculate consumer surplus. After selling the products to the consumers in question (a)-(b), there are still other consumers in the market willing to buy this product at lower price. This firm is able to do price discrimination in the secondary market. e. Write down the demand function and marginal revenue in the secondary market. f. Calculate the price and quantity in the secondary market. g. Calculate the profit of the firm in the secondary market. h. Calculate consumer surplus in the secondary market. i. Show that the welfare loss is less when the firm is able to do price discrimination. You need to calculate the welfare loss before and after the price discrimination respectively. j. Calculate the price elasticity of demand in the first market and in the secondary market.

Mercer Asbestos Removal Company removes potentially toxic asbestos insulation and related products from buildings. There has been a long-simmering dispute between the company’s estimator and the work supervisors. The on-site supervisors claim that the estimators do not adequately distinguish between routine work, such as removal of asbestos insulation around heating pipes in older homes, and nonroutine work, such as removing asbestos-contaminated ceiling plaster in industrial buildings. The on-site supervisors believe that nonroutine work is far more expensive than routine work and should bear higher customer charges. The estimator sums up his position in this way: “My job is to measure the area to be cleared of asbestos. As directed by top management, I simply multiply the square footage by $2.80 to determine the bid price. Since our average cost is only $2.575 per square foot, that leaves enough cushion to take care of the additional costs of nonroutine work that shows up. Besides, it is difficult to know what is routine or not routine until you actually start tearing things apart.”

To shed light on this controversy, the company initiated an activity-based costing study of all of its costs. Data from the activity-based costing system follow:

Required:

1. Perform the first-stage allocation of costs to the activity cost pools.

2. Compute the activity rates for the activity cost pools.

3. Using the activity rates you have computed, determine the total cost and the average cost per thousand square feet of each of the following jobs according to the activity-based costing system.

a. A routine 1,000-square-foot asbestos removal job.

b. A routine 2,000-square-foot asbestos removal job.

c. A nonroutine 2,000-square-foot asbestos removal job.

Perform the first-stage allocation of costs to the activity cost pools.

Compute the activity rates for the activity cost pools.

Using the activity rates you have computed, determine the total cost and the average cost per thousand square feet of each of the following jobs according to the activity-based costing system. (Round the "Average Cost per thousand square feet" to 2 decimal places.)

a. A routine 1,000-square-foot asbestos removal job.
b. A routine 2,000-square-foot asbestos removal job.
c. A nonroutine 2,000-square-foot asbestos removal job.

Show less

Mercer Asbestos Removal Company removes potentially toxic asbestos insulation and related products from buildings. There has been a long-simmering dispute between the company’s estimator and the work supervisors. The on-site supervisors claim that the estimators do not adequately distinguish between routine work, such as removal of asbestos insulation around heating pipes in older homes, and nonroutine work, such as removing asbestos-contaminated ceiling plaster in industrial buildings. The on-site supervisors believe that nonroutine work is far more expensive than routine work and should bear higher customer charges. The estimator sums up his position in this way: “My job is to measure the area to be cleared of asbestos. As directed by top management, I simply multiply the square footage by $2.80 to determine the bid price. Since our average cost is only $2.315 per square foot, that leaves enough cushion to take care of the additional costs of nonroutine work that shows up. Besides, it is difficult to know what is routine or not routine until you actually start tearing things apart.”

To shed light on this controversy, the company initiated an activity-based costing study of all of its costs. Data from the activity-based costing system follow:

Required:

1. Perform the first-stage allocation of costs to the activity cost pools.

2. Compute the activity rates for the activity cost pools.

3. Using the activity rates you have computed, determine the total cost and the average cost per thousand square feet of each of the following jobs according to the activity-based costing system.

a. A routine 1,000-square-foot asbestos removal job.

b. A routine 2,000-square-foot asbestos removal job.

c. A nonroutine 2,000-square-foot asbestos removal job.

Perform the first-stage allocation of costs to the activity cost pools.

• Req 1

Compute the activity rates for the activity cost pools.

Using the activity rates you have computed, determine the total cost and the average cost per thousand square feet of each of the following jobs according to the activity-based costing system. (Round the "Average Cost per thousand square feet" to 2 decimal places.)

a. A routine 1,000-square-foot asbestos removal job.
b. A routine 2,000-square-foot asbestos removal job.
c. A nonroutine 2,000-square-foot asbestos removal job.

Show less