Create a professional MS Excel file and associated MS Word report using APA 7 formatting to be presented to your boss and Sandra to address the following scenarios:

Scenario 1-Vanilla You are a loan officer and your next client is Sandra Patterson. Sandra wants to borrow $200,000 from the bank at 6 percent interest compounded monthly to be repaid over thirty (30) years. Workings illustrating the payment to be paid monthly Amortization table for first 12 months Answers to the following questions: (i) Principal paid in the first month? (ii) Balance at the end of the 3rd month? (iii) Amount of interest in the last installment? (iv) Total interest paid?