TITLE : FINANCIAL ACCOUNTING WITH LOTUS 123.*

PREFACE ix
 
ACKNOWLEDGMENTS	xi
 
1 INTRODUCTION	1
Accounting Background, 2
Lotus 1-2-3 Background, 3
Chapter Format, 7
File Retrieval and Format, 7
APPENDIX 1: Getting Started with 1-2-3, 9
 
2 GETTING STARTED 11	
The Accounting Problem, 13
Solution to the Problem, 14
Special Features of Lotus 1-2-3, 14
Spreadsheet Setup, 15
Setup Hints, 26
Example, 26
Limitations and Extensions, 29
Printing Parameters, 30
 
3 FINANCIAL STATEMENT PREPARATION 35
The Accounting Problem, 36
Solution to the Problem, 38
Special Features of Lotus 1-2-3, 39
Spreadsheet Setup, 40
Setup Hints, 44
Example, 44
Limitations and Extensions, 50
Printing Parameters, 50
 
4 FINANCIAL STATEMENT ANALYSIS 56
The Accounting Problem, 57
Solution to the Problem, 57
Special Features of Lotus 1-2-3, 58
Spreadsheet Setup, 59
Setup Hints, 61
Example, 61
Limitations and Extensions, 62
Printing Parameters, 62
 
5 ACCOUNTS RECEIVABLE  78
The Accounting Problem, 79
Solution to the Problem, 79
Special Features of Lotus 1-2-3, 80
Spreadsheet Setup, 81
Setup Hints, 87
Example, 88
Limitations and Extensions, 90
Printing Parameters, 90
 
6 DEPRECIATION 95
The Accounting Problem, 96
Solution to the Problem, 96
Special Features of Lotus 1-2-3, 99
Spreadsheet Setup, 101
Setup Hints, 105
Example, 106
Limitations and Extensions, 106
Printing Parameters, 106
 
7 TIME VALUE OF MONEY  109
Time Value of Money, Future Value, 111
Present Value, 115
Other Problems, 118
 
8 LIABILITIES  128
The Accounting Problem, 129
Solution to the Problem, 129
Special Features of Lotus 1-2-3, 130
Spreadsheet Setup and Examples, 131
Bond Amortization, 131
Setup Hints, 134
Limitations and Extensions, 135
Printing Parameters, 135
 
9 LEASES 140
The Accounting Problem, 141
Solution to the Problem, 143
Special Features of Lotus 1-2-3, 143
Spreadsheet Setup, 144
Setup Hints, 147
Example, 147
Limitations and Extensions, 148
Printing Parameters, 151
 
10 MACROS 158
What Is a Macro? 159
How Do You Invoke a Macro? 160
How Do I Type Special Function Keys? 160
Why Do You Call It a Programming Language? 160
How Do I Debug a Macro? 162
Examples of Macros, 162
Macro 1, 163
Macro 2, 163
Macro 3, 165
Macro 4, 167
Macro 5, 168
APPENDIX 2: Macros for Use with Symphony, 173
 
INDEX	175