| Johnson Beverage sell to Retail store customers - about 20 customers | ||||||||||||||
| Last year Revenue was $12 million - Sell Sport Drinks | ||||||||||||||
| (Exhibit 1 Customer Profitability) | ||||||||||||||
| Saver | Oscars | Downtown | ||||||||||||
| Superstore | Odd Lots | Midwellon | Retail | Others | Total JBI | |||||||||
| Net Revenue | $1,168,000 | $1,192,000 | $121,520 | $454,500 | $9,063,980 | $12,000,000 | ||||||||
| Cost of Goods Sold | 1,048,000 | 1,048,000 | 104,800 | 393,000 | 7,886,200 | 10,480,000 | ||||||||
| Gross Profit | 120,000 | 144,000 | 16,720 | 61,500 | 1,177,780 | 1,520,000 | ||||||||
| Customer Service Costs | 116,800 | 119,200 | 12,152 | 45,450 | 906,398 | 1,200,000 | ||||||||
| Customer Profit | 3,200 | 24,800 | 4,568 | 16,050 | 271,382 | 320,000 | ||||||||
| Profit % | 0.3% | 2.1% | 3.8% | 3.5% | 3.0% | 2.7% | ||||||||
| List price is $15.20 per case Cost is $13.10 per case | ||||||||||||||
| Discounts vary by customer | ||||||||||||||
| (Exhibit 2 Customer information) | ||||||||||||||
| Saver | Oscars | Downtown | ||||||||||||
| Superstore | Odd Lots | Midwellon | Retail | Others | Total JBI | |||||||||
| Price per Case | $14.60 | $14.90 | $15.19 | $15.15 | $15.06 | $15.00 | ||||||||
| Number of Cases | 80,000 | 80,000 | 8,000 | 30,000 | 602,000 | 800,000 | ||||||||
| Number of Orders | 16 | 40 | 20 | 30 | 394 | 500 | ||||||||
| Number of Deliveries | 110 | 400 | 200 | 230 | 3,540 | 4,480 | ||||||||
| Miles per Delivery | 5 | 19 | 11 | 4 | 10 | |||||||||
| Expedited Deliveries | 10 | 250 | 130 | 90 | 2,020 | 2,500 | ||||||||
| Sales Visits | 12 | 25 | 18 | 9 | 296 | 360 | ||||||||
| Customer Saver Superstore is not happy - they think they | ||||||||||||||
| are paying too much | ||||||||||||||
| Customer Service Cost Detail | ||||||||||||||
| In addition to COGS Johnson has Customer Service costs | Cost | |||||||||||||
| of $1.2 million per year - like overhead See Table 1 | Product Handling | $672,000 | ||||||||||||
| Currently allocated based on % of revenue | Taking Orders from Customers | 100,000 | ||||||||||||
| Delivering the Product | 140,000 | |||||||||||||
| They Run a report of Profitability by Customer | Expediting Deliveries | 198,000 | ||||||||||||
| See Exhibit 1 | Sales visits | 90,000 | ||||||||||||
| Total | $1,200,000 | |||||||||||||
| Can you help them using Activity Based costing? | ||||||||||||||
In: Accounting
Background Information:
In this project you are to assume that you are the audit partner on the audit engagement of Earthwear Clothiers, Inc. (Earthwear). Earthwear is a U.S. publicly traded company and is subject to the rules and regulations of the Public Company Accounting Oversight Board (United States). It is classified as an “accelerated filer” under the rules of the Securities and Exchange Commission (SEC).
Your firm has been engaged to perform an audit of the financial statements of Earthwear's calendar year ended December 31, 2017. Your audit will include:
-Issuance of an Engagement Letter
-Timely quarterly reviews
-An audit of Earthwear’s internal control over financial reporting
-An audit of Earthwear’s Financial Statements for the year then ended
-Issuance of a Management Letter concerning findings and recommendations
Earthwear has an audit committee of the board of directors charged with oversight of financial reporting and disclosure. While you are conducting your audit of Earthwear, you and your audit team are expected to meet with the audit committee on several occasions.
Required Task:
Prepare a calendar of your proposed meetings with the audit committee on a month by month basis. For each meeting you should identify the information (matters) that you should communicate to the audit committee.
In: Accounting
On January 2, 2006, in the strategic committee meeting of the company, Christine Carmen Chairman, President and Chief Executive Officer said, we are optimistic about 2006 and the years beyond. The proposed projects presently under consideration will enable us efficiently to expand our productivity in order to meet ever-increasing customers demand with high quality engineered products and systems for defense, aerospace and industrial applications.
Carmen Corporation is a supplier of sophisticated, highly engineered products and systems for defense, aerospace and industrial applications. The Company has three business segments.
The Company's Defense segment provides integrated front-line war-fighting systems and components, including electronic warfare systems, reconnaissance and surveillance systems, aircraft weapons suspension and release systems and airborne mine countermeasures systems.
The Company's Communications and Space Products segment supplies antenna products and ultra-miniature electronics and systems for the remote sensing, communications and electronic warfare industries.
The Company's Engineered Materials segment supplies piezoelectric ceramic products for commercial and military markets and advanced fiber composite structural products for the aircraft, communication, navigation, chemical, petrochemical, paper, and oil industries.
Carmen Corporation has the following financial statements:
|
Table 1 CARMEN COMPANY |
|||
|
Balance Sheet 12/31/2005 |
|||
|
Assets |
Liability & Equity |
||
|
Cash |
$6,000,000 |
Account Payable |
$1,000,000 |
|
Account Receivable |
$8,000,000 |
Notes Payable |
$3,000,000 |
|
Inventory |
$3,000,000 |
Accrued Taxes |
$1,000,000 |
|
Current Asset |
$17,000,000 |
Current Liabilities |
$5,000,000 |
|
GFA |
$40,000,000 |
Long-term debt |
$10,000,000 |
|
Accumulated Depreciation |
($2,000,000) |
Preferred Stock (0.5 million shares) |
$15,000,000 |
|
Net Fixed Assets |
$38,000,000 |
Common Stock (1 million shares) |
$10,000,000 |
|
Returned Earnings |
$15,000,000 |
||
|
Common Equity |
$25,000,000 |
||
|
Total Asst |
$55,000,000 |
Total Liability & Equity |
$55,000,000 |
|
Table 2 -Income Statement (12/31/2005) |
|
|
Sales |
$25,000,000 |
|
Cost of Sales |
-8,500,000 |
|
Earnings Before Depreciation and Amortization (EBITDA) |
$16,500,000 |
|
Depreciation |
-1,550,000 |
|
Earnings Before Interest and taxes (EBIT) |
$14,950,000 |
|
Interest Expense |
($950,000) |
|
Taxable Income |
$14,000,000 |
|
Taxes (40%) |
($5,600,000) |
|
Net Income |
$8,400,000 |
Its established common stock’s dividend payout ratio after the preferred stock dividends payment is 50 percent and it is expected to grow at a constant rate of 9 percent in the future. The tax rate is 40 percent and investors requiring a rate of return of 15% on the common stock.
Preferred stock is trading at a price of $40 per share, with a dividend of $4.8. The 30-year long-term debt with a par value of $1,000 was issued 10 years ago with a coupon rate of 8%. The bonds can be refinanced at the market interest rate of 10 percent today.
Carmen has the following investment opportunities:
|
Table 3 |
Project |
Annual Net |
|
|
Project |
Cost |
Cash Flow |
Life |
|
Defense 1 |
$1,000,000 |
$219,120 |
7 |
|
Defense 2 |
$2,000,000 |
368,580 |
10 |
|
Eng. Materials 1 |
$1,000,000 |
222,851 |
8 |
|
Eng. Materials 2 |
$2,000,000 |
542,784 |
6 |
|
Communication and Space 1 |
$1,000,000 |
202168 |
9 |
|
Communication and Space 2 |
$1,000,000 |
319,775 |
5 |
Part I
Determine the book value and market value of the capital structure.
Determine the weighted average cost of capital (WACC) for each of the capital structure.
Calculate the internal rate of return (IRR) and Net Present Value of each project and compare them against the book value and market value weighted average cost of capital.
Are there any conflict between NPV and IRR? How do you resolve the conflict in ranking?
e.
How much of the internal fund is available for investments?
Are there any issues about the projects you should consider before yourrecommendation?
In: Finance
CARMEN CORPORATION
On January 2, 2006, in the strategic committee meeting of the company, Christine Carmen Chairman, President and Chief Executive Officer said, we are optimistic about 2006 and the years beyond. The proposed projects presently under consideration will enable us efficiently to expand our productivity in order to meet ever-increasing customers demand with high quality engineered products and systems for defense, aerospace and industrial applications.
Carmen Corporation is a supplier of sophisticated, highly engineered products and systems for defense, aerospace and industrial applications. The Company has three business segments.
The Company's Defense segment provides integrated front-line war-fighting systems and components, including electronic warfare systems, reconnaissance and surveillance systems, aircraft weapons suspension and release systems and airborne mine countermeasures systems.
The Company's Communications and Space Products segment supplies antenna products and ultra-miniature electronics and systems for the remote sensing, communications and electronic warfare industries.
The Company's Engineered Materials segment supplies piezoelectric ceramic products for commercial and military markets and advanced fiber composite structural products for the aircraft, communication, navigation, chemical, petrochemical, paper, and oil industries.
Carmen Corporation has the following financial statements:
|
Table 1 CARMEN COMPANY |
|||
|
Balance Sheet 12/31/2005 |
|||
|
Assets |
Liability & Equity |
||
|
Cash |
$6,000,000 |
Account Payable |
$1,000,000 |
|
Account Receivable |
$8,000,000 |
Notes Payable |
$3,000,000 |
|
Inventory |
$3,000,000 |
Accrued Taxes |
$1,000,000 |
|
Current Asset |
$17,000,000 |
Current Liabilities |
$5,000,000 |
|
GFA |
$40,000,000 |
Long-term debt |
$10,000,000 |
|
Accumulated Depreciation |
($2,000,000) |
Preferred Stock (0.5 million shares) |
$15,000,000 |
|
Net Fixed Assets |
$38,000,000 |
Common Stock (1 million shares) |
$10,000,000 |
|
Returned Earnings |
$15,000,000 |
||
|
Common Equity |
$25,000,000 |
||
|
Total Asst |
$55,000,000 |
Total Liability & Equity |
$55,000,000 |
|
Table 2 -Income Statement (12/31/2005) |
|
|
Sales |
$25,000,000 |
|
Cost of Sales |
-8,500,000 |
|
Earnings Before Depreciation and Amortization (EBITDA) |
$16,500,000 |
|
Depreciation |
-1,550,000 |
|
Earnings Before Interest and taxes (EBIT) |
$14,950,000 |
|
Interest Expense |
($950,000) |
|
Taxable Income |
$14,000,000 |
|
Taxes (40%) |
($5,600,000) |
|
Net Income |
$8,400,000 |
Its established common stock’s dividend payout ratio after the preferred stock dividends payment is 50 percent and it is expected to grow at a constant rate of 9 percent in the future. The tax rate is 40 percent and investors requiring a rate of return of 15% on the common stock.
Preferred stock is trading at a price of $40 per share, with a dividend of $4.8. The 30-year long-term debt with a par value of $1,000 was issued 10 years ago with a coupon rate of 8%. The bonds can be refinanced at the market interest rate of 10 percent today.
Carmen has the following investment opportunities:
|
Table 3 |
Project |
Annual Net |
|
|
Project |
Cost |
Cash Flow |
Life |
|
Defense 1 |
$1,000,000 |
$219,120 |
7 |
|
Defense 2 |
$2,000,000 |
368,580 |
10 |
|
Eng. Materials 1 |
$1,000,000 |
222,851 |
8 |
|
Eng. Materials 2 |
$2,000,000 |
542,784 |
6 |
|
Communication and Space 1 |
$1,000,000 |
202168 |
9 |
|
Communication and Space 2 |
$1,000,000 |
319,775 |
5 |
Part I
Determine the book value and market value of the capital structure.
Determine the weighted average cost of capital (WACC) for each of the capital structure.
Calculate the internal rate of return (IRR) and Net Present Value of each project and compare them against the book value and market value weighted average cost of capital.
Are there any conflict between NPV and IRR? How do you resolve the conflict in ranking?
How much of the internal fund is available for investments?
Are there any issues about the projects you should consider before your recommendation?
In: Finance
Select the best answer for each of the following unrelated items. Answer each of these items in your examination booklet by giving the number of your choice. For example, if the best answer for item (a) is (1), write (a)(1) in your examination booklet. If more than one answer is given for an item, that item will not be marked. Incorrect answers will be marked as zero. Marks will not be awarded for explanations.
In: Accounting
You have recently been hired as the assistant controller for Stanton Temperton Corporation, which rents building space in major metropolitan areas. Customers are required to pay six months of rent in advance. At the end of 2018, the company's president, Jim Temperton, notices that net income has fallen compared to last year. In 2017, the company reported before-tax profit of $330,000, but in 2018 the before-tax profit is only $280,000. This concerns Jim for two reasons. First, his year-end bonus is tied directly to before-tax profits. Second, shareholders may see a decline in profitability as a weakness in the company and begin to sell their stock. With the sell-off of stock, Jim's personal investment in the company's stock, as well as his company-operated retirement plan, will be in jeopardy of severe losses. After close inspection of the financial statements, Jim notices that the balance of the Deferred Revenue account is $120,000. This amount represents payments in advance from long-term customers ($80,000) and from relatively new customers ($40,000). Jim comes to you, the company's accountant, and suggests that the firm should recognize as revenue in 2018 the $80,000 received in advance from long-term customers. He offers the following explanation: “First, we have received these customers' cash by the end of 2018, so there is no question about their ability to pay. Second, we have a long-term history of fulfilling our obligation to these customers. We have always stood by our commitments to our customers and we always will. We earned that money when we got them to sign the six-month contract.”
Discuss the ethical dilemma you face:
1. What is the issue?
2. Who are the parties affected?
3. What factors should you consider in making your decision?
4. What is the stance you will take?
Required: 1) Reach a consensus concerning the answers to the four questions.
2) Write a memo to the company’s controller discussing the issue and the stance that your group is taking.
In: Accounting
1. In 1980 France had a GDP of $325 billion francs and a population of 11.78 million. In 1980 the exchange rate was 1 US dollar was equal to 1.67 francs. In 2010, France had a GDP of $435 billion euros and a population of 21.75 million. In 2010 0.8 euros was equal to 1 US Dollar. The GDP deflator was 51 in 1980 and 125 in 2010. By what percentage did France’s Real GDP per capita rise between 1980 and 2010 in U.S. dollars?
2. Identify the most commonly cited measure of inflation in the United States and explain how it is calculated. Identify and briefly discuss the some of the problems that statisticians have paid considerable attention to in recent years (your answer needs to be thorough).
3. Describe the relationship between inflation levels in prices and inflation levels for prices, wages and interest rates with respect to their ability to affect people's economic status and business outcomes (again, here be thorough and explain what happens when wages, etc. does and does not keep up with inflation).
4. Explain the differences and similarities between the GDP deflator and the CPI. Be thorough in your answer and write in complete sentences.
5. What is Hyperinflation and what are some reasons it may occur and persist? What is deflation, when does deflation usually occur, and is deflation a good or bad thing? Give examples of when each scenario happened in history as well. Again, be thorough in your answer.
6. In an imaginary economy, consumers buy only hot dogs and hamburgers. The fixed basket consists of 15 hot dogs and 8 hamburgers. A hot dog cost $2.25 in 2006 and $5.40 in 2007. A hamburger cost $5.75 in 2006 and $7.86 in 2007. Calculate the CPI for both years and then find the inflation rate.
7. In an imaginary economy, consumers buy only sandwiches and magazines. The fixed basket consists of 25 sandwiches and 40 magazines. In 2006, a sandwich cost $4.50 and a magazine cost $3.99. In 2007, a sandwich cost $5.75. If the inflation rate in 2007 was 21 percent, then how much did a magazine cost in 2007?
8. When Anders took out his first two-year membership with Maxima Gym in 2004, the fee was $525.00. He renewed his membership three times; in 2006 for $580.00, in 2008, for $600.00, and again in 2010, for $699.00. What is the OVERALL rate of inflation for Anders' gym membership?
9. In 1949, Sycamore, Illinois built a hospital for about $500,000. In 1987, the county restored the courthouse for about $2.4 million. A price index for nonresidential construction was 12 in 1949, 96 in 1987, and 117.5 in 2000. Calculate the value of the courthouse in 2000 dollars and the value of the hospital in 2000 dollars and compare your answers. Which one cost more?
10. Ruben earned a salary of $60,000 in 2001 and $80,000 in 2006. The consumer price index was 156 in 2001 and 227.25 in 2006. What is Ruben's 2006 salary in 2001 dollars? What does this mean about how his purchasing power increased or decreased?
In: Economics
Conceptual Framework:
For each of the following situations, state whether you agree or disagree with the financial reporting practice employed, and then briefly explain the reason and proper treatment if you disagree. Use the conceptual framework as your guide in deriving your answer.
The controller of the Dumars Corporation increased the carrying value of land from its original cost of $2 million to its recently appraised value of $3.5 million.
The president of Vosburgh Industries asked the company controller to charge miscellaneous expense for the purchase of an automobile to be used solely for personal use.
At the end of its 2016 fiscal year, Dower, Inc., received an order from a customer for $45,350. The merchandise will ship early in 2017. Because the sale was made to a long-time customer, the controller recorded the sale in 2016.
At the beginning of its 2016 fiscal year, Rossi Imports paid $48,000 for a two-year lease on warehouse space. Rossi recorded the expenditure as an asset to be expensed equally over the two-year period of the lease.
The Reliable Tire Company included a note in its financial statements that described a pending lawsuit against the company.
The Hughes Corporation, a company whose securities are publicly traded, prepares monthly, quarterly, and annual financial statements for internal use but disseminates to external users only the annual financial statements.
In: Accounting
Some of the account balances of Mali Company at December 31, 20x0 are shown below:
6% Preferred Stock ($100 par, 2,000 shares authorized) $ 20,000
PCIEP, Preferred 3,000
Common Stock ($10 par, 100,000 shares authorized) 500,000
PCIEP, Common 100,000
Retained Earnings 304,000
Treasury Stock-Preferred (50 shares at cost) 5,500
Treasury Stock-Common (1,000 shares at cost) 16,000
The price of the company’s common stock has been increasing steadily on the market; it was $21 on January 1, 20x1, advanced to $24 by July 1, and to $27 at the end of the year 20x1. The preferred stock was not openly traded, but was appraised at $120 per share during 20x1.
1) Give the proper journal entries for each of the following occurred in 20x1:
(1) The company resold the 50 shares of preferred stock held in the treasury for $116 per share.
(2) On July 1, the company declared a 5% stock dividend to the common stockholders.
(3) On October 15, the company declared a cash dividend of $100,000. Assume the preferred stock is non-cumulative. Prepare two separate journal entries: common and preferred dividends.
2) Prepare the stockholders’ equity section of the balance sheet at December 31, 20x1
In: Accounting
Note that Walmart's fiscal year starts the first week of February. This means that when analyzing the data, week 41 is actually week 45(41+4 weeks for January) in 2003 or the beginning of November 2003. Also, week 52 is actually week 4 (52+4 weeks for January 2003 minus 52 weeks for 2003) in 2004 or the end of January 2004.
1. Identify spikes(outliers) in the data where extreme (high or low) sales values occur and correlate these spikes with actual calendar dates in 2003 or 2004 and with any holidays or special events or abnormally slow periods that may occur during these periods.
| Week | Sales in $ |
| 41 | 18000 |
| 42 | 16800 |
| 43 | 15200 |
| 44 | 15000 |
| 45 | 13600 |
| 46 | 16000 |
| 47 | 12600 |
| 48 | 14800 |
| 49 | 16800 |
| 50 | 14800 |
| 51 | 15200 |
| 52 | 16000 |
| 53 | 15600 |
| 54 | 15600 |
| 55 | 15000 |
| 56 | 15700 |
| 57 | 15800 |
| 58 | 13800 |
| 59 | 12800 |
| 60 | 14400 |
| 61 | 15800 |
| 62 | 16000 |
| 63 | 12400 |
| 64 | 16200 |
| 65 | 17000 |
| 66 | 18600 |
| 67 | 16000 |
| 68 | 18000 |
| 69 | 19600 |
| 70 | 18600 |
| 71 | 18450 |
| 72 | 18000 |
| 73 | 18200 |
| 74 | 18600 |
| 75 | 16000 |
| 76 | 15200 |
| 77 | 16800 |
| 78 | 15800 |
| 79 | 17600 |
| 80 | 15800 |
| 81 | 15600 |
| 82 | 14200 |
| 83 | 16600 |
| 84 | 16100 |
| 85 | 14100 |
| 86 | 14400 |
| 87 | 14500 |
| 88 | 16900 |
| 89 | 17000 |
| 90 | 16000 |
| 91 | 17800 |
In: Statistics and Probability