In: Accounting
4-5 The following unadjusted trial balance is prepared at fiscal year-end for Nelson Company. NELSON COMPANY Unadjusted Trial Balance January 31, 2017 Debit Credit Cash $ 31,200 Merchandise inventory 14,500 Store supplies 5,200 Prepaid insurance 2,800 Store equipment 42,600 Accumulated depreciation—Store equipment $ 16,000 Accounts payable 13,000 Common stock 3,800 Retained earnings 19,000 Dividends 2,100 Sales 141,750 Sales discounts 1,900 Sales returns and allowances 2,050 Cost of goods sold 38,000 Depreciation expense—Store equipment 0 Salaries expense 27,800 Insurance expense 0 Rent expense 16,000 Store supplies expense 0 Advertising expense 9,400 Totals $ 193,550 $ 193,550 Rent expense and salaries expense are equally divided between selling activities and general and administrative activities. Nelson Company uses a perpetual inventory system. Additional Information: Store supplies still available at fiscal year-end amount to $2,700. Expired insurance, an administrative expense, for the fiscal year is $1,500. Depreciation expense on store equipment, a selling expense, is $1,600 for the fiscal year. To estimate shrinkage, a physical count of ending merchandise inventory is taken. It shows $10,900 of inventory is still available at fiscal year-end. rev: 10_24_2018_QC_CS-145044 Required: 1. Using the above information prepare adjusting journal entries: 2. Prepare a multiple-step income statement for fiscal year 2017. 3. Prepare a single-step income statement for fiscal year 2017.
1
Store supplies still available at fiscal year-end amount to $2,700.
2
Expired insurance, an administrative expense, for the fiscal year is $1,500.
3
Depreciation expense on store equipment, a selling expense, is $1,600 for the fiscal year.
4
To estimate shrinkage, a physical count of ending merchandise inventory is taken. It shows $10,900 of inventory is still available at fiscal year-end.
Prepare a multiple-step income statement for fiscal year 2017.
|
Prepare a single-step income statement for fiscal year 2017.
|
In: Accounting
BluStar Company has two service departments, Administration and Accounting, and two operating departments, Domestic and International. Administration costs are allocated on the basis of employees, and Accounting costs are allocated on the basis of number of transactions. A summary of BluStar operations follows:
Administration | Accounting | Domestic | International | |||||||||
Employees | – | 21 | 44 | 35 | ||||||||
Transactions | 34,000 | – | 19,000 | 76,000 | ||||||||
Department direct costs | $ | 359,000 | $ | 144,000 | $ | 935,000 | $ | 3,780,000 | ||||
Required:
a. Allocate the cost of the service departments to the operating departments using the direct method. (Do not round intermediate calculations. Negative amounts should be indicated by a minus sign.)
b. Allocate the cost of the service departments to the operating departments using the step method. Start with Administration. (Do not round intermediate calculations. Negative amounts should be indicated by a minus sign.)
c. Allocate the cost of the service departments to the operating departments using the reciprocal method. (Do not round intermediate calculations. Negative amounts should be indicated by a minus sign.)
In: Accounting
Financial Statements and Closing Entries
The Gorman Group is a financial planning services firm owned and operated by Nicole Gorman. As of October 31, 2018, the end of the fiscal year, the accountant for The Gorman Group prepared an end-of-period spreadsheet, part of which follows:
The Gorman Group End-of-Period Spreadsheet For the Year Ended October 31, 2018 |
||
Adjusted Trial Balance | ||
Account Title | Dr. | Cr. |
Cash | $11,200 | |
Accounts Receivable | 24,380 | |
Supplies | 3,810 | |
Prepaid Insurance | 8,230 | |
Land | 87,000 | |
Buildings | 312,000 | |
Accumulated Depreciation-Buildings | 101,500 | |
Equipment | 225,000 | |
Accumulated Depreciation-Equipment | 132,200 | |
Accounts Payable | 28,840 | |
Salaries Payable | 2,860 | |
Unearned Rent | 1,300 | |
Common Stock | 130,000 | |
Retained Earnings | 240,660 | |
Dividends | 21,600 | |
Service Fees | 411,290 | |
Rent Revenue | 4,340 | |
Salaries Expense | 294,860 | |
Depreciation Expense-Equipment | 16,000 | |
Rent Expense | 13,400 | |
Supplies Expense | 9,490 | |
Utilities Expense | 8,570 | |
Depreciation Expense-Buildings | 5,720 | |
Repairs Expense | 4,720 | |
Insurance Expense | 2,590 | |
Miscellaneous Expense | 4,420 | |
1,052,990 | 1,052,990 |
Required:
1. Prepare an income statement.
The Gorman Group Income Statement For the Year Ended October 31, 2018 |
||
---|---|---|
Revenues: | ||
Total Revenues | ||
Expenses: | ||
Total Expenses | ||
Net income |
Prepare a Retained Earnings Statement.
The Gorman Group Retained Earnings Statement For the Year Ended October 31, 2018 |
||
---|---|---|
Prepare a balance sheet.
The Gorman Group Balance Sheet October 31, 2018 |
||||||
---|---|---|---|---|---|---|
Assets | Liabilities | |||||
Current assets: | Current liabilities: | |||||
Total liabilities | ||||||
Total current assets | ||||||
Property, plant, and equipment: | Stockholders' Equity | |||||
Total property, plant, and equipment | Total stockholders' equity | |||||
Total assets | Total liabilities and stockholders' equity |
2. Journalize the entries that were required to close the accounts at October 31. For a compound transaction, if a box does not require an entry, leave it blank.
Date | Account | Debit | Credit |
---|---|---|---|
2018 | |||
Oct. 31 Close revenues | |||
Oct. 31 Close expenses | |||
Oct. 31 Close income/loss | |||
Oct. 31 Close dividends | |||
3. If Retained Earnings had instead decreased
$30,300 after the closing entries were posted, and the dividends
remained the same, what would have been the amount of net income or
net loss? Enter all amounts as positive numbers.
$
In: Accounting
Honey Ltd, a New Zealand company, has sold US$150,000 of products to the US, to receive cash exactly one month later. At the time of sale, the spot rate of exchange is US$0.55, that is, NZ$1 buys US$0.55. Honey Ltd wishes to hedge the currency risk associated with this transaction, so on the day of the sale, the company buys a put option – that is, it buys the right to sell US$150,000 at an exercise price of US$0.57 one month later. The option costs $3,000 in cash. The relevant information is shown in the table below:
spot rate | Option value | |
At the date of sale | 0.55 | $3,000 |
One month late (i.e., at settlement) | 0.62 |
Required:
(i) In accordance with NZ IFRS 9, show the journal entry to record the sale and any additional journal entries that are required through to (and including) settlement.
(ii) What is the most that Honey Ltd can lose overall in this hedging activity (regardless of what the exchange rate is at settlement date)? Show all workings.
In: Accounting
Dividends Per Share Imaging Inc., a developer of radiology equipment, has stock outstanding as follows: 15,000 shares of cumulative preferred 1% stock, $120 par, and 50,000 shares of $15 par common. During its first four years of operations, the following amounts were distributed as dividends: first year, $12,000; second year, $34,000; third year, $46,200; fourth year, $76,500. Compute the dividends per share on each class of stock for each of the four years. Round all answers to two decimal places. If no dividends are paid in a given year, enter "0". 1st Year 2nd Year 3rd Year 4th Year Preferred stock (dividend per share) $ $ $ $ Common stock (dividend per share) $ $ $ $
In: Accounting
Suppose that the 2017 actual and 2018 projected financial statements for Cramner Corp. are initially as shown in the following tables. In these tables, sales are projected to rise 35 percent in the coming year, and the components of the income statement and balance sheet that are expected to increase at the same 35 percent rate as sales are indicated with an italics font. Assuming that Cramner Corp. wants to cover the AFN with 45 percent equity, 25 percent long-term debt, and the remainder from notes payable, what amount of additional funds will they need to raise if debt carries an 8 percent interest rate?
Income Statement | ||||||
2017 Actual |
2018 Forecast | |||||
Sales | $ | 3,000,000 | $ | 4,050,000 | ||
Costs except depreciation | 1,000,000 | 1,350,000 | ||||
Depreciation | 1,500,000 | 2,025,000 | ||||
EBIT | $ | 500,000 | $ | 675,000 | ||
Less Interest | 80,000 | 126,772 | ||||
EBT | $ | 420,000 | $ | 548,228 | ||
Taxes (40%) | 168,000 | 219,291 | ||||
Net income | $ | 252,000 | $ | 328,937 | ||
Common Dividends | $ | 180,000 | $ | 180,000 | ||
Addition to Retained Earnings | $ | 72,000 | $ | 148,937 | ||
Balance Sheet | ||||||
2017 Actual |
2018 Forecast |
|||||
Assets | ||||||
Cash | $ | 100,000 | $ | 135,000 | ||
Accounts Receivable | 200,000 | 270,000 | ||||
Inventories | 300,000 | 405,000 | ||||
Total Current Assets | $ | 600,000 | $ | 810,000 | ||
Net Plant and Equipment | 4,000,000 | 5,400,000 | ||||
Total Assets | $ | 4,600,000 | $ | 6,210,000 | ||
Liabilities and Equity | ||||||
Accounts Payable | $ | 100,000 | $ | 135,000 | ||
Notes Payable | 500,000 | 675,000 | ||||
Accruals | 100,000 | 135,000 | ||||
Total Current Liabilities | $ | 700,000 | $ | 945,000 | ||
Long-term bonds | 500,000 | 675,000 | ||||
Total Debt | $ | 1,200,000 | $ | 1,620,000 | ||
Common Stock | $ | 3,000,000 | $ | 4,050,000 | ||
Retained Earnings | 400,000 | 540,000 | ||||
Total Common Equity | $ | 3,400,000 | $ | 4,590,000 | ||
Total Liabilities and Equity | $ | 4,600,000 | $ | 6,210,000 |
In: Accounting
On December 31, 2019, the Income Statement section of the
worksheet is shown below. The balance of Ally Logan’s drawing
account is $32,000.
INCOME STATEMENT COLUMNS | ||||||
ACCOUNT NAME | DEBIT | CREDIT | ||||
Income Summary | $ | 63,000 | $ | 69,000 | ||
Sales | 250,000 | |||||
Sales Returns and Allowances | 6,100 | |||||
Interest Income | 760 | |||||
Purchases | 87,000 | |||||
Freight In | 3,900 | |||||
Purchases Returns and Allowances | 2,900 | |||||
Purchases Discounts | 3,500 | |||||
Sales Salaries Expense | 53,000 | |||||
Office Salaries Expense | 20,100 | |||||
Office Supplies Expense | 860 | |||||
Utilities Expense | 5,100 | |||||
Payroll Taxes Expense | 2,700 | |||||
Uncollectible Accounts Expense | 2,800 | |||||
Depr. Expense - Office Equipment | 900 | |||||
Totals | 245,460 | 326,160 | ||||
Net Income | 80,700 | |||||
$ | 326,160 | $ | 326,160 | |||
Prepare the closing entries that should be made in the general
journal.
Journal entry worksheet
Record entry to transfer sales, interest, purchases return and
allowances and purchase discounts to income summary.
Note: Enter debits before credits.
Date General Journal Debit
Credit
Dec 31, 2019
In: Accounting
Cost of new machine needed $150,000
Annual net cash inflows $40,000
Salvage value of the machine in 10 years .$20,000
Useful life of the machine 10 years
Required rate of return 10%
The company uses straight-line depreciation on all equipment.
a. What is the payback period for this machine? Ignore the impact of income taxes.
b. How is the payback period used in evaluating potential investments?
In: Accounting
Aztec Company sells its product for $160 per unit. Its actual
and budgeted sales follow.
Units | Dollars | ||
April (actual) | 4,000 | $ | 640,000 |
May (actual) | 2,000 | 320,000 | |
June (budgeted) | 4,500 | 720,000 | |
July (budgeted) | 3,500 | 719,000 | |
August (budgeted) | 4,100 | 656,000 | |
All sales are on credit. Recent experience shows that 26% of credit
sales is collected in the month of the sale, 44% in the month after
the sale, 29% in the second month after the sale, and 1% proves to
be uncollectible. The product’s purchase price is $110 per unit.
60% of purchases made in a month is paid in that month and the
other 40% is paid in the next month. The company has a policy to
maintain an ending monthly inventory of 23% of the next month’s
unit sales plus a safety stock of 100 units. The April 30 and May
31 actual inventory levels are consistent with this policy. Selling
and administrative expenses for the year are $1,728,000 and are
paid evenly throughout the year in cash. The company’s minimum cash
balance at month-end is $110,000. This minimum is maintained, if
necessary, by borrowing cash from the bank. If the balance exceeds
$110,000, the company repays as much of the loan as it can without
going below the minimum. This type of loan carries an annual 14%
interest rate. On May 31, the loan balance is $47,000, and the
company’s cash balance is $110,000.
Required:
1. Prepare a schedule that shows the computation
of cash collections of its credit sales (accounts receivable) in
each of the months of June and July.
2. Prepare a schedule that shows the computation
of budgeted ending inventories (in units) for April, May, June, and
July.
3. Prepare the merchandise purchases budget for
May, June, and July. Report calculations in units and then show the
dollar amount of purchases for each month.
4. Prepare a schedule showing the computation of
cash payments for product purchases for June and July.
5. Prepare a cash budget for June and July,
including any loan activity and interest expense. Compute the loan
balance at the end of each month.
In: Accounting
In: Accounting
Three years ago, Karen Suez and her brother-in-law Reece Jones opened Gigasales Department Store. For the first 2 years, business was good, but the following condensed income statement results for 2017 were disappointing.
GIGASALES DEPARTMENT STORE
Income Statement
For the Year Ended December 31, 2017
Net sales
$518,000
Cost of goods sold
414,400
Gross profit
103,600
Operating expenses
Selling expenses
$74,000
Administrative expenses
14,800
88,800
Net income
$14,800
Karen believes the problem lies in the relatively low gross profit rate of 20%. Reece believes the problem is that operating expenses are too high. Karen thinks the gross profit rate can be improved by making two changes. (1) Increase average selling prices by 15%; this increase is expected to lower sales volume so that total sales dollars will increase only 4%. (2) Buy merchandise in larger quantities and take all purchase discounts. These changes to purchasing practices are expected to increase the gross profit rate from its current rate of 20% to a new rate of 25%. Karen does not anticipate that these changes will have any effect on operating expenses.
Reece thinks expenses can be cut by making these two changes. (1) Cut 2018 sales salaries of $44,400 in half and give sales personnel a commission of 2% of net sales. (2) Reduce store deliveries to one day per week rather than twice a week; this change will reduce 2018 delivery expenses of $29,600 by 40%. Reece feels that these changes will not have any effect on net sales.
Karen and Reece come to you for help in deciding the best way to improve net income.
Answer the following.
In: Accounting
Cost Flow Relationships
The following information is available for the first year of operations of Creston Inc., a manufacturer of fabricating equipment:
Sales | $909,300 |
Gross profit | 245,500 |
Indirect labor | 81,800 |
Indirect materials | 33,600 |
Other factory overhead | 15,500 |
Materials purchased | 463,700 |
Total manufacturing costs for the period | 1,003,900 |
Materials inventory, end of period | 33,600 |
Using the above information, determine the following amounts:
c. Direct labor cost | $ |
In: Accounting
Explain the compliance aspects of consolidated returns. |
In: Accounting
1) What is a quantity standard? What is a price standard?
2) Why are separate price and quantity variances computed?
3) Who is generally responsible for the materials price variance? The materials quantity variance? The labor efficiency?
5) If the materials price variance is favorable but the materials quantity variance is unfavorable, what might this indicate?
7) "Our workers are all under labor contracts; therefore, our labor rate variance is bound to be zero." Discuss.
8) What effect, if any, would you expect poor-quality materials to have on direct labor variances?
In: Accounting