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.

A design studio received a loan of $9,400 at 5.90% compounded monthly to purchase a camera. If they settled the loan in 2 years by making monthly payments, construct the amortization schedule for the loan and answer the following questions. a. What was the payment size? Round to the nearest cent K SUBMIT QUESTION SAVE PROGRESS SUBMIT ASSIGNMENT 12°C Partly sunny ENG 10:03 8/5/2

What is the apr? Please solve this question general Accounting question

Complete the next line of the schedule. 

The following loan was paid in full before its due date. a) Find the value of h using an appropriate formula. b) Use the actuarial method to find the amount of unearned interest. c) Find the payoff amount. Regular Monthly Payment APR # of Payments Remaining after Payoff 8.7% 4 $214 What is the finance charge per $100 financed? h = $ (Round to the nearest cent.) The unearned interest is about $ (Round to the nearest cent.) The payoff amount is $ Enter your answer in each of the answer boxes. f12 inser f9 f1o f7 fg f6 f4 f5 esc 5 7 8. %24 3 %23

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

Calculate the interest? General accounting