Consider a loan of $7000 with an APR of 9% and a loan term of 10 years. Complete parts (a) through (c) below. a. Use technology to construct a table showing the interest payment and loan balance after each month. Verify that, with monthly payments of $88.67, the loan balance reaches $0 after 120 months. (Do not round until the final answer. Then round to the nearest cent as needed.) Month Interest Principal Balance $7000.00 S6963 83 S52.50 S36.17 1 119 120

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

Find the monthly payment for the loan. (Round your answer to the nearest cent.) $700 loan for 12 months at 15%

PLEASE Use the correct function on EXCEL

Find the monthly payment and estimate the remaining balance. Assume interest is on the unpaid balance. 5-year computer loan for $2770 at 6.7%; remaining balance after 2 years. The monthly payment is (Round to the nearest cent as needed

Find the monthly payment and estimate the remaining balance. Assume interest is on the unpaid balance. 4-year computer loan for $3106 at 5.7%; remaining balance after 2 years. The monthly payment is $. (Round to the nearest cent as needed.) The remaining balance is $. (Round to the nearest dollar as needed.)

Suppose you secure a home improvement loan in the amount of $5,000 from a local bank. The loan officer gives you the following loan terms:• Contract amount = $5,000• Contract period = 24 months• Annual percentage rate = 12%• Monthly installment = $235 .37Shown is the cash flow diagram for this loan. Construct the loan payment schedule by showing the remaining balance, interest payment, and principal payment at the end of each period over the life of the loan.

The loan below was paid in full before its due date. (a) Obtain the value of h from the annual percentage rate table. Then (b) use the actuarial method to find the amount of unearned interest, and (c) find the payoff amount. Regular Monthly Payment $445.22 Remaining Number of Scheduled Payments after Payoff 6 APR 11.0% Click the icon to view the annual percentage rate table. (a) h=$ (b) The unearned interest is $ (c) The payoff amount is $ (Round to the nearest cent as needed.) (Round to the nearest cent as needed.)

Watch the video and then solve the problem given below. Click here to watch the video. You are considering a loan with an annual rate of 8%. The mortgage is $130,000 with 180 monthly payments of $1242.35 for 15 years. Complete the first two months of the amortization table. (Simplify your answers. Round to the nearest cent as needed.) Payment number Interest payment Principal payment Balance of loan 1

Suppose you have a student loan of $45,000 with an APR of 12% for 20 years. Complete parts (a) through (c) below. a. What are your required monthly payments? The required monthly payment is $ (Do not round until the final answer. Then round to the nearest cent as needed.)