Using the data in the student spreadsheet file P&G.xlsx (to find the student spreadsheets for Financial Analysis
Question:
a. What is the discretionary financing needed in 2014? 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.38% 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:
1) Best Case — Sales are 5% higher than expected.
2) Base Case — Sales are exactly as expected.
3) Worst Case — Sales are 5% less than expected. What is the DFN under each scenario?
Balance Sheet
Balance sheet is a statement of the financial position of a business that list all the assets, liabilities, and owner’s equity and shareholder’s equity at a particular point of time. A balance sheet is also called as a “statement of financial... Dividend
A dividend is a distribution of a portion of company’s earnings, decided and managed by the company’s board of directors, and paid to the shareholders. Dividends are given on the shares. It is a token reward paid to the shareholders for their...
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Financial Analysis with Microsoft Excel
ISBN: 978-1285432274
7th edition
Authors: Timothy R. Mayes, Todd M. Shank
Question Posted: