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

Assignmentyou are a manager of table top limited a

Assignment You are a manager of Table Top Limited, a manufacturer of small tables . You have been instructed to prepare a budget for the next year's operations with the following forecast: The sales volume is forecast to ...

Management accounting assignmentquestion 1 a how do fixed

Management Accounting Assignment Question 1: a. How do fixed costs in a business create a problem for job costing? b. Provide examples of wages that might be deemed to be (1) a direct cost and (2) an indirect costs. Ques ...

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

Managerial accounting assignment questionwidget airlines is

Managerial Accounting Assignment Question Widget Airlines is a leading business in travelling industry and has experienced turbulent times during the past 10 years due to stiff competition and as a result of global slowd ...

Managerial accounting assignment task specification-group

Managerial Accounting Assignment Task Specification- Group Report: "Measuring Performance and Management Control Systems" - A review of control systems reported in 2016 annual reports in Australian Public Companies. Subj ...

Venus brewery is a craft brewery that produces a special

Venus Brewery is a craft brewery that produces a special light beer for ladies. The beer are processed sequentially in two departments (Department X and Department Y) before the final products are transferred to the fini ...

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

Wyoming community college has three divisions liberal arts

Wyoming Community College has three divisions: Liberal Arts, Sciences, and Business Administration. The college's comptroller is trying to decide how to allocate the costs of the Admissions Department, the Registrar's De ...

Assignmentpart 1use the following data for questions 1 and

Assignment Part 1 Use the following data for questions 1 and 2. Fox Company manufactures a specialty line of belts. The company uses a job-order costing system. Cost detail for the job follow: Units produced 5,000 belts ...

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

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

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