Create a blank workbook in Excel, select the Retrospect theme

Select columns A to I, then set the column width to 12

Enter and format the labels below

Cell A1 - Type Loan Amortization Schedule, 24 pt, bold, merged and left-aligned across cells A1 to I1

Cell B3 - Type Loan information, bold, left-aligned across cells B3 to C3

Cell B4 - Type Loan amount, left-aligned across B4 to C4

Cell B5 - Type Annual interest rate, left-aligned across B5 to C5

Cell B6 - Type Loan period in years, left-aligned across B6 to C6

Cell B8 - Type Optional extra payments, left-aligned across B8 to C8

Cell F3 - Type Loan Summary, bold, left-aligned across F3 to G3

Cell F4 - Type Scheduled payment, left-aligned across F4 to G4

Cell F5 - Type Total interest, left-aligned across F5 to G5

Select the range B3:D8 and add outside border lines

Select the range F3:H5 and add outside border lines

Select the range B4:B8, click the increase indent button in the Alignment group two times, select the range F4:F5, click the increase indent button in the Alignment group two times

Enter and format the labels below

Cell A10 - Type PMT No

Cell B10 - Type Payment Date

Call C10 - Type Beginning Balance

Cell D10 - Type Scheduled Payment

Cell E10 - Type Extra Payment

Cell F10 - Type Total Payment

Cell G10 - Type Interest

Cell H10 - Type Principal

Cell I10 - Type Ending Balance

Select the range A10:I22, click Format as Table in the Styles group, select Table Style Light 3, click the My table has headers check box, then click OK

Select columns A to I, reset the column width to 12, select the range A10:I10, then click Wrap Text in the Alignment group on the Home tab (When you format cells as a table, the column widths are sometimes adjusted and you need to readjust them. By default, filter arrows appear in the header row of a table so that you can filter table entries. You can remove these arrows.)

With row 1 of the table selected, click the Table Tools Design tab, deselect the Filter Button check box in the Table Style Options group

*****Click cell D4, enter and format values related to a loan for $10,000 and rename the sheet tab Loan Schedule, save the Lab2.xlsx spreadsheet.