Mark A 10,000 loan is being repaid over 5 years with monthly end-of-the-month installments at a 15% annual effective rate of interest. Find the amount of principal repaid in the 20th payment.
A.131
B.145
C.175
D.191
E.211
Converting effective rate to nominal:-
=NOMINAL(15%,12)
=14.06%
the amount of principal repaid in the 20th payment is calculated using the PPMT function:
=PPMT(rate,per,nper,pv,fv,0)
=PPMT(14.06%/12,20,5*12,10000,,0)
=145
Mark A 10,000 loan is being repaid over 5 years with monthly end-of-the-month installments at a...
A loan is to be repaid in level installments payable at the end of each year for 7 years. The effective annual interest rate on loan is 4 %. After the 4^th payment the principal remaining is $ 5000. Find the amount of the loan.
The Purchase of a car requires a $25,000 loan to be repaid in monthly installments for four years at 12% interest compounded monthly and the general inflation is 6% compounded monthly. a) Find the actual & constant dollar value of the 20th payment. b) The total loan payback amount in constant & actual dollars.
Problem 3. A loan of $10,000 is being repaid with payments of $1,000 at the end of each year for 20 years. If each payment is immediately reinvested at 5% effective, find the effective annual rate of interest earned by the lender over the 20-year period.
11.9 The purchase of a car requires a $25,000 loan to be repaid in monthly installments for four years at 9% interest compounded monthly. If the general inflation rate is 4% compounded monthly, find the actual-and constant-dollar value of the 20th payment.
A loan of $ 8500 is to be repaid in 25 equal monthly installments with the first one paid seven months after the loan is made. The nominal annual interest rate is 8 % compounded bimonthly. Determine the amount of the monthly payment.
Consdera $35.000 loan to be repaid in equal installments at the end of each of the next years. The rest is a Set up an amortization schedule for the loan. Do not round intermediate calculations, Round your answers to the nearest cent. If netry is required, enter Repayment Interest Regayment of Principal Balance Total . How large must each annual payment be if the loan is for $70,0007 Assume that the interest rate remains round intermediate calculations. Round your answer...
Question 1: a) A loan is to be repaid by a student The student has debts of $10,000 to be paid at the end of the first year, $5,000 to be paid in 18 months and $3,000 to be paid in the 24th month The student would prefer to pay the debts as follows. $1,000 now, followed by payments at the end of the 6th, 20th and 30th month. The payment at the end of the 6th month is half...
An individual approaches the Loan Shark Agency for $1,000 to be repaid in 24 monthly installments. The agency advertises an interest rate of 1.5% per month. They proceed to calculate his monthly payment in the following manner. Amount requested: $1000 Credit investigation: $25 Credit risk insurance: $5 Total : $1,030 a) What is the nominal interest rate? b) What is the effective interest rate?
A homebuyer borrows 400,000 to be repaid over a 20 year period with level monthly payments beginning one month after the loan is made. The interest rate on the loan is a nominal annual rate of 12% convertible monthly. Find: a. the monthly payment b. the total principal paid on the loan over 20 years c. the total interest paid on the loan over 20 years d. the loan balance after 15 years e. the total principal paid on the...
A loan of $2000 is being repaid by equal monthly payments for an unspecified length of time. Interest on the loan is j2 = 15%. (Do not round intermediate calculations. Round your answers to 2 decimal places.) a) If the amount of principal in the 4th payment is $40, what amount of the 18th payment will be principal? b) Determine the regular monthly payment.