Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a user-defined function to calculate the future value of an uneven stream of cash flows assuming an interest rate of 7%. Test your formula
- Create a user-defined function to calculate the future value of an uneven stream of cash flows assuming an interest rate of 7%. Test your formula using the following cash flows:
Time | 1 | 2 | 3 | 4 | 5 |
Cash Flow | $200 | $300 | $100 | $400 | $500 |
- Use the ForNext loop in your function, and call the function FVCFA.
Still using a ForNext loop, rewrite your function so that it makes use of Application.WorksheetFunction to calculate the future value with the built-in FV function. Call this function FVCFB.
Step 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