your company took out an amortizing loan with the following terms

amount: 9,000

terms(years): 30

rate: 4%

1. what is the annual payment (as a positive number) use excels pmt function

2. create an ampetization table on excel. what is the outstanding balance at the end of the first year

3. what is the outstanding balance at the end of year 20?