.. .u. ......
Copy Command^557(a)(b)FIGURE A-I (a) Year 1 amortization schedule. (b) Completed amortization schedule.
This appendix has introduced the basics of spreadsheets. Chapter 2 uses spreadsheets and
simple bar charts to draw cash flow diagrams. Chapters 4-15 each have spreadsheet sec-
tions. These are designed to develop spreadsheet modeling skills and to reinforce your
understanding of engineering economy. As current spreadsheet packages are built around
using mice to click on cells and items in charts, there is usually an intuitive connection
between what you would like to do and how to do it. It seems the best way to learn how to
use the spreadsheet package is to simply play around with it. In addition, as you look at the
menu choices, you will find new commands that you hadn't thought of but find useful.'~"::::, A B C D E
1 Entered Data
2 5000 LoanAmount(^35) Number of Payments
4 8% InterestRate
(^5) ComputerData
(^6) $1,252.28 Loan Payment
7
Interest Principal Balance
8 Year Owed Payment Due
9 0 5000.00
(^101) 400.00 852.28 4147.72 =D9-ClO
(^11) /
(^12) $A$4D9 =$A$6-BlO
A B C D E
Interest Principal Balance
8 Year Owed Payment Due
9 0 5000.00
,
10 1 400.00 852.28 4147.72
11 2 331.82 920.46 3227.25
12 3 258.18 994.10 2233.15
13 4 178.65 1073.63 1159.52
,^145 92.76 1159.52 0.00 =Dl3-CI4
(^15) /
16 = $A$4D 13 =$A$6-BI4