Questions
Exchange Corp. is a company that acts as a facilitator in tax-favored real estate swaps. Such...

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
Analysis of Revenues and Costs
For the Month Ended May 31

Actual
Unit Revenues
and Costs

Planning Budget
Unit Revenues
and Costs

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.)

Exchange Corp

Flexible Budget Performance Report

For the Month Ended May 31

Actual Results

Revenue and Spending Variances

Flexible Budget

Activity Variances

Planning Budget

Exchanges completed

30

25

Revenue

Expenses:

Legal and search fees

Office expenses

Equipment depreciation

Rent

Insurance

Total expense

Net operating income

In: Accounting

Create an excel workbook for the following questions. Answer these questions under your Solver work for...

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:

  1. We want to figure out how many rooms of each type to build based on maximizing revenue if we fill up the hotel. We expect to charge $190 for a suite that is non-smoking and $140 for a budget room that is non-smoking. Smoking room customers for both suites and budget rooms will have to pay an additional $20 per night.
  2. We can spend up to $7,500,000 on construction of our hotel. The cost to build a non-smoking budget room is $12,000. The cost to build a non-smoking suite is $15,000. It is $3,000 additional for a smoking room of either type for smoke detectors and sprinklers.
  3. We require that the number of budget rooms be at least 1.5 times the number of suites, but no more than 3 the number of suites.
  4. There needs to be at least 80 suites, but no more than 200.
  5. Industry trends recommend that smoking rooms should be less than 50% of the non-smoking room and in addition, we require our builder gives us at least 4 smoking rooms.

Answer the following using your Solver answers:

  1. How many of each room type should be built, and what would the revenue be for a night when our hotel was fully booked?
  2. Without re-running Solver, what happens to our revenue if we get an additional $1,500,000 for building? Explain in words how you got this answer without re-running solver. Over what amount of construction costs can you use this procedure?
  3. Over what range of room price can our budget non-smoking rooms vary over for us to get the same answer for the quantity of each type of room?

In: Statistics and Probability

Blue Spruce Company recently hired a new accountant whose first task was to prepare the financial...

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
Income Statement
December 31, 2021

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
Balance Sheet
Year Ended December 31, 2021

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...

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...

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.

CHART OF ACCOUNTS
Corporation
General Ledger
ASSETS
111 Cash
121 Accounts Receivable
141 Inventory
152 Prepaid Insurance
181 Equipment
198 Accumulated Depreciation
LIABILITIES
211 Accounts Payable
231 Salaries Payable
250 Unearned Revenue
255 Bonds Payable
256 Premium on Bonds Payable
261 Income Taxes Payable
EQUITY
311 Common Stock
315 Additional Paid-In Capital
331 Retained Earnings
REVENUE
411 Sales Revenue
EXPENSES
500 Cost of Goods Sold
511 Insurance Expense
512 Utilities Expense
521 Salaries Expense
532 Bad Debt Expense
540 Interest Expense
541 Depreciation Expense
559 Miscellaneous Expenses
910 Income Tax Expense

PAGE 1

GENERAL JOURNAL

DATE ACCOUNT TITLE POST. REF. DEBIT CREDIT

1

2

3

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

DATE ACCOUNT TITLE POST. REF. DEBIT CREDIT

1

2

3

4

In: Accounting

The following list of accounts and their balances represents the unadjusted trial balance of Alt Company...

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...

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...

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
ASSETS
111 Cash
121 Accounts Receivable
141 Inventory
152 Prepaid Insurance
172 Building
181 Equipment
189 Accumulated Depreciation
LIABILITIES
211 Accounts Payable
231 Salaries Payable
250 Unearned Revenue
261 Income Taxes Payable
EQUITY
305 Preferred Stock
311 Common Stock
312 Common Stock Subscribed
318 Additional Paid-in Capital on Preferred Stock
320 Additional Paid-in Capital on Common Stock
326 Subscriptions Receivable
331 Retained Earnings
REVENUE
411 Sales Revenue
EXPENSES
500 Cost of Goods Sold
511 Insurance Expense
512 Utilities Expense
521 Salaries Expense
532 Bad Debt Expense
540 Interest Expense
541 Depreciation Expense
559 Miscellaneous Expenses
910 Income Tax Expense

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...

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:

Actual Purchases Variances Marketing & Administrative Variances Flexible Budget Activity Variance Master Budget
Sales revenue $700 $600
Variable costs:
Purchases 450 360
Hourly wages 35 30
Franchise fee 21 18
Utilities 45 42
Total variable costs $551 $450
Contribution margin $149 $150
Fixed costs:
Advertising 50 50
Depreciation 25 25
Lease 15 15
Salaries 15 15
Total fixed costs $105 $105
Operating profit $44 $45

In: Accounting

The following income statement items appeared on the adjusted trial balance of Schembri Manufacturing Corporation for...

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.

  1. Investments were sold during the year at a loss of $220. Schembri also had an unrealized gain of $320 for the year on investments in debt securities that qualify as components of comprehensive income.
  2. One of the company’s factories was closed during the year. Restructuring costs incurred were $1,200.
  3. During the year, Schembri completed the sale of one of its operating divisions that qualifies as a component of the entity according to GAAP. The division had incurred a loss from operations of $560 in 2021 prior to the sale, and its assets were sold at a gain of $1,400.
  4. In 2021, the company’s accountant discovered that depreciation expense in 2020 for the office building was understated by $200.
  5. Negative foreign currency translation adjustment for the year totaled $240.


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

SCHEMBRI MANUFACTURING CORPORATION
Statement of Comprehensive Income
For the Year Ended December 31, 2021
($ in 000s)
Gross profit
Operating expenses:
Total operating expenses
Operating income
Other income (expense):
Other income, net
Income from continuing operations before income taxes
Income from continuing operations
Discontinued operations:
Income on discontinued operations
Net income
Other comprehensive income, net of tax:
Comprehensive income
Earnings per share:
Net income

In: Accounting