do these two problems in excel balance sheet and


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

Request for Solution File

Ask an Expert for Answer!!
Financial Management: do these two problems in excel balance sheet and
Reference No:- TGS0264785

Expected delivery within 24 Hours