consumer loan of 1000 is being repaid with 24 monthly installments of 50 at the end of each month. Rather than making payments as originally scheduled, the borrower repaid the outstanding principal immediately after the 10th regular installment. Determine the unearned finance charge recovered by the borrower. A. 200.00 B.116.65 C. 83.35 D. 73.40 E. 67.85

2. Find the amount (in $) of interest on the loan. Principal Rate (%) Time Interest $60,000 7 5 1 2  years $

Calculate the principal and interest portions of the specified payment for this ordinary annuty, and give the balance remaining after that payment For full marks your answer should be rounded to the nearest cont Payment Principal Interest Balance Payment Frequency Term Number to Find Interest Payment Loan Principal Paid Paid After Payment 4. 0.00 0.00 0.00 $45,000.00 3.50 % compounded quarterly $3,250.97 Semi-annual 8 years

Use exact interest method to find rate of interest on a loan of $9000 for 354 days if amount of interest is $$489.50 6.1%5.6%4.9%5.4%

Suppose you borrow $14,000. The interest rate is 11%, and it requires 4 equal end-of-year payments. Set up an amortization schedule that shows the annual payments, interest payments, principal repayments, and beginning and ending loan balances. Round your answers to the nearest cent. If your answer is zero, enter "0".     Beginning     Repayment Ending Year Balance Payment Interest of Principal Balance 1 $  fill in the blank 60 $  fill in the blank 61 $  fill in the blank 62 $  fill in the blank 63 $  fill in the blank 64 2 $  fill in the blank 65 $  fill in the blank 66 $  fill in the blank 67 $  fill in the blank 68 $  fill in the blank 69 3 $  fill in the blank 70 $  fill in the blank 71 $  fill in the blank 72 $  fill in the blank 73 $  fill in the blank 74 4 $  fill in the blank 75 $  fill in the blank 76 $  fill in the blank 77 $  fill in the blank 78 $  fill in the blank 79

please provide excel formulas

6

The buyer of a piece of real estate is often given the option of buying down the loan. This option gives the buyer a choice of loan terms in which various combinations of interest rates and discount points are offered. The choice of how many points and what rate is optimal is often a matter of how long the buyer intends to keep the property. Darrell Frye is planning to buy an office building at a cost of $987,000. He must pay 10% down and has a choice of financing terms. He can select from a 9% 30-year loan and pay 4 discount points, a 9.25% 30-year loan and pay 3 discount points, or a 9.5% 30-year loan and pay 2 discount points. Darrell expects to hold the building for four years and then sell it. Except for the three rate and discount point combinations, all other costs of purchasing and selling are fixed and identical. (Round your answers to the nearest cent. Use this table, if necessary.) (a) What is the amount being financed? $4 (b) If Darrell chooses the 4-point 9% loan, what…

Note: Round all answers to the nearest cent when necessary. Calculate the amount financed, the finance charge, and the total deferred payment price (in $) for the following installment loan. Purchase(Cash)Price DownPayment AmountFinanced MonthlyPayment Number ofPayments FinanceCharge TotalDeferredPaymentPrice $2,500 0 $  $186.69 18 $   $

A loan carries a simple interest rate of 5.25 % . The loan was fully repaid by two $5000 payments made 8 and 11 months after the original date of the loan. How much was borrowed at the start? Multiple Choice $10,000 $9601.34 $9661.84 $9540.85 $9329.44