Workbook Index: Click on the following links or on each of the tabs
below to access the 5 calculation pages. Complete all sections on
each page using the instructions in the A1 cell.
Wk 3 - Set 1, Part 1
Wk 3 - Set 2, Part 1
Wk 3 - Set 2, Part 2
Wk 3 - Set 2, Part 3
, Wk 2 Financial Exercises - Part 1
HCS/385 v4
Page 2 of 8
Tab 1 of 5: Complete the following 7 Wk 3 Financial Exercises:
Table 1: Set 1, Part 1 Questions in A5 through B13 using either the
financial functions in Excel or the present value (PV) formula shown
in A2 and future value (FV) formula shown in A3.
Present value formula: PV = FV * 1 / (1+i)^n
Future value formula: FV = PV * (1+i)^n
Table 1: Set 1, Part 1 Questions
Question Answer
1. If you want to have $60,000 in 8 years, how much do you need to
$ 30,111.98
deposit in the bank today if the account pays an interest rate of 9%?
2. What will $110,000 grow to be in 9 years if it is invested today at 11%? $ 281,384.06
3. You would like to have $200,000 in a college fund in 15 years. How
much do you need today if you expect to earn 12% while you are investing $ 36,539.25
to pay for your child’s college?
4. You have been offered $3,000 in 4 years for providing $2,000 today into
The future value would be 2,928.2 when the money is invested 1t 10%,
a business venture with a friend. If interest rates are 10%, is this a good
but then 3000 is greater. Therefore this is agreat investment.
investment for you?
5. What will $82,000 grow to be in 11 years if it is invested today at 8%
$ 193.63
and the interest rate is compounded monthly?
6. How many years will it take for $136,000 to grow to $468,000 if it is
16 years
invested in an account with an annual interest rate of 8%?
7. At what interest rate must $112,000 be invested so that it will be worth
9.56%
$392,000 in 14 years?
Copyright© 2020 by University of Phoenix. All rights reserved.
below to access the 5 calculation pages. Complete all sections on
each page using the instructions in the A1 cell.
Wk 3 - Set 1, Part 1
Wk 3 - Set 2, Part 1
Wk 3 - Set 2, Part 2
Wk 3 - Set 2, Part 3
, Wk 2 Financial Exercises - Part 1
HCS/385 v4
Page 2 of 8
Tab 1 of 5: Complete the following 7 Wk 3 Financial Exercises:
Table 1: Set 1, Part 1 Questions in A5 through B13 using either the
financial functions in Excel or the present value (PV) formula shown
in A2 and future value (FV) formula shown in A3.
Present value formula: PV = FV * 1 / (1+i)^n
Future value formula: FV = PV * (1+i)^n
Table 1: Set 1, Part 1 Questions
Question Answer
1. If you want to have $60,000 in 8 years, how much do you need to
$ 30,111.98
deposit in the bank today if the account pays an interest rate of 9%?
2. What will $110,000 grow to be in 9 years if it is invested today at 11%? $ 281,384.06
3. You would like to have $200,000 in a college fund in 15 years. How
much do you need today if you expect to earn 12% while you are investing $ 36,539.25
to pay for your child’s college?
4. You have been offered $3,000 in 4 years for providing $2,000 today into
The future value would be 2,928.2 when the money is invested 1t 10%,
a business venture with a friend. If interest rates are 10%, is this a good
but then 3000 is greater. Therefore this is agreat investment.
investment for you?
5. What will $82,000 grow to be in 11 years if it is invested today at 8%
$ 193.63
and the interest rate is compounded monthly?
6. How many years will it take for $136,000 to grow to $468,000 if it is
16 years
invested in an account with an annual interest rate of 8%?
7. At what interest rate must $112,000 be invested so that it will be worth
9.56%
$392,000 in 14 years?
Copyright© 2020 by University of Phoenix. All rights reserved.
