Nicolas Drinks Inc. (Nicolas) manufactures fizzy drinks such as
cola and lemonade as
well as other soft drinks and its year end is 31 December 2017. You
are the audit
manager of B&J CPAs LL.P. and are currently planning the audit
of Nicolas.
You attended the planning meeting with the engagement partner and
finance director
last week and recorded the minutes from the meeting shown below.
You are reviewing
these as part of the process of preparing the audit strategy.
Minutes of planning meeting for Nicolas
Nicolas’ sales results have been strong this year and the company
is forecasting
revenue of $85 million, which is an increase from the previous
year. The company has
invested significantly in the cola and fizzy drinks production
process at the factory. This
resulted in expenditure of $5 million on updating, repairing and
replacing a significant
amount of the machinery used in the production process.
As the level of production has increased, the company has expanded
the number of
warehouses it uses to store inventory. It now utilises 15
warehouses; some are owned
by Nicolas and some are rented from third parties. There will be
inventory counts taking
place at all 15 of these sites at the year end.
A new accounting general ledger has been introduced at the
beginning of the year, with
the old and new systems being run in parallel for a period of two
months.
As a result of the increase in revenue, Nicolas has recently
recruited a new credit
controller to chase outstanding receivables. The finance director
thinks it is not
necessary to continue to maintain an allowance for receivables and
so has released the
opening allowance of $1·5 million.
In addition, Nicolas has incurred expenditure of $4·5 million on
developing a new brand
of fizzy soft drinks. The company started this process in January
2017 and is close to
launching their new product into the market place. The finance
director stated that there
was a problem in November in the mixing of raw materials within the
production process
which resulted in a large batch of cola products tasting different.
A number of these
products were sold; however, due to complaints by customers about
the flavour, no
further sales of these goods have been made. No adjustment has been
made to the
valuation of the damaged inventory, which will still be held at
cost of $1 million at the
year end.
As in previous years, the management of Nicolas is due to be paid a
significant annual
bonus based on the value of year-end total assets.
Required:
1. Using the minutes provided, identify and describe SIX audit
risks, and explain the
auditor’s response to each risk, in planning the audit of Nicolas
Drinks Inc. (12
marks)
2. Describe substantive procedures the audit team should perform to
obtain
sufficient and appropriate audit evidence in relation to the
following three matters:
(i) The treatment of the $5 million expenditure incurred on
improving the
factory production process;
(ii) The release of the $1·5 million allowance for receivables;
and
(iii) The damaged inventory.
In: Accounting
b) Electric Car Co (ECC). currently manufactures two different types of fully electronic cars in 2021. Type 8Y is a large SUV whereas Type 8W will be the fastest car in the world with 10 rocket thrusters. ECC has decided to use ABC costing instead of traditional costing. The 2021 budget to manufacture these new types include manufacturing overhead of $126,920,760 which has been allocated on each product’s inspection hours. The expected prime costs of two new types are as follows: Type 8Y Type 8W Prime Costs $20,915 $43,625 ECC’s controller believes the traditional costing system may be providing misleading cost information. They have developed an analysis of the 2021 budgeted manufacturing-overhead costs shown in the following chart. Activity Cost Driver Budgeted Activity Budgeted Cost Assembly Assembly hours 10,000 $63,460,000 Inspection Inspection hours 10,000 $27,920,000 Painting Gallons of paint 5,000 $22,850,000 Quality control Number of tests 8,000 $12,690,760 Total manufacturing-overhead cost $126,920,760 Actual data regarding the 2021 manufacturing of the Type 8Y and the Type 8W is shown in the following table with a total MOH of $216,920,760: Type 8Y Type 8W Budgeted Sales (units) 2,222 555 Assembly hours 767 2,955 Inspection hours 767 2,955 Paint Gallons 383 1477 Tests 612 2364 Required: 1) Using the traditional method i. Determine the company’s predetermined overhead rate(s) applied ii. Determine how much overhead was applied to Type 8Y iii. Provide the MOH true up journal entry required for this method at the end of the year 2) Using the ABC method i. Determine the company’s predetermined overhead rate(s) applied ii. Determine how much overhead was applied to Type 8Y iii. Provide the MOH true up journal entry required for this method at the end of the year
In: Accounting
Windsor Corporation had 141,600 shares of stock outstanding on January 1, 2017. On May 1, 2017, Windsor issued 48,000 shares. On July 1, Windsor purchased 9,600 treasury shares, which were reissued on October 1. Compute Windsor’s weighted-average number of shares outstanding for 2017.
In: Accounting
Denton Company manufactures and sells a single product. Cost data for the product are given:
| Variable costs per unit: | ||||
| Direct materials | $ | 3 | ||
| Direct labor | 11 | |||
| Variable manufacturing overhead | 3 | |||
| Variable selling and administrative | 2 | |||
| Total variable cost per unit | $ | 19 | ||
| Fixed costs per month: | ||||
| Fixed manufacturing overhead | $ | 180,000 | ||
| Fixed selling and administrative | 166,000 | |||
| Total fixed cost per month | $ | 346,000 | ||
The product sells for $51 per unit. Production and sales data for July and August, the first two months of operations, follow:
| Units Produced |
Units Sold |
|
| July | 30,000 | 26,000 |
| August | 30,000 | 34,000 |
The company’s Accounting Department has prepared the following absorption costing income statements for July and August:
| July | August | ||||
| Sales | $ | 1,326,000 | $ | 1,734,000 | |
| Cost of goods sold | 598,000 | 782,000 | |||
| Gross margin | 728,000 | 952,000 | |||
| Selling and administrative expenses | 218,000 | 234,000 | |||
| Net operating income | $ | 510,000 | $ | 718,000 | |
Required:
1. Prepare contribution format variable costing income statements for July and August.
2. Reconcile the variable costing and absorption costing net operating incomes.
In: Accounting
Assume your organization has the following inventory changes during the year.
Beginning inventory - 15 units valued at $10,000 each
February purchases - 13 units at $11,500 each
June purchases - 20 units at $12,000 each
Total units used - 42
calculate the value of then ending inventory and the value of the inventory used for the year, using both the FIFO and the LIFO method of cost flow
In: Accounting
The general ledger of Red Storm Cleaners at January 1, 2018, includes the following account balances:
| Accounts | Debits | Credits | ||||
| Cash | $ | 12,000 | ||||
| Accounts Receivable | 6,400 | |||||
| Supplies | 2,400 | |||||
| Equipment | 18,000 | |||||
| Accumulated Depreciation | $ | 6,200 | ||||
| Salaries Payable | 8,700 | |||||
| Common Stock | 17,000 | |||||
| Retained Earnings | 6,900 | |||||
| Totals | $ | 38,800 | $ | 38,800 | ||
The following is a summary of the transactions for the year:
Required:
1., 3. 6. & 10. Enter the unadjusted balances from the trial balance and post the adjusting entries to the T-accounts, and post the closing entries to the T-accounts.
2. Record each of the summary transactions listed above. (If no entry is required for a particular transaction, select "No journal entry required" in the first account field.)
4. Prepare an unadjusted trial balance.
5. Record adjusting entries. (If no entry is required for a particular transaction/event, select "No journal entry required" in the first account field.)
7. Prepare an adjusted trial balance.
8-a. Prepare the income statement for the year ended December 31, 2018.
9. Record closing entries. (If no entry is required for a particular transaction/event, select "No journal entry required" in the first account field.)
11. Prepare a post-closing trial balance.
In: Accounting
Troy Engines, Ltd., manufactures a variety of engines for use in heavy equipment. The company has always produced all of the necessary parts for its engines, including all of the carburetors. An outside supplier has offered to sell one type of carburetor to Troy Engines, Ltd., for a cost of $40 per unit. To evaluate this offer, Troy Engines, Ltd., has gathered the following information relating to its own cost of producing the carburetor internally:
| Per Unit | 15,000 Units per Year |
|||||
| Direct materials | $ | 15 | $ | 225,000 | ||
| Direct labor | 11 | 165,000 | ||||
| Variable manufacturing overhead | 2 | 30,000 | ||||
| Fixed manufacturing overhead, traceable | 9 | * | 135,000 | |||
| Fixed manufacturing overhead, allocated | 12 | 180,000 | ||||
| Total cost | $ | 49 | $ | 735,000 | ||
*One-third supervisory salaries; two-thirds depreciation of special equipment (no resale value).
Required:
1. Assuming the company has no alternative use for the facilities that are now being used to produce the carburetors, what would be the financial advantage (disadvantage) of buying 15,000 carburetors from the outside supplier?
2. Should the outside supplier’s offer be accepted?
3. Suppose that if the carburetors were purchased, Troy Engines, Ltd., could use the freed capacity to launch a new product. The segment margin of the new product would be $150,000 per year. Given this new assumption, what would be the financial advantage (disadvantage) of buying 15,000 carburetors from the outside supplier?
4. Given the new assumption in requirement 3, should the outside supplier’s offer be accepted?
Assuming the company has no alternative use for the facilities that are now being used to produce the carburetors, what would be the financial advantage (disadvantage) of buying 15,000 carburetors from the outside supplier?
Should the outside supplier’s offer be accepted? Yes/No
Suppose that if the carburetors were purchased, Troy Engines, Ltd., could use the freed capacity to launch a new product. The segment margin of the new product would be $150,000 per year. Given this new assumption, what would be the financial advantage (disadvantage) of buying 15,000 carburetors from the outside supplier?'
In: Accounting
XYZ Corporation has a deferred compensation plan under which it allows certain employees to defer up to 20 percent of their salary for five years. For purposes of this problem, ignore payroll taxes in your computations. (Use Table 1.) (Round your intermediate calculations and final answers to the nearest whole dollar amount.)
Problem 13-61 Part a
a. Assume XYZ has a marginal tax rate of 21 percent for the foreseeable future and earns an after-tax rate of return of 13 percent on its assets. Joel Johnson, XYZ’s VP of finance, is attempting to determine what amount of deferred compensation XYZ should be willing to pay in five years that would make XYZ indifferent between paying the current salary of $10,400 and paying the deferred compensation. What amount of deferred compensation would accomplish this objective?
In: Accounting
4. During 3 months of the year, current assets drop to $400,000. Its operating profit (EBIT) is expected to be $620,000. Its tax rate is 40 percent. Shares are valued at $10. Its capital structure is short-term financing at 3 percent and long-term financing of 50 percent equity, 50 percent debt at 6 percent. (Round the final answers to 2 decimal places.)
a. Calculate expected EPS if the firm is perfectly hedged. EPS $
b. Calculate expected EPS if Phu is a more aggressive with its capital structure and finances all current assets and 20 percent of its capital assets with short-term loans. EPS $
c. Recalculate a and b if short-term rates go to 8 percent while long-term rates remain the same. EPS Perfectly Hedged $ Capital structure $
In: Accounting
Link Company acquired Tuna Inc. on January 1, 2017. On January 1, 2017 all of Tuna's assets and liabilities had a FVs = BV except for the following:
Land was undervalued by $30,000
Buildings were overvalued by $45,000 (20-yr remaining useful life)
Equipment was undervalued by $90,000 (5-yr remaining useful life)
In addition, Tuna had internally developed a customer list with an appraised value of $150,000 and a 10-yr remaining useful life. Link originally acquired Tuna at the FV of its net identifiable assets that equaled $1,050,000.
The following are selected accounts for Link's Company and Tuna Inc as of December 31, 2021 ( Link's investment in Tuna and equity in Tuna's income accounts have been omitted). Credit balances are indicated by parenthesis:
| Link | Tuna | |
| Revenues | (900,000) | (375,000) |
| COGS | 420,000 | 150,000 |
| Depreciation Exps | 180,000 | 75,000 |
| RE, Beginning Balance | (1,350,000) | (900,000) |
| Dividends Paid | 195,000 | 60,000 |
| Current Assets | 300,000 | 1,035,000 |
| Land | 450,000 | 135,000 |
| Buildings (net) | 750,000 | 210,000 |
| Equip (net) | 300,000 | 375,000 |
| Liabilities | (600,000) | (465,000) |
| Common Stock | (450,000) | (60,000) |
| APIC | (75,000) | (240,000) |
Determine the proper December 31, 2021 consolidated totals for each of the following accounts:
Revenues, COGS, Depreciation Exps, Amortization Exps, Buildings net, Equipment net, Customer list, Common Stock, APIC.
Show work please!
In: Accounting
On 1/1/10, R-U Ready issued $100,000, 6.5%, 10-year bonds at an effective rate of 4.75%. Interest is paid annually on 12/31 of each year.
Edit:
Present the accounts and dollar amounts that would appear on comparative balance sheets and income statements for the years ending 12/31/16 and 12/31/15.
In: Accounting
Atlas Enterprises Inc. manufactures elliptical exercise machines and treadmills. The products are produced in its Fabrication and Assembly production departments. In addition to production activities, several other activities are required to produce the two products. These activities and their associated activity rates are as follows: Activity Activity Rate Fabrication $28 per machine hour Assembly $20 per direct labor hour Setup $75 per setup Inspecting $30 per inspection Production scheduling $12 per production order Purchasing $ 8 per purchase order The activity-base usage quantities and units produced for each product were as follows: Activity Base Elliptical Machines Treadmill Machine hours 700 600 Direct labor hours 182 64 Setups 20 15 Inspections 10 16 Production orders 30 20 Purchase orders 56 75 Units produced 400 250 Use the activity rate and usage information to calculate the total activity cost and activity cost per unit for each product. If required round your answers to nearest cent. Total Activity Cost Activity Cost Per Unit Elliptical machines $ $ Treadmill
In: Accounting
Capricorn Inc. is a private company reporting under ASPE. Its unadjusted trial balance at its fiscal year end, December 31, 2023 is shown below:
|
Capricorn Inc. Unadjusted Trial Balance December 31, 2023 |
||
|
Debit |
Credit |
|
|
Cash |
$38,000 |
|
|
Inventory |
46,500 |
|
|
Supplies |
5,000 |
|
|
Building |
600,000 |
|
|
Accumulated depreciation – building |
120,000 |
|
|
Equipment |
330,000 |
|
|
Accumulated depreciation – equipment |
$66,000 |
|
|
Accounts payable |
34,000 |
|
|
Dividends payable |
0 |
|
|
Interest payable |
0 |
|
|
Income tax payable |
0 |
|
|
Unearned revenue |
30,600 |
|
|
Bonds payable (maturity date January 1, 2029) |
500,000 |
|
|
Preferred shares ($4 noncumulative, 1,000 issued) |
40,000 |
|
|
Common shares (120,000 issued) |
60,000 |
|
|
Retained earnings |
73,000 |
|
|
Cash dividends – preferred |
0 |
|
|
Cash dividends – common |
0 |
|
|
Sales |
515,000 |
|
|
Cost of goods sold |
159,000 |
|
|
Depreciation expense |
20,000 |
|
|
Income tax expense |
0 |
|
|
Insurance expense |
8,200 |
|
|
Interest expense |
1,800 |
|
|
Rent expense |
32,600 |
|
|
Salaries expense |
185,000 |
|
|
Supplies expense |
12,500 |
|
|
TOTALS |
$1,438,600 |
$1,438,600 |
No new shares were issued or reacquired during 2023.
The following transactions have not yet been recorded for
2023:
1. On December 31, 2023, the board of directors declared a total
cash dividend of $54,000
2. The bonds were issued at par with a contract interest rate of
4%. Interest is paid semi-annually on July 1 and January 1.
3. The income tax rate for 2023 is 20%
Required:
Using a blank MS Excel workbook, answer the following
questions:
1. Prepare the adjusting entries required for December 31, 2023
(
2. Prepare the closing entries for December 31, 2023
3. Prepare an income statement for the year ended December 31,
2023
4. Prepare a statement of retained earnings for the year ended
December 31, 2023
5. Prepare a classified balance sheet at December 31, 2023
6. Calculate Capricorn’s earnings per share for 2023.
In: Accounting
Chris Guthrie was recently hired by S&S Air, Inc., to asset the company with its financial planning and to evaluate the company's performance. Chris graduated from college five years ago with a finance degree. He has been employed in the finance department of a Fortune 500 company since then.
S&S Air was founded 10 years ago by friends Mark Sexton and Todd Story. The company has manufactured and sold light airplanes over this period, and the company's products have received high reviews for safety and reliability. The company has a niche market in that is sells primarily to individuals who own and fly their own airplanes. The company has two models: the Birdie, which sells for $103,000, and the Eagle, which sells for $178,000.
Although the company manufactures aircraft, its operations are different from commercial aircraft companies. S&S Air builds aircraft to order. By using prefabricated parts, the company can complete the manufacture of an airplane in only five weeks. The company also receives a deposit on each order, as well as another partial payment before the order is complete. In contast, a commercial airplane may take one and one-half to two years to manufacture once the order is placed.
Mark and Todd have provided financial statements (which are to the left and below). In addition, Chris has gathered the industry ratios for the light airplance manufacturing industry (below).
| 2019 Income Statement | |||
| Sales | $ 40,259,230 | ||
| COGS | 29,336,446 | ||
| Other expenses | 5,105,100 | ||
| Depreciation | 1,804,220 | ||
| EBIT | $ 4,013,464 | ||
| Interest | 630,520 | ||
| Taxable income | $ 3,382,944 | ||
| Taxes (40%) | 1,353,178 | ||
| Net income | $ 2,029,766 | ||
| Dividends | $ 610,000 | ||
| Add to RE | $ 1,419,766 | ||
| 2019 Balance Sheet | |||||||
| Assets | Liabilities & Equity | ||||||
| Current Assets | Current Liabilities | ||||||
| Cash | $ 456,435 | Accounts Payable | $ 929,005 | ||||
| Accounts rec. | 733,125 | Notes Payable | 2,121,350 | ||||
| Inventory | 1,073,180 | Total CL | $ 3,050,355 | ||||
| Total CA | $ 2,262,740 | ||||||
| Long-term debt | $ 5,500,000 | ||||||
| Shareholder Equity | |||||||
| Fixed assets | Common stock | $ 400,000 | |||||
| Net PP&E | $ 17,723,430 | Retained earnings | 11,035,815 | ||||
| Total Equity | $ 11,435,815 | ||||||
| Total Assets | $ 19,986,170 | Total L&E | $ 19,986,170 | ||||
| Industry | ||||
| Lower Quartile | Median | Upper Quartile | ||
| Current ratio | 0.50 | 1.43 | 1.89 | |
| Quick ratio | 0.21 | 0.35 | 0.62 | |
| Cash ratio | 0.08 | 0.21 | 0.39 | |
| Total asset turnover | 0.68 | 0.85 | 1.38 | |
| Inventory turnover | 4.89 | 6.15 | 10.89 | |
| Receivables turnover | 6.27 | 9.82 | 14.11 | |
| Total debt ratio | 0.44 | 0.52 | 0.61 | |
| Debt-equity ratio | 0.68 | 1.08 | 1.56 | |
| Equity multiplier | 1.68 | 2.08 | 2.56 | |
| Times interest earned | 5.18 | 8.06 | 9.83 | |
| Cash coverage ratio | 5.84 | 9.41 | 10.27 | |
| Profit margin | 4.05% | 5.10% | 7.15% | |
| Return on assets | 6.05% | 10.53% | 13.21% | |
| Return on equity | 9.93% | 18.14% | 26.15% | |
Questions:
1. Using the financial statements provided above, calculate each of the ratios listed in the industry table for S&S Air (all 14 of them).
2. Mark and Todd agree a ratio analysis can provide a measure of the company's performance. They have chosen Boeing as an aspirant (comparison) company. Would you choose Boeing as an aspirant company? Why or why not? There are other aircraft manufacturers S&S Air could use as aspirant companies. Discuss whether it is appropriate to use any of the following companies: Bombadier, Embraer, Cirrus Aircraft Corporation, and Cessna Aircraft Company.
3. Compare the performance of S&S Air to the industry, using the 14 ratios you calculated in part 1 and the industry table provided. For each ratio, comment on whether it would be viewed as positive or negative (favorable or unfavorable) to the industry and why.
In: Accounting
Discuss the differences between cash and accrual accounting. What is one significant advantage of accrual accounting over cash accounting?
In: Accounting