Page 97 - CalcBus_Flipbook

CH 11] Calculating Business 11-3

4. With the labels in place, now bold and underline Loan Calculator at cell B2 and
Table 1 Data in cell F15. To bold and underline Loan Calculator put your mouse
cursor on location B2 then select in the Font the Bold icon and the Underline icon.
Complete the same task with location F15, Table 1 Data.

11

5. Enter the details for your specific calculation in Column D, rows 4 – 9, to
coincide with the labels. Principal Loan is ($12,399 − $1,240 =) $11,159. Place this
amount in D4 and format it to $. The interest Rate is 17.5% but you will enter the
decimal of 0.175, and you will FORMAT the Cells D4 D13, H5, H10 and H12 to $
and the cell D5 to %, which is found at the top of the screen and change the
Decimal Placement to 2.

Copyrighted Material