What is the annual payment on the loan (as a positive number)? Use Excel's PMT() function. 357.20 Correct A B 1 Amount 8,000 2 Term (years) 30 3 Interest rate 2% 4 Annual payment 357.2 =PMT(B3,B2,-B1) The function is: PMT(rate, nper, pv) Enter the present value of the loan (the loan amount) as a negative number to get a positive payment, or vice versa. Part 2 Attempt 2/10 for 10 pts. Create an amortization table in Excel. What is the outstanding balance at the end of the first year? 0+ decimals Submit esc Mccepl My courses Bus 2339-OL49 Time value of money Problem 77 Intro Your company took out an amortizing loan with the following terms: A B 8,000 1 Amount 2 Term (years) |30 3 Interest rate 2% Part 1 Attempt 5/10 for 8 pts. What is the annual payment on the loan (as a positive number)? Use Excel's PMT() function. 357.20 Correct A C 1 Amount 8,000 2 Term (years) 30 3 Interest rate 2% 4 Annual payment | 357.2|=PMT(B3,B2,-B1) The function is: PMT(rate, nper, pv) Enter the present value of the loan (the loan amount) as a negative number to get a positive payment, or vice versa. F1 F2 Attempt Opts MacBook Air 80 F3 F4 F5 F6 @ # $ % &