Share
Explore BrainMass

Finance PV, FV, Nominal versus effective rate

a) Explain why the sign we use for present value or future value variables is important when we use Excel or a financial calculator to solve time value of money problems? Also explain how it work (i.e., tackle the "how" as well as "why).

b) True or False - Nominal versus effective rates. Let's make sure we all understand this concept by indicating whether the question below is true or false. Then support your reasoning.

An investment vehicle that compounds more frequently than once per year will always result in an effective rate that is higher than the nominal rate

Solution Preview

a) Explain why the sign we use for present value or future value variables is important when we use Excel or a financial calculator to solve time value of money problems? Also explain how it work (i.e., tackle the "how" as well as "why).

The negative sign signals an "outflow" and a positive sign indicates an "inflow." If you put all amounts in as positive, Excel will think that there is no investment and the amounts are all profits This will give you a very exaggerated (and wrong) computation! ...

Solution Summary

Your tutorial is 221 words discussing how Excel treats positive and negative amounts and why the comment is true. A sample computation is given.

$2.19