Reference no: EM13852847
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 function BANKFV (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%
|
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. 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.
|
Characteristics of the socio-economic environment
: 1. What are the characteristics of the socio-economic environment in many western European countries that reduced the negative human impact of the most recent global economic meltdown (2008)?
|
|
Draw a time line of the cash flows
: Draw a time line of the cash flows. For this section of the project, students should follow and use the Cash Flow Estimation Excel Template File provided under the "Example Files for Term Project" folder.
|
|
Identify contemporary management challenges
: Identify contemporary management challenges facing health care organizations. Assess the implications of various health care management challenges and methods of managing them
|
|
Prepare report identifying causes of failure to a erp system
: You have been asked to prepare a report identifying the causes of failure and recommendations to adopt a new ERP system.
|
|
Write a payment schedule calculator macro
: Write a payment schedule calculator macro
|
|
Case study-when faced with growth
: Jayne's Sandwich Stop is one of the best-known and most loved sandwich concessions in town. In business for about five years, she sells sandwiches and other lunch items made from locally produced food from her mobile food trailer. Jayne's passion ..
|
|
What is the expected completion time of the project
: Describe a project you're familiar with. Analyze it carefully in light of the material covered in this module. Draw a path diagram for the project and calculate the expected length of each task. Fill in the following worksheet Was some version of P..
|
|
Discuss the meaning of each variable
: discuss the meaning of each variable. Chart and interpret its history, provide a rationale for its importance, andrationalize your ranking order.
|
|
What specific steps would you recommend to brian
: What specific steps would you recommend to Brian for him to better assess this opportunity? What specific opportunity is available to Brian and how would you describe it to a potential investor
|