Using the code for FVCFs, where CashFlows = B2:F2, Time = 7, and Rate = 7%, what is the value of FV when t=2?
Public Function FVCFs(CashFlows As Range, Time As Single, Rate As Single) As Single
Dim t As Integer, VarCount As Integer
Dim FV As Single
VarCount = CashFlows.Count
FV = 0
For t = 1 To VarCount
FV = FV + CashFlows(t) * (1 + Rate) ^ (Time - t)
Next t
FVCFs = FV
End Function
a) $150.07
b) $430.58
c) $823.82
d) $1,313.84
e) $1,886.29
b) $430.58
You might also like to view...
Putting together a request for proposal for a training program is a quick process.
Answer the following statement true (T) or false (F)
Group decision making should be used when strong commitment to the decision is needed and when there is a low probability of acceptance if only one person makes the decision.
Answer the following statement true (T) or false (F)
A cost that has both fixed and variable components is known as a ____________________ cost
Fill in the blank(s) with correct word
Linear programming is considered to be one of the most commonly used techniques for prescriptive analytics in business organizations
a. True b. False