1. Consider a $140,000, 7-year loan at 5 percent interest. The loan agreement requires the firm to pay equal amounts of principal for each year plus interest and the loan to be paid in full at the end of year 7. Use excel to build a fixed principal payment amortization schedule