answersLogoWhite

0

You need to start with total amount owed, total monthly payments, and annual interest.

FORMULA:

Payment = (Loan amount x Interest) ÷ (Payments per Year x (1 - (1 + (Interest) ÷ Payments per Year)) raised to the power of negative Payments per Year x Length of Loan)))

Or, you could just use Excel and use the PMT function:

PMT(interest_rate,number_payments,PV,FV,Type)

interest_rate = interest rate for the loan

number_payments = number of payments for the loan

PV = present value or principal of the loan

FV (optional) = future value or the loan amount outstanding after all payments have been made. If this parameter is omitted, the PMT function assumes a FV value of 0.

Type (optional) = when the payments are due. Type can be one of the following values:

- 0 = payments due at end of period (default)

- 1 = payments due at beginning of period

User Avatar

Wiki User

15y ago

What else can I help you with?

Continue Learning about Math & Arithmetic

How do i calculate the percentage being paid?

To calculate the percentage being paid, divide the amount being paid by the total amount possible, then multiply the result by 100. The formula is: (Amount Paid / Total Amount) × 100 = Percentage Paid. For example, if you are paid $50 out of a total $200, the calculation would be (50 / 200) × 100 = 25%.


How do you figure the sales tax on a total number?

To calculate sales tax on a total amount, first determine the sales tax rate, which is usually expressed as a percentage. Multiply the total amount by the sales tax rate (in decimal form). For example, if the total amount is $100 and the sales tax rate is 7%, you would calculate $100 x 0.07 = $7. Finally, add the sales tax amount to the original total to get the final amount.


How do you find total amount if principle rater of interest months and interest is given?

To find the total amount, you can use the formula: Total Amount = Principal + Interest. First, calculate the interest using the formula: Interest = Principal × Rate × Time (in months/12). Then, add the interest to the principal to get the total amount.


What shows how installment loans are calculated?

amount financed= cash price- down payment


How do you use the total cost to find the amount of interest?

To find the amount of interest using the total cost, you first need to determine the principal amount and the total cost incurred. The total cost typically includes both the principal and the interest. You can calculate the interest by subtracting the principal from the total cost: Interest = Total Cost - Principal. This will give you the amount of interest charged over the specified period.

Related Questions

How do you calculate percent abundance for silicon?

You calculate the total amount of whatever it is that you want to find the silicon abundance for. Then you calculate the amount f silicon in that. Then percentage abundance of silicon = 100*amount of silicon/total amount Typically the amount would be measured as the mass.


How do you record installment of receivables in tally9?

To record installment of receivables in Tally.ERP 9, first create a sales invoice for the total amount due. Then, record each installment received by going to the "Receipt" option under the "Accounting Vouchers" menu. Select the customer’s account, enter the installment amount, and link it to the appropriate sales invoice. Ensure that you adjust the outstanding balance accordingly for accurate tracking of remaining receivables.


How can I calculate the total interest paid on my mortgage?

To calculate the total interest paid on your mortgage, you can use the formula: Total Interest Total Payments - Loan Amount. This means you subtract the initial loan amount from the total amount you will pay over the life of the loan. This will give you the total interest paid.


You want to buy laptop by installment in thane What are installment amount per month?

To buy a laptop in Thane in installment,the monthly installments will depend with the price of the laptop.


Which ststement about installment loans is not true?

One statement about installment loans that is not true is that they do not require regular payments. In reality, installment loans require borrowers to make fixed payments over a set period until the loan is fully repaid. Additionally, installment loans typically come with a predetermined interest rate, which means that the total repayment amount is known upfront.


How do you calucate percentage?

The simple way to calculate percentage is to divide the given amount by the total amount and then multiply the answer by 100 to get the percentage of the given amount in respect of the total amount


How do you calculate a pro rata investment?

To calculate a pro rata investment, divide the amount of money you are investing by the total amount being invested, then multiply that fraction by the total value of the investment. This will give you the proportional amount of the investment that you own.


How do you calculate PAR levels?

par = (total outstanding or portfolio - delequent amount)/ total portfolio or total outstanding


Is the amount added to the principal of a loan by the lender?

interest


How do i calculate the percentage being paid?

To calculate the percentage being paid, divide the amount being paid by the total amount possible, then multiply the result by 100. The formula is: (Amount Paid / Total Amount) × 100 = Percentage Paid. For example, if you are paid $50 out of a total $200, the calculation would be (50 / 200) × 100 = 25%.


How do you calculate capital in a balance sheet?

To calculate capital in a balance sheet, you subtract total liabilities from total assets. This gives you the amount of capital or equity that the company has.


How do you figure the sales tax on a total number?

To calculate sales tax on a total amount, first determine the sales tax rate, which is usually expressed as a percentage. Multiply the total amount by the sales tax rate (in decimal form). For example, if the total amount is $100 and the sales tax rate is 7%, you would calculate $100 x 0.07 = $7. Finally, add the sales tax amount to the original total to get the final amount.