$.$

Step 1 2 3 4 5 67 1 2 Description 3 4 Points Save your Excel File as LastName_FirstName_ House Insert $400,000 as the Purchase Price in C4, formatted as currency Insert $80,000 for the Down Payment in C5, formatted as currency Calculate the Loan Amount in C6 and format it as currency Insert 8.5% as the Interest Rate in C7, formatted as a percent to two decimal points Insert 30 for the Loan Years in C8 Calculate the Loan 0 3 3 3 3 3 Length in C9 5 8 Calculate the Monthly 10 9 10 Payment in C10 Insert 1-360 for the periods, starting in E5 Insert the Beginning 5