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

Suppose a firm has had the following historic sales

Suppose a firm has had the following historic sales figures: 2009: 1,450,000 2010: $ 1,710,000 2011 : $ 1,600,000 2012: $ 2,000,000 2013: $ 1,850,000 What would be the forecast for next year's sales using regression to e ...

Which career is for you please respond to the

"Which Career is for You?" Please respond to the following: • Compare and contrast the key responsibilities of certified management accountants and certified public accountants. Select the career path that you plan to pu ...

Accounting paperwrite a 1000 - 1250 word paper on the

Accounting Paper Write a 1,000 - 1250 word paper on the following topic: Describe the role of managerial accounting in contemporary business. Provide one specific, real-life example of how managerial accounting helps man ...

Your company has spent 390000 on research to develop a new

Your company has spent $390,000 on research to develop a new computer game. The firm is planning to spend $59,000 on a machine to produce the new game. Shipping and installation costs of the machine will be capitalized a ...

Individual research paper instructions1write a 8-10-page

INDIVIDUAL RESEARCH PAPER INSTRUCTIONS 1. Write a 8-10-page, double-spaced research paper that adheres to APA format. 2. It must include references from at least 6 different sources, a title page, and a reference page. 3 ...

Assignment managerial accounting projectabstractyou are the

ASSIGNMENT: Managerial Accounting Project Abstract: You are the owner of your own company. Fast growth and the need to expand have made it necessary for you to seek financing from a local bank. However, you need to show ...

The facts and figures relating to irrigation corporation

The facts and figures relating to Irrigation Corporation are as follows. Irrigation Corporation produces plastic garden sprinklers. The company is preparing its budget for 2016. The first step is to plan for the first qu ...

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

Task question 1 1000 wordsmather and peison 2006 report

Task Question 1 (1000 words) Mather and Peison (2006) report that public debt contracts tend to have a lower average number of accounting based debt covenants as well as less binding debt covenants relative to private de ...

Decision making under uncertaintyproblem descriptionmangers

Decision Making Under Uncertainty Problem Description Mangers deal with a number of decisions about processes, capacity, location, inventory, etc. The process of making a decision is complicated because of the uncertaint ...

  • 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