Question: Which of the following calculates the monthly payment (expressed as a positive number) for a loan of $10,000 for 2 years with a 3.5% annual

Which of the following calculates the monthly payment (expressed as a positive number) for a loan of $10,000 for 2 years with a 3.5% annual interest rate?
a. –Financial.Pmt(0.035, 2, 10000)
b. –Financial.Pmt(0.035 / 12, 2 * 12, 10000)
c. –Financial.Pmt(2 * 12, 0.035 / 12, 10000)
d. –Financial.Pmt(10000, 0.035 / 12, 2 * 12)

Step by Step Solution

★★★★★

3.52 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

b Fina... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Microsoft Visual Basic Questions!

Which of the following calculates the average of the values in the OnHand field? a. SELECT AVERAGE(OnHand) AS Available FROM dbo.Inventory b. SELECT OnHand.AVG AS Available FROM dbo.Inventory c....

Which of the following calculates a 10% commission on the values in the Sales field and then stores the results in the Commission field? a. SELECT Year, Sales, Commission = Sales * 0.1 FROM...

In this exercise, you modify the Savings Account application from this chapters Apply lesson. Use Windows to make a copy of the Savings Solution folder. Rename the copy Modified Savings Solution....

let E18 v f A B D E F G H 1 J K L M Sales Tax Rate 6.754 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Transaction ID Amount Sales Tax Total 578 42.00 579 167.00 580 V209.00 an 581 142.00 Venue 582...

FAN SAHIT ITTHI w E .00.0 JUTH H17 xVfx A C D E F G H 1 K L L M N 1 Basic Loan 35,000.00 1.06% Financial Stress and Forbearance 2 Years into loan hit 6 month pause buttor Interest accrues - no...

please show work as well thank you (formulas) Aid (FSA). Complete each task by inserting the appropriate function, referencing the appropriate cells in the task data, in the specified cells. (3.1...

C12 fx A D E F H I J T 2 3 Financial Stress and Forbearance 2 Years into loan hit 6 month pause button Interest accrues - no payment made 4 5 6 7 Amount Needed Fee Percent Fee Loan Amount Annual...

Hello, Would like assistance completing attached document. If you need assistance using Excel, you can access a tutorial that is appropriate for your exper Access these tutorials at Atomic Learning...

A perpetuity with the first annual cash flow paid at the beginning of year 4 is equivalent to receiving $103,000 in 15 years? time. Assume that the perpetuity and the lump sum are of equivalent risk...

Please write it in C#. Thank you so much Instructions 1. Create a Loan class . The Loan class should have fields for o Loan Amount o Years o Annual Interest Rate . The constructor for the class...

An RL circuit is driven by an AC voltage source as shown in the figure. R L

BulgurCom has a wheat warehouse with a capacity of 19,000 bushels. At the beginning of month 1, company has 12,000 bushels of wheat. Each month, wheat can be bought and sold at the price per 1000...

Bills referred to standing committees by the party leadership have greater success in being reported favorably out of committee.

4. Refranchise a significant portion of Wendys-operated restaurants.

Write the statements that determine the highest row and highest column subscripts in the strTypes array. The statements should assign the subscripts to the intHighRow and intHighCol variables,...

In this exercise, you code an application that displays a grade based on the number of points entered by the user. The grading scale is shown in Figure 9-43. Open the VB2015\Chap09\Chang...

In this exercise, you modify one of the Waterson Company applications from this lesson. Use Windows to make a copy of the Stock Solution-Highest folder. Rename the copy Stock Solution-Highest-DoLoop....

Home Excel Online Activity: ROE and ROIC Excel Ortine Structured Activity: ROC and RosC Baker thdustries' net income is $23000, its interest expense is $4000, and its tax rate is 45%. Its notes...

Based on Exhibit 7-8, what would be the monthly mortgage payments for each of the following situations? (Round mortgage payment factors and final answers to 2 decimal places. Omit the "$" sign in...

Suppose an initial deposit of D dollars into a savings account yielding p% per year. We would like to know how much capital a person needs to initially deposit when he/she retires to live for N...