Ask Question, Ask an Expert


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


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

E4-13 - analyze adjusted datathis is a partial adjusted

E4-13 - Analyze adjusted data This is a partial adjusted trial balance of Barone Company   BARONE COMPANY Adjusted Trial Balance 31-Jan-14         Debit Credit Supplies $700   Prepaid Insurance 1,560 Salaries and Wages P ...

Learning outcomeanalyse the issues or problems in a given

Learning Outcome: Analyse the issues or problems (in a given scenario) using management accounting techniques and tools, and formulate recommended solutions. Required: Write a short analysis based on the assignment detai ...

Management accounting acc-5202topic use of management

Management Accounting (ACC-5202) Topic: Use of Management Accounting tools and techniques in your organization. - Five people in a group - Select an imaginary company - One CEO, other four might have some ...

Accounting for business decisions group assignment-you can

Accounting for Business Decisions Group Assignment- You can select any company just need to be listed in ASX. The assignment aims to develop an understanding of financial statements structure and their use in decision-ma ...

Assume that an investor has accounted for a 320000 cost 8

Assume that an investor has accounted for a $320,000 cost, 8% investment in the investee using the fair value method (available-for-sale designation). The following additional information is available: Cumulative Dividen ...

Exercise units sold to break even unit variable cost unit

Exercise : Units Sold to Break Even, Unit Variable Cost, Unit Manufacturing Cost, Units to Earn Target Income Werner Company produces and sells disposable foil baking pans to retailers for $2.75 per pan. The variable cos ...

Discussion questions managerial accounting tools for

Discussion Questions: Managerial Accounting: Tools for Business Decision Making Question 1: What are value-added processes? How do you determine if a process adds value? How does identification of value-added processes h ...

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

Denise ssn 182-90-0113 and marcus anders claim their two

Denise (SSN 182-90-0113) and Marcus Anders claim their two children, David (SSN 392-40-7417, age 7) and Stacy (SSN 813-20-4444, age 11) as dependents. During the year, Denise worked full-time and earned $38,200. Marcus w ...

Write the given assignmentfinancial managementnote for part

Write the given assignment. FINANCIAL MANAGEMENT Note: For part three of question B there is an article i attached you have to consider that to answer part three of question B. Part A Q1.i) What factors determine the exp ...

  • 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