Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Basic Finance Expert

Finance


Home >> Basic Finance

Using the data in the student spreadsheet file P&G.xlsx (to find the student spreadsheets for Financial Analysis with Microsoft Excel, sixth edition, go to www.cengage.com/finance/mayes) forecast the June 30, 2011, income statement and balance sheet for Procter & Gamble. Use the percent of sales method and the following assumptions: (1) Sales in FY 2011 will be $81,000; (2) The tax rate will be 27.26%; (3) Each item that changes with sales will be the five-year average percentage of sales; (4) The preferred dividend will be 219; and (5) The common dividend payout ratio will be 42% of income available to common stockholders.

a. What is the discretionary financing needed in 2011? Is this a surplus or deficit?

b. Assume that the DFN will be absorbed by long-term debt and that the total interest rate is 4.50% of LTD. Set up an iterative worksheet to eliminate it.

c. Create a chart of cash vs. sales and add a linear trend line. Is the cash balance a consistent percentage of sales? Does the relationship fit your expectations?

d. Use the regression tool to verify your results from part c. Is the trend statistically significant? Use at least three methods to show why or why not.

e. Turn off iteration, and use the Scenario Manager to set up three scenarios:

1470_40865a19-a8d4-4cdf-bda0-0cfcd99e695b.png

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M92178253

Have any Question?


Related Questions in Basic Finance

1 you are valuing a common stock that just paid a dividend

1.) You are valuing a common stock that just paid a dividend of $1.25 per share. You are expecting the stock to grow at the rate of 4% annually, and the stock to give you a return of 9%. What should be the price of the s ...

Tiffany borrows a 200000 5 years loan at 7 with a fixed

Tiffany borrows a $200,000, 5 years loan at 7%, with a fixed amount of principal to be repaid every year. What is the total amount that she will need to pay at the end of year 4? (round off all answers to 2 decimal place ...

Mcconnell corporation has bonds on the market with 185

McConnell Corporation has bonds on the market with 18.5 years to maturity, a YTM of 7.9 percent, a par value of $1,000, and a current price of $1,067. The bonds make semiannual payments. What must the coupon rate be on t ...

Find the modified internal rate of return mirr the annual

Find the modified internal rate of return (MIRR) The annual rate is 8.24%. Initial outlay is $356,800. Year 1: $163,100 Year 2: $173,100 Year 3: $181,300 Year 4: $175,700 Year 5: $161,400

Find the future value of the following income stream as of

Find the future value of the following income stream as of year 30, assuming that the appropriate interest rate is 15% per year. Year 1 2---------9 10 11----30 Income $100 $100-----$100 $100 $300-----$300

Think about childrens education in the us describe two

Think about children's education in the U.S. Describe two factors that are currently hindering the intellectual development of children in this country. Explain why each of these factors impacts intellectual development

Net income is 300 million depreciation is 70 million

Net income is 300 million, depreciation is 70 million, capital expenditures are 120 million, investment in working capital is 30 million, interest expenses (before tax) are 40 million, and outstanding debt is 850 million ...

Question - you are given one-year stock options with an

Question - You are given one-year stock options with an exercise price of $30. The current stock price is $30, so the options are at-the-money. Without hedging, the stock price at year-end will either be $28 or $38 with ...

Would you pay 23 for a share of common stock that just paid

Would you pay $23 for a share of common stock that just paid a $1.65 dividend, its expected growth rate is 4% and your required return is 11%?

What factors are involved in cash flow management as they

What factors are involved in cash flow management as they relate to various payment methods and What kinds of payment terms might the business venture have with its vendor to help manage its cash flow?

  • 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

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As

Follow Us

© Copyright 2013-14 mywordsolution.com All rights reserved