Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Managerial Accounting Expert

Perform these two problems in Excel. Balance Sheet and Income Statement. Following information is used for first two problems. Problem 1 is an income statement and problem 2 is a balance sheet.

Coffin Corporation had the following highly summarized financial events during the present year:

1. Jan. 2: Ordered new equipment with a 10-year life, for $80,000. No payment was made and the equipment has not been delivered.
2. Feb. 19: Bought $35,000 of inventory. Only $20,000 was paid for the inventory on that date, and the balance is owed to the suppliers. Coffin expects to be able to sell the inventory for $60,000.
3. July 12: Received equipment ordered on January 2, and mailed the check for the balance due.
4. Dec. 28: Coffin paid its employees $68,000 of wages. Wage expense for the year is $66,000. Payment included the $2,000 wages payable balance outstanding from the previous year plus some payment for work done this year.
5. Dec. 30: Sales for the year totaled $123,000. All but $3,000 of that amount has been collected. The entire $6,000 balance in accounts receivable from beginning of the year was also collected. The cost of the books and posters sold was $32,000.
6. Dec. 31: Coffin makes a payment of $34,000 on its long-term note.  This is an interest free business development loan.
7. Dec. 31: Coffin's building and equipment are now one year older. Depreciation for the year is $15,000.

Suppose that Coffin began the year with the following balances (shown in alphabetical order) in their accounts at the beginning of the year:

Accounts Payable              $ 2,000
Accounts Receivable            6,000
Cash                              180,000
Equipment, Net                150,000
Notes Payable                 150,000
Contributed Capital           30,000
Retained Earnings             52,000
Wages Payable                  2,000

Quetions:

1) Prepare the income statement.

2) Prepare A comparative statement of financial position (balance sheet).

Managerial Accounting, Accounting

  • Category:- Managerial Accounting
  • Reference No.:- M91180

Have any Question? 


Related Questions in Managerial Accounting

Discuss the concept of legal liability for auditors and the

Discuss the concept of legal liability for auditors and the massive risk involved. Take a position on this thought and defend it to your classmates. Include a differentiation between common law and statutory law.

Bonita company is constructing a building construction

Bonita Company is constructing a building. Construction began on February 1 and was completed on December 31. Expenditures were $2,004,000 on March 1, $1,284,000 on June 1, and $3,055,300 on December 31. Bonita Company b ...

Assignment-task this is an assignment in which required to

Assignment- Task: This is an assignment in which required to answer all of the problems. Assignment details: Problem 1: a. Two four-year-old companies are identical in all respects except that Company A has used straight ...

Leeds architectural consultants began operations on january

Leeds Architectural Consultants began operations on January 2. The following activity was recorded in the company's Work in Process account for the first month of operations:                                               ...

You are the chief financial officer of general motors

You are the chief financial officer of General Motors Corporation (GM) at the beginning of 2009. The company’s board of directors has asked you to inform board’s audit committee about the pending audit opinion of Deloitt ...

Determine gross profitduring the current year merchandise

Determine Gross Profit During the current year merchandise is sold for $2,450,000. The cost of the merchandise sold is $1,519,000. A . What is the amount of the gross? $__________ B. Compute the gross profit percentage ( ...

When bonds are issued at other than par value a discount or

When bonds are issued at other than par value, a discount or premium is recorded. This discount or premium is amortized over the life of the bond. However, a callable bond may be retired before the maturity date, which l ...

Task specificationthis case study is designed for you to

Task Specification This Case Study is designed for you to demonstrate your abilities in relation to the following subject learning outcomes Learning Outcomes a) Analyse the links between management accounting, customers, ...

Accountingthree questions please provide references

Accounting Three questions please provide references where needed Financial statement analysis 1. The Financial Statement Analysis is the process of reviewing and evaluating the company's financial statements with the on ...

Both interest expense on borrowing and dividends on common

Both interest expense on borrowing and dividends on common stock reduce net assets and reduce shareholders' equity. Accountants treat interest as an expense in measuring net income but do not treat dividends on common st ...

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate