VBA Excel Project 2
$10-30 USD
Pagado a la entrega
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 [login to view URL] 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.
Nº del proyecto: #33588608
Sobre el proyecto
9 freelancers están ofertando un promedio de $26 por este trabajo
Greetings! I have reviewed all the 10 problems in the Workbook. I can implement VBA for all the functions as per description. Can you please share the questions for Problems 8, 9 and 10? Being a full time freelancer Más
Hey Hi Myself Yesu I am a VBA developer I can do this you can contact me on this for further discussion thanks
Hello, I read your job details and I can figure out the requirements. please contact me to share more information and start to work on it.
Hi there, I'm "Salehin Mohammad F; I am an expert in professionalization in the Excel program and dissertations with skills including ✓Excel ✓VBA Excel✓ CSV✓ Macro ✓ Excel Sheet Guru with report Writing. Feel free to c Más
Hi, i'm ready your job, and i have ùany experienced in project similar like yours. So, why wasting time, i'm waiting you on chat. thanks
I completed the task and it works. The problems 8, 9 and 10 in template was not described but if you describe them I can complete in a day
