1. Create a loan payment schedule. Use the layout below as a starting point. Add what you need to make this work for 4 years of monthly car payments for a $35,000 loan at 5.5% /10 A B D E F 1 Payment Number Month Principle Portion Interest Portion Payment Amount Balance 2 0 3 1 Jan 4 2 Feb Import (a new worksheet tab, create it.)