FS Builder - Project Feasibility Analysis Tool

A comprehensive web-based project appraisal and feasibility analysis tool similar to UNIDO's COMFAR. Built with React, TypeScript, Node.js, and PostgreSQL.

• Project Setup: Define project parameters, timeline, and financial assumptions
• Investment Planning: Track fixed assets, pre-production costs, working capital with depreciation
• Production & Revenue: Capacity planning, product pricing, and sales projections
• Operating Costs: Fixed and variable cost tracking with escalation
• Financing: Equity, loans with amortization schedules, and grants

• Cash Flow Projections: Operating, investing, and financing activities
• Financial Statements: Income Statement and Balance Sheet generation
• Profitability Indicators:
  • Net Present Value (NPV)
  • Internal Rate of Return (IRR)
  • Modified IRR (MIRR)
  • Payback Period (simple and discounted)
  • Return on Investment (ROI)
  • Benefit-Cost Ratio
• Break-Even Analysis: Units and revenue calculation with visualization
• Sensitivity Analysis: Variable impact analysis with tornado charts
• Scenario Analysis: Best/base/worst case comparisons

• PDF Reports: Professional formatted reports with charts
• Excel Export: Multi-sheet workbooks with formulas preserved

• Node.js 18+
• PostgreSQL 14+
• npm or yarn

1. Clone the repository

   git clone <repository-url>
   cd fs-builder

2. Install dependencies

   npm install

3. Configure environment

   cp .env.example .env
   # Edit .env with your database credentials

4. Set up the database

   npm run db:generate
   npm run db:migrate

5. Start development servers

   npm run dev

   This will start:

   • Frontend at http://localhost:3000
   • Backend at http://localhost:4000

fs-builder/
├── client/                    # React frontend
│   ├── src/
│   │   ├── components/        # Reusable UI components
│   │   ├── features/          # Feature modules
│   │   │   ├── investment/
│   │   │   ├── production/
│   │   │   ├── costs/
│   │   │   ├── financing/
│   │   │   ├── analysis/
│   │   │   └── reports/
│   │   ├── hooks/             # Custom hooks & stores
│   │   ├── pages/             # Route pages
│   │   ├── services/          # API client
│   │   ├── types/             # TypeScript types
│   │   └── utils/             # Helpers
│   └── package.json
├── server/                    # Node.js backend
│   ├── src/
│   │   ├── routes/            # API routes
│   │   ├── middleware/        # Auth, error handling
│   │   ├── services/
│   │   │   ├── calculations/  # Financial calculation engine
│   │   │   └── reports/       # Report generators
│   │   └── types/
│   └── package.json
├── prisma/                    # Database schema
│   └── schema.prisma
└── package.json               # Root package.json

• POST /api/auth/register - Register new user
• POST /api/auth/login - Login
• GET /api/auth/me - Get current user

• GET /api/projects - List projects
• POST /api/projects - Create project
• GET /api/projects/:id - Get project
• PUT /api/projects/:id - Update project
• DELETE /api/projects/:id - Delete project
• POST /api/projects/:id/duplicate - Duplicate project

• /api/projects/:id/investments - Investment CRUD
• /api/projects/:id/products - Products CRUD
• /api/projects/:id/costs - Operating costs CRUD
• /api/projects/:id/financing - Financing CRUD

• GET /api/projects/:id/analysis/indicators - Financial indicators
• GET /api/projects/:id/analysis/cashflow - Cash flow projections
• GET /api/projects/:id/analysis/income-statement - Income statements
• GET /api/projects/:id/analysis/balance-sheet - Balance sheets
• POST /api/projects/:id/analysis/sensitivity - Sensitivity analysis
• GET /api/projects/:id/analysis/break-even - Break-even analysis

• POST /api/projects/:id/reports/pdf - Generate PDF report
• POST /api/projects/:id/reports/excel - Generate Excel report

NPV = Σ (CFt / (1 + r)^t)

Where CFt = cash flow at time t, r = discount rate

Rate r where NPV = 0 (calculated using Newton-Raphson method)

Year when cumulative cash flow turns positive

Break-Even Units = Fixed Costs / (Price - Variable Cost per Unit)

npm run test

npm run build

npm run db:generate  # Generate Prisma client
npm run db:migrate   # Run migrations
npm run db:push      # Push schema changes (dev only)

MIT License

Inspired by UNIDO's COMFAR (Computer Model for Feasibility Analysis and Reporting) software for investment project analysis.