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

Grana enterprise incgrana enterprise inc gei is a

Grana Enterprise Inc. Grana Enterprise Inc. (GEI) is a manufacturing company with operations in Italy and Serbia. GEI in Italy: In addition to other assets, GEI owns and operates a commercial building in Italy that is ca ...

Kent cpa is a staff auditor participating in the audit

Kent, CPA is a staff auditor participating in the audit engagement of Fort, Inc. Based upon each of the circumstances below, indicate whether or not Kent's actions impair his independence. Explain your response for each ...

You are starting your own internet business you decide to

You are starting your own Internet business. You decide to form a company that will sell cookbooks online. Justcookbooks.com is scheduled to launch 6 months from today. You estimate that the annual cost of this business ...

1 as a small business owner in todays economy what three

1. As a small business owner in today's economy, what three financial reports would you use on a regular basis? What information would you find on each statement? What decisions might each statement help you make? Please ...

Dq1respond to the ethics discussion case at the end of

DQ1 Respond to the Ethics Discussion Case at the end of chapter 13 in the textbook. Assume that you are a CPA and a tax specialist. Your clients include Ale and Grains, Inc., an S corporation, and Gustav and Heidi Lager, ...

Question 1if total liabilities are 1000 and total assets

Question 1 If total liabilities are $1,000 and total assets are $8,000, owner's equity must be A. $7,000. B. $3,000. C. $10,000. D. $13,000. Question 2 If total assets are $30,000 and total liabilities are $18,000, capit ...

Watch accounting witts video titled cash and accrual -

Watch Accounting WITT's video titled "Cash and Accrual - Conceptual": https://www.youtube.com/watch?v=aPwdgUDXkkE&feature=youtu.be Based on the video, explain two (2) advantages and two (2) disadvantages in using both th ...

1you have been hired by the cfo of strayer university to

1.You have been hired by the CFO of Strayer University to develop a plan to protect its accounting and financial systems at a reasonable cost. Suggest a high-level plan for the CFO. Provide support for your suggestion. B ...

Fasb ongoing projectproject objectivedescribe the history

FASB Ongoing Project Project Objective Describe the history, current status, and adoption implications of a Financial Accounting Standards Board ongoing project. Requirements The FASB has several ongoing projects that in ...

Question 1the following information relates to the

Question 1 The following information, relates to the imputation credit account (ICA) for Killorglin Park Fair Ltd ("Killorglin Park") for the year ending 31 March 2016. (i) The shareholders as at 31 March 2015 were Donna ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen