Please use the excel sheets I provided. Thanks

Isabela have a daughter who is 13 years old this year, and their daughter, Emma, will be starting college 5 years from now. According to Isabela's estimation, Emma will need $12,000 in her first college year and the yearly tuition increases $2,000 per year during each of the remaining three years of her education. The following investments are available to the Alex and Isabela:

Investment	Available	Matures	Return
A	Every year	1 year	6%
B	1, 3, 5, 7	2 year	14%
C	1, 4	3 year	18%
D	1	7 year	65%

Alex and Isabela want to find an investment plan that will provide the necessary funds to cover Lisa's anticipated college expenses with the smallest initial investment.

1. Draw a diagram depicting this problem as a network flow problem.
2. Solve using Excel Solver.

\f