please show formulas!

M 2 a Alexis wants to start saving for his 3 year old brother, Peyton, to attend hisslma mater, UA. Ales antepates that Peyton will start college once he turn 18 and take 4 years to finish. Assume that UA's tuition currently costs $15,000 per year and the Board of Trustees has approved a cost increase of 4% per year. Alexis is unable to start making deposits until next year (Year 1) into an account that earns 8.5% Interest. He will keep making annual deposits unth Peyton graduates from college 8 10 11 Deposit Amount 12 Interest Rate 13 College Cost This Year 14 Cest Growth Rate 15 16 $4,000.00 8.5% $15,000 4.0% Year Peyton's Age Deposits Balance without Balance with Tuition Costs 17 Scholarship Scholarship 18 50.00 $15,000.00 $0.00 $0.00 19 1 4 $4,000.00 $15.600.00 $4,000 00 $100.00 20 2 5 $4,000.00 $16 224.00 $8,340 00 $5.50 21 3 6 $4,000.00 $16.872.96 $13,048.90 22 4 7 $4,000.00 $17,547.88 SIB 158.06 23 5 8 $4,000.00 $18.249.79 $23,701.49 24 6 9 $4,000.00 S18.979.79 $29,716.12 25 7 10 $4,000.00 $19.738.98 S36,241.99 26 8 11 $4,000.00 $20,528,54 $43.322.56 27 9 12 $4,000.00 $21.349.68 $51,004.97 28 10 13 $4,000.00 $22.203.66 $59,340.40 29 11 14 $4,000.00 $23,091 R1 $68,184 13 30 12 15 $4,000.00 $24.01548 $78.197.00 31 13 16 $4,000.00 $24.976.10 SR8,843.74 32 14 17 $4,000.00 $25.975.15 $100,195.46 33 15 18 $4,000.00 $27.014.15 $85,914.92 34 16 19 $4,000.00 $28.094.72 $67,999.19 35 17 20 $4,000.00 $29.218.51 $48,560 61 36 18 21 $4,000.00 $30,387.25 $26,30101 37 38 R. Peyton ended up being a pee-wee football standout so LA might be the perfect fit for him after all. He seered a scholarship that will 39 pay 75% of his cost of tuition at college. Recalculate the balance to account for this scholarship. Use the balance with Scholarship 40 column for this 42 Scratchsheet Tracker