VBA Excel Project 2

Notes: Please use the template to show your functions do work.
1. Write a VBA function for f (x) = x2 −3.
2. Write a VBA function for f (x) = √2x2 + 2x.
3. Suppose a share was priced at price P0 at time 0, and suppose that at time 1 it will
be priced at P1. Then the continuously compounding return is defined as ln(P1/P0).
You can use Application.Ln or the VBA function Log.
4. A bank offers different yearly interest rates to its customers based on the size of the
deposit in the following way:
For deposits up to 1,000 the interest rate is 5.5 percent.
For deposits from 1,000 and up to 10,000 the interest rate is 6.3 percent.
For deposits from 10,000 and up to 100,000 the interest rate is 7.3 percent.
For all other deposits the interest rate is 7.8 percent.
Implement the function Interest(deposit) in VBA.
5. Using the function in problem 4, implement a function NewDFV(Deposit, Years).
The function will return the future value of the deposit with the bank assuming the
interest is compounded each year. Thus, NewDFV(10000,10) should return 10000 ×
(1.063)10 = 18, 421.82.
6. An investment company offers a bond linked to the FT100 index. On redemption the
bond pays the face value plus the largest of (a) the face value times the change in the
index or (b) 5 percent yearly interest compounded monthly. For example, 100 invested
when the index was 110 and redeemed a year later when the index was 125 will pay
(a) 100+100×(125−110)/110 = 113.636 and not (b) 100×(1+0.05/12)12 = 105.116.
Implement a VBA function Bond(Deposit, Year, FT0, FT1).
7. Fibonacci numbers are defined as follows:
F (0) = 0
F (1) = 1
F (2) = F (0) + F (1) = 1
F (3) = F (1) + F (2) = 2
···
In general, F (n) = F (n −2) + F (n −1). Write a VBA function Fibonacci1(n) that
using recursion to compute the nth number in the series.