> 10 A\pMichael Garrison Ba==$L,8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* ""_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* ""_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* ""??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* ""??_);_(@_) 0.0%0.000000.0000
0.000=8_("$"* #,##0.0_);_("$"* \(#,##0.0\);_("$"* ""??_);_(@_)94_("$"* #,##0_);_("$"* \(#,##0\);_("$"* ""??_);_(@_) + ) , * ,!
A
A # ! ,! # A# A + 83ffff̙3f3fff3f3f33333f33333\`
Future Value
Present ValueFV of an Annuity%FVA Due+PV of an Annuity0PVA Due6Unequal Cash FlowsV14Time Value on Excel (Using the Function (fx) Wizard)Enote: click on the cell next to the question mark to see the formula.Future Value:
I If I deposit $100 in an account earning 10% per year, how much will my$ deposit be worth after 5 years? PVInFV?F What if we had the same problem but interest is compounded monthly?^***Note: Change the values of any variable other than that being solved for to view changes***Present Value: L How much would I need to deposit today in an account earning 10% per year0 in order to accumulate $10,000 after 5 years?FVPV?. What if my interest was compounded monthly?Future Value of an Annuity:K How much would I have in my retirement account if I deposited $2000 eachH year for 35 years and I earned 10% on my savings? What about $4,000?PMTFVA?_ Instead, what if I made monthly deposits of $166.67? How about monthly deposits of $333.33?Future Value of an Annuity Due:_ How much would I have in my retirement account if I deposited $2000 at the beginning of eachFVAD?n Instead, what if I made beginning of the month deposits of $166.67? How about monthly deposits of $333.33?Present Value of an Annuity:Y How much could I afford to borrow for a home if I can make monthly payments of $12,000F per year for 30 years at 8%? What about monthly payment of $1,000?PVA?U What if I wanted to know what my montlhy payments would be a $20,000 car loan over five years at 8%?PVAD?Unequal Cash Flows:a) Present Value[ How much must I deposit today to receive $100 in year 1,$ 200 in year 2, $300 in year 3,: and $400 in year four if I can earn 10% on my deposits?PVIF atYear PV of CFn#Present Value of Unequal Cash Flowsb) Future Valuea What will my bank account be worth if I deposit $100 in year 1, $200 in year 2, $300 in year 37 and $400 in year 4 if I can earn 10% on my deposits?FVIF at FV of CFn"Future Value of Unequal Cash FlowsX How much could I afford to borrow for a home if I can make annual payments of $12,0002 O
"wGi
g[xWd NbG=pFFWН0*4FW% FWhFT1@bip0F
b
bFdbC@C@C`T0bt00b
FhECbzm00b E000bbb߿0b`bt0b8bPercent0]bZ@.M*~LL
"nPe0P{T00{T0P Ze0Z բ0 Z !dbhFb{AANdbbI_dbhF4i@b0D`T0db`T0`T0XbÆ0hF`T0dbtb`T0nbbŕ0`T0\bb%0bXbޡc0\bXb b"0k0hpΡSTb,b S1
A/
dMbP?_*+%Maabahp42135bbbbZ@g ,, wB wBB @MSUDOHP LaserJet 4<d
"d,,??U}}U}
}
}qT0bb b
b%F
~
Y
~
$@
~
@
/
ʡ!d@DD DB9
~
Y
#?
?
N@
/Qd@
DDDB9
"A5/A>@
A>J
dMbP?_*+%"??U}T0bb b
b%F
~
~
$@
~
@
/
6G6A@DD DB8
~
#?
?
N@
/1N⽷@
DDDB8
"A5/A>@
AY $
dMbP?_*+%"??U}}T0bb b
b%F
~
@
~
@
~
$@
~
$@
~
A@
~
A@
/
^Ry ADD DB9
/
^Ry0A
DD DB9
~
F
~
F
#?
?
$k??
@z@#
@z@#
/v
TO#A
DDDB9
/`C2ADDDB9
";8888k^>@
A%F+
dMbP?_*+%"??U}UT0bb b
b
%F@b
~
@
~
@
~
$@
~
$@
~
A@
~
A@
/
^Ry ADD DB9
/
^Ry0A
DD DB9
&8;2"AD
D
&8;22AD
D
~
F
~
F
#?
?
$k??
@z@#
@z@#
/v
TO#A
DDDB9
/`C2ADDDB9
&x#ADD
&WA3ADD
&C@888p8k^p>@
AY,X0
dMbP?_*+%"??U}
}qT0bb b
b
%F
~
p@
~
@@
~
@
#O贁N{?
{Gz?
~
>@
v@
/
p3}
DD DB8
/
ցۢ
DD DB8
~
@
#O贁N{?
{Gz?
N@
/VX8rXyDDDB;
$,8QK5/A>@
Ai1(6
dMbP?_*+%"??U}
T0bb b
b
%F@b
0
~
p@
~
@@
~
@
#O贁N{?
{Gz?
~
>@
v@
/
p3}
DD DB8
/
ցۢ
DD DB8
!&_fD
D
!&?g@D
D
~
@
#O贁N{?
{Gz?
N@
/VX8rXyDDDB;
!&nyyDD
(T8QKp5/A8>@
A!A7'>>
dMbP?_*+%"??U}
!T0bb b
b
%F@bb0Cb
"
#
$
%
&
'
~
!$@
(?Y@*]tE?D
D!袋.V@DD@i@*Tx?r?D
D!7Ad@
DD
@r@*
[V
?
D
D
!
3A,l@D
D
@y@*}??D
D!>Iq@DD
)#b@
%
*
+
,

'
~
"$@
#.?Y@&?D
D![@DD@i@&](\?D
D!$@n@DD@r@&K?D
D!$x@DD@y@&y!l?D
D!$QM@DD
/#(\@
%6
8iiii5
8eeee T0
">@
Oh+'08@\xDaniel J. BorgiaeMichael GarrisoneMicrosoft Excel@&ϼ
՜.+,D՜.+,P PX
,Florida Gulf Coast UniversityUn1
Future ValuePresent ValueFV of an AnnuityFVA DuePV of an AnnuityPVA DueUnequal Cash FlowsWorksheets 6>
_PID_GUIDAN{94E233F77BF611D39C8B00E09800EBA2}
!"#$%&')*+,./Root Entry FWorkbook>SummaryInformation( DocumentSummaryInformation8(