Using the data presented belowa recreate the income, Ask an Expert

Finance

Using the data presented below:

a. Recreate the income statement and balance sheet using formulas wherever possible. Each statement should be on a separate worksheet. Try to duplicate the formatting exactly.

b. On another worksheet, create a statement of cash flows for 2011. Do not enter any numbers directly on this worksheet. All formulas should be linked directly to the source on previous worksheets.

c. Using Excel's outlining feature, create an outline on the statement of cash flows that, when collapsed, shows only the subtotals for each section.

d. Suppose that sales were $3,800,000 in 2011 rather than $3,500,000. What is the 2011 net income and retained earnings?

e. Undo the changes from part d, and change the tax rate to 40%. What is the 2011 net income and retained earnings?

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M92178340

Have any Question?Write your Review or question?

Related Questions in Basic Finance

Sheridan company plans to introduce a new product and is

Sheridan Company plans to introduce a new product and is using the target cost approach. Projected sales revenue is $1770000 ($6.00 per unit) and target costs are $1563500. What is the desired profit per unit?

Set up an amortization schedule for a 15000 loan to be

Set up an amortization schedule for a $15,000 loan to be repaid in equal installments at the end of each of the next 4 years. The interest rate is 10%. How large must each payment be if the loan is for $30,000? Assume th ...

With its current leverage cowcow copr will have net income

With its current leverage, COWCOW copr will have net income next year of $7 million. If COWCOWs corporate tax rate is 30% and it pays 7% interest on its debt, how much debt can COWCOW issue this year and still receive th ...

What are the main reasons for dji competitiveness in the

What are the main reasons for DJI competitiveness in the Drone Market? What are the main differences in the customers needs and values in the customer retail and Commercial professional drone market?

Whipple corp just issued 320000 bonds with a coupon rate of

Whipple Corp. just issued 320,000 bonds with a coupon rate of 6.26 percent paid semiannually that mature in 25 years. The bonds have a YTM of 6.70 percent and have a par value of $2,000. How much money was raised from th ...

Why does eps decrease if a companies additional capital it

Why does EPS decrease if a companies additional capital it wants is obtained by issuing more shares? How would it affect a companies decision about issuing equity to try and raise their capital? What would be the firms d ...

What is the effective annual rate of a savings account that

What is the effective annual rate of a savings account that pays an APR of 3% and compounds quarterly? Answer in percent and round to two decimal places.

Consider a currency swap for 10 million and sf 15 million

Consider a currency swap for $10 million and SF 15 million. One party pays dollars at a fixed rate of 9%, and the other pays Swiss francs at a fixed rate of 8 percent. The payments are made semiannually based on the exac ...

Dom grady just won the lottery and will receive annuity

Dom Grady just won the lottery and will receive annuity payments of $15,000 for each of the next 20 years, starting today (January 1, 2017). What is the present value of the annuity payments as of today, assuming a 8% in ...

A company has 6 percent coupon compounded semiannually

A company has 6 percent coupon (compounded semiannually) bonds on the market with 15 years to maturity, and the par value of $1,000. At what price should the bonds be selling for if YTM is 7%? Had the bond been selling a ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Basic Finance Expert