DATA FLOW DIAGRAM FOR EXCEL SPREADSHEET

							Price                                       DATA FLOW DIAGRAM FOR EXCEL SPREADSHEET
                       Input
                    Initial Price                                                                                                 RRR                   Initial
Return                                          Calculate                                                                                              Investment
Rate                                            Projected                                 Taxes             Calculate EAT
                            Returns               Price
                                                               Determine
No. of                               Revenues                  Gross Profit                                                                             Input Initial
Units           Input #                                                                                                                                  Investment
Sold            of units                                                                                                     Projected
                                Net Units       Determine                                 Calculate Taxes                   Cash Flows
                                                 COGS
Labor                                                                                                            Add Back                  Calculate
Requirements    Labor                                                                     Calculate EBT        Non-Cash Items                                 NPV


                Materials
Direct

Costs           Inventor’s Fee                                          Total Indirect and Other Costs
                                                                                                                                                       Calculate
                                                                                                                                                       IRR
                Determine Indirect Labor
                Expense & Projected Expenses


                Determine Utilities Expense                                                                                     Generate          Cash Flow
                                                                                                                                Output            Statement

Indirect &
Overhead
Costs                Determine Heating &                       Determine Total            Calculate
                       A/C Expense                             Overhead Costs             Projected
                                                                                          Increases          Project,                             Cash Flow
                                                                                                            Scenario,                              Reports
                Repair (Machinery) Expense                                                                     Date


                Administrative Salaries


                      Depreciation


Advertising                           Determine Advertising Expenses
 Expense



Sales Commissions                     Determine Sales Commissions