Only can use time value formulas! All answers in red are wrong.

Cu Hulp Power Pot Tell me what you want to do Copy - Format Painter SI Clipboard BO - 5 Simple PV and FV Calculations Solve for the values required in the green cells 300 e instructions 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. If you can earn 3.4% on your savings, how much will you have when your child enters college Tuinroom & board at Brockport has recerdy been about $20.000 annually You hope to send your 10 year old child to Brockport when he turns 18. The cost of college fufon, room and board has been growing at an annual rate of 4.5%, and that trend is expected to continue. How much w you have to pay for your childs education over the 4 years at Brockport? 3.45 1 1 100,000.00 144.45279 Growth rate 40% Current Cost 25. Current age 19 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 time? LLLL treshman year sophomore year Junior year Senior year 365 4 0500,000.00 121.500.951 Total cost for 4 years You win a lottery and can either receive $60.000 3 years from today (option 1 or $60.000 7 years from today option 2) you could eam 40% on savings for the nexd 7 years, what is the correct choice to make? How much do you gain by making the correct choice? PV option 1 Potion 2 3 0 .000.00 44,449 82 use me Excel functions auon me rear Al calculations should su POSITIVE numbers Do not found a n d Reference is the gray is your formules student Aces main igate Read t Startsearch