222222

Which excel function returns the loan payment (principal plus interest) per period, assuming constant payment?

• Rate
• IPMT
• PMT
• PPMT

What is correct syntax of IPMT function?

• IPMT(rate, per, nper, pv, fv, type)
• IPMT(per,rate, nper, pv, fv, type)
• IPMT(nper,rate, per, pv, fv, type)
• IPMT(pv,rate, nper, per, fv, type)

Which of the following PMT function will return the monthly payment amount for a 5,000 loan with a 6 percent annual percentage rate. The loan has a term of four years

• PMT(.06, 48, -5000)
• PMT(.06, 4, -5000)
• PMT(.06/12, 48, 5000)
• PMT(.06/12, 48, -5000)

Which of the following excel function will help to calculate the CAGR?

• NPV
• IRR
• Rate
• PV

if a bank has deposit scheme to deposit 1000 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 bike of 50000 on 100% finance and duraation of loan is 6 years and rate of interest is 12% PA. What is his EMI?

• 1000
• 977
• 1200
• 950