Client Information
Lindsey (single mom w/ 2 kids)	Age 36
Rob	Age 11
Ann	Age 4
*Both Rob and Ann will go to college at age 18
*Rob will go to a 4-year program; Ann will go to a 5-year program
Current saving for Rob	$ 45,000.00
Current saving for Ann	$ 8,000.00
Current tuition (& fees) per year	$ 30,000.00
Tuition (& fees) inflation	7.50%
General inflation	2.50%
Interest rate (for both Rob's and Ann's 529 plans)	13%

Create an education saving plan for Lindsey's two kids using METHOD 2 (NPV).

*Should calculate separately for the two kids

PLEASE SHOW WORK IN EXCEL ILL UPVOTE!