To help you reach your $20,000 goal, your relative offers to give you $5,000 today. You will need get a Part-Time job and make 20 additional deposits of equal amounts each 6 months thereafter, i.e. semi-annual deposits. If all of the money is deposited in a bank that pays a stated 7% annual rate, compounded semi-annually, how large must each of your 20 deposits be so that your account balance will be $30,000 in ten-years?

Account Balance in 10-Years	$30,000
Invest Period - Years	10
Investment Interest Rate	7%
Compounding Periods per year	2
Lump sum at Time 0	$5,000

What is the $ Value for each of the required 20 deposits?

Please use excel. (show work)