Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello I need help,with my assignment the details are in the files.please help me.Thank U FINA 415 -15B Homework -5 1. A bank offers different
Hello I need help,with my assignment the details are in the files.please help me.Thank U
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 5000 The interest rate is r r+0.5% r+1.1% r+1.7% r+2.1% 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 FINA 415-15B Homework 5- Nirosha Wellalage 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. The spreadsheet shows cash flow over five years for an investment proposal. After an outflow at the start, the cumulated cash flows turn positive during the third year , the time at which this happens being known as the project's payback period (here 2.4 years). The intermediate calculations determining the payback period are set out in the worksheet. They centre on cumulating cash flows at yearly intervals and testing to determine the time at which the cumulative sum first turns positive. Develop a Payback Function, say PayBack (cvec) that returns the payback period for any array of cash flows. FINA 415-15B Homework 5- Nirosha WellalageStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started