| Collyer Products Inc. has a Valve Division that manufactures and sells a standard valve as follows: |
| Capacity in units | 230,000 | |
| Selling price to outside customers on the intermediate market | $ 16 | |
| Variable costs per unit | $ 10 | |
| Fixed costs per unit (based on capacity) | $ 7 | |
|
The company has a Pump Division that could use this valve in the manufacture of one of its pumps. The Pump Division is currently purchasing 20,000 valves per year from an overseas supplier at a cost of $15 per valve. |
| Required: |
| 1. |
Assume that the Valve Division has ample idle capacity to handle all of the Pump Division's needs. What is the acceptable range, if any, for the transfer price between the two divisions? |
| 2. |
Assume that the Valve Division is selling all that it can produce to outside customers on the intermediate market. What is the acceptable range, if any, for the transfer price between the two divisions? |
| 3. |
Assume again that the Valve Division is selling all that it can produce to outside customers on the intermediate market. Also assume that $3 in variable expenses can be avoided on transfers within the company, due to reduced selling costs. What is the acceptable range, if any, for the transfer price between the two divisions? |
| 4. |
Assume the Pump Division needs 25,000 special high-pressure valves per year. The Valve Division's variable costs to manufacture and ship the special valve would be $11 per unit. To produce these special valves, the Valve Division would have to reduce its production and sales of regular valves from 230,000 units per year to 180,000 units per year. As far as the Valve Division is concerned, what is the lowest acceptable transfer price? (Round your answer to 2 decimal places.) |
In: Accounting
9-12 Mini-Case
APV Valuation
Flowmaster Forge Inc. is a designer and manufacturer of industrial air-handling equipment that
is a wholly owned subsidiary of Howden Industrial Inc. Howden is interested in selling
Flowmaster to an investment group formed by company CFO Gary Burton.
Burton prepared a set of financial projections for Flowmaster under the new ownership. For the
first year of operations, firm revenues were estimated to be $160 million, variable and fixed
operating expenses (excluding depreciation expense) were projected to be $80 million, and
depreciation expense was estimated to be $15 million. Revenues and expenses were projected
to grow at a rate of 4% per year in perpetuity.
Flowmaster currently has $125 million in debt outstanding that carries an interest rate of 6%.
The debt trades at par (i.e., at a price equal to its face value). The investment group intends to
keep the debt outstanding after the acquisition is completed, and the level of debt is expected
to grow by the same 4% rate as firm revenues.
Projected income statements for the first three years of operation of Flowmaster following the
acquisition are as follows:
Burton anticipates that efficiency gains can be implemented that will allow Flowmaster to
reduce its needs for net working capital. Currently, Flowmaster has net working capital equal to
30% of anticipated revenues for year 1. He estimates that, for year 1, the firm’s net working
capital can be reduced to 25% of year 2 revenues, then 20% of revenues for all subsequent
years. Estimated net working capital for years 1 through 3 is as follows:
To sustain the firm’s expected revenue growth, Burton estimates that annual capital
expenditures that equal the firm’s annual depreciation expense will be required.
Burton has been thinking for some time about whether to use Howden’s corporate cost of
capital of 9% to value Flowmaster and has come to the conclusion that an independent
estimate should be made. To make the estimate, he collected the following information on the
betas and leverage ratios for three publicly traded firms with manufacturing operations that are
very similar to Flowmaster’s:
1. Calculate the unlevered cash flows (i.e., the firm FCFs for Flowmaster for years 1 to 3).
2. Calculate the unlevered cost of equity capital for Flowmaster. The risk-free rate of
interest is 4.5% and the market risk premium is estimated to be 6%.
3. Calculate the value of Flowmaster’s unlevered business.
4. What is the value of Flowmaster’s interest tax savings, based on the assumption that the
$125 million in debt remains outstanding (i.e., the investment group assumes the debt
obligation) and that the firm’s debt and consequently its interest expenses grow at the
same rate as revenues?
5. What is your estimate of the enterprise value of Flowmaster based on your analysis in
Problem 9-13(a) to (d)? How much is the equity of the firm worth today, assuming the
$125 million in debt remains outstanding?
*
The leverage ratio is the ratio of the market value of debt to the sum of the market values of
debt and equity. Debt ratios are assumed to be constraint.
†
Revenues are the entire firm’s revenues for the most recent fiscal year.
Note 1—Property, plant, and equipment grow at the same rate as revenues so that
depreciation expenses grow at 4% per year.
| GIVEN | |||||||
| Growth rate in revenues and expenses | 4.00% | ||||||
| Debt (year 0) | $125 | million | |||||
| Interest rate | 6.00% | ||||||
| Tax rate | 34.00% | ||||||
| Net working capital / Revenues | 30.00% | ||||||
| SOLUTIONS GIVEN | |||||||
| Pro Forma Income Statements | |||||||
| Year | |||||||
| ($ millions) | 1 | 2 | 3 | 4 | 5 | 6 | |
| Revenues | $160.00 | $166.40 | $173.06 | ?? | ?? | ?? | |
| Expenses | (80.00) | (83.20) | (86.53) | ?? | ?? | ||
| Depreciation | (15.00) | (15.60) | (16.22) | ?? | ?? | ||
| Earnings before interest and taxes | $65.00 | $67.60 | $70.30 | ?? | ?? | ||
| Interest expense | (7.50) | (7.80) | (8.11) | ?? | ?? | ||
| Earnings before taxes | $57.50 | $59.80 | $62.19 | ?? | ?? | ||
| Taxes | (19.55) | (20.33) | (21.15) | ?? | ?? | ||
| Net Income | $37.95 | $39.47 | $41.05 | ?? | ?? | ||
| Balance Sheet | |||||||
| Pro forma | |||||||
| Year | |||||||
| ($ millions) | Current | 1 | 2 | 3 | 4 | 5 | |
| Net Working Capital (t-1) / Revenues (t) | 30% | 25% | 20% | 20% | ?? | ?? | |
| Net Working Capital | $48.00 | $41.60 | $34.61 | $36.00 | ?? | ?? | |
| Debt | $125.00 | $130.00 | $135.20 | $140.61 | ?? | ?? | |
|
START SOLVING |
|||||||
| a. Calculate the unlevered equity cash flows for years 1-3. | |||||||
| Year | |||||||
| Firm free cash flows (unlevered equity) | Current | 1 | 2 | 3 | 4 | ||
| EBIT | $65.00 | $67.60 | $70.30 | $73.12 | ?? | ||
| Less: Tax on EBIT | |||||||
| NOPAT | |||||||
| Plus: Depreciation | 15.00 | 15.60 | 16.22 | 16.87 | ?? | ||
| Less: CAPEX | (15.00) | (15.60) | (16.22) | (16.87) | ?? | ||
| Less: Increase in NWC | |||||||
| FCF | |||||||
| Year | |||||||
| Equity free cash flows | Current | 1 | 2 | 3 | 4 | ||
| Net Income | $37.95 | $39.47 | $41.05 | $42.69 | ?? | ||
| Plus: Depreciation | 15.00 | 15.60 | 16.22 | 16.87 | ?? | ||
| Less: CAPEX | (15.00) | (15.60) | (16.22) | (16.87) | ?? | ||
| Less: Increase in NWC | |||||||
| Less: Paid up principal | - | - | - | - | - | ||
| Plus: New debt issued | |||||||
| Equity FCF | |||||||
| Year | |||||||
| Check | Current | 1 | 2 | 3 | 4 | ||
| Equity free cash flow | |||||||
| Plus: Interest (1 – T) | |||||||
| Plus: Principal payments** | - | - | - | - | - | ||
| Less: New debt issues | |||||||
| Equals: Project free cash flow (PFCF) | |||||||
| b. Unlevered cost of equity capital | |||||||
| tax rate | |||||||
| Cost of Capital Information | |||||||
| Company | Leveraged Equity Beta | Debt Beta | Debt/Equity Ratio | Revenues** ($ millions) |
% weight by revenue | Unlevered beta | |
| Gopher Forge | 1.61 | 0.52 | 0.46 | $400 | |||
| Alpha | 1.53 | 0.49 | 0.44 | 380 | |||
| Global Diversified | 0.73 | 0.03 | 0.15 | 9,400 | |||
| $10,180 | |||||||
| Flowmaster Forge | |||||||
| Unlevered beta | debt beta | equity | debt | D/E | |||
| 0 | 100 | 125 | 1.25 | ||||
| 4.50% | rf | ||||||
| 6.00% | MRP | ||||||
| ku | Unlevered cost of capital | ||||||
| c. Value of Flowmaster's unlevered business | |||||||
| PV of FCF in planning period (Year 1-3) | |||||||
| Terminal Value at Year 3 | |||||||
| PV of Year 3 value | |||||||
| Unlevered firm value | |||||||
| d. Value of interest tax shields | |||||||
| PV of tax shields on interest payments | Using MM formula | ||||||
| Value of tax shields | Discounted at unlevered cost of equity since debt and interest expense grows and therefore | ||||||
| varies with firm revenues. | |||||||
| e. Enterprise Value | |||||||
| Enterprise Value | |||||||
| Equals: unlevered firm value + tax shields | |||||||
| debt value today | |||||||
| Hence equity value | |||||||
In: Finance
Conduct a ONE WAY ANOVA using the following data in Excel.
Group 1 : 11, 17, 22, 15
Group 2 : 21, 15, 16
Group 3 : 7, 8, 3, 10, 6, 4
Group 4 : 13, 6, 17, 27, 20
In: Statistics and Probability
LearningExchange Ltd offers specialised exchange programs for
Australian students to live overseas and study in a local school
from two to twelve months. The company’s exchange programs also
include local tours. The sales and direct cost data on the two
popular programs for last year are as follows:
Thailand New Zealand Number of exchange programs sold 10 15 Number
of students per program 6 6 Revenue per student $14,000 $17,000
Direct cost per program: Program leaders' salary (percentage of
revenue per program) 5% 7% Program assistant salary $5,000 $6,000
Local school fees (percentage of revenue per program) 25% 30% Local
tour guides $2,000 $4,200 Air travel cost $4,500 $1,900
Accommodation and meals $20,000 $38,000 Insurance $2,100
$2,200
The overhead costs for the last year as follows:
Managers' salaries $100,000 Sales personnel salaries $120,000 Rent
and property taxes $22,000 Utilities $8,000 Depreciation on
equipment $6,000 Other operating costs $9,000
To calculate the profitability of each exchange program, overheads
are allocated to each program in proportion to the actual sales
revenue.
Required: 1. Calculate the contribution of each tour package
towards the overall profit of the company. [10 marks]
Click or tap here to enter text.
2. Should the company keep on offering both tour packages? Explain
and support your answer with necessary calculations. [1 mark]
Click or tap here to enter text.
3. Do you consider the company’s overhead allocation method to be
appropriate or would you suggest an alternative? Explain. [1
mark]
Click or tap here to enter text.
4. What should the company do to improve the profitability of each
exchange program? Provide some suitable examples
In: Accounting
Many European governments are reluctant to allow online betting
in an attempt to protect
their national gambling businesses. A recent study found that seven
countries out of the
27 in the European Union banned online gambling. Of the other 20
only 13 have opened
their markets to competition; in the rest gambling is dominated by
monopolies owned or
licensed by the government. In the Netherlands, for example,
residents can only place
online bets with a state monopoly: De Lotto. The Ministry of
Justice even warned banks in
the country that they could be prosecuted if they transferred money
to online gambling
companies. Other countries have ordered online betting companies to
block access to
their sites. Their governments argue that this is to protect people
from gambling
excessively. However the revenue they gain from their own
monopolies should not be
ignored as a possible motive.
Questions
1. If governments believe that gambling is bad for their citizens
then in economic
terms how would you classify this service?
2. Why might governments want to protect their own monopolies in
the gambling
sector?
3. What might be the effect of greater competition in the gambling
industry in these
countries?
In: Economics
Oriole Company’s balance sheet at December 31, 2021, is presented below.
|
Oriole Company |
|||||||
|---|---|---|---|---|---|---|---|
|
Cash |
$13,680 |
Accounts payable |
$8,900 | ||||
|
Accounts receivable |
21,100 |
Common stock |
21,800 | ||||
|
Allowance for doubtful accounts |
(740) |
Retained earnings |
13,330 | ||||
|
Inventory |
9,990 | ||||||
| $44,030 | $44,030 | ||||||
During January 2022, the following transactions occurred. Oriole
uses the perpetual inventory method.
| Jan. 1 | Oriole accepted a 4-month, 8% note from Betheny Company in payment of Betheny’s $4,800 account. | |
| 3 | Oriole wrote off as uncollectible the accounts of Walter Corporation ($500) and Drake Company ($300). | |
| 8 | Oriole purchased $18,800 of inventory on account. | |
| 11 | Oriole sold for $25,700 on account inventory that cost $16,020. | |
| 15 | Oriole sold inventory that cost $730 to Jack Rice for $1,100. Rice charged this amount on his Visa First Bank card. The service fee charged Oriole by First Bank is 3%. | |
| 17 | Oriole collected $24,400 from customers on account. | |
| 21 | Oriole paid $17,100 on accounts payable. | |
| 24 | Oriole received payment in full ($300) from Drake Company on the account written off on January 3. | |
| 27 | Oriole purchased advertising supplies for $1,540 cash. | |
| 31 | Oriole paid other operating expenses, $2,910. |
Adjustment data:
| 1. | Interest is recorded for the month on the note from January 1. | |
| 2. | Bad debts are expected to be 6% of the January 31, 2022, accounts receivable. | |
| 3. | A count of advertising supplies on January 31, 2022, reveals that $510 remains unused. | |
| 4. | The income tax rate is 30%. (Hint: Prepare the income statement up to Income before taxes and multiply by 30% to compute the amount; round to whole dollars.) |
(You may want to set up T-accounts to determine ending
balances.)
Prepare journal entries for the transactions listed above and adjusting entries. (Include entries for cost of goods sold using the perpetual inventory system.) (Round answers to 0 decimal places, e.g. 1,250. Credit account titles are automatically indented when amount is entered. Do not indent manually. Record journal entries in the order presented in the problem.)
Prepare an adjusted trial balance at January 31, 2022. (Round answers to 0 decimal places, e.g. 1,250.)
Prepare an income statement for the month ending January 31, 2022. (Round answers to 0 decimal places, e.g. 1,250.)
Prepare a retained earnings statement for the month ending January 31, 2022. (Round answers to 0 decimal places, e.g. 1,250.)
Prepare a classified balance sheet as of January 31, 2022. (List Current Assets in order of liquidity. Round answers to 0 decimal places, e.g. 1,250.)
In: Accounting
CASE-STUDY
Aggressive Sales Quotas or Unfair Business Practice?
"In the advertising industry, money is the bottom line-regardless," said Peter Allen, a customer service representative for a large-scale online directory. It was 1999 and the online business was booming. Everyone in the city wanted to get in on the Internet revolution, but many didn't really understand what that even involved.
Peter was new to the industry. He was given his territory, the city of San Francisco, and told to sell as much advertising as possible-at any cost-both to the company's existing clients and to new customers. For his first few months on the job, Peter focused on getting to know the existing customers and evaluating their current advertising packages with the company. Peter was surprised to find that many of his customers were small business owners-auto-body shops and family-owned restaurants that already had large advertising packages way beyond their needs. His boss, the director of customer service, had already set Peter's quota at a level that presumed that many more sales were possible. Yet, in Peter's judgment, the market was saturated.
"These small shops thought that the Internet was the next best thing," said Peter. "They didn't even understand what the Internet actually was."
Peter couldn't fathom how these small businesses got persuaded into spending so much money on advertising. "The businesses you would least think to look up online were the businesses with the most expensive advertising packages," said Peter.
Peter was getting daily phone calls from the home office, pressuring him to meet his numbers and sell the most in his territory. Peter complained to the sales manager, who said that Peter had to be honest. "It was my obligation to set things straight," said Peter.
With the support of his manager, Peter told the top executives of the company that the sales team in San Francisco needed to have some leeway in meeting the quota. Unlike other sales territories, San Francisco, as the hub of the high-tech world, was cluttered with competition and, with companies cropping up everywhere in Silicon Valley, Peter and his team didn't have the luxury to selectively pursue businesses. Instead, they had to go after any and every business possible because other online directories were quickly entering the San Francisco market. The executives feared that changing the quota for San Francisco would lead to other territories vying for lower quotas as well. But Peter's case proved strong enough: The executives decided to "look the other way" for the San Francisco territory.
Peter went to each business and gave them an honest evaluation of their advertising needs-often recommending they downgrade their packages with the company.
"We moved them into more appropriate packages and became number one in customer retention," said Peter. "We lost money in the short term, but in the long term we made money through referrals and retention."
Discussion Questions:
Jessica Silliman was a 2006-07 Hackworth Fellow at The Markkula Center for Applied Ethics.
In: Economics
Required information
The general ledger of Zips Storage at January 1, 2021, includes the following account balances:
| Accounts | Debits | Credits | |||||
| Cash | $ | 25,000 | |||||
| Accounts Receivable | 15,800 | ||||||
| Prepaid Insurance | 12,800 | ||||||
| Land | 152,000 | ||||||
| Accounts Payable | $ | 7,100 | |||||
| Deferred Revenue | 6,200 | ||||||
| Common Stock | 147,000 | ||||||
| Retained Earnings | 45,300 | ||||||
| Totals | $ | 205,600 | $ | 205,600 | |||
The following is a summary of the transactions for the year:
| 1. | January | 9 | Provide storage services for cash, $138,100, and on account, $54,200. | |||
| 2. | February | 12 | Collect on accounts receivable, $51,900. | |||
| 3. | April | 25 | Receive cash in advance from customers, $13,300. | |||
| 4. | May | 6 | Purchase supplies on account, $10,000. | |||
| 5. | July | 15 | Pay property taxes, $8,900. | |||
| 6. | September | 10 | Pay on accounts payable, $11,800. | |||
| 7. | October | 31 | Pay salaries, $127,600. | |||
| 8. | November | 20 | Issue shares of common stock in exchange for $31,000 cash. | |||
| 9. | December | 30 | Pay $3,200 cash dividends to stockholders. |
5. Record adjusting entries. Insurance expired during the year is $7,400. Supplies remaining on hand at the end of the year equal $3,300. Provide services of $12,200 related to cash paid in advance by customers. (If no entry is required for a particular transaction/event, select "No Journal Entry Required" in the first account field.)
Prepare an adjusted trial balance, as well.
Prepare the income statement for the year ended December 31, 2021.
In: Accounting
There is a well-known bakery in the town, named Paris Bakery
A). what is the daily revenue of the bakery based on the following assumptions? (10 points)
- there are 10 customers in/out in 10 minutes
-each costumer buys 3 biscuits on average
-The price of biscuit is $1.50 each
-The bakery open from 8 A.M to 6 P.M
B) Owner of the Bakery wants to adopt Kanban system to reduce the inventory. Howmany Kanban containers will be needed to support the bakery based on the following assumptions?
-The daily demand is 100 batches
-The production lead time is 2 days
-Management has decided to have 1 day of safety stock
-One container fits 20 batches
C) At the Bakery, it takes 120 seconds to assemble one sandwich through 20 activities. If 30 customers arrive at the restaurant every hour on average, what is the Target Manpower the Restaurant needs to meet the demand of the sandwich?(10 points)
D) The weight of one batch has to be 3.6 lbs. to make constant size of biscuits. The Bakery has a low specification limit of 3.5 lbs. and upper specification limit of 3.7 lbs. The standard deviation is 0.1 lbs. Owner wants to reduce its defect probability 1.1%. To what level would the have to reduce the standard deviation in the process to meet this target? (10 points)
In: Operations Management
The Course Project requires you to act as consultants for a fast food chain and develop a new food product. Your competitor has just launched a new campaign introducing Junior and Grand sizes to their already famous and successful hamburger and is drawing sales away from your client. Time is of the essence, yet you do not want to over-react and make a costly mistake. You will need to be innovative and capitalize not only on your client’s success, but also focus on how to bring back lost revenue and launch a strong marketing campaign. Your market research and product launch strategy will be described both in a written paper as well as presentation of your recommendations to the class.
1. Complete product/service description, including the type of innovation represented, and the source for the idea.
2. Product/service offering and a description of benefits that customers will both recognize and realize
3. Competitive analysis
"Points awarded for description of the innovation of the new competitive product and how it will compete in the marketplace. Product offering and a description of benefits customers will realize over that of your client’s competitor. In short, how will your new innovative food product increase sales for your client and as well as win back sales from your client’s competitor. Include in this section an identification of competitor products and specific customer benefits. The material in this assignment covers sections 4-6 listed in the outline above."
In: Finance