 # Financial math with excel, assignment help Anonymous
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

strongboss5
School: Carnegie Mellon University   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  Review Anonymous
Tutor went the extra mile to help me with this essay. Citations were a bit shaky but I appreciated how well he handled APA styles and how ok he was to change them even though I didnt specify. Got a B+ which is believable and acceptable. 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