One question. Multiple parts. Thank you. Will upvote answer

Bill and Laura borrowed $150,000 at 6% per annum compounded monthly for 30 years to purchase a home. Their monthly payment is determined to be $899.33. Complete parts (a) through (h). Bill and Laura's interest expense when the loan is paid is $ (Type an integer or decimal rounded to two decimal places as needed.) (g) Suppose that Bill and Laura decide to pay an additional $100 each month on their loan. Answer parts (a) to (f) under this scenario. Find a recursive formula for their balance after each monthly payment has been made. O A. Ao = 150,000, A = 1- 0.06 12 An- 1 +999.33 0.06 O B. A = 150,000, A = 1- 12 An- 1 - 999.33 0.06 O C. Ao = 150,000, A = 1+ 12 An-1+999.33 0.06 O D. A = 150,000, A = 1+ 12 An- 1 - 999.33 Bill and Laura's balance after making the first payment is $. (Type an integer or decimal rounded to two decimal places as needed.) Using a graphing utility, create a table showing Bill and Laura's balance after each monthly payment with an additional $100 each month. n u(n) O VOUAWNBill and Laura borrowed $150,000 at 6% per annum compounded monthly for 30 years to purchase a home. Their monthly payment is determined to be $899.33. Complete parts (a) through (h). (c) Using a graphing utility, create a table showing Bill and Laura's balance after each monthly payment. n u(n) O N K 10 (Type whole numbers.) (d) Using a graphing utility, determine when Bill and Laura's balance will be below $140,000. Bill and Laura's balance will be below $140,000 after |payments. (e) Using a graphing utility, determine when Bill and Laura will pay off the balance. Bill and Laura will pay off the balance after payments of $899.33 plus the last payment of $ (Type an integer or decimal rounded to two decimal places as needed.) (f) Determine Bill and Laura's interest expense when the loan is paid. Bill and Laura's interest expense when the loan is paid is $ (Type an integer or decimal rounded to two decimal places as needed.) (g) Suppose that Bill and Laura decide to pay an additional $100 each month on their loan. Answer parts (a) to (f) under this scenario.Bill and Laura borrowed $150,000 at 6% per annum compounded monthly for 30 years to purchase a home. Their monthly payment is determined to be $899.33. Complete parts (a) through (h). (a) Find a recursive formula for their balance after each monthly payment has been made. 0.06 O A. A = 150,000, A = 1+ 12 An- 1 -899.33 O B. A = 150,000, A= 1 + 0.06 12 An-1 +899.33 0.06 O C. Ap = 150,000, A = 1 12 An- 1 - 899.33 K 0.06 O D. A = 150,000, An = 1- 12 An-1 +899.33 (b) Determine Bill and Laura's balance after the first payment. Bill and Laura's balance after making the first payment is $. (Type an integer or decimal rounded to two decimal places as needed.) (c) Using a graphing utility, create a table showing Bill and Laura's balance after each monthly payment. n u(n) W N OUA 5 60 00 NBill and Laura borrowed $150,000 at 6% per annum compounded monthly for 30 years to purchase a home. Their monthly payment is determined to be $899.33. Complete parts (a) through (h). N - 10 (Type whole numbers.) Bill and Laura's balance will be below $140,000 after |payments. Determine when Bill and Laura will pay off the balance. Bill and Laura will pay off the balance after payments of $999.33 plus the last payment of $ (Type an integer or decimal rounded to two decimal places as needed.) Bill and Laura's interest expense when the loan is paid is $. (Type an integer or decimal rounded to two decimal places as needed.) (h) Is it worthwhile for Bill and Laura to pay the additional $100? Explain. O A. Yes, it is worthwhile for Bill and Laura to pay the additional $100 because they will need to pay less interest than the previous payment. O B. No, it is not worthwhile for Bill and Laura to pay the additional $100 because they will need to pay a higher rate of interest. O C. No, it is not worthwhile for Bill and Laura to pay the additional $100 because they will need to pay more interest than the previous payment. O D. Yes, it is worthwhile for Bill and Laura to pay the additional $100 because they will need to pay a lower rate of interest