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
In: Accounting
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:
|
Total Company |
Commercial |
Residential |
|
|
Sales |
$750,000 |
$250,000 |
$500,000 |
|
Cost of goods sold |
500,000 |
140,000 |
360,000 |
|
Gross margin |
250,000 |
110,000 |
140,000 |
|
Selling and administrative expenses |
240,000 |
104,000 |
136,000 |
|
Net operating income |
$ 10,000 |
$ 6,000 |
$ 4,000 |
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.
In: Accounting
Inventory by Three Methods; Cost of Goods Sold
The units of an item available for sale during the year were as follows:
| Jan. 1 | Inventory | 23 units at $1,800 |
| May 15 | Purchase | 30 units at $1,950 |
| Aug. 7 | Purchase | 12 units at $2,040 |
| Nov. 20 | Purchase | 17 units at $2,100 |
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.
| Cost | ||
| Inventory Method | Ending Inventory | Cost of Goods Sold |
| a. First-in, first-out method | $fill in the blank 1 | $fill in the blank 2 |
| b. Last-in, first-out method | $fill in the blank 3 | $fill in the blank 4 |
| c. Weighted average cost method | $fill in the blank 5 | $fill in the blank 6 |
In: Accounting
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.
In: Accounting
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.
| Product |
Inventory |
Cost Per |
|
| Class 1: | |||
| Model A | 34 | $66 | $82 |
| Model B | 8 | 45 | 24 |
| Model C | 41 | 44 | 59 |
| Class 2: | |||
| Model D | 27 | 235 | 259 |
| Model E | 39 | 281 | 293 |
a. Determine the value of the inventory at the lower of cost or market applied to each item in the inventory.
| Inventory at the Lower of Cost or Market | ||||||
Product |
Inventory Quantity |
Cost per Unit |
Market Value per Unit (Net Realizable Value) |
Cost | Market | Lower of Cost or Market |
| Model A | $ | $ | $ | $ | $ | |
| Model B | ||||||
| Model C | ||||||
| Model D | ||||||
| Model E | ||||||
| Total | $ | $ | $ | |||
b. Determine the value of the inventory at the lower of cost or market applied to each class of inventory.
| Inventory at the Lower of Cost or Market |
||||||
Product |
Inventory Quantity |
Cost per Unit |
Market Value per Unit (Net Realizable Value) |
Cost | Market | Lower of Cost or Market |
| Class 1: | ||||||
| Model A | $ | $ | $ | $ | ||
| Model B | ||||||
| Model C | ||||||
| Subtotal | $ | $ | $ | |||
| Class 2: | ||||||
| Model D | $ | $ | ||||
| Model E | ||||||
| Subtotal | $ | $ | ||||
| Total | $ | $ | $ | |||
c. Determine the value of the inventory at the lower of cost or market applied to total inventory.
| Inventory at the Lower of Cost or Market | ||||||
Product |
Inventory Quantity |
Cost per Unit |
Market Value per Unit (Net Realizable Value) |
Cost | Market | Lower of Cost or Market |
| Model A | $ | $ | $ | $ | ||
| Model B | ||||||
| Model C | ||||||
| Model D | ||||||
| Model E | ||||||
| Total | $ | $ | $ | |||
In: Accounting
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:
| Junior | Pro Striker | |
| Production budget | 6,300 units | 18,800 units |
Both rackets are produced in two departments, Forming and Assembly. The direct labor hours required for each racket are estimated as follows:
| Forming Department | Assembly Department | |
| Junior | 0.25 hour per unit | 0.5 hour per unit |
| Pro Striker | 0.35 hour per unit | 0.6 hour per unit |
The direct labor rate for each department is as follows:
| Forming Department | $16 per hour |
| Assembly Department | $9 per hour |
Prepare the direct labor cost budget for March.
| MatchPoint Racket Company | ||
| Direct Labor Cost Budget | ||
| For the Month Ending March 31 | ||
| Forming Department |
Assembly Department |
|
| Hours required for production: | ||
| Junior | ||
| Pro Striker | ||
| Total hours required | ||
| Hourly rate | x$ | x$ |
| Total direct labor cost | $ | $ |
In: Accounting
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
|
January |
February |
March |
|
|
60% of current months sale |
|||
|
30% of previous months sale |
|||
|
10% of second previous months sale |
|||
|
Total collections |
Purchase Budget
|
December |
January |
February |
March |
|
|
Desired Ending Inventory |
||||
|
Cost of Goods Sold |
||||
|
Total Needed |
||||
|
Beginning Inventory |
||||
|
Purchases |
Statement of Cash Receipts and Disbursements
|
January |
February |
March |
|
|
Cash Balance Beginning |
|||
|
Plus Cash Collections |
|||
|
=Cash Available Before Financing |
|||
|
Less Cash Disbursements: |
|||
|
Purchases |
|||
|
Rent |
|||
|
Wage and Salaries |
|||
|
Miscellaneous Expenses |
|||
|
Dividends |
|||
|
Purchase of Fixtures |
|||
|
Total Disbursements |
|||
|
Plus Minimum Cash Desired |
|||
|
Total Cash Needed |
|||
|
Excess (Deficiency) |
|||
|
Financing: |
|||
|
Borrowing, at the beginning of period |
|||
|
Repayment, at the end of period |
|||
|
Interest at 12% per annum |
|||
|
Cash Balance, end |
Income Statement for the 3 months ending March 31
|
Sales |
|
|
Less Cost of Goods Sold |
|
|
=Gross Profit |
|
|
Less Operating Expenses: |
|
|
? |
|
|
? |
|
|
? |
|
|
? |
|
|
? |
|
|
Net Income from Operations |
|
|
Interest Expense |
|
|
Net Income |
Balance Sheet as of March 31:
|
Assets |
|
|
Current Assets: |
|
|
Cash |
|
|
Accounts Receivable |
|
|
Inventory |
|
|
Prepaid |
|
|
Fixed Assets |
|
|
Total Assets |
|
|
Liabilities: |
|
|
Accounts Payable |
|
|
Rent Payable |
|
|
Dividend Payable |
|
|
Shareholders’ Equity |
|
|
Retained Earnings and Share Capital |
In: Accounting
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:
| January | 3,800 |
| February | 4,000 |
| March | 4,500 |
| April | 4,300 |
| May | 3,700 |
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.)
|
In: Accounting
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):
| Year 1 | Year 2 | Year 3 | ||||||||
| Sales | $ | 1,000,000 | $ | 780,000 | $ | 1,000,000 | ||||
| Cost of goods sold | 750,000 | 540,000 | 787,500 | |||||||
| Gross margin | 250,000 | 240,000 | 212,500 | |||||||
| Selling and administrative expenses | 230,000 | 200,000 | 230,000 | |||||||
| Net operating income (loss) | $ | 20,000 | $ | 40,000 | $ | (17,500 | ) | |||
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:
| Year 1 | Year 2 | Year 3 | |
| Production in units | 50,000 | 60,000 | 40,000 |
| Sales in units | 50,000 | 40,000 | 50,000 |
Additional information about the company follows:
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.
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.
Variable selling and administrative expenses were $3 per unit sold in each year. Fixed selling and administrative expenses totaled $80,000 per year.
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?
In: Accounting
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.
|
|
Enlarge |
Frame |
||
|
Selling price |
0.8 |
1.2 |
4.5 |
|
|
Direct material and labor costs per unit |
0.17 |
0.31 |
1.8 |
|
|
Variable manufacturing costs |
0.10 |
0.22 |
0.5 |
|
|
Expected sales units |
45,000 |
60,000 |
15,000 |
|
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%?
In: Accounting
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:
| Industry Average Ratios | ||||
| Current ratio | 3.17x | Fixed assets turnover | 6.73x | |
| Debt-to-capital ratio | 20.40% | Total assets turnover | 3.78x | |
| Times interest earned | 22.72x | Profit margin | 8.24% | |
| EBITDA coverage | 19.80x | Return on total assets | 30.69% | |
| Inventory turnover | 12.59x | Return on common equity | 47.29% | |
| Days sales outstandinga | 23.7 days | Return on invested capital | 38.4% | |
aCalculation is based on a 365-day year.
| Balance Sheet as of December 31, 2016 (Millions of Dollars) | ||||
| Cash and equivalents | $50 | Accounts payable | $30 | |
| Accounts receivables | 44 | Other current liabilities | 14 | |
| Inventories | 83 | Notes payable | 33 | |
| Total current assets | $177 | Total current liabilities | $77 | |
| Long-term debt | 14 | |||
| Total liabilities | $91 | |||
| Gross fixed assets | 124 | Common stock | 77 | |
| Less depreciation | 26 | Retained earnings | 107 | |
| Net fixed assets | $98 | Total stockholders' equity | $184 | |
| Total assets | $275 | Total liabilities and equity | $275 | |
| Income Statement for Year Ended December 31, 2016 (Millions of Dollars) | |
| Net sales | $550.0 |
| Cost of goods sold | 412.5 |
| Gross profit | $137.5 |
| Selling expenses | 38.5 |
| EBITDA | $99.0 |
| Depreciation expense | 9.4 |
| Earnings before interest and taxes (EBIT) | $89.6 |
| Interest expense | 2.8 |
| Earnings before taxes (EBT) | $86.8 |
| Taxes (40%) | 34.7 |
| Net income | $52.1 |
| 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% |
| Firm | Industry | |
| Profit margin | % | 8.24% |
| Total assets turnover | x | 3.78x |
| Equity multiplier | x | x |
In: Accounting
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.
|
Year |
Cash (EGP) |
Revenue (EGP) |
|
0 |
−70,000,000 |
|
|
1 |
−23,800,000 |
20,825,000 |
|
2 |
−24,990,000 |
23,949,000 |
|
3 |
−26,239,000 |
27,541,000 |
|
4 |
−27,551,000 |
31,672,000 |
|
5 |
−28,929,000 |
36,423,000 |
|
6 |
−30,375,000 |
41,887,000 |
|
7 |
−31,894,000 |
48,169,000 |
|
8 |
−33,489,000 |
55,395,000 |
|
9 |
−35,163,000 |
63,704,000 |
|
10 |
−36,922,000 |
73,259,000 |
QUESTIONS
|
1. |
Determine the resulting net cash flow for each year; and compute:
|
||||||
|
2. |
Give your decision on each result in terms of the project’s expected profitability and Khaled’s ten-year investment horizon |
In: Accounting
In: Accounting
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 $.
In: Accounting
Exercise 17-13 The 2020 accounting records of Blocker Transport reveal these transactions and events. Payment of interest $10,600 Collection of accounts receivable $190,700 Cash sales 49,900 Payment of salaries and wages 56,100 Receipt of dividend revenue 17,100 Depreciation expense 15,000 Payment of income taxes 15,300 Proceeds from sale of vehicles 12,600 Net income 37,900 Purchase of equipment for cash 21,700 Payment of accounts payable Loss on sale of vehicles 3,200 for merchandise 114,400 Payment of dividends 14,600 Payment for land 73,800 Payment of operating expenses 28,700
Prepare the cash flows from operating activities section using the
direct method.
In: Accounting