Exchange Corp. is a company that acts as a facilitator in tax-favored real estate swaps. Such swaps, know as 1031 exchanges, permit participants to avoid some or all of the capital gains taxes that would otherwise be due. The bookkeeper for the company has been asked to prepare a report for the company to help its owner/manager analyze performance. The first such report appears below:
|
Exchange Corp |
|||||||||
|
Actual |
Planning Budget |
Variances |
|||||||
|
Exchanges completed |
30 |
25 |
|||||||
|
Revenue |
$ |
620 |
$ |
700 |
$ |
80 |
U |
||
|
Expenses: |
|||||||||
|
Legal and search fees |
251 |
230 |
21 |
U |
|||||
|
Office expenses |
140 |
254 |
114 |
F |
|||||
|
Equipment depreciation |
25 |
30 |
5 |
F |
|||||
|
Rent |
75 |
90 |
15 |
F |
|||||
|
Insurance |
15 |
18 |
3 |
F |
|||||
|
Total expense |
506 |
622 |
116 |
F |
|||||
|
Net operating income |
$ |
114 |
$ |
78 |
$ |
36 |
F |
||
Note that the revenues and costs in the above report are unit revenues and costs. For example, the average office expense is $254 per exchange completed on the planning budget; whereas, the average actual office expense is $140 per exchange completed.
Legal and search fees is a variable cost; office expenses is a mixed cost; and equipment depreciation, rent, and insurance are fixed costs. In the planning budget, the fixed component of office expenses was $5,000.
All of the company’s revenues come from fees collected when an exchange is completed.
Required:
1. Is the report prepared by the bookkeeper useful as a performance report?
|
Yes |
|
|
No |
2. Complete a performance report that would help the owner/manager assess the performance of the company in May. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
Create an excel workbook for the following questions. Answer these questions under your Solver work for each respective problem.
1. Devos Inc. is building a hotel. It will have 4 kinds of rooms: suites where customers can smoke, suites that are non-smoking, budget rooms where the customers can smoke, and budget rooms that are non-smoking. When we build the hotel, we need to plan for how many rooms of each type we should have. The following are requirements for the hotel:
Answer the following using your Solver answers:
In: Statistics and Probability
Blue Spruce Company recently hired a new accountant whose first
task was to prepare the financial statements for the year ended
December 31, 2021. The following is what he produced:
|
BLUE SPRUCE COMPANY |
|||||||||
|
Sales |
$396,000 |
||||||||
|
Less: Unearned revenue |
$5,400 |
||||||||
|
Purchase discounts |
3,600 |
9,000 |
|||||||
|
Total revenue |
387,000 |
||||||||
|
Cost of goods sold |
|||||||||
|
Purchases |
231,500 |
||||||||
|
Less: Purchase returns and allowances |
3,900 |
||||||||
|
Net purchases |
235,400 |
||||||||
|
Add: Sales returns and allowances |
7,500 |
||||||||
|
Cost of goods available for sale |
242,900 |
||||||||
|
Add: Freight out |
9,500 |
||||||||
|
Cost of selling merchandise |
252,400 |
||||||||
|
Gross profit margin |
134,600 |
||||||||
|
Operating expenses |
|||||||||
|
Freight in |
4,600 |
||||||||
|
Insurance expense |
10,600 |
||||||||
|
Interest expense |
2,500 |
||||||||
|
Rent expense |
18,100 |
||||||||
|
Salaries expense |
42,200 |
||||||||
|
Total operating expenses |
78,000 |
||||||||
|
Profit margin |
56,600 |
||||||||
|
Other revenues |
|||||||||
|
Interest revenue |
$1,400 |
||||||||
|
Investment by owner |
3,400 |
4,800 |
|||||||
|
Other expenses |
|||||||||
|
Depreciation expense |
7,100 |
||||||||
|
Drawings by owner |
48,500 |
55,600 |
(50,800 |
) | |||||
|
Profit from operations |
$5,800 |
||||||||
|
BLUE SPRUCE COMPANY |
||||||
|
Assets |
||||||
|
Cash |
$16,400 |
|||||
|
Accounts receivable |
7,900 |
|||||
|
Merchandise inventory, January 1, 2021 |
29,600 |
|||||
|
Merchandise inventory, December 31, 2021 |
24,100 |
|||||
|
Equipment |
$71,000 |
|||||
|
Less: loan payable (for equipment purchase) |
49,600 |
21,400 |
||||
|
Total assets |
$99,400 |
|||||
|
Liabilities and Owner's Equity |
||||||
|
Long-term investment |
$49,600 |
|||||
|
Accumulated depreciation—equipment |
21,300 |
|||||
|
Sales discounts |
2,800 |
|||||
|
Total liabilities |
73,700 |
|||||
|
Owner’s equity |
25,700 |
|||||
|
Total liabilities and owner’s equity |
$99,400 |
|||||
| The owner of the company, Lily Oliver, is confused by the statements and has asked you for your help. She doesn’t understand how, if her Owner’s Capital account was $74,800 at December 31, 2020, owner’s equity is now only $25,700. The accountant tells you that $25,700 must be correct because the balance sheet is balanced. The accountant also tells you that he didn’t prepare a statement of owner’s equity because it is an optional statement. You are relieved to find out that, even though there are errors in the statements, the amounts used from the accounts in the general ledger are the correct amounts. |
In: Accounting
Make a Horizontal and Vertical analysis of SBUX balance sheet with four years of camparative data from Yahoo Finance If you can only answer one then please answer the Verical analysis
| Starbucks Corporation (SBUX) | ||||
| Balance Sheet | ||||
| For the year ended Sept 30 | ||||
| Breakdown | TTM | 9/30/2019 | 9/30/2018 | 9/30/2017 |
| Total Revenue | 24061900 | 26508600 | 24719500 | 22386800 |
| Cost of Revenue | 18647800 | 19020500 | 17367700 | 15531500 |
| Gross Profit | 5414100 | 7488100 | 7351800 | 6855300 |
| Operating Expense | 3534000 | 3572400 | 3545300 | 2958500 |
| Operating Income | 1880100 | 3915700 | 3806500 | 3896800 |
| Net Non Operating Interest Income Expense | -360800 | -234500 | 21100 | 182800 |
| Other Income Expense | 206600 | 785000 | 1952400 | 237900 |
| Pretax Income | 1725900 | 4466200 | 5780000 | 4317500 |
| Tax Provision | 391500 | 871600 | 1262000 | 1432600 |
| Net Income Common Stockholders | 1338500 | 3599200 | 4518300 | 2884700 |
| Diluted NI Available to Com Stockholders | 1338500 | 3599200 | 4518300 | 2884700 |
| Basic EPS | - | 0.003 | 0.0035 | 0.002 |
| Diluted EPS | - | 0.0029 | 0.0032 | 0.002 |
| Basic Average Shares | - | 1184600 | 1309100 | 1431600 |
| Diluted Average Shares | - | 1233200 | 1394600 | 1461500 |
| Total Operating Income as Reported | 2086700 | 4077900 | 3883300 | 4134700 |
| Total Expenses | 22181800 | 22592900 | 20913000 | 18490000 |
| Net Income from Continuing & Discontinued Operation | 1338500 | 3599200 | 4518300 | 2884700 |
| Normalized Income | 1412414 | 3207165 | 3227062 | 2987238 |
| Interest Income | 47000 | 96500 | 191400 | 275300 |
| Interest Expense | 407800 | 331000 | 170300 | 92500 |
| Net Interest Income | -360800 | -234500 | 21100 | 182800 |
| EBIT | 2133700 | 4797200 | 5950300 | 4410000 |
| EBITDA | 3623400 | - | - | - |
| Reconciled Cost of Revenue | 18571200 | 18948500 | 17308800 | 15475800 |
| Reconciled Depreciation | 1489700 | 1449300 | 1305900 | 1067100 |
| Net Income from Continuing Operation Net Minority Interest | 1338500 | 3599200 | 4518300 | 2884700 |
| Total Unusual Items Excluding Goodwill | -95600 | 487000 | 1651200 | -153500 |
| Total Unusual Items | -95600 | 487000 | 1651200 | -153500 |
| Normalized EBITDA | 3719000 | 5759500 | 5605000 | 5630600 |
| Tax Rate for Calcs | 0 | 0 | 0 | 0 |
| Tax Effect of Unusual Items | -21686 | 94965 | 359962 | -50962 |
In: Accounting
On January 1, 2015, when its $30 par value common stock was selling for $80 per share, a corporation issued $10 million of 10% convertible debentures due in 10 years. The conversion option allowed the holder of each $1,000 bond to convert it into six shares of the corporation’s $30 par value common stock. The debentures were issued for $11 million. At the time of issuance, the present value of the bond payments was $8.5 million, and the corporation believes the difference between the present value and the amount paid is attributable to the conversion feature. On January 1, 2016, the corporation’s $30 par value common stock was split 3 for 1. On January 1, 2017, when the corporation’s $10 par value common stock was selling for $90 per share, holders of 40% of the convertible debentures exercised their conversion options. The corporation uses the straight-line method for amortizing any bond discounts or premiums.
Required:
| 1. | Prepare the journal entry to record the original issuance of the convertible debentures. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2. |
Prepare the journal entry to record the exercise of the conversion option, using the book value method.
PAGE 1 GENERAL JOURNAL
Prepare the journal entry to record the exercise of the conversion option, using the book value method on January 1, 2017. PAGE 1 GENERAL JOURNAL
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
The following list of accounts and their balances represents the unadjusted trial balance of Alt Company at December 31, 2018:
| Cash | $25,490 | |
| Equity Investments (trading) | $60,000 | |
| Accounts Receivable | $69,000 | |
| Allowance for Doubtful Accounts | $500 | |
| Inventory | $54,720 | |
| Prepaid Rent | $36,000 | |
| Plant Assets | $160,000 | |
| Accumulated Depreciation-Plant Assets | $14,740 | |
| Accounts Payable | $11,370 | |
| Bonds Payable | $90,000 | |
| Common Stock | $170,000 | |
| Retained Earnings | $97,180 | |
| Sales Revenue | $214,800 | |
| Cost of Goods Sold | $154,400 | |
| Freight-Out | $11,000 | |
| Salaries and Wages Expense | $32,000 | |
| Interest Expense | $2,040 | |
| Rent Revenue | $21,600 | |
| Miscellaneous Expense | $890 | |
| Insurance Expense | $14,650 | |
| $620,190 | $620,190 |
Additional Data:
The balance in the Insurance Expense account contains the premium costs of three policies:
Policy 1, remaining cost of $2,550, 1-yr. term, taken out on May 1, 2017;
Policy 2, original cost of $10,800, 3-yr. term, taken out on Oct. 1, 2018;
Policy 3, original cost of $1,300, 1-yr. term, taken out on Jan. 1, 2018.
On September 30, 2018, Alt received $21,600 rent from its lessee for an eighteen month lease beginning on that date.
The regular rate of depreciation is 8% per year. Acquisitions and retirements during a year are depreciated at half this rate. There were no purchases during the year. On December 31, 2017, the balance of the Plant and Equipment account was $220,000.
On December 28, 2018, the bookkeeper incorrectly credited Sales Revenue for a receipt on account in the amount of $20,000.
At December 31, 2018, salaries and wages accrued but unpaid were $4,200.
Alt estimates that 2% of gross accounts receivable will become uncollectible.
On August 1, 2018, Alt purchased, as a short-term investment, 60 $1,000, 5% bonds of Allen Corp. at par. The bonds mature on August 1, 2019. Interest payment dates are July 31 and January 31.
On April 30, 2018, Alt rented a warehouse for $3,000 per month, paying $36,000 in advance.
Instructions
Record the necessary correcting and adjusting entries.
Indicate which of the adjusting entries may be reversed at the beginning of the next accounting period.
In: Accounting
1) Paula Corporation owns all of the voting common stock of
Sally Company. Sally manufactures toys and sells
them to Paula. In turn, Paula sells them to customers. Neither of
these companies do anything else. At the
beginning of 2012 neither company had any inventory. During 2012
Sally manufactured 120,000 toys and
sold 100,000 of them to Paula for $10 each and Paula sold 90,000 of
these toys to customers for $16 each.
These toys had cost Sally only $7 each to produce. During 2013
Sally manufactured 115,000 toys and sold
98,000 to Paula for $10 each. Paula sold 100,000 toys to customers
during 2013 for $16 each. (The
manufacturing cost for Sally was still $7 per toy.) Please
determine each of the following:
A. Total Consolidated Sales Revenue for 2013
B. Total Consolidated Cost of Goods Sold for 2013
C. Consolidated Ending Inventory for December 31, 2013
2) During 2014 Sally produced 200,000 toys at a cost of $7 each.
Paula produced 30,000 books at a cost of $12
each. Sally sold 120,000 toys to Paula for $10 each and 50,000 toys
to customers for $15 each. Paula sold
110,000 of the toys to customers for $16 each and 20,000 books to
customers for $20 each. Please
determine each of the following:
A. Total Consolidated Sales Revenue for 2014
B. Total Consolidated Cost of Goods Sold for 2014
C. Consolidated Ending Inventory for December 31, 2014
Part II
t the beginning of 2014 Peri Co. created a wholly owned subsidiary,
Speri Co., to handle the marketing and sales of its
products. During 2014 Peri manufactured goods for a total cost of
$1,000,000. It sold 80% of these items to Speri for
$1,200,000. Speri sold 75% of what it purchased from Peri to
customers for $1,500,000. (Peri only sold to Speri and
Speri only purchased from Peri.) In the 2014 annual consolidated
financial statements for Peri and Speri, what should
be reported for each of the following:
A. Total Consolidated Sales Revenue for 2014
B. Total Consolidated Cost of Goods Sold for 2014
C. Consolidated Ending Inventory for December 31, 2014
In: Accounting
Lodi Company is authorized to issue 100,000 shares of no-par, $6 stated-value common stock and 10,000 shares of 9%, $100 par preferred stock. It enters into the following transactions on December 31:
| 1. | Accepts a subscription contract to 7,000 shares of common stock at $41 per share and receives a 30% down payment. |
| 2. | Collects the remaining balance of the subscription contract and issues the common stock. |
| 3. | Acquires a building by paying $2,000 cash and issuing 3,000 shares of common stock and 900 shares of preferred stock. Common stock is currently selling at $45 per share; preferred stock has no current market value. The building is appraised at $1,310,000. |
| 4. | Sells 1,000 shares of common stock at $48 per share. |
| 5. | Sells 900 shares of preferred stock at $110 per share. |
| 6. | Declares a three-for-one stock split on the common stock, reducing the stated value to $2.00 per share. |
Required:
| Prepare the journal entries to record the preceding transactions. |
| CHART OF ACCOUNTS | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Lodi Company | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| General Ledger | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Prepare journal entries to record the transactions on December 31. Additional Instructions
PAGE 1PAGE 2 (PLEASE FILL OUT BOTH PAGES)!!!!!!!!!!!!!!!!!!!! (12 ENTRIES FOR BOTH)
GENERAL JOURNAL
| DATE | ACCOUNT TITLE | POST. REF. | DEBIT | CREDIT | |
|---|---|---|---|---|---|
|
1 |
|||||
|
2 |
|||||
|
3 |
|||||
|
4 |
|||||
|
5 |
|||||
|
6 |
|||||
|
7 |
|||||
|
8 |
In: Accounting
Problem 17-38 Analyze Performance for a Restaurant (LO 17-5)
Doug’s Diner is planning to expand operations and is concerned that its reporting system might need improvement. The master budget income statement for the Downtown Doug’s, which contains a delicatessen and restaurant operation, follows (in thousands):
| Delicatessen | Restaurant | Total | |||||||||||||
| Sales revenue | $ | 600 | $ | 2,000 | $ | 2,600 | |||||||||
| Costs | |||||||||||||||
| Purchases | 360 | 1,100 | 1,460 | ||||||||||||
| Hourly wages | 30 | 438 | 468 | ||||||||||||
| Franchise fee | 18 | 39 | 57 | ||||||||||||
| Advertising | 50 | 100 | 150 | ||||||||||||
| Utilities | 42 | 63 | 105 | ||||||||||||
| Depreciation | 25 | 38 | 63 | ||||||||||||
| Lease cost | 15 | 25 | 40 | ||||||||||||
| Salaries | 15 | 25 | 40 | ||||||||||||
| Total costs | $ | 555 | $ | 1,828 | $ | 2,383 | |||||||||
| Operating profit | $ | 45 | $ | 172 | $ | 217 | |||||||||
The company uses the following performance report for management evaluation:
| DOWNTOWN DOUG’S | |||||||||||||||||||||||
| Net Income for the Year | |||||||||||||||||||||||
| ($000) | |||||||||||||||||||||||
| Actual Results | |||||||||||||||||||||||
| Actual Results | Delicatessen | Restaurant | Total | Budget | Over-
or (Under-) Budgeta |
||||||||||||||||||
| Sales revenue | $ | 700 | $ | 1,000 | $ | 1,700 | $ | 2,600 | $ | (900 | ) | ||||||||||||
| Costs | |||||||||||||||||||||||
| Purchasesb | 450 | 400 | 850 | 1,460 | $ | (610 | ) | ||||||||||||||||
| Hourly wagesb | 35 | 350 | 385 | 468 | (83 | ) | |||||||||||||||||
| Franchise feeb | 21 | 30 | 51 | 57 | (6 | ) | |||||||||||||||||
| Advertising | 50 | 100 | 150 | 150 | |||||||||||||||||||
| Utilitiesb | 45 | 50 | 95 | 105 | (10 | ) | |||||||||||||||||
| Depreciation | 25 | 38 | 63 | 63 | |||||||||||||||||||
| Lease cost | 15 | 25 | 40 | 40 | |||||||||||||||||||
| Salaries | 15 | 25 | 40 | 40 | |||||||||||||||||||
| Total costs | $ | 656 | $ | 1,018 | $ | 1,674 | $ | 2,383 | $ | (709 | ) | ||||||||||||
| Operating profit | $ | 44 | $ | (18 | ) | $ | 26 | $ | 217 | $ | (191 | ) | |||||||||||
a There is no sales price variance.
b Variable costs; all other costs are fixed.
Required:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
The following income statement items appeared on the adjusted
trial balance of Schembri Manufacturing Corporation for the year
ended December 31, 2021 ($ in thousands): sales revenue, $15,300;
cost of goods sold, $6,200; selling expenses, $1,300; general and
administrative expenses, $800; interest revenue, $40; interest
expense, $180. Income taxes have not yet been recorded. The
company’s income tax rate is 25% on all items of income or loss.
These revenue and expense items appear in the company’s income
statement every year. The company’s controller, however, has asked
for your help in determining the appropriate treatment of the
following nonrecurring transactions that also occurred during 2021
($ in thousands). All transactions are material in
amount.
Required:
1. Prepare Schembri’s single, continuous
multiple-step statement of comprehensive income for 2021, including
earnings per share disclosures. One million shares of common stock
were outstanding at the beginning of the year and an additional
400,000 shares were issued on July 1, 2021.
2. Prepare a separate statement of comprehensive
income for 2021
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting