Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed 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 Wellalage

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Mathematics For Business Economics, Life Sciences, And Social Sciences

Authors: Raymond Barnett, Michael Ziegler, Karl Byleen, Christopher Stocker

14th Edition

0134674146, 978-0134674148

More Books

Students also viewed these Finance questions

Question

Armed conflicts.

Answered: 1 week ago

Question

Pollution

Answered: 1 week ago