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

thank u for your time Find the solutions using Excel. Financial functions:

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!