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

Define long position in future contract and options contract, What is the m...

What is the major difference in the obligation of one with a long position in a futures (or forward) contract in comparison to an options contract? Answer: A futures or forward c

What are the weaknesses of the traditional approach, What are the Weaknesse...

What are the Weaknesses of the traditional approach The traditional approach to the scope of finance function evolved during 1920s and 1930s and dominated academic during 40's

Define moody or standard & poor credit ratings, Why do most international b...

Why do most international bonds have high Moody’s or Standard & Poor’s credit ratings? Answer:  Moody’s Investors Service and Standard & Poor’s offer credit ratings on several

What is the maximum additional short-term funding, B.J. Industries has a cu...

B.J. Industries has a current ratio of 2.5, with $2.5 million in current assets.  Due to sales growth, the company wants to expand accounts receivable and inventories by

What are municipal bonds, What are Municipal Bonds? Define this term. M...

What are Municipal Bonds? Define this term. Municipal bonds are debt instruments issued through US local, state or county governments to finance public interest projects. These

182-day t-bills, 182-Day T-Bills Following the Sukhamoy Chakravarty Com...

182-Day T-Bills Following the Sukhamoy Chakravarty Committee recommendations, in November, 1986, 182-day T-bills were introduced in order to develop the short-term money market

Accounting entity - accounting principle, Accounting Entity - Accounting Pr...

Accounting Entity - Accounting Principle For accounting reasons it is suppose that business has separate existence and its entity is different from that of its owner(s). In si

Working capital as a percentage of net sales, Q. Working Capital as a Perce...

Q. Working Capital as a Percentage of Net Sales? This approach to estimate the working capital requirement is based on the fact that the working capital for any firm is directl

Can you explain dispersion method, Q. Can you explain Dispersion method? ...

Q. Can you explain Dispersion method? Dispersion method help to assert risk in receiving a return on investment. The greater the potential dispersion, the greater the risk. One

When they analyze pro forma financial statements, What do financial manager...

What do financial managers look for when they analyze pro forma financial statements? After the pro forma financial statements are finished, financial managers examine the

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