Page 109 - CalcBus_Flipbook
P. 109
CH 11] Calculating Business 11-15
11. Select location D23 and type =Regular_Payment. This is the label you gave D13. Note
that as you type the software will open a menu list with Regular_Payment. You may
select with your mouse cursor, Regular_Payment, or continue typing in this label. Your
typing MUST BE ACCURATE. When completed the computer will fill this cell with the value
of D13. In this example 134.2054058. This value needs to be formatted for dollars.
11
12. Format the Cell to dollars. As the cell is selected go to the $ sign in the icons and select
$ with your mouse cursor. This will format the cell to $ and cents, rounding the value to
two decimal places to the right of the decimal which is read as cents.
At this point you will need to label C23 Current_Balance. This is because you will be causing
the Loan Payment Schedule to begin making calculations.
13. Select cell C23 and label it Current_Balance. Note that in fx the value is = Loan_Amount. By
giving cell C23 a label will not change the value in C23, It only ascribes a label to the cell.
Copyrighted Material
