what is the formulas for the blank green areas

at Page Layout formules Data Review View Developer Help Power Pool Simple PV P ace Now (U- Excel tel me what you want to do O . Parter Artinya S A Font 5. X Simple PV and FV Calculations Solve for the values required in the green cells See other sucson You receive an inhance of $100.000 Yout Save it for your child's college education Your should begin college in 11 years you can earn 3.4% on your how much will you have when your child enters college Tution room & board at Brockport has recently been about $25.000 You have to send your 10 year old had to Brockport when he turns 18. The cost of college to and board has been growing at an annual rate of 45 and that trends espected to continue How much will you have to pay for your child's education over the years Brockport? 11 1 00 000.00 1465279 Growth concurrent Cost 25.000 Current age 10 How much would you have to deposit today to have a balance of $500.000 at retirement years trem today assuming you could eam 36 APR during the m eshman year sophomore year 30 000 00123 Serior year Total cost for years You win a lottery and can ether receive $50.000 3 years from today option 1). 60.000 7 years from today (option 2) you could earn 40% on savings for the next 7 years, what is the correct choke to make? How much do you gain by making the correct 50,000.00 GO000.00 44 440 82 45.0507 Option 2 Use the Excel functions to in the rest Al calculations should resun POSITIVE bers Do not found any actions Reenene me vas in the gray be your formulas studentane main Start a search O te me