Question: please do this in excel and be very clear where you got your numbers from 11 You invest $5,000 in a bank which compoundsinterest monthly
11 You invest $5,000 in a bank which compoundsinterest monthly You leave the money in the bank for 7 years. It grows to $8,000 Create a formula to calculate the nominal rate of interest. Show your work: PV N=7 Yrs x12 FV R 50001 84 80001 + (FV/PV) (FV/PV)^(1/N) R=1.0694488-1 1.6 1.00561096 ?? FV/PV=(1+r)^N (FV/PV)^(1/N)=(1+R) 0.56% 8000 OIR& =(E144/E142)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
