Williams Company, located in southern Wisconsin, manufactures a variety of industrial valves and pipe fittings that are sold to customers in nearby states. Currently, the company is operating at about 70% capacity and is earning a satisfactory return on investment. Glasgow Industries Ltd. of Scotland has approached management with an offer to buy 120,000 units of a pressure valve. Glasgow Industries manufactures a valve that is almost identical to Williams’ pressure valve; however, a fire in Glasgow Industries’ valve plant has shut down its manufacturing operations. Glasgow needs the 120,000 valves over the next 4 months to meet commitments to its regular customers; the company is prepared to pay $21 each for the valves. Williams’s product cost for the pressure valve, based on current attainable standards, follows: Direct materials $ 6 Direct labor (0.5 hour per valve) 8 Manufacturing overhead (1/3 variable) 9 Total manufacturing cost $ 23 Additional costs incurred in connection with sales of the pressure valve are sales commissions of 5% and freight expense of $1 per unit. However, the company does not pay sales commissions on special orders that come directly to management. Freight expense will be paid by Glasgow. In determining selling prices, Williams adds a 40% markup to product cost. This provides a $32 suggested selling price for the pressure valve, rounded to the nearest whole dollar. The marketing department, however, has set the current selling price at $30 to maintain market share. Production management believes that it can handle the Glasgow Industries order without disrupting its scheduled production. The order would, however, require additional fixed factory overhead of $12,000 per month in the form of supervision and clerical costs. If management accepts the order, Williams will manufacture and ship 30,000 pressure valves to Glasgow Industries each month for the next 4 months. Shipments will be made in weekly consignments, FOB shipping point. Required: 1. Determine how many additional direct labor hours (DLHs) will be required each month to fill the Glasgow order. 2. Prepare an analysis showing the impact on operating income of accepting the Glasgow order. 3. Calculate the minimum unit price that Williams’ management could accept for the Glasgow order without reducing operating income. 4. To prove your answer to Requirement 3, use the Goal Seek function in Excel to calculate the minimum unit selling price for the special sales order. 5. Suppose now that if the Glasgow order were accepted, sales of 5,000 units per month to regular customers would be precluded (at a selling price of $30 per unit). All other facts are as given in this problem. What is the revised breakeven selling price per unit for the Glasgow special sales order?
In: Accounting
Activity-Based Costing for a Service Company
Bounce Back Insurance Company carries three major lines of
insurance: auto, workers' compensation, and homeowners. The company
has prepared the following report:
| Bounce Back Insurance Company Product Profitability Report For the Year Ended December 31 |
|||||
| Auto | Workers' Compensation | Homeowners | |||
| Premium revenue | $5,800,000 | $6,250,000 | $8,200,000 | ||
| Estimated claims | (4,060,000) | (4,375,000) | (5,740,000) | ||
| Underwriting income | $1,740,000 | $1,875,000 | $2,460,000 | ||
| Underwriting income as a percent of premium revenue | 30% | 30% | 30% | ||
Management is concerned that the administrative expenses may
make some of the insurance lines unprofitable. However, the
administrative expenses have not been allocated to the insurance
lines. The controller has suggested that the administrative
expenses could be assigned to the insurance lines using
activity-based costing. The administrative expenses are comprised
of five activities. The activities and their rates are as
follows:
| Activity | Activity Rates |
| New policy processing | $110 per new policy |
| Cancellation processing | $180 per cancellation |
| Claim audits | $330 per claim audit |
| Claim disbursements processing | $100 per disbursement |
| Premium collection processing | $25 per premium collected |
Activity-base usage data for each line of insurance were
retrieved from the corporate records as follows:
| Auto | Workers' Compensation | Homeowners | ||||||
| Number of new policies | 1,330 | 1,400 | 4,100 | |||||
| Number of canceled policies | 490 | 300 | 2,200 | |||||
| Number of audited claims | 390 | 110 | 950 | |||||
| Number of claim disbursements | 470 | 220 | 850 | |||||
| Number of premiums collected | 8,500 | 1,900 | 15,200 | |||||
a. Complete the product profitability report through the administrative activities. Determine the operating income as a percent of premium revenue. Rounded to the nearest whole percent.
| Bounce Back Insurance Company | |||
| Product Profitability Report | |||
| For the Year Ended December 31 | |||
| Auto | Workers' Comp. | Homeowners | |
| Premium revenue | $ | $ | $ |
| Estimated claims | |||
| Underwriting income | $ | $ | $ |
| Administrative activities: | |||
| New policy processing | $ | $ | $ |
| Cancellation processing | |||
| Claim audits | |||
| Claim disbursements processing | |||
| Premium collection processing | |||
| Total administrative expenses | $ | $ | $ |
| Operating income | $ | $ | $ |
| Operating income as a percent of premium revenue | % | % | % |
In: Accounting
Question from chapter 2 -3rtDa
| 2006-2015 | 2016-2025 | 2026-2035 | 2036-2045 | 2046-2055 | 2056-2065 | 2066-2075 | 2076-2081 | |
| Revenues | 1,746.60 | 2,604.60 | 3,908.20 | 5,453.60 | 7,588.60 | 10,749.00 | 14,656.20 | 11,797.90 |
| Expenditures | ||||||||
| General operating | 468.80 | 771.00 | 1,267.80 | 2,084.90 | 3,428.60 | 5,638.30 | 9,272.10 | 8,227.90 |
| Repairs and renovations | 577.80 | 705.20 | 839.40 | 1,011.20 | 1,231.20 | 1,512.70 | 1,873.10 | 1,337.80 |
| Total expenditures | 1,046.60 | 1,476.20 | 2,107.20 | 3,096.10 | 4,659.80 | 7,151.00 | 11,145.20 | 9,565.70 |
| Revenues over expenditures | 700.00 | 1,128.40 | 1,801.00 | 2,357.50 | 2,928.80 | 3,598.00 | 3,511.00 | 2,232.20 |
In 2006 the State of Indiana in the USA sold a 75-year concession to operate and maintain the East-West Toll Road. Before doing so, it commissioned a consulting report that estimated the value of the concession.
Q: Calculate the present value of the concession using a discount rate of 6%. Cash flows are reported in Table 1 for each ten-year block up until 2066–2075 with the last block as five years (2076–2081). Assume in your calculations that cash flows are spread evenly during those blocks.
In: Finance
Calculate:
1) Covariance
2) Expected return on a portfolio XY
2) Risk on a portfolio XY
Weight of each asset is 50%.
Average annual return:
asset X: 11.74%
asset Y: 11.14%
Standard deviation:
asset X: 8.9
asset Y: 2.78
| Asset X | |||
| Value | |||
| Year | Cash Flow | Beginning | Ending |
| 2006 | $1,000 | $20,000 | $22,000 |
| 2007 | 1500 | 22000 | 21000 |
| 2008 | 1400 | 21000 | 24000 |
| 2009 | 1700 | 24000 | 22000 |
| 2010 | 1900 | 22000 | 23000 |
| 2011 | 1600 | 23000 | 26000 |
| 2012 | 1700 | 26000 | 25000 |
| 2013 | 2000 | 25000 | 24000 |
| 2014 | 2100 | 24000 | 27000 |
| 2015 | 2200 | 27000 |
30000 |
| Asset Y | |||
| Ending | |||
| Year | Cash Flow | Beginning | Ending |
| 2006 | $1,500 | $20,000 | $20,000 |
| 2007 | 1600 | 20000 | 20000 |
| 2008 | 1700 | 20000 | 21000 |
| 2009 | 1800 | 21000 | 21000 |
| 2010 | 1900 | 21000 | 22000 |
| 2011 | 2000 | 22000 | 23000 |
| 2012 | 2100 | 23000 | 23000 |
| 2013 | 2200 | 23000 | 24000 |
| 2014 | 2300 | 24000 | 25000 |
| 2015 | 2400 | 25000 | 25000 |
In: Finance
On July 31, 2017, Wildhorse Company engaged Minsk Tooling Company to construct a special-purpose piece of factory machinery. Construction was begun immediately and was completed on November 1, 2017. To help finance construction, on July 31 Wildhorse issued a $328,800, 3-year, 12% note payable at Netherlands National Bank, on which interest is payable each July 31. $232,800 of the proceeds of the note was paid to Minsk on July 31. The remainder of the proceeds was temporarily invested in short-term marketable securities (trading securities) at 10% until November 1. On November 1, Wildhorse made a final $96,000 payment to Minsk. Other than the note to Netherlands, Wildhorse’s only outstanding liability at December 31, 2017, is a $28,600, 8%, 6-year note payable, dated January 1, 2014, on which interest is payable each December 31. Calculate the interest revenue, weighted-average accumulated expenditures, avoidable interest, and total interest cost to be capitalized during 2017. Interest revenue $ Weighted-average accumulated expenditures $ Avoidable interest $ Interest capitalized $ Prepare the journal entries needed on the books of Wildhorse Company at each of the following dates. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.) (1) July 31, 2017. (2) November 1, 2017. (3) December 31, 2017. Date Account Titles and Explanation Debit Credit (To record the note.) (To record the payment to Minsk.) (To record the proceeds from the investment.) (To record the payment to Minsk.) 12/31 Click if you would like to Show Work for this question: Open Show Work
In: Accounting
1. An oil company was evaluating the economic performance of one of its recompleted wells to decide whether to abandon it. The company uses 10% MARR or hurdle rate. The well is expected to produce for another 5 years. Year 1 post recompletion revenue was $500,000. Annual revenues are anticipated to drop by $50,000 each year starting in year 2.
a) What is the forecast revenue for year 4?
b) What is the equivalent annual worth of the revenue for the five year period?
2. A large building HVAC system has an estimated life expectancy of 12 more years. Replacement at that time is expected to cost $350,000. The building engineer is considering a plan to set aside equal annual deposits into a fund bearing 8 percent annual interest so that $350,000 will be on hand in 12 years. If he is ready to make a deposit right now, what equal amounts should he deposit now and for each of the next twelve years?
In: Accounting
|
Suppose Powers Ltd. just issued a dividend of $2.55 per share on its common stock. The company paid dividends of $2.05, $2.12, $2.29, and $2.39 per share in the last four years. |
| Required: |
|
What was the dividend growth rate for each year? (Do not round intermediate calculations. Enter your answers as a percentage rounded to 2 decimal places (e.g., 32.16).) |
| Growth rate | |
| Year 1 | % |
| Year 2 | % |
| Year 3 | % |
| Year 4 | % |
|
What were the arithmetic and geometric dividend growth rates over the past four years? (Do not round intermediate calculations. Enter your answers as a percentage rounded to 2 decimal places (e.g., 32.16).) |
| Cost of equity | |
| Arithmetic dividend growth rate | % |
| Geometric dividend growth rate | % |
|
If the stock currently sells for $74, what is your best estimate of the company’s cost of equity capital using arithmetic and geometric growth rates? (Do not round intermediate calculations. Enter your answers as a percentage rounded to 2 decimal places (e.g., 32.16).) |
| Cost of equity | |
| Arithmetic dividend growth rate | % |
| Geometric dividend growth rate | % |
In: Finance
Suppose Hornsby Ltd.
just issued a dividend of $2.55 per share on its common stock. The
company paid dividends of $2.05, $2.12, $2.29, and $2.39 per share
in the last four years.
What was the dividend growth rate for each year? (Do not
round intermediate calculations and enter your answers as a percent
rounded to 2 decimal places, e.g., 32.16.)
| Growth rate | |
| Year 1 | % |
| Year 2 | % |
| Year 3 | % |
| Year 4 | % |
What were the arithmetic and geometric dividend growth rates over
the past four years? (Do not round intermediate
calculations and enter your answers as a percent rounded to 2
decimal places, e.g., 32.16.)
| Cost of equity | |
| Arithmetic dividend growth rate | % |
| Geometric dividend growth rate | % |
If the stock currently sells for $74, what is your best estimate of
the company’s cost of equity capital using arithmetic and geometric
growth rates? (Do not round intermediate calculations and
enter your answers as a percent rounded to 2 decimal places, e.g.,
32.16.)
| Cost of equity | |
| Arithmetic dividend growth rate | % |
| Geometric dividend growth rate | % |
In: Finance
|
Titan Mining Corporation has 6.2 million shares of common stock outstanding, 215,000 shares of 3.5 percent preferred stock outstanding, and 100,000 bonds with a semiannual coupon rate of 5.2 percent outstanding, par value $1,000 each. The common stock currently sells for $74 per share and has a beta of 1.10, the preferred stock has a par value of $100 and currently sells for $82 per share, and the bonds have 16 years to maturity and sell for 106 percent of par. The market risk premium is 6.9 percent, T-bills are yielding 2.9 percent, and the company’s tax rate is 22 percent. |
| a. |
What is the firm’s market value capital structure? (Do not round intermediate calculations and round your answers to 4 decimal places, e.g., .1616.) 1. debt 2. preferred stocks 3. equity |
| b. | If the company is evaluating a new investment project that has the same risk as the firm’s typical project, what rate should the firm use to discount the project’s cash flows? (Do not round intermediate calculations enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) |
In: Finance
Problem 14-8 Calculating Cost of Debt [LO2]
|
Jiminy’s Cricket Farm issued a bond with 30 years to maturity and a semiannual coupon rate of 5 percent 3 years ago. The bond currently sells for 94 percent of its face value. The company’s tax rate is 22 percent. The book value of the debt issue is $65 million. In addition, the company has a second debt issue on the market, a zero coupon bond with 7 years left to maturity; the book value of this issue is $45 million, and the bonds sell for 74 percent of par. |
| a. |
What is the company’s total book value of debt? (Enter your answer in dollars, not millions of dollars, e.g. 1,234,567.) |
| b. | What is the company’s total market value of debt? (Enter your answer in dollars, not millions of dollars, e.g. 1,234,567.) |
| c. |
What is your best estimate of the aftertax cost of debt? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) |
a) total book value?
b) total market value?
c) cost of debt?
please help
In: Finance