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

Determine the key factor affecting financing costs, Determine The key facto...

Determine The key factor affecting financing Costs Because cost of capital is measured under the assumption that both firm's asset structure and its capital (financial) structu

Cases let, How would you judge the potential profit of Bajaj Electronics on...

How would you judge the potential profit of Bajaj Electronics on the first year of sales to Booth Plastics and give your views to increase the profit.

Why do financial managers calculate the marginal tax rate, Why do financial...

Why do financial managers calculate the marginal tax rate? Financial managers make use of marginal tax rates to estimate the future after-tax cash flows from investments. As th

Changes in liquidity risk, Liquidity risk tends to change as and when...

Liquidity risk tends to change as and when there exists a change in the spread between the bid and the ask price. Market liquidity change is a matter of concern f

Write a report to outlining the theoretical arguments, QUESTION The Man...

QUESTION The Managing Director of your firm is thinking aloud about an appropriate gearing level for the company: "The consultants I spoke to yesterday explained that some t

Discuss the pros and cons of financing in unhedged, You have the following ...

You have the following information about rates in London for Eurocurrency loans of one-year duration, the exchange rate between the USD and euros, the currency in which you want fi

Stock valuation, Investors require an 11% return on a preferred stock that ...

Investors require an 11% return on a preferred stock that pays a $2.30 annual dividend.  What is the price

Show the signs of overtrading, Q. Show the Signs of Overtrading? There ...

Q. Show the Signs of Overtrading? There are a number of usually recognised signs that a company may be overtrading. These are considered mutually with relevant financial data f

Which method should we use to valuate young companies, Which method should ...

Which method should we use to valuate young companies with high growth but uncertain futures? Two examples were Boston Chicken and Telepizza when they began. The great majo

Approximating the percentage price change using duration, Let us expr...

Let us express the process of calculating approximate percentage price change for a given change in yield and a given duration using the following formula:

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