please post solutions with explanations .. i've posted this 3 times and i don't get the solutions given because they're being posted without explanations and formulars. Please help urgently

1 Problem 2 3 Jane is a newborn. Her parents are planning to contribute $4,000 a year (or possibly less) towards her college fund into an account that will grow at a constant rate of 4.5% a year. Both parents work for the same company that offered to match 5 parental contributions dollar for dollar for the first 5 parental deposits and 30 cents for every parental dollar for subsequent 6 parental deposits, until Jane reaches 19. Once she reaches 19, both the company and parents stop their contributions. College 7 costs are expected to be $40,000 a year and Jane spends 4 years in college once she reaches 19. Assume that the beginning balance on the account is $25,000 (a) What is the smallest amount parents should contribute each year to make Jane's o college affordable? Complete table below and solve the problem (15 points). 11 Inputs 12 Beginning Balance (at age 0) 13 Annual parental contribution 14 Interest rate 15 Annual college cost (b) What the amount the total amount both parents and company contributes to college fund in year 1 when this problem is solved? (3 pts) $25,000.00 $4,000.00 4.50% $40,000.00 Jane's age Deposit or Account withdrawal at balance the beginning beg. year of year $25,000.00 $4,000.00 $30,305.00 $4,000.00 $4,000.00 $4,000.00 $4,000.00 $4,000.00 Interest earned during year $1,305.00 Total in account end of year $30,305.00 The table to the right must show solved problem ROWN (c)Formula in cell D35? (3 pts) (d) Amount in cell F41 when this problem is solved? (3 pts) 4 2 Problem 2 (continue) 4 (e) Create a graph that shows how the total amount in the account at the 5 end of the year changes with Jane's age (6 pts) 7 On the graph label X-axis "Jane's age", Y-axis "Amount in US dollars" and use graph 8 title "Jane's college fund". Place the graph in this sheet