Microsoft Office Tutorials and References
In Depth Information
Creating an Amortization Schedule
column shows
amount paid
on principal
each year
column shows
amount owed
on loan at
beginning of year
column shows
amount owed
on loan at
end of year
column shows
interest paid (lending
institution’s gross
profi t) each year
borrower owes
181,606.20 after
sixth year
total interest paid
in cell K21 equals
total interest
paid in cell E5
amount paid on
principal in cell
J21 equals loan
amount in cell C6
total cost in
cell K23
equals total
cost in cell E6
Figure 4–33
To Change Column Widths and Enter Titles
Column Borders
In this chapter, columns A
and F are used as column
borders to divide sections
of the worksheet from
one another, as well as
from the row headings.
A column border is an
unused column with a
signifi cantly reduced
width. You also can use
row borders to separate
sections of a worksheet.
The fi rst step in creating the Amortization Schedule section is to adjust the column
widths and enter the Amortization Schedule section title and column titles, as shown in
the following steps.
1 Position the mouse pointer on the right boundary of column heading F and then drag to
the left until the ScreenTip shows Width: 1.57 (16 pixels).
2 Position the mouse pointer on the right boundary of column heading G and then drag to
the left until the ScreenTip shows Width: 8.43 (64 pixels).
3 Drag through column headings H through K to select them. Position the mouse pointer
on the right boundary of column heading K and then drag to the right until the ScreenTip
shows Width: 14.00 (103 pixels).
4 Select cell G1. Type Amortization Schedule as the section title. Press the ENTER key.
 
 
Search JabSto ::




Custom Search