⚖️ Automated Financial Scoring & Risk Assessment Model

📌 Project Overview

An independent analytical model built in MS Excel to evaluate and rank complex financial offers. The architecture ensures strict separation of raw data, weighting assumptions, and computational layers, making it highly scalable and audit-ready.

⚙️ Key Architectural Features

• Modular Design: The project is divided into distinct operational layers: Baza Zródłowa (raw data), Założenia (risk weightings), Matryca punktacyjna (scoring engine), and Ranking (final output).
• API Integration: Automated retrieval of live currency exchange rates directly from the National Bank of Poland (NBP) via Power Query (API_NBP sheet).
• Parametric Logic: The Symulacja Finansowa engine uses advanced logical formulas to eliminate hardcoded values, updating the entire matrix dynamically when assumptions change.

📊 Visual Architecture

1. Final Output: Dynamic Ranking Dashboard

2. Parameterization: Risk Weightings & Assumptions

3. Data Pipeline: Automated NBP API Connectivity

🛠️ Technical Stack

• Tool: MS Excel
• Data Connectivity: Power Query / External API (REST)
• Core Logic: Multi-criteria scoring, dynamic weighting logic, arrays.