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

Instructionsall assignments must be typed in a minimum 11

Instructions: All assignments must be typed in a minimum 11 font size into the assignment template question sheet (available on Moodle). Additional pages may be added as needed. There is no word limit, but be guided by t ...

Accounting1 from the e-activity assess the advantages and

Accounting 1. From the e-Activity, assess the advantages and disadvantages of the continued use of the traditional relational database and then decide if businesses should be moving toward relational databases in the clo ...

Exploring potential research topicsdo the following to

Exploring Potential Research Topics Do the following to complete this assignment: • Based on your business experience and the information accumulated in this class, identify three possible research topics related to the ...

Dillon jones and kline ltd is studying the acquisition of

Dillon, Jones, and Kline, Ltd. is studying the acquisition of two electrical component insertion systems for producing its sole product, the universal gismo. Data relevant to the systems follow. Model A: Variable costs, ...

Tri-county cable services inc is organized with three

Tri-County Cable Services, Inc., is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the year just ended follow. Metro Suburban Outlying Service revenue $ 1,050,000 $ 850,000 $ 45 ...

Need research paper by december 5th 2016compose a research

Need Research Paper by December 5th, 2016 Compose a research paper that discusses the use of either the balanced scorecard or economic value added as a tool for improving organization performance. The paper must be doubl ...

Problem 1 master budgetomega inc has developed the

Problem 1: Master Budget Omega, Inc. has developed the following sales forecast for the first six months of the coming year Month Sales (in units) January 30,000 February 50,000 March 70,000 April 80,000 May 60,000 June ...

Accounting assessment1 ohio corporation sells its product

Accounting Assessment 1. Ohio Corporation sells its product for $16 per unit and incurs variable costs of $10 per unit and total fixed costs of $12,000. What is Ohio Corporation's break-even point for sales of this produ ...

Question wmtb is an independent television station run by a

Question: WMTB is an independent television station run by a major state university. The station's broadcast hours vary during the year depending on whether the university is in session. The station's production crew and ...

Managerial accounting-you have just been hired as a

Managerial Accounting- You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company's financial statement ...

  • 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