Tax adjustment for financial processing in a relational database management system

Abstract

A financial processing system that accesses account, event and organization attributes from a relational database management database, wherein: (1) the account attributes comprise data about accounts being measured, (2) the event attributes comprise data about account-related transactions, and (3) the organization attributes comprise data about the organization's financial status. Profitability calculations are performed in the computer using the account, event and organization attributes accessed from the relational database management system, as well as one or more profit factors and one or more rules. The profitability calculations comprise the following: for an account a. Thereafter, one or more earnings calculations are performed in the computer using results from the profitability calculations and tax adjustment attributes accessed from the database. The earnings calculations comprise the following:Earnings ()=Profit () * (1−Effective Tax Rate)for the account a. In these earnings calculations, the Effective Tax Rate comprises the following:Effective Tax Rate=(1−tax rate) * (tax rate)+tax rateThe tax rateand tax rateare effective rates, wherein tax rateis deducted from income, and tax rateis not deducted from income. In one embodiment, tax rateis a federal income tax rate and tax rateis a state income tax rate. Finally, one or more total earnings calculations are performed in the computer using results from the earnings calculations. The total earnings calculations comprise the following: for all accounts a.