Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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:
difference between private limited company and public limited
Analyze the pro forma statement for Kristin Raina Interior Designs created in the previous module and create a detailed PowerPoint presentation with speaker's notes to demonstrate why the bank should give Kristin a loan.
FIN 370- Based on the little that you read about interest rates and how they impact the housing market, what would you say is the best time to try and sell a house: when interest rates are rising or falling and why?
what will happen to each of the stocks required rates of return? Will one go up more than the other? Will they stay the same? Why?
Prepare income statements for the two plans that proves EPS will be the same regardless of the plan chosen at the EBIT level found in part a.
you are the marketing manager of a cosmetic products company. harris your supervisor is suggesting an advertisement
What is financial system? How it helps firms to raise short term and long term funds requirements and what are major components of financial statements? What purposes it serves to its users.
How does TVM affect management decisions regarding special terms, such as "no payment due for 6 months, interest free," or "buy a gift card for $50 and get $5 off your next purchase?" What TVM calculations would have to be considered in offers lik..
Based upon the ""trade-off theory"" of capital structure, what differences might you expect in the capital structure of a food producer and a defense contractor?
Calculate the total value added of all the manager's decisions this period and calculate the value added (or subtracted) by her country allocation decisions - What was the contribution of security selection to relative performance
to be classified as short-term investments debt investments must be readily marketable and be expected to be sold
Suppose that the risk-free rate is 5%, the company's beta is equal to 2, and the expected market return is equal to 20%. What should be the IPO price (which is equal to the fundamental value of the firm) according to the two stage DDM?
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!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd