I am not getting the right numbers on "Payment", "Interest", "Repayment of Principal", and "Remaining Balance"

You are asked to build a flexible loan amortization table for your summer internship at the bank. The following is basic information for the loan applicant. Loan amount=$40,000 Term term=48 months Loan rate=8% APR, compounded mounthly Payment starts at the end of each month. Extra payment option without penalty: Extra payment = $10,000 one time a) Write a flexible program that answers actual laon period with extra payment option exercised. In the answer table, list monthly loan schedule: payment, interest payment, principal repayment, balance. b) In the output section, find out the period that the remaining balance is below $ 9000, so the customer can exercise this balloon payment option. Note: excel functions such as IF fuction etc are expected in your answer sections. Your output automatically updates when inputs change. Input section Output Section loan amount Annual Ratel (APR) - Loan Term (months) Extra Payment at the end of month S40,000 8.00% 40 (Compounded Monthly) Formulas 1142.56 =PMT(F12,B13,-B11) 0.67% -B12/12 months Regular Payment Monthly Rate Actual Loan Period 15 Which period can you pay off your balance with $9000 $10,000.00 $9,000.00 Extra Payment Balance you want to pay off answer section: Remaining Balance Month Payment Interest ck A A A 0 $ 1 $ 2 $ 3 $ 4 $ 5 $ 6 S 7 $ 8 $ 9 $ 10 $ 11 1.01 S 2.01 S 3.02 S 4.03 $ 5.03 $ 6.04 $ 7.05 $ 8.05 S 9.06 $ 1007 S Repayment of Principal $ $ 0.01 $ 1.00 0.01 $ 2.00 0.02 $ 3.00 0.03 $ 4.00 0.03 $ 5.00 0.04 S 6.00 0.05 S 7.00 0.05 S 8.00 0.06 $ 9.00 007 S 100 $40,000 $40,000.00 $39,999.00 $39,997.00 $39,994.00 $39.990.00 $39,985.00 $39,979.00 $39,972.00 $39,964.00 $39,955.00 $39 945