Pages

Microsoft Office Excel 2007 Financial Schedules

This chapter, which makes use of much of the information contained in the two previous chapters, contains useful examples of a wide variety of financial calculations.

Creating Financial Schedules

 

Financial schedules present financial information in many different forms. Some present a summary of information, such as a Profit & Loss Statement, which presents the results of operations of a company. Others present a detail list, such as an amortization schedule, which schedules the payments of a loan.
Financial schedules can be static or dynamic. Static schedules generally use a few Excel functions but mainly exist in Excel to take advantage of its grid system, which lends itself well for formatting schedules. Dynamic schedules, on the other hand, usually contain an area for user input. A user can change certain input parameters and affect the results.
The sections that follow demonstrate summary and detail schedules as well as static and dynamic schedules