The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. Enter your answers as positive values.

Find the FV of $1,000 invested to earn 12% after 4 years. Round your answer to the nearest cent.

$ fill in the blank 2

b. What is the investment's FV at rates of 0%, 5%, and 20% after 0, 1, 2, 3, 4, and 5 years? Round your answers to the nearest cent.

Year	Interest Rate
	0%	5%	20%
0	$	$	$
1	$	$	$
2	$	$	$
3	$	$	$
4	$	$	$
5	$	$	$

c. Find the PV of $1,000 due in 4 years if the discount rate is 12%. Round your answer to the nearest cent.

$ ________

d. A security has a cost of $1,000 and will return $2,000 after 4 years. What rate of return does the security provide? Round your answer to two decimal places.

________ %

e. Suppose California's population is 34.0 million people, and its population is expected to grow by 3% annually. How long will it take for the population to double? Round your answer to the nearest whole number.

___________years

f. Find the PV of an ordinary annuity that pays $1,000 each of the next 4 years if the interest rate is 17%. Then find the FV of that same annuity. Round your answers to the nearest cent.

PV of ordinary annuity: $ __________ FV of ordinary annuity: $ _______

g. How will the PV and FV of the annuity in part f change if it is an annuity due rather than an ordinary annuity? Round your answers to the nearest cent.

PV of annuity due: $ ________ FV of annuity due: $ ________

h. What will the FV and the PV for parts a and c be if the interest rate is 12% with semiannual compounding rather than 12% with annual compounding? Round your answers to the nearest cent.

FV with semiannual compounding: $ _________ PV with semiannual compounding: $ _________

i. Find the annual payments for an ordinary annuity and an annuity due for 8 years with a PV of $1,000 and an interest rate of 10%. Round your answers to the nearest cent.

Annual payment for ordinary annuity:	$
Annual payment for annuity due:	$

j. Find the PV and the FV of an investment that makes the following end-of-year payments. The interest rate is 10%.

Year	Payment
1	$200
2	$300
3	$400

Round your answers to the nearest cent.

PV of investment: $ ____ FV of investment: $ ____

k. Five banks offer nominal rates of 8% on deposits, but A pays interest annually, B pays semiannually, C pays quarterly, D pays monthly, and E pays daily. Assume 365 days in a year.

What effective annual rate does each bank pay? If you deposit $4,000 in each bank today, how much will you have in each bank at the end of 1 year? 2 years? Round your answers to two decimal places.

	A		B		C		D		E
EAR		%		%		%		%		%
FV after 1 year	$		$		$		$		$
FV after 2 years	$		$		$		$		$

If the TVM is the only consideration, what nominal rate will cause all of the banks to provide the same effective annual rate as Bank A? Round your answers to two decimal places.

	B		C		D		E
Nominal rate		%		%		%		%

Suppose you don't have the $4,000 but need it at the end of 1 year. You plan to make a series of deposits annually for A, semiannually for B, quarterly for C, monthly for D, and daily for E with payments beginning today. How large must the payments be to each bank? Round your answers to the nearest cent.

	A		B		C		D		E
Payment	$		$		$		$		$

Even if the five banks provided the same effective annual rate, would a rational investor be indifferent between the banks?

It is more likely that an investor would prefer the bank that compounded

moreless

frequently.

l. Suppose you borrow $16,000. The interest rate is 10%, and it requires 4 equal end-of-year payments. Set up an amortization schedule that shows the annual payments, interest payments, principal repayments, and beginning and ending loan balances. Round your answers to the nearest cent. If your answer is zero, enter "0".

	Beginning			Repayment	Ending
Year	Balance	Payment	Interest	of Principal	Balance
1	$	$	$	$	$
2	$	$	$	$	$
3	$	$	$	$	$
4	$	$	$	$	$

39 c. Finding PV 40 Future value (FV) 41 Discount rate (I) 42 Number of years (N) 43 Present value (PV) 4 Formulas 44 45 d. Finding the rate of return provided by the security \begin{tabular}{l|l|r|} \hline 46 & Cost of security (PV) & $1,000 \\ 44 & Future value of security (FV) & $2,000 \\ 48 & Number of years (N) & 4 \\ 49 & Rate of return (I) & \end{tabular} e. Calculating the number of years required to double the population \begin{tabular}{l|l|r|} \hline 52 & Current population in millions (PV) & 34 \\ \hline 53 & Growth rate (I) & \\ \hline 54 & Doubled population in millions (FV) & \\ \hline 55 & Number of years required to double (N) & \\ \hline 56 & & $N/A/A \\ \hline 57 & f. Finding the PV and FV of an ordinary annuity \\ \hline 58 & Annuity (PMT) & 17% \\ \hline 59 & Interest rate (I) & 4 \\ \hline 60 & Number of years (N) & \\ \hline 61 & Present value of ordinary annuity (PV) & FN/A \\ \hline 62 & Future value of ordinary annuity (FV) & \end{tabular} g. Recalculating the PV and FV for part f if the annuity is an annuity due Present value of annuity due (PV) Future value of annuity due (FV) \#N/A h. Recalculating the PV and the FV for parts a and c if the interest rate is semiannually compounded Future value (FV) Present value (PV) \#N/A 39 c. Finding PV 40 Future value (FV) 41 Discount rate (I) 42 Number of years (N) 43 Present value (PV) 4 Formulas 44 45 d. Finding the rate of return provided by the security \begin{tabular}{l|l|r|} \hline 46 & Cost of security (PV) & $1,000 \\ 44 & Future value of security (FV) & $2,000 \\ 48 & Number of years (N) & 4 \\ 49 & Rate of return (I) & \end{tabular} e. Calculating the number of years required to double the population \begin{tabular}{l|l|r|} \hline 52 & Current population in millions (PV) & 34 \\ \hline 53 & Growth rate (I) & \\ \hline 54 & Doubled population in millions (FV) & \\ \hline 55 & Number of years required to double (N) & \\ \hline 56 & & $N/A/A \\ \hline 57 & f. Finding the PV and FV of an ordinary annuity \\ \hline 58 & Annuity (PMT) & 17% \\ \hline 59 & Interest rate (I) & 4 \\ \hline 60 & Number of years (N) & \\ \hline 61 & Present value of ordinary annuity (PV) & FN/A \\ \hline 62 & Future value of ordinary annuity (FV) & \end{tabular} g. Recalculating the PV and FV for part f if the annuity is an annuity due Present value of annuity due (PV) Future value of annuity due (FV) \#N/A h. Recalculating the PV and the FV for parts a and c if the interest rate is semiannually compounded Future value (FV) Present value (PV) \#N/A