college planing

years until college starts? 18

amount to withdraw wach yeat in colle? $47,000

years to withdraw in the college study/years? 4

interest rate? 8%

what is the amount needed when the college year starts?

what is the amount she mjsg save each year to dins the college expense?

the lump sum that must be deposited today to find the college expense?

please provide answer with the excel formulas showing the formulas