Please answer

Create an amortization table for the fixed-rate mortgage that is most affordable. (The Excel worksheet will calculate the monthly payment based on your input and create the amortization table.) Loan Amount _____ Number of Years _____ Annual Interest Rate _____ Monthly Payment _____ Amortization Schedule for Year 1 Compare the allocation of principal versus interest paid per year on the loan. (The Excel Worksheet will create a bar graph based on your input.)