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

Why are trend analysis and industry comparison, Why are trend analysis and ...

Why are trend analysis and industry comparison important to financial ratio analysis? Trend analysis assists financial analysts and managers see whether a company's current fin

Explain about routine functions, Q. Explain about Routine Functions? Ro...

Q. Explain about Routine Functions? Routine Functions: - The routine functions are Supervision of cash receipts and payments. Opening Bank Accounts as well as managing them Saf

Explain why accounting profits and cash flows, Explain why accounting profi...

Explain why accounting profits and cash flows are not the same thing. Stock worth depends on future cash flows, their riskiness and their timing.  Profit calculations don't con

Gathering competitive intelligence information, K is a kitchen and bathroom...

K is a kitchen and bathroom design and installation company which currently has showrooms in one region only of Country T. The company has enjoyed considerable success since it was

Determine the concept of dividend yield, Dividend yield Dividend yield ...

Dividend yield Dividend yield = (Dividend per share/Market share price) x 100% Dividend yield is the cash return on the share (not whole return which is cash dividend and ca

Risk of default influence the rate of interest, Q. Risk of default influenc...

Q. Risk of default influence the rate of interest? The bank offering the loan to Blin will make an assessment of the risk that the company might default on its loan commitments

Marketing, How to use integrated promotional mix to achieve marketing objec...

How to use integrated promotional mix to achieve marketing objectives

Mortgages, A mortgage may be defined as a pledge of property ...

A mortgage may be defined as a pledge of property to secure a debt payment; in this context, we will use the term property to mean real estate. If the

State the cash flow from investing activities, Cash flow from investing act...

Cash flow from investing activities The items included in this heading are: Cash payments Cash receipts Acquiring proper

Buy down loans, The buy down loan is similar to the PAM; however, it ...

The buy down loan is similar to the PAM; however, it is the seller of the property and not the buyer/borrower who places cash in a segregated account so that additional

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