I need help filling out the table. I don't know what to plug into the internet and principle

oboard Font Formatting Styles Alignment Number Table Styles 12 EF G H Part 7: Additional principal payment - Show your work 428 429 430 431 432 433 434 435 Shown below is an excerpt from the repayment schedule for Ben Birnbaum's mortgage loan. It was originated on May 1. Interest is paid in arrears. Recall that the interest portion of each payment is based on the outstanding balance during the previous month. For example: $179,890.96 x.085 = $1,274.23* (Interest for month of June, paid on July 1) 436 Birnbaum Loan Repayment Schedule - $180,000 @ 8.5% for 30 years Date 437 438 439 440 441 442 Payment 1-Jun $1,384.04 Interest Principal Loan Balance $180,000.00 $1,275.00 $109.04 179890.96** 1274.23* 109.81 179,781.15 1273.45 110.59 179,670.56 1272.67 111.37 179,559.19 ** Balance after the 6/1 payment. June balance. 1-Jul 1-Aug 1-Sep 443 1,384.04 1,384.04 444 445 446 447 On August 1, along with his regular payment of $1,384.04, Ben also made an additional principal payment of Sheet1 10 of 25 Type here to search Die Dies Font Alignment Number Styles B D E I G H I On August 1, along with his regular payment of $1,384.04, Ben also made an additional principal payment of $500. Complete the repayment schedule below to reflect the additional payment. (On September 1, Ben pays the regular monthly amount). Note 1: The regular monthly loan payment amount is not affected by the additional principal payment. It will remain the same each month. Note 2: The interest portion of the August 1 payment (paying interest for July) is still based on $179,670.56. Date Payment Interest Principal Loan Balance $180,000.00 179,890.96 179,781.15 1-Jun 1-Jul $1,275.00 1,274.23 $109.04 109.81 $1,384.04 1,384.04 1,384.04 +500 extra 1,384.04 1-Aug 1-Sep Show Work Here: August: Sheet1 of 25 Type here to search o Et e = a = 0 & Ta Styles 2 IC IDIE 1-Jul 1,384.04 1,384.04 1-Aug +500 extra 1-Sep 1,384.04 1,274.23 109.81 179,781.15 Show Work Here: August: September: Page 11 of 25 Sheet1 o i e = 2 = 0 Type here to search C