Question
What does the PMT function do in
Excel?Solution
The PMT function in Excel calculates the payment for a loan based on constant payments and a constant interest rate.
Farhan invested a certain amount of money 8 years ago. He put his money at the rate of 5% for the first 2 years, 7% per annum for the next 4 years and ...
Priyanka wants to invest Rs. 30,000 for 3 years, which of the following options would fetch her the highest amount as interest?
I) Company A unde...
If a sum of money becomes 4000 in 2 yrs and 5500 in 4 yrs 6 months at the same rate of simple interest per annum. Then the rate of simple interest is
Suppose a man invested an amount in the ratio of 3 : 2 at the rate of (r – 1)% & (2r – 16)% respectively at simple interest. If bigger amount invest...
The difference between total SI earned on Rs 'P' at 18% p.a. for 3 years and total CI earned on same sum at 20% p.a. for 2 years when compounded annuall...
A person sells an article at 10% below its cost price. Had he sold it for ₹332 more, he would have made a profit of 20%. What is the original selling ...
Farhan invested a certain amount of money 8 years ago. He put his money at the rate of 5% for the first 2 years, 7% per annum for the next 4 years and ...
Suppose a man invested Rs.(4000 + 2a) in Mutual Fund 'X' for 2 years and Rs. (3200 + 6a) in scheme 'Y' for 2 years and interest gets from Mutual Fund 'X...
₹4,300 becomes ₹4,644 in 2 years at simple interest. Find the principle amount that will become ₹10,104 in 5 years at the same rate of interest.
Praveen earned an interest of Rs. 10,400 by investing a certain sum with bank C under scheme III for two years. How much interest he would have earned h...
Relevant for Exams:
