time value of money

### Question Description

For this milestone, submit a draft of the Time Value of Money section of the final project, along with your supporting explanations. Base your calculations on the data provided in this case study

Be sure to substantiate your claims.

Submit your calculations on the designated tab of the Final Project Student Workbook and your supporting explanations as a Microsoft Word document

### Unformatted Attachment Preview

Purchase answer to see full attachment

Interest
2015
113

10%
2016
111

2017
108

2018
101

2019
97

PV

\$ -102.73

\$ -91.74

\$ -81.14

\$ -68.98

\$ -60.23

Total PV

\$ -404.82

Amount(million)

Present Value
Period ,nper
Interest
PMT
Future Value

\$ -404.82
5
0.1
0
\$ 651.96

1

Milestone Project
Name
University Name
Course
Sept 22, 2017

MILESTONE PROJECT

2
Introduction

The time value of money is a concept that says that the money available at the present
time is worth more than the same amount in future due to potential earning capacity (Curwin,
2013). Thus, the time value of money serves as a connection between the value of money and
the time.The relationship between time and value of money holds importance in case of
capital structure decision, investment decision and capital budgeting.An investor can use the
concepts in making an investment decision and assessing the risk of the capital.In short, an
everyday decision based on saving, borrowing, and spending depends on the time value of
money as it affects our daily transactions.
The objective of the paper is to analyze the concept of time value of money for the
company Home Depot, Inc. The Home Depot is an American home improvement supplies
that sell tools, construction products and services.
Present Value of Company at 8% Cost of Capital
In order to calculate the present value of the firm in 2014, the expected revenue of the
firm is obtained from the year 2015 to 2018 from the annual financial report of Home Depot,
Inc. ("HD-2.1.2015-10-K", 2017).The cash flows from 2015 to 2018 obtained were \$113
million,\$111 million,\$108 million,\$101 million and \$97 million respectively. The present
value for 2014 will be the sum of discounted value from the year 2015 to 2018 Using excel,
the present value of cash flow at the 8% cost of capital obtained was \$425.78 million,
Present Value of Company at 10% Cost of Capital
When the risk of the changes from 8% to 10%, the present value of money decreased
from \$425.78 million to \$404.82(see Appendix).Thus, increasing the capital cost from 8% to
10% cause a decrease of \$20.96 million in its present value.

MILESTONE PROJECT

3

Reasonable Amount Company should be sold
When the five-year has elapsed the company can be sold based on its future value five
years from now. The future value of the company being obtained in five years from now will
be \$685.73 million. On the other hand, future value calculated at 8% cost of capital obtained
was \$625.61 which is \$60.12 million less compared to 10% cost of capital. Thus, the
reasonable amount that should be sold at 10% interest rate is \$685.73 million.
Net present value and risk have a strong relationship with each other. In order to
arrive at the correct or approximate present value, it is appropriate to assess the ris...

psumanrec (3859)
Cornell University
Review

Anonymous
I was on a very tight deadline but thanks to Studypool I was able to deliver my assignment on time.

Anonymous
The tutor was pretty knowledgeable, efficient and polite. Great service!

Anonymous
Heard about Studypool for a while and finally tried it. Glad I did caus this was really helpful.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors