need Excel formulas, like pv, fv, rate, nper im the open green areas

Buta Review View Developer Help Power Pivot Tell me what you want to do Bam Rat u Formu Arial v12 VAA BIU A Canal Format Merge Center Alignment Simple PV and FV Calculations Solve for the values required in the green cells See other instrucions below You receive an inheritance of $100 000 You want to Save it for your child's college education Your child should begin college in 11 years you can eam 3.4% on your savings, how much will you have when your child enters college? Tution room & board at Brockport has recently been about $25,000 annually. You hope to send your 10 year old child to Brockport when he lums 18. The cost of college lion room and board has been growing at an annual rate of 4.5% and that trend is expected to continue. How much will you have to pay for your child's education over the years at Brockport? Current age 10 40 25.000 Current Cost 11 100.000.00_ Growth rate 144.45279 freshman year How much would you have to deposit today to have a balance of $500 000 at retirement 40 years from today assuming you could eam 36% APR during that or year 40 500.00000121.500.00 Total cost for 4 years You win a lonery and can the receive $50.000 3 years from today (option 1), 560,000 7 years from today option 2) you could earn 40% on savings for the next years, what is the correct choice to ? How much do you gain by making the correct choice? Popon 1 10,000.00 Use the Excel functions a nd in the text Alc o ns should rest in POSITIVE numbers Do not round any calculations Feriehus the gray in your hommes emain Stata seards