Balance sheet and income statement, Financial Management

Assignment Help:

Do these two problems in Excel. Balance Sheet and Income Statement.  The following information is used for the first two problems.  Problem 1 is the income statement and problem 2 is the balance sheet. 

Coffin Corporation had the following highly summarized financial events during the current 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 the equipment ordered on January 2, and mailed a check for the balance due.

4. Dec. 28-Coffin paid its employees $68,000 of wages. Wage expense for the year is $66,000.  The 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.

Assume 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                    130,000
Retained Earnings                       52,000

Wages Payable                           2,000

Prepare:

1) An income statement.

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


Related Discussions:- Balance sheet and income statement

What are the failure of mergers and takeovers, Failure of mergers and tak...

Failure of mergers and takeovers Failure of mergers and takeovers Poor strategic plan will result in slow or failed integration. Integra

What is indirect method, What is Indirect method Indirect method is wha...

What is Indirect method Indirect method is what you would probably be familiar with. It requires a lot less information to produce it and hence can be argued to be easier metho

Orperating cycle, #discuss the applicability of an operating cycle in veget...

#discuss the applicability of an operating cycle in vegetable growing business in uganda..

Define defined benefit and defined contribution pension plan, Compare and c...

Compare and contrast a defined benefit and a defined contribution pension plan. In a defined benefit plan, retirement benefits are defined by a formula that generally considers t

Functional silo, It is a phrase referring to the tendency of departments to...

It is a phrase referring to the tendency of departments to become isolated from one another in a functionally structured company.

Agency relationship, Solutions to shareholders and government agency proble...

Solutions to shareholders and government agency problemquestion #Minimum 100 words accepted#

Assignment, The objective of the assignment is to develop an understanding ...

The objective of the assignment is to develop an understanding of the factors that influence changes in the prices of stocks. *A person has $ 100,000 that they have to invest in s

Optimal portfolio selection, Optimal Portfolio Selection: The next step...

Optimal Portfolio Selection: The next step involves selecting the optimal portfolio. The strategic asset allocation will have overriding importance in pension fund management.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd