# Financial math with excel, assignment help

*label*Mathematics

*timer*Asked: Oct 7th, 2016

*account_balance_wallet*$25

### Question Description

Hi

Need to be done in 24 hours. Leave best price

### Unformatted Attachment Preview

Purchase answer to see full attachment

## Tutor Answer

Dear student,Please find enclosed a doc file containing the step by step solution to the different questions, together with an xls file with the different calculations. In the xls file, each question is presented as an independent worksheet so that you can find them easily

Question 1

a) Time value of money represents the actual value we give to money. It appears as a necessary

concept to understand why even while a $100 bill has the same monetary value both now and in

the future. This can easily be understood by considering that if we have the money available right

now, we would be able of investing it, such that in the future we would have both the available

money (the $100 bill) and the interests that have matured from it. This concept is further analysed

through the examples in section b.

b)

1. Since no further information is provided, we will assume a simple interest investment to evaluate

the future value. According to this, the relationship between the current and future value of money

would be given by the formula:

𝑑𝑎𝑦𝑠

𝐹𝑢𝑡𝑢𝑟𝑒 𝑣𝑎𝑙𝑢𝑒 = 𝐶𝑢𝑟𝑟𝑒𝑛𝑡 𝑣𝑎𝑙𝑢𝑒 (1 + 𝑎𝑛𝑛𝑢𝑎𝑙 𝑖𝑛𝑡𝑒𝑟𝑒𝑠𝑡 𝑟𝑎𝑡𝑒 ∗

)

365

Taking this into account, we find:

Current value = $120

Interest rate = 7.5% annually

Time = 120 days

𝐹𝑢𝑡𝑢𝑟𝑒 𝑣𝑎𝑙𝑢𝑒 = 120 (1 + 0.075 ∗

120

) = $122.96

365

2. Since we are told that there are no interest payments in the 7 year period, we should assume a

simple interest regime. Taking this into account, we would calculate the annual interest rate by

applying the formula

𝐹𝑢𝑡𝑢𝑟𝑒 𝑣𝑎𝑙𝑢𝑒

1

𝑟=(

− 1) ∗

𝐶𝑢𝑟𝑟𝑒𝑛𝑡 𝑣𝑎𝑙𝑢𝑒

𝑛𝑢𝑚𝑏𝑒𝑟 𝑜𝑓 𝑦𝑒𝑎𝑟𝑠

Taking this into account, we find:

1360.86

1

𝑟=(

− 1) ∗ = 5.16%

1000

7

3. Considering an annual interest rate of 12%, we can easily calculate the corresponding quarterly and

monthly interest rates by taking into account that one year has 3 quarters and 12 months. Thus,

the corresponding quarterly and monthly interest rates would be:

𝑞𝑢𝑎𝑟𝑡𝑒𝑟𝑙𝑦 𝑖𝑛𝑡𝑒𝑟𝑒𝑠𝑡 𝑟𝑎𝑡𝑒 =

𝑚𝑜𝑛𝑡ℎ𝑙𝑦 𝑖𝑛𝑡𝑒𝑟𝑒𝑠𝑡 𝑟𝑎𝑡𝑒 =

𝑎𝑛𝑛𝑢𝑎𝑙 𝑖𝑛𝑡𝑒𝑟𝑒𝑠𝑡 𝑟𝑎𝑡𝑒 12

=

= 3%

4

4

𝑎𝑛𝑛𝑢𝑎𝑙 𝑖𝑛𝑡𝑒𝑟𝑒𝑠𝑡 𝑟𝑎𝑡𝑒 12

=

= 1%

12

12

If we calculate the effective annual rates assuming it was compounded quarterly or monthly, we

would find:

𝐴𝑛𝑛𝑢𝑎𝑙 𝑟𝑎𝑡𝑒 (𝑐𝑜𝑚𝑝𝑜𝑢𝑛𝑑𝑒𝑑 𝑞𝑢𝑎𝑟𝑡𝑒𝑟𝑙𝑦) = (1 + 0.03)4 = 12.55%

𝐴𝑛𝑛𝑢𝑎𝑙 𝑟𝑎𝑡𝑒 (𝑐𝑜𝑚𝑝𝑜𝑢𝑛𝑑𝑒𝑑 𝑚𝑜𝑛𝑡ℎ𝑙𝑦) = (1 + 0.01)12 = 12.68%

Question 2

a) Some statistical concepts that are commonly used in finance include:

The mode, which represents the financial value that is repeated most frequently

The arithmetic mean, which is calculated by adding up all the financial va...

*flag*Report DMCA

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