Home » mcq » Visual basic » What will be the output of the following Visual Basic expression? -Financial.Pmt (0.06/12, 5*12, 12000)
200
231.99
345
324.99
Answer is Wrong!
Answer is Right!
The correct answer is $\boxed{\text{B) }231.99}$.
The Financial.Pmt function calculates the periodic payment for a loan based on the following parameters:
- Principal: The 64 288 64S117.2 64 74.6 75.5c-23.5 6.3-42 24.9-48.3 48.6-11.4 42.9-11.4 132.3-11.4 132.3s0 89.4 11.4 132.3c6.3 23.7 24.8 41.5 48.3 47.8C117.2 448 288 448 288 448s170.8 0 213.4-11.5c23.5-6.3 42-24.2 48.3-47.8 11.4-42.9 11.4-132.3 11.4-132.3s0-89.4-11.4-132.3zm-317.5 213.5V175.2l142.7 81.2-142.7 81.2z"/>
Subscribe on YouTube
amount of money borrowed.
Interest rate: The annual interest rate, expressed as a decimal.
Number of payments: The total number of payments to be made.
Payment frequency: The frequency of payments, in months.
In this case, the parameters are:
- Principal: $12000$
- Interest rate: $0.06/12 = 0.005$
- Number of payments: $5*12 = 60$
- Payment frequency: $12$
The formula for the Financial.Pmt function is:
$$PMT = -\frac{P}{1-(1+r)^-n}r$$
where:
- $P$ is the principal
- $r$ is the interest rate
- $n$ is the number of payments
Substituting the values for the parameters into the formula, we get:
$$PMT = -\frac{12000}{1-(1+0.005)^-60}0.005 = 231.99$$
Therefore, the output of the following Visual Basic expression is $\boxed{\text{B) }231.99}$:
Financial.Pmt (0.06/12, 5*12, 12000)