Trade Opportunity Finder & Profitability Analysis
A database-driven tool for an import and export business. Products, suppliers, clients and prices are added through forms, and sales simulations calculate landed cost, truck loading volume, credit terms and NPV to find the most profitable deals.
- Industry
- International Trade
- Deliverable
- Opportunity Finder.xlsb
- Built with
- Excel VBA, UserForms, Financial modelling
More like this
Related projects
Sales & Purchase Inventory Data Model
Trading
A relational data model in Excel with customers, suppliers, products and countries. Sales and purchase orders are entered through forms, stock levels update automatically and customs…
View project
Inventory Management System for Drilling Operations
Oil & Gas
A complete materials and inventory workbook for a drilling services company. It links every well design to the chemicals and cement it consumes, tracks monthly usage…
View project
Automated Cashflow & Bank Categorisation
Accounting
Downloads bank and QuickBooks data, classifies every transaction into a ledger using a keyword table and produces a monthly cashflow statement with payroll summary. New vendors…
View project