Question: thank u for your time Find the solutions using Excel. Financial functions: PMT FV NPER RATE PV First 1: 1) We place 20,000 Euros at
thank u for your time

Find the solutions using Excel. Financial functions: PMT FV NPER RATE PV First 1: 1) We place 20,000 Euros at an annual rate of 16.5% for 20 years. What is the acquired value after 20 years? 2) You buy a shop by paying 20 annuities of 120.000 Euros paid at the beginning of the year, the rst payment being made on the date of acquis tion. Knowing that the interest rate is 14% what is the purchase price? 3) We borrow a sum repayable in 30 inStallments of 20,000 Euros each paid at the end of the period. The interact rate being at 24% what is the loan amount? Second 2: one bank (A) offers certicates of deposits at annual rates of 12%. the other bank (B) offers a product that pays monthly coupons at an annual rate of 11.5%. Which product do you prefer. knowing that you want to invest your money over two years without withdrawing it? Third 3: After 14 years, the coSt for each Study year will be 80,000 USD. 1) How much will we have to invest today at an annual rate of 20% to get the 80,000 USD? 2) If you only have $ 30,000 to invest, what should the rate be to reach $ 80,000? Fourth 4: For how long muSt a sum be deposited in an account paying 28% com- pound interest in order to double in value
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
