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 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.


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 to calculate the amount of caffeine in coffee?

To calculate the amount of caffeine in coffee, you can multiply the number of milligrams of caffeine per ounce by the total number of ounces of coffee consumed.


What is the installment price minus the down payment equal to?

amount financed


Types of recurring deposit?

Recurring deposit can be classified into two types: 1. Fixed Recurring Deposit: In this the installment amount remains fixed for the entire tenor of RD from the time of booking. 2. Flexible Recurring Deposit: In the installment amount can be changed during any part of the tenor as and when the customer decides to increase or decrease his installment amount.