O Mail - albis Assignment - Goal.seekt X M2 Video Lectures Pt 2. FINA X M2 Lecture Resources: FIN445 x .com/courses/1448480/assignments/9005189 What is an Overview Asteroid.. New Tab e Asteroid family is a... 15 10 Things You Nee... https//www.cuse ASSIGNMENT Goal-seek Loan Amortization Schedule . Amount of the loan: $500,000 Length of the loan: 30 years. Payment: Equal annual paymerit Interest rate: Annual interest rate is 3.0% in year 1, and increases at 0.1% increment every year after that So Year 2's rate will be 3.1%, Year 3's rate will be 3.2%, etc. (It's a simple addition, each following year's rate will be previous year's rate + 0.1%) M1 Assignment - Goal-seek Loan Amortization Schedule Rubric Successfully created year-by-year table with Year, Beginning balance, PMT, interest, principal, ending balance 4 Successfully created a column to reflect floating interest rates pts Successfully utilized goal seek to calculate loan annual payment 1 pt 2 Total pts 7 pts Previous 7 0 Next RE a O Mail - albis Assignment - Goal.seekt X M2 Video Lectures Pt 2. FINA X M2 Lecture Resources: FIN445 x .com/courses/1448480/assignments/9005189 What is an Overview Asteroid.. New Tab e Asteroid family is a... 15 10 Things You Nee... https//www.cuse ASSIGNMENT Goal-seek Loan Amortization Schedule . Amount of the loan: $500,000 Length of the loan: 30 years. Payment: Equal annual paymerit Interest rate: Annual interest rate is 3.0% in year 1, and increases at 0.1% increment every year after that So Year 2's rate will be 3.1%, Year 3's rate will be 3.2%, etc. (It's a simple addition, each following year's rate will be previous year's rate + 0.1%) M1 Assignment - Goal-seek Loan Amortization Schedule Rubric Successfully created year-by-year table with Year, Beginning balance, PMT, interest, principal, ending balance 4 Successfully created a column to reflect floating interest rates pts Successfully utilized goal seek to calculate loan annual payment 1 pt 2 Total pts 7 pts Previous 7 0 Next RE a