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

Cash flow valuation technique, Cash Flow Valuation Technique The aim o...

Cash Flow Valuation Technique The aim of this research is to empirically enquire into how to value a company using discounted cash flow valuation technique within its real lif

State the term- dividend cover, Dividend cover Dividend cover = Profit ...

Dividend cover Dividend cover = Profit available to ordinary shareholders (PAT) / Annual dividend(no. of times) Or =    EPS/Dividend per share Dividend cover shows safety

Add or Drop Analysis, Lakespring Retirement Village is home to senior citiz...

Lakespring Retirement Village is home to senior citizens who are fairly independent but need assistance with basic health care and occasional meals. Jill Thompson, a licensed beaut

Advantages of budgetary control, ADVANTAGES OF BUDGETARY CONTROL 1. Pr...

ADVANTAGES OF BUDGETARY CONTROL 1. Profits are maximizes. 2. It makes easy the controlling of activities. 3. Effective co-ordination is made achievable. 4. Executive

Future value, (a).At the end of three years, how much is an initial deposit...

(a).At the end of three years, how much is an initial deposit of $100 worth, assuming a compound annual interest rate of (i) 100 percent? (ii) 10 percent? (iii) 0 percent? (b).b. A

APR and EAR, Assume a bank charges a 15.5% APR (annual percentage rate) on ...

Assume a bank charges a 15.5% APR (annual percentage rate) on credit card holder compounds quarterly. What EAR (effective annual rate) is the bank is charging? What if they change

Eurobond, Eurobond A corporate bond denominated in U.S. dollars or oth...

Eurobond A corporate bond denominated in U.S. dollars or other hard currencies and sold to investors outside the country whose currency is used. Eurobonds have become an impor

Reasons for time preference of money, Q. Reasons for Time Preference of Mon...

Q. Reasons for Time Preference of Money? 1) Future Uncertainties: One of the reasons for preference for current money is that there is a certainty about it whereas the future

Incremental policy model to the policy making process, Question 1: Poli...

Question 1: Policy implementation is the most critical stage of the policy process. Critically analyse some of the main constraints that hinder the implementation of public pol

Nominal interest rate, You have to make a payment of $1,561.39 in 10 years....

You have to make a payment of $1,561.39 in 10 years. To get the money for this payment, you will make 5 equivalent deposits, starting today and for the following 4 quarters, in a b

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