Expert answer:Milestone 4 section 5
Solved by verified expert:For this milestone, submit a draft of the Macroeconomic Items section of the final project, along with your supporting explanations. Base your calculations on the data provided in this case study https://www.sec.gov/Archives/edgar/data/354950/000… Be sure to substantiate your claims.
fin550_milestone_iv_modified___final_project___17tw1.doc
fin550_milestone_iii__section_iv__modified_17tw1.doc
Unformatted Attachment Preview
Instructions for Milestone #4 (Section 5) & Final Project Submission
The following additional information should be used when you write up your Milestone #4
(Section 5) assignment and your Final Project Submission. The CEO of the company is
convinced that a financial analysis should hinge only on what is happening internally within HD.
Using the Home Depot balance sheet on page 32 and the income statement on page 33, conduct
the following financial analysis by computing the ratios below:
Macroeconomic Items to Cover for Milestone #4 (Section 5):
1. How might a positive issue from the stock market impact the company’s stock valuation
numbers? For example, since the November 2016 election, there has been a considerable
increase in all major stock market indices. Would higher values for HD’s common stock result
in an increase or decrease in cost of equity capital in its WACC as we discussed in class and in
Chapter 9 (i.e., the value of rs in the DCF model for the cost of equity)? In addition, explain how
such a change in the cost of rs might lead the firm to use more or less debt financing in its
WACC? Finally, briefly explain how a change in HD’s WACC would impact (increase or
decrease) the NPV of the capital budgeting project you analyzed in Milestone #3 (Section 4) of
your term project.
2. Suppose the US economy continues to expand as it has most recently. How might this
external event impact HD (in terms of its sales, net income, etc.)? Briefly distinguish between
nominal GDP versus real GDP. As the firm’s CEO, if you were to analyze changes in nominal
GDP versus real GDP data briefly explain which of the two would you argue is most relevant.
Furthermore, it has been widely speculated that the FED will continue to increase interest rates in
the future. Based on our macroeconomics discussions in class on 10/16, what are the three (3)
tools of monetary policy which the FED can use to change interest rates? Which of these three
monetary policy tools is most often used by FED policymakers? How might an increase in
overall market interest rates impact HD? Explain your answer.
For your Final Project Submission and Financial Analysis, Please Cover the Following
Items:
1. Determine the current and quick ratios for 2015 and 2014 and briefly comment on the
changes between these two years.
2. Determine days sales outstanding (DSO) for 2015 and 2014 and briefly comment on the
changes between these two years. Note: Here use Net Receivables and Net Sales as well as a
365-day year.
3. Determine the total asset turnover ratios (TATO) for 2015 and 2014 and briefly comment on
the changes between these two years.
4. Determine the Operating Cycle for HD in 2015 and 2014 as well as HD’s Cash Conversion
Cycle in both 2014 and 2015. Based on your CCC for Home Depot, has operating liquidity
increased or decreased over these two years? Briefly explain.
Note: Use Merchandise Inventories from the balance sheet on page 32 and Accounts Payable
from the balance sheet when you determine the turnover ratios and the Operating Cycle for HD.
Similarly, use Net Sales and Cost of Sales (as cost of goods sold) from the income statement on
page 33 when you determine DSO (question #2 above) and payables turnover for HD and then
its Payables Deferral Period.
5. Determine the profit margin (PM) for 2015 and 2014 and briefly comment on the changes
between these two years.
Note: Here use the value of Net Earnings for each of the two years and the values of Net Sales
for the two years as well.
6. Determine the value of return on assets (ROA) for 2015 and 2014 and briefly comment on the
changes between these two years. Once again, rely on the value of Net Earnings (from the
income statement and Total Assets from the balance sheet).
7. Determine the value of return on equity (ROE) for 2015 and 2014 and briefly comment on the
changes between these two years. In your calculation of ROE, once again rely on the value of
Net Earnings (from the income statement) and Total Stockholders’ Equity (in the next-to-last
line of the balance sheet on page 32 of the 10-K report).
Instructions for Milestone #3 (Section IV)
The following additional information should be used when you write up your Milestone #3
(Final Project, Section IV) assignment. Based on the in-class handout discussed on Monday,
October 16, perform a capital budgeting analysis for HD. More specifically, use the spreadsheet
and the following inputs provided.
FCF’s for the five years as:
FCF1 = $50,000,000
FCF2 = $45,000,000
FCF3 = $65,500,000
FCF4 = $55,000,000
FCF5 = $25,000,000
And the operating costs:
OPC1 = 25,500,000
OPC2 = 25,500,000
OPC3 = 25,500,000
OPC4 = 25,500,000
OPC5 = 25,500,000
As noted in the instructions in the spreadsheet, assume HD’s WACC = 8% and it uses straight
line depreciation when evaluating capital projects.
1. Determine the NPV for this project. Based on your NPV, should HD accept or reject the
project? Briefly explain why it should accept or reject this project based on its NPV.
2. Determine the IRR for this project. Based on your IRR, should HD accept or reject the
project? Briefly explain why it should accept or reject this project based on the IRR.
3. Why do financiers/analysts use the WACC for new projects, and also explain why analysts
use the term “hurdle rate” when it comes to a firm’s WACC?
4. What happens to a project’s NPV if the WACC increases? Briefly explain why this is the
case.
…
Purchase answer to see full
attachment
How it works
- Paste your instructions in the instructions box. You can also attach an instructions file
- Select the writer category, deadline, education level and review the instructions
- Make a payment for the order to be assignment to a writer
- Download the paper after the writer uploads it
Will the writer plagiarize my essay?
You will get a plagiarism-free paper and you can get an originality report upon request.
Is this service safe?
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades