1 / 16

BMIS 441 Bluth Company Financial Analysis Database System

BMIS 441 Bluth Company Financial Analysis Database System. BMIS441 FALL 2012 Group # 3 Sahan Fernando David French Will McCahill Michael Morgan. Goals for Bluth Database. Public Company Need for accurate financial data Foreign currency issues with multiple subsidiaries

hien
Download Presentation

BMIS 441 Bluth Company Financial Analysis Database System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. BMIS 441Bluth Company Financial AnalysisDatabase System BMIS441 FALL 2012 Group # 3 Sahan Fernando David French Will McCahill Michael Morgan

  2. Goals for Bluth Database • Public Company Need for accurate financial data • Foreign currency issues with multiple subsidiaries • Database to help with summarizing financial items • Summarize whole company and individual subsidiaries • Specifically, assets, liabilities, and stockholders equity • Data will help in preparation of Financial Statements issued to public BMIS 441

  3. Design of Bluth Database • Track currency and division level data • Convert each division data into currency of parent company • Primary users of information will be corporate managers and strategists • Design is as follows: BMIS 441

  4. E R M O D E L

  5. BLUTH Currency Current_Assets Long_Term_Assets Current_Liabilities Long_Term_Liabilities Stockholders_Equity

  6. BLUTH Currency Current_Assets Long_Term_Assets Explain/illustrate: 1. Functional dependency, 2. Normalization process with 3NF Current_Liabilities Long_Term_Liabilities Stockholders_Equity

  7. Order of Data Entry • Bluth • Currency • Current_Assets • Long_Term_Assets • Current_Liabilities • Long_Term_Liabilities • Stockholders_Equity BMIS 441

  8. Objectives of Bluth Database • Provide easy access of division balance sheets to managers • Accurate quarterly data to company stockholders • Keep record of division performance by quarter • Allow management to observe financial performance of each division • Generate financial statements for Bluth company as a whole BMIS 441

  9. SDLC of Bluth Database • Create models of database based on divisional needs • Perform trial runs of database • Check to make sure all relevant data is included • Create queries to help management easily retrieve important company data • Update database with new currency and quarterly data

  10. Implementation of Database • Set up database within a test environment • Database will have same tables and sample data • Put database on web for trial run by managers • Managers will enter most recent quarterly data • Use current exchange rate and sample queries to test usability of database • Create queries for specific management needs • Allow managers to use database for 6 weeks

  11. Implementation Cont. • Management feedback after 6 weeks • Alter database and queries based on management’s feedback • Roll out full system, train foreign managers, and begin use of database • Set up time tables to ensure timely entering of quarterly data

  12. Maintenance of Bluth Database • Division level managers primary modifiers • Insert quarter-end data and new currency rates • Host database on-site with off-site backup • Backup database after each quarter-end data and currency rates entered • Minimum of 15 yearsbacked up • Anti-Fraud queries

  13. Queries • Asset and Liability check against Stockholder’s Equity for fraud • Broken out by division • Calculate total assets of company in USD • Removes currency differences • Calculate total liabilities of company in USD • Removes currency differences • Calculate current ratio of company • Determine liquidity of company

  14. Queries • Calculate division percentage of assets, liabilities, and stockholders equity • Create view and allows managers to insert values into the view • Create Sequence to enforce integrity of data

  15. Analysis of Bluth Database • Database is mandatory for effective management decisions • Helps eliminate currency boundaries • Quicker processing of quarterly data • More accurate quarterly and year-end financial statements • Better understanding of overall health of company • More timely and better informed decisions by management

  16. Questions?

More Related