Which of the following sections of code will calculate the monthly payment for a

Question

Which of the following sections of code will calculate the monthly payment for a $150,000 house with a 30 year mortgage at an annual rate of 5.5%, and assign the result to dblMPay?

a. Dim dblAIntRate as Double = 5.5
Dim dblLoanAmt as Double = 150000
Dim intYears as Integer = 30
Dim dblMPay as Double
dblMPay = Pmt(dblAIntRate / 12, intYears * 12, -dblLoanAmt)

b. Dim dblAIntRate as Double = 5.5
Dim dblLoanAmt as Double = 150000
Dim intYears as Integer = 30
Dim dblMPay as Double
dblMPay = Pmt(dblAIntRate, intYears, -dblLoanAmt)

c. Dim dblAIntRate as Double = 5.5
Dim dblLoanAmt as Double = 150000
Dim intYears as Integer = 30
Dim dblMPay as Double
dblMPay = Pmt(dblAIntRate / 12, intYears, -dblLoanAmt)

d. Dim dblAIntRate as Double = 5.5
Dim dblLoanAmt as Double = 150000
Dim intYears as Integer = 30
Dim dblMPay as Double
dblMPay = Pmt(dblAIntRate, intYears * 12, -dblLoanAmt)

Explanation / Answer

a. Dim dblAIntRate as Double = 5.5
Dim dblLoanAmt as Double = 150000
Dim intYears as Integer = 30
Dim dblMPay as Double
dblMPay = Pmt(dblAIntRate / 12, intYears * 12, -dblLoanAmt)

because pmt() is a financial function provided by microsoft .net

where 3 compulsory parameters are rate, no. of payment period,prasent valu

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.