Chapter 5 Assignment Using Excel, prepare an appropriate amortization schedule for each part below. Your schedule must include dates and the following columns: Motes Payable (dr.), Cash (cr.) (amount paid for principal) Cash (cr.}) {amount paid for interest) Interest Expense (dr.) Discount on Notes Payable (cr.) Present Value Balance of the Note Annual Cash Flows Part IlI: To finance an expansion, on October 1, 2024, Cristina issued a 5660,000, 5-year non-interest bearing note when the prevailing interest rate for such obligations was 8.6%. The company will pay off the note in five 5132,000 installments due at the end of each year. Please note that now there is only an annual annuity and no payment for interest. row 3: Sample input area: column A Part ll: Column B row 4: Mote face value 5660,000 row5: Interest periods row 7: Effective (market) rate row 8: Met Present Value NPV [B7 H14:H18)