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

Types of us treasury securities, Under treasuries, there exist ...

Under treasuries, there exist different types of securities like treasury bills, treasury notes, treasury bonds, inflation protection securities

Does high operating leverage always mean high business risk, Does high oper...

Does high operating leverage always mean high business risk?  Explain. High operating leverage doesn't always mean high business risk.  If the company's sales are quite steady

Explain about economic order quantity, Q. Explain about economic order quan...

Q. Explain about economic order quantity? The economic order quantity (EOQ) model is basis on a cost function for holding inventory which has two terms: holding costs as well a

Accumulate the money necessary for your retirement, You plan to retire in 3...

You plan to retire in 35 years and can invest to earn 7 percent. You estimate that you will need $85,000 at the end of each year for an estimated 25 years after retirement, and you

Explain the effect of foreigners’ portfolio investments, As the early 1980s...

As the early 1980s, foreign portfolio investors have purchased an important portion of U.S. treasury bond issues. Discuss the short-term and long-term influences of foreigners’ por

What is maturity, Q. What is Maturity? Maturity: The maturity period of...

Q. What is Maturity? Maturity: The maturity period of the securities should be short, otherwise, the company might suffer losses on account of getting the funds pre-maturely re

Facts about mortgages, Lenders in the US insist upon ...

Lenders in the US insist upon some kind of mortgage insurance. There are broadly two types of mortgage insurance - one is

Financial analysis task force, Task I am sure you are aware that the c...

Task I am sure you are aware that the corporate annual meeting is coming up soon. As part of the Treasurer's presentation, I have been asked to propose a Special Capital Requi

Evaluation of change in credit policy, Evaluation of change in credit polic...

Evaluation of change in credit policy Current average collection period = 30 + 10 = 40 days Current accounts receivable = 6m × 40/ 365 = $657534 The Average collection pe

Marginal weighting system, uses and limitations of the marginal weighting s...

uses and limitations of the marginal weighting system

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