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

Put, Put This is an agreement which is allowing a holder of privacies t...

Put This is an agreement which is allowing a holder of privacies to sell them back to the issuer at a specified amount during a specified time interval. This technique protects

Explain the purpose of corporate appraisal, PRC Company, a retailer of baby...

PRC Company, a retailer of baby clothes and toys, has been in existence for 20 years. Its approach to strategy has tended to be informal and emergent rather than planned. However,

#pseudocode.., #pseudocode for finance class ..

#pseudocode for finance class ..

Profitability index (pi), Profitability Index (PI) : It is a ratio of t...

Profitability Index (PI) : It is a ratio of the present value of the total cash benefits to the present value of the net cash outlay.  The higher the PI, the higher the return.

What are the benefits of traditional approach, What are the benefits of Tra...

What are the benefits of Traditional approach Traditional approach had a very narrow perception and was devoid of an integrated conceptual and analytical framework. It had pre

What are three major sections of the statement of cash flow, What are the t...

What are the three major sections of the statement of cash flows? Cash flows from financing activities Cash flows from investing activities Cash flows from Operations

Show regression analysis to estimate the default probability, 1. The standa...

1. The standard approach here is to calculate some conventional ratios. These ratios can afterwards be used along with regression analysis to estimate the default probability.

Determine the present value of store, Assume that ABC is considering openin...

Assume that ABC is considering opening an ice cream shop in Amsterdam. The shop will cost 1.8 million Euros, and the present value of the expected cash flows from the store is 1.4

Operating cycle, make an cash conversion cycle of cabbages

make an cash conversion cycle of cabbages

What do you mean by letter of credit, Q. What do you mean by Letter of Cred...

Q. What do you mean by Letter of Credit? A letter of credit is an arrangement whereby a bank helps its customer to obtain credit from its (customer's) suppliers. When a bank op

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