Part 4: Number of Periods

In this part, calculate the number of periods. Use the Excel Nper function to compute the number of periods.

1. You expect to receive $20,000 at graduation. You plan on investing it at 6 percent until you have $130,000. How long will you wait from now? (7 Points)

2. Calculate the number of periods in the table below using the Excel Nper function. (7 Points)

Present Value	Interest Rate	Future Value	Years
$190	6%	$870	?
$2,175	12%	$3,590	?
$47,850	11%	$326,890	?
$38,571	16%	$213,674	?

Part 4:	(see https://support.office.com/en-us/article/NPER-function-8d353a63-394b-4e74-9541-bac395031dab?ui=en-US&rs=en-US&ad=US)
G)
Rate	Pmt	PV	FV		Nper
Present Value	Interest Rate	Future Value	Years
$190	6%	$870
$2,175	12%	$3,590
$47,850	11%	$326,890
$38,571	16%	$213,674