Find the value of P for which the inflows will equal the outflows. Find the effective rate first.

Rate	12%	p y c d
Year	Outflows	Inflows
0	-P
1	-12P
2	-16P
3	-24P
4	0
5	-P	$24,000
6	-P	$30,000

Answers:	$530
	$661
	$769
	$990

Could you please work the problems in excel and show the steps you used to get the answers?

thanks for your help!