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:
a) Use the For…Next loop in your function, and call the function FVCFA.
b) Still using a For…Next 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.
You might also like to view...
The block code is the coding scheme most appropriate for a chart of accounts
Indicate whether the statement is true or false
The null hypothesis for a correlation states that:
A) the population correlation coefficient is equal to zero. B) the population correlation coefficient is +1. C) the population correlation coefficient is -1 D) the population correlation coefficient is ±1. E) the population correlation coefficient is positive.
An employee earned $37,000 during the year working for an employer when the maximum limit for Social Security was $128,400. The FICA tax rate for Social Security is 6.2% and the FICA tax rate for Medicare is 1.45%. The employee's annual FICA taxes amount is:
A. $2,830.50. B. $536.50. C. $8,950.50. D. $1,757.50. E. $2,294.00.
Increasingly, emerging economies are