Math Concepts 6. Exam 3 Name: Assume that the following loan was paid in full before its due date. Regular Monthly Payments $785 APR 6.5% Remaining Number of Scheduled Payments after Payoff 36 (i) Obtain the value of h. (ii) Find the amount of unearned interest by the actuarial method.

Complete the next line of the schedule. 

PLEASE Use the correct function on EXCEL

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 $414.84 APR 4.0% Remaining Number of Scheduled Payments after Payoff 18 Click the icon to view the annual percentage rate table. ... (a) h= $3.20 (b) The unearned interest is $ (Round to the nearest cent as needed.)

1) Use the Loan worksheet to complete the loan amortization table.

In cell F2, insert the IPMT function to calculate the interest for the first payment. Copy the function to the range F3:F25. (The results will update after you complete the other functions and formulas.) 2) In cell G2, insert the PPMT function to calculate the principal paid for the first payment. Copy the function to the range G3:G25. 3) In cell H2, insert a formula to calculate the ending principal balance. Copy the formula to the range H3:H25. 4) Now you want to determine how much interest was paid during the first two years.

In cell B10, insert the CUMIPMT function to calculate the cumulative interest after the first two years. Make sure the result is positive. 5) In cell B11, insert the CUMPRINC function to calculate the cumulative principal paid at the end of the first two years. Make sure the result is positive. 6) You want to perform a what-if analysis to determine the rate if the monthly payment is…

A design studio received a loan of $6,850 at 6.20% compounded semi-annually to purchase a camera. If they settled the loan in 2 years by making quarterly payments, construct the amortization schedule for the loan and answer the following questions: a. What was the payment size? $0.00 Round to the nearest cent b. What was the size of the interest portion on the first payment? a $0.00 0 SUBMIT QUESTION SAVE PROGRESS SUBMIT AS

Following the calculation for years 1 and 2, what would be the payment adjustments and loan balances for years 3 to 5? Replicate the numbers in the table.

Select the correct choice that completes the sentence below. The rebate amount is equal to the rebate fraction O A. multiplied by the total finance charge O B. multiplied by the number of months of a loan OC. divided by the number of weeks of the loan O D. divided by the total interest

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

Am. 327.