NVIDIA Corp. financial statements are presented below. Analysts forecast that its 2018 sales will be $8,260. The expected 2018 tax rate will be 17.35%. Assume the firm pays 5% interest on short-term debt and 7% on long term debt.
a) Use your judgement to forecast the items on the income statement and balance sheet with the percent of sales method. What is the discretionary financing needed in 2018? Is this a surplus or deficit?
Assume that the dividends per share will be $0.54 and the number of shares will be the same as in 2017.
b) Assume that DFN will be absorbed by long-term debt and that the interest rate is 2.5% of the sum of LTD and short-term debt. Set up an iterative worksheet to eliminate it.
c) Create a scatter chart of research and development vs. sales and add a linear trend line. Does there appear to be a consistent trend in this relationship?
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 15% higher than expected.
2. Base Case — Sales are exactly as expected.
3. Worst Case — Sales are 15% less than expected.
What is the DFN under each scenario?
You might also like to view...
In a(n) ________, a business cuts prices to take sales from competitors
A) equity competition B) share of wallet battle C) price war D) channel switch E) brand stretch
Which of the following is an input to MRP?
A. customer orders B. an operations plan C. a bill of materials file D. a sales plan
Blogs that allow open comments may generate negative responses from consumers. Why do many companies view them as worth the risk?
Answer the following statement(s) true (T) or false (F)
1. The Board of Directors, voted into office by the shareholders, is involved in the day-to-day operations of the firm. 2. No organization has control over economic growth, inflation, interest rates, or foreign exchange rates. 3. Strategic management’s success requires a commitment to a defined set of objectives by managers. 4. The vision statement of an organization provides a focus point for the future. 5. Cost leaders may offer their product or service to customers at the same cost as their competitors.