cant use calculater , or excel formulas. what does IN mean and what are the formulas for the blanks

Solve for r: Start with: FV = PV x (1 + r)" FV/PV = (1+r)" (FV/PV) 1 = 1 +r r = (FV / PV)(1/N) 1 Solve for n: Start with: FV = PV x (1 + r) FV/PV = (1+r)" In(FV/PV) = In(1+r) In(FV/PV) =n x In(1+r) n = In(FV / PV) / In (1 + r) n = years r = interest rate / discount rate PV = present value FV = future value Simple NPER RATE New (1) - Excel Tell me what you want to do Formulas Duta Insert Page Layout Review View Home Developer Help Power Pivot Te Cut Copy Weg > - - Simple Periods and Rate Calculations Solve for the values required in the green cells See other instron below On 1/20/2000 on the date of President Obama's first inauguration, the S&P 500 stok index closed at 805 22. Eight years later on 120/2017. on the date of President Trump's inauguration, the SAP 500 index closed at 2271.31. At what an od the S&P 500 grow during the Obama years? The current US population is about 330.000.000 is growing ata rate of 6% per year. How many years will take for the US population to reach 400,000,000? 2000.000 400000000005 You deposited 55.000 and grew to $7,250. HOW eans og stein rechtle you m 500000 725000 You deposited and grew to $25,500 in 20 years. What rate of returns you have been caming out that ? 2006.000.000000 Use the fort romme lest nor Excel functions DO NO round any unies instructed student name main