# FINANCE- A bank offers different interest rates on deposit accounts

FINA 415 -15B Homework -5

1.
A bank offers different interest rates on deposit accounts.
The rate is based on the size of the periodical deposit (CF) and the following
table. Write a future value functionBANKFV(CF,r,n)

For Periodical
Deposits

The interest rate
is

<=100 r <=500 r+0.5% <=1000 r+1.1% <=5000 r+1.7% >5000

r+2.1%

.png”>

2.
Write a payment schedule
calculator macro. The macro is to ask the user for the sum of the loan, the
number of payments, and the interest rate. Assume payment at the end of the
period.
Hints:
You may want to use the
worksheet function PMT
The following macro and
its output might be interest

Sub StringConcat()

Dim S As String

S = “Col1” &Chr(9) & “Col2” ‘ Chr (9) is the
Tab

S = S &Chr(13) & “aaa” &Chr(9) &
“bbb”
MsgBox S
End Sub

3.
Develop code for a function
that behaves in the same manner as Excel’s SUM function. The function should
sum all numerical values in an array.

4.
Develop code for a function
that behaves in the same manner as Excel’s NPV function that requires two
inputs, the first an array of cash flows and the second the discount rate.
E.g Function NetPV(cvec,rate)

5.