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
Before
Product, supplier and client data lived in separate files and deal profitability was estimated by hand.
After
Data is entered through forms and simulations calculate landed cost, truck loading, credit terms and NPV to rank deals.
More like this
Related projects
Timesheet & Billing Dashboard
Legal Services
A timesheet and payout system for a small legal team. Users log in by role, workers record tasks and hours, and the admin dashboard shows billed,…
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
Hotel & Restaurant Management System
Hospitality
A complete hotel system inside Excel. Rooms are shown on a building map with live status colours, and the restaurant module handles table bookings, orders, menu…
View project