Financial Statement Creator Macro: Executive Summary
VBA Final Project - Eric Hardester
This Excel Macro project presents the user with a form that allows entry of line items that need to be placed in the three financial statements - Balance Sheet, Income Statement, and Statement of Cashflows. The statements are created independent of each other, removing the need to create all three if only one or two are needed. The number of line items in each statement is variable, and the statements are sized according to the number of line items. Formulas are placed in the "totals" line items of the statements so that changes to different line item values after the creation of the statements is reflected accordingly. The statement spreadsheets are not modified when the "create" buttons are clicked. Instead, the particular statement spreadsheet is deleted and a new spreadsheet is created.
No comments:
Post a Comment