Pirate Company purchased 60 percent ownership of Ship Corporation on January 1, 20X1, for $82,800. On that date, the noncontrolling interest had a fair value of $55,200 and Ship reported common stock outstanding of $100,000 and retained earnings of $20,000. The full amount of the differential is assigned to land to be used as a future building site. Pirate uses the fully adjusted equity method in accounting for its ownership of Ship. On December 31, 20X2, the trial balances of the two companies are as follows: Pirate Company Ship Corporation Item Debit Credit Debit Credit Cash and Accounts Receivable $ 69,400 $ 51,200 Inventory 60,000 55,000 Land 40,000 30,000 Buildings & Equipment 520,000 350,000 Investment in Ship Corporation 103,780 Cost of Goods Sold 99,800 61,000 Depreciation Expense 25,000 15,000 Interest Expense 6,000 14,000 Dividends Declared 40,000 10,000 Accumulated Depreciation $175,000 $ 75,000 Accounts Payable 68,800 41,200 Bonds Payable 80,000 200,000 Bond Premium 1,200 Common Stock 200,000 100,000 Retained Earnings 227,960 50,000 Sales 200,000 120,000 Income from Ship Corporation 11,020 $963,980 $963,980 $586,200 $586,200 Page 289Ship sold inventory costing $25,500 to Pirate for $42,500 in 20X1. Pirate resold 80 percent of the purchase in 20X1 and the remainder in 20X2. Ship sold inventory costing $21,000 to Pirate in 20X2 for $35,000, and Pirate resold 70 percent of it prior to December 31, 20X2. In addition, Pirate sold inventory costing $14,000 to Ship for $28,000 in 20X2, and Ship resold all but $13,000 of its purchase prior to December 31, 20X2. Assume both companies use straight-line depreciation and that no property, plant, and equipment has been purchased since the acquisition. Required Record the journal entry or entries for 20X2 on Pirate’s books related to its investment in Ship Corporation, using the equity method. Prepare the consolidation entries needed to complete a consolidated worksheet for 20X2. Prepare a three-part consolidation worksheet for 20X2.

1) At the beginning of the current year, Omar Company declared a 1 for 5 reverse stock split, when the market value per share was $10. Prior to the split, Omar had 100,000 shares issued and outstanding. After the split, what is the market value of the shares? Select one:

a. 10

b. 20

c. 50

d. 2

2) How would retained earnings be affected by the declaration of cash dividends – common and stock dividends? Select one:

a. Component of shareholders’ equity as part of total shareholders’ equity

b. Component of total liabilities as current liability

c. Component of total liabilities as noncurrent liability

d. Component of equity as part of share premium

3) What information is typically included in the shareholders’ equity of a public corporation’s balance sheet?

i - Number of shares authorized ii - Number of shares issued iii - Number of shares outstanding iv – Number of shares held by each shareholder Select one:

a. all of i, ii, iii, and iv

b. i and ii only

c. i and iv only

d. i, ii, and iii only

4) A liquidating dividend: Select one:

a. Forces to corporation to downsize its operations

b. Uses paid-in capital to pay dividends

c. Forces shareholders to sell their shares for cash

d. Forces the issuer to repurchase shares for cash Forces to corporation to downsize its operations

5) How would retained earnings be affected by the declaration of cash dividends – common and stock dividends? Select one:

a. Decrease and Decrease

b. No effect and No effect

c. Decrease and No effect

d. No effect and Decrease

Using the scenario provided, your textbook, and at least one outside source discuss whether you agree with the intern’s decision to use an absorption format for her segmented income statement and her decision to allocate the common fixed expenses to the Commercial and Residential segments? Why or why not? Write in complete sentences and included proper APA citations for each of your sources used in your post.

Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s accounting intern was asked to prepare segmented income statements that the company’s divisional managers could use to calculate their break-even points and make decisions. She took the prior month’s companywide income statement and prepared the absorption format segmented income statement shown below:

In preparing these statements, the intern determined that Toxaway’s only variable selling and administrative expense is a 10% sales commission on all sales. The company’s total fixed expenses include $72,000 of common fixed expenses that would continue to be incurred even if the Commercial or Residential segments are discontinued, $55,000 of fixed expenses that would be avoided if the Commercial segment is dropped, and $38,000 of fixed expenses that would be avoided if the Residential segment is dropped.

Inventory by Three Methods; Cost of Goods Sold

The units of an item available for sale during the year were as follows:

There are 19 units of the item in the physical inventory at December 31.

Determine the cost of ending inventory and the cost of goods sold by three methods, presenting your answers in the following form:

Round your final answers to the nearest dollar.

10. The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information:

    	May		June		July
    Sales	$86,000		$90,000		$95,000
    Manufacturing costs	34,000		39,000		44,000
    Selling and administrative expenses	15,000		16,000		22,000
    Capital expenditures	_		_		80,000

    The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $3,500 of the estimated monthly manufacturing costs. The annual insurance premium is paid in September, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month.

    Current assets as of May 1 include cash of $33,000, marketable securities of $40,000, and accounts receivable of $90,000 ($72,000 from April sales and $18,000 from March sales). Sales on account for March and April were $60,000 and $72,000, respectively. Current liabilities as of May 1 include $6,000 of accounts payable incurred in April for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of $14,000 will be made in June. Sonoma’s regular quarterly dividend of $5,000 is expected to be declared in June and paid in July. Management wants to maintain a minimum cash balance of $30,000.

    Required:

    1. Prepare a monthly cash budget and supporting schedules for May, June, and July 2016. Input all amounts as positive values except overall cash decrease and deficiency which should be indicated with a minus sign.

    Sonoma Housewares Inc.
    Cash Budget
    For the Three Months Ending July 31
    	May	June	July
    Estimated cash receipts from:
    Cash sales	$	$	$
    Collection of accounts receivable
    Total cash receipts	$	$	$
    Estimated cash payments for:
    Manufacturing costs	$	$	$
    Selling and administrative expenses
    Capital expenditures
    Other purposes:
    Income tax
    Dividends
    Total cash payments	$	$	$
    Cash increase or (decrease)	$	$	$
    Cash balance at beginning of month
    Cash balance at end of month	$	$	$
    Minimum cash balance
    Excess or (deficiency)	$	$	$

    2. The budget indicates that the minimum cash balance be maintained in July. This situation can be corrected by and/or by the of the marketable securities, if they are held for such purposes. At the end of May and June, the cash balance will the minimum desired balance.

On the basis of the following data, determine the value of the inventory at the lower of cost or market. Assemble the data in the form illustrated in Exhibit 10.

a. Determine the value of the inventory at the lower of cost or market applied to each item in the inventory.

b. Determine the value of the inventory at the lower of cost or market applied to each class of inventory.

c. Determine the value of the inventory at the lower of cost or market applied to total inventory.

MatchPoint Racket Company manufactures two types of tennis rackets, the Junior and Pro Striker models. The production budget for March for the two rackets is as follows:

Both rackets are produced in two departments, Forming and Assembly. The direct labor hours required for each racket are estimated as follows:

The direct labor rate for each department is as follows:

Prepare the direct labor cost budget for March.

Requirement: Complete the various budget schedules using Excel.

The Distribution Center of 123 Oil and Gas Company wants a master budget for the next three months, beginning January 1st. It desires an ending minimum cash balance of $4,000 each month. Sales are forecasted at an average selling price/transfer price of $4 per widget. In January, the Distribution Centre is beginning just-in-time deliveries from suppliers, which means that purchases equal expected sales. The December 31 inventory balance will be drawn down to $5,000, which will be the desired ending inventory thereafter. Purchase price per widget is $2. Purchases during any given month are paid in full during the following month. All sales are on credit, payable within thirty days, but experience has shown that 60 percent of current sales are collected in the current month, 30 percent in the next month, and 10 percent in the month thereafter. Bad debts are negligible. The Distribution Centre sells to related sister corporations as well as outside/external sales. The following are some of the expenses for the Distribution Centre:

Wages and salaries $12000/month Insurance expired 100/month Depreciation 200/month Miscellaneous 2000/month

Rent 200/month + 10% of quarterly sales over $10,000

Cash dividends of $1,000 are to be paid quarterly, beginning January 15, and are declared on the fifteenth of the previous month. All operating expenses are paid as incurred, except insurance, depreciation, and rent. Rent of $200 is paid at the beginning of each month and the additional 10 percent of sales is paid quarterly on the tenth of the month following the quarter. The next settlement is due January 10.

The company plans to buy some new office fixtures for $2,000 cash in March. To the distribution company this will be considered a capital purchase.

Money can be borrowed and repaid in multiples of $500, at an interest rate of 12 percent per annum. Management wants to minimize borrowing and repay rapidly. Interest is computed and paid when the principal is repaid. Assume that borrowing takes place at the beginning, and repayment at the end, of the months in question. Money is never borrowed at the beginning and repaid at the end of the same month. Compute interest to the nearest dollar.

ASSETS AS OF
DECEMBER 31,
Cash $4,000 Accounts receivable 16,000 Inventory* 31,250 Prepaid insurance 1,200 Fixed assets, net 10,000

Total $62,450

LIABILITIES AS OF DECEMBER 31,
Accounts payable (merchandise) $28,750 Dividends payable $1,000 Rent Payable $6,000

Total $35,750

*November 30 inventory balance = $12,500

Recent and forecasted sales:

October $30,000 December $20,000 November $20,000 January $50,000 February $60,000 March $30,000 April $36,000

Required

Prepare a master budget for the following schedules identified below. Use Excel and incorporate a formula based spread sheet whenever possible. I will be altering the sales figures in your submitted Excel spread sheet to test your formulas.

Work Sheet/Template Cash Collections Schedule

Purchase Budget

Statement of Cash Receipts and Disbursements

Income Statement for the 3 months ending March 31

Balance Sheet as of March 31:

Wesley Power Tools manufactures a wide variety of tools and accessories. One of its more popular items is a cordless power handisaw. Each handisaw sells for $46. Wesley expects the following unit sales:

Wesley’s ending finished goods inventory policy is 25 percent of the next month’s sales.

Suppose each handisaw takes approximately 0.60 hours to manufacture, and Wesley pays an average labor wage of $22 per hour.

Each handisaw requires a plastic housing that Wesley purchases from a supplier at a cost of $5.00 each. The company has an ending direct materials inventory policy of 20 percent of the following month’s production requirements. Materials other than the housing unit total $4.50 per handisaw.

Manufacturing overhead for this product includes $72,000 annual fixed overhead (based on production of 27,000 units) and $1.20 per unit variable manufacturing overhead. Wesley’s selling expenses are 7 percent of sales dollars, and administrative expenses are fixed at $18,000 per month.

Required:
Compute the following for the first quarter: (Round your intermediate calculations to nearest whole dollar.)

Problem 6-25 Prepare and Interpret Income Statements; Changes in Both Sales and Production; Lean Production [LO6-1, LO6-2, LO6-3]

Starfax, Inc., manufactures a small part that is widely used in various electronic products such as home computers. Results for the first three years of operations were as follows (absorption costing basis):

In the latter part of Year 2, a competitor went out of business and in the process dumped a large number of units on the market. As a result, Starfax’s sales dropped by 20% during Year 2 even though production increased during the year. Management had expected sales to remain constant at 50,000 units; the increased production was designed to provide the company with a buffer of protection against unexpected spurts in demand. By the start of Year 3, management could see that it had excess inventory and that spurts in demand were unlikely. To reduce the excessive inventories, Starfax cut back production during Year 3, as shown below:

Additional information about the company follows:

1. The company’s plant is highly automated. Variable manufacturing expenses (direct materials, direct labor, and variable manufacturing overhead) total only $6.00 per unit, and fixed manufacturing overhead expenses total $450,000 per year.

2. A new fixed manufacturing overhead rate is computed each year based that year's actual fixed manufacturing overhead costs divided by the actual number of units produced.

3. Variable selling and administrative expenses were $3 per unit sold in each year. Fixed selling and administrative expenses totaled $80,000 per year.

4. The company uses a FIFO inventory flow assumption. (FIFO means first-in first-out. In other words, it assumes that the oldest units in inventory are sold first.)

Starfax’s management can’t understand why profits doubled during Year 2 when sales dropped by 20% and why a loss was incurred during Year 3 when sales recovered to previous levels.

Required:

1. Prepare a contribution format variable costing income statement for each year.

2. Refer to the absorption costing income statements above.

a. Compute the unit product cost in each year under absorption costing. Show how much of this cost is variable and how much is fixed.

b. Reconcile the variable costing and absorption costing net operating income figures for each year.

5b. If Lean Production had been used during Year 2 and Year 3, what would the company’s net operating income (or loss) have been in each year under absorption costing?

Futaba photo shop has three services, print, enlargement, frame. The shop owner thinks these two services can be sold as a bundle, Print 3, Enlarge 4 and Frame 1. The company spends 10% of selling price as variable advertising expenses. Fixed cost for the shop is $129,320. The following information related to these three services is given.

Determine the contribution margin per unit of each product

Compute the breakeven point volume for each service. Present supporting calculations

What is the total sales units required to earn profit of $252,000 on after tax, the above assumption and a tax rate of 40%?

DuPONT ANALYSIS

A firm has been experiencing low profitability in recent years. Perform an analysis of the firm's financial position using the DuPont equation. The firm has no lease payments but has a $2 million sinking fund payment on its debt. The most recent industry average ratios and the firm's financial statements are as follows:

^aCalculation is based on a 365-day year.

1. Calculate the following ratios. Do not round intermediate steps. Round your answers to two decimal places.

   	Firm	Industry Average
   Current ratio	x	3.17x
   Debt to total capital	%	20.40%
   Times interest earned	x	22.72x
   EBITDA coverage	x	19.80x
   Inventory turnover	x	12.59x
   Days sales outstanding	days	23.7days
   Fixed assets turnover	x	6.73x
   Total assets turnover	x	3.78x
   Profit margin	%	8.24%
   Return on total assets	%	30.69%
   Return on common equity	%	47.29%
   Return on invested capital	%	38.40%

2. Construct a DuPont equation for the firm and the industry. Do not round intermediate steps. Round your answers to two decimal places.

   	Firm	Industry
   Profit margin	%	8.24%
   Total assets turnover	x	3.78x
   Equity multiplier	x	x

3. Do the balance sheet accounts or the income statement figures seem to be primarily responsible for the low profits?
   -Select-IIIIIIIVVItem 17
   1. The low ROE for the firm is due to the fact that the firm is utilizing more debt than the average firm in the industry and the low ROA is mainly a result of an excess investment in assets.
   2. The low ROE for the firm is due to the fact that the firm is utilizing less debt than the average firm in the industry and the low ROA is mainly a result of an lower than average investment in assets.
   3. Analysis of the extended Du Pont equation and the set of ratios shows that the turnover ratio of sales to assets is quite low; however, its profit margin compares favorably with the industry average. Either sales should be higher given the present level of assets, or the firm is carrying more assets than it needs to support its sales.
   4. Analysis of the extended Du Pont equation and the set of ratios shows that the turnover ratio of sales to assets is quite low; however, its profit margin compares favorably with the industry average. Either sales should be lower given the present level of assets, or the firm is carrying less assets than it needs to support its sales.
   5. Analysis of the extended Du Pont equation and the set of ratios shows that most of the Asset Management ratios are below the averages. Either assets should be higher given the present level of sales, or the firm is carrying less assets than it needs to support its sales.
      
4. Which specific accounts seem to be most out of line relative to other firms in the industry?
   -Select-IIIIIIIVVItem 18
   1. The accounts which seem to be most out of line include the following ratios: Debt to Total Capital, Inventory Turnover, Total Asset Turnover, Return on Assets, and Profit Margin.
   2. The accounts which seem to be most out of line include the following ratios: Times Interest Earned, Total Asset Turnover, Profit Margin, Return on Assets, and Return on Equity.
   3. The accounts which seem to be most out of line include the following ratios: Inventory Turnover, Days Sales Outstanding, Fixed Asset Turnover, Profit Margin, and Return on Equity.
   4. The accounts which seem to be most out of line include the following ratios: Inventory Turnover, Days Sales Outstanding, Total Asset Turnover, Return on Assets, and Return on Equity.
   5. The accounts which seem to be most out of line include the following ratios: Current, EBITDA Coverage, Inventory Turnover, Days Sales Outstanding, and Return on Equity.
      
5. If the firm had a pronounced seasonal sales pattern or if it grew rapidly during the year, how might that affect the validity of your ratio analysis?
   -Select-IIIIIIIVVItem 19
   1. It is more important to adjust the debt ratio than the inventory turnover ratio to account for any seasonal fluctuations.
   2. Seasonal sales patterns would most likely affect the profitability ratios, with little effect on asset management ratios. Rapid growth would not substantially affect your analysis.
   3. Rapid growth would most likely affect the coverage ratios, with little effect on asset management ratios. Seasonal sales patterns would not substantially affect your analysis.
   4. Seasonal sales patterns would most likely affect the liquidity ratios, with little effect on asset management ratios. Rapid growth would not substantially affect your analysis.
   5. If the firm had seasonal sales patterns, or if it grew rapidly during the year, many ratios would most likely be distorted.
      
   
   How might you correct for such potential problems?
   -Select-IIIIIIIVVItem 20
   1. It is possible to correct for such problems by comparing the calculated ratios to the ratios of firms in the same industry group over an extended period.
   2. There is no need to correct for these potential problems since you are comparing the calculated ratios to the ratios of firms in the same industry group.
   3. It is possible to correct for such problems by insuring that all firms in the same industry group are using the same accounting techniques.
   4. It is possible to correct for such problems by using average rather than end-of-period financial statement information.
   5. It is possible to correct for such problems by comparing the calculated ratios to the ratios of firms in a different line of business.

Said Al Hamli and his friend Khaled Al Masri are the owners of a small hotel, the Sun Star, in the Red Sea town of Hurghada. Close to Cairo, the resort town has grown from a fishing village to one of Egypt’s famous vacation spots. Hurghada is the gateway to many small islands and offshore reefs favored by recreational snorkelers and divers and many tourists combine their stay with excursions to the Nile Valley, the Great Pyramids and Luxor.

To take advantage of the growing numbers of tourists, particularly from Europe and the Middle East, Said and Khaled are planning to double the room capacity of their hotel by adding a second building to the already existing structure. Fortunately, Said recognized the great potential of Hurghada ten years ago, well before the town became a hub for recreational tourism, and bought the land adjacent to the hotel for relatively little money when it was still under construction.

Now, Said and Khaled are studying the new layout and trying to determine if the expected revenues justify the substantial initial investment of EGP 70 million ($11.8 million). According to their calculations, operating cost would rise by EGP 23.8 million ($4 million) in the first year, which would include hiring and training of new personnel, maintenance of facilities and equipment etc., and likely increase by about 5 percent per year thereafter. With an aggressive marketing strategy, Said and Khaled believe that a revenue enhancement of EGP 20.8 million in the first year is realistic and that a subsequent annual increase of about 15 percent for eight to nine years, with revenues leveling off thereafter, can be achieved. Ideally, Khaled would like to retire in ten years. Seeking advice from you, a knowledgeable friend, they share their detailed cost and revenue projections with you.

QUESTIONS

Fallow Corporation is subject to tax only in State X. State income taxes are not deductible for State X income tax purposes. Fallow generated the following income and deductions:

a. The starting point in computing the State X income tax base is Federal taxable income, which is $.

b. If the interest on State X's obligations is exempt from State X's income tax, Fallow's State X taxable income is $.

c. If the interest on State X's obligations is subject to State X's income tax, Fallow's State X taxable income is $.