Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Accounting Basics Expert

From the information given below, prepare the required schedules and financial statements using an excel spreadsheet being careful to use formulas whenever possible. Do not type in numbers that could otherwise be find outd or transferred from another schedule column or line item.

You are thinking of investing in one of two corporations, both in the same industry, the Craig Corporation or the Lori Corporation. Selected data follows:

Sales data for the year ended 12/31/10:
Craig: Gross revenue $31,485,000; Returns $ 725,000
Lori: Gross revenue $37,245,000; Returns $1,230,000

Selling expenses:
Craig: Payroll $2,642,000; benefits $1,150,000, travel $275,200; supplies $310,150, commissions $420,300, marketing $720,000, postage $210,300, misc $39,500.
Lori: Payroll $3,110,000; benefits $1,310,000, travel $320,200; supplies $460,300, commissions $502,300, marketing $790,000, postage $242,100, misc $82,300.

Administrative expenses:
Craig: Distribution $1,028,000, warehouse $959,000, IT $625,200, finance $529,400, human resources $413,250; administrative $310,000, depreciation $122,000
Lori: Distribution $1,212,310, warehouse $1,020,220, IT $616,420, finance $515,270, human resources $385,450; administrative $350,600, depreciation $156,100.

Other Gains and Losses
Craig: Sale of machine with a book value of $32,000 for $45,000 cash.
Lori: Sold a marketable security with at a profit of $15,000.

Irregular Items:
Craig: Extraordinary loss due to warehouse fire of $240,000 before tax effect.
Lori: Loss on sale of discontinued division of $575,000 before tax effect.

Tax rates: 35% for both companies:

Outstanding shares of common stock:
Craig: 800,000 shares
Lori: 950,000 shares.

Selected Balance Sheet Information:

Craig: Cash $1,520,000; marketable securities (at cost $410,300, at fair value $495,400); Account receivable (gross $1,725,400 less allowance for doubtful accounts of $112,100); Finished goods inventory, opening balance $322,000, purchases $9,450,000, ending balance $242,000. Prepaid expenses $55,210. Plant assets at cost $21,400,000, accumulated depreciation $7,312,000. Accounts payable, $613,410, accrued expense payable $191,260, bonds payable $7,383,375, capital stock $1,450,000, retained earnings beginning balance $1,500,210, dividends paid, $1 per share.

Lori: Cash $1,960,000; marketable securities (at cost $352,430, at fair value $292,400); Account receivable (gross $2,935,400 less allowance for doubtful accounts of $172,300); Finished goods inventory, opening balance $420,000, purchases $11,842,400, ending balance $358,420. Prepaid expenses $22,110. Plant assets at cost $19,240,000, accumulated depreciation $8,245,000. Accounts payable, $693,450, accrued expense payable $201,220, bonds payable $3,579,217, Capital stock $2,210,000, retained earnings beginning balance $2,240,000, dividends paid $ per share.

Required:

problem
: Prepare a separate schedule comparing the selling and administrative expenses of the two companies. Separate subtotals are required for both selling and administrative expenses. You should have a column which compares the dollar difference by line item of the two companies.

a) Sort Craig Company Selling expenses from highest amounts to lowest using the sort function listed in the table function on the tool bar.

problem: Prepare a separate schedule of cost of goods sold for each of the companies.

problem: Prepare a comparative income statement in good form (chapter 4) for the two companies. Be sure the selling, administrative and cost of goods number comes from your first two schedules by way of formula. DO NOT SIMPLY TYPE IN THE NUMBERS. Percentage of sale data should be presented for cost of goods sold, gross margin, selling expense and administrative expense and net income.

problem: Prepare an EPS summary following your income statement.

problem: Prepare a classified balance sheet.

problem: Prepare a Statement of Retained Earnings.

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M9314

Have any Question? 


Related Questions in Accounting Basics

Account assignmentlets use this discussion to study bonds

Account Assignment Let's use this discussion to study bonds together. Assume the following information for a bond issue: ABC Company issues the bonds at a face value of $10,000.000 with a contractual (stated) interest ra ...

To understand the accounting equation and its

To understand the accounting equation and its elements QUESTION Mr. "A" starts a new business. Before to start the business operation, he has purchased vehicle Rs. 1,500,000, office premises Rs. 3,000,000, stock of goods ...

Royalty calculation problem setdaenerys owns a 38ths

Royalty Calculation Problem Set Daenerys owns a 3/8ths mineral interest in Section 8. The other 5/8ths are owned by Viserys. Daenerys and Viserys both enter into a lease with Westeros Oil and Gas on the AAPL form lease, ...

Westerville company reported the following results from

Westerville Company reported the following results from last year % 2013 operations: Sales $ 1,000,000 Variable expenses 300,000 -------------------------------------- Contribution margin 700,000 Fixed expenses 500,000 - ...

In january 2013 mitzu co pays 2650000 for a tract of land

In January 2013, Mitzu Co. pays $2,650,000 for a tract of land with two buildings on it. It plans to demolish Building 1 and build a new store in its place. Building 2 will be a company office; it is appraised at $823,50 ...

Taskyou are required to complete all questions in the same

Task You are required to complete all questions, in the same sequence as listed below, and submit all workings. Follow the assignment requirements (refer below to the Requirements section above) very closely. Question 1 ...

Del gato clinic deposits all cash receipts on the day when

Del Gato Clinic deposits all cash receipts on the day when they are received and it makes all cash payments by check. At the close of business on June 30, 2015, its Cash account shows a(n) $14,287 debit balance. Del Gato ...

Accounting assignment1 in the context of present value

Accounting Assignment 1. In the context of present value analysis, what is the discount rate? How does the discount rate affect the present value calculation? If the present value of a future return is calculated using a ...

Assessment cloud on-line accounting and systems

Assessment: Cloud On-line Accounting and Systems Documentation You are working as an accountant in an accounting firm. You have been approached by the owner of "Splash!" a start-up business that sells swimming accessorie ...

Managerial accounting and financial accountingcompare and

Managerial Accounting and Financial Accounting Compare and Contrast Managerial Accounting and Financial Accounting. Be sure to discuss how managerial accounting is useful for providing information for at least one of the ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro