In: Accounting
5) Assume an installment note payable with a $240,000 face value, a 6% contractual interest rate, and requiring monthly fixed principal payments of $2000. Create an installment payment schedule with headings for Interest Period, Cash Payment, Interest Expense, Reduction of Principal, and Principal Balance and complete the first four rows. Try to use a spreadsheet for this exercise.