EFM Quiz 2

Which excel function can be applied to check the forecated value for multiple years?

• Rate
• IPMT
• PMT
• Trend

Which of the following excel function will help to calculate the maturity value of a FD amount?

• NPV
• IRR
• Rate
• FV

if a bank has deposit scheme to deposit 2000 for 120 months and on maturity your money will be double. What is the annual rate of interest?

• 0.1011
• 0.111
• 0.1272
• 0.145

if rate of interest on deposit is 10% PA compunding quarterly and if you deposit 10000 in the bank. In approx how many years your money will be double?

• 6
• 7
• 5
• 8

If a maturity amount of a fixed depoist is 20000, duration is 5 year and rate is 12%. What is deposit amount?

• 10000
• 11348
• 12438
• 12000

If a deposit amount of a fixed depoist is 20000, duration is 5 year and rate is 12%. What is maturity amount?

• 35246
• 32456
• 36755
• 34565

If a company profit is 5000 in a year and increased by 1000 every year for next five years. Company CAGR is?

• 0.17
• 0.15
• 0.18
• 0.19

If a parson purchase a scootor of 50,000 on 100% finance and duration of loan is 6 years and rate of interest is 12% PA. What is his EMI?

• 1000
• 977
• 1200
• 950

In case study of home furnishing, what is current year gross sales

• 72676000
• 70531000
• 2145000
• 77626000

In case study of home furnishing, current year cost of sales incrased by percentage?

• 0.0304
• 0.0293
• 0.0626
• -0.0293