Financial Analytics Portfolio

Executive
Financial
Dashboards

Built on real Xero accounting data, this interactive dashboard delivers CEO-grade financial intelligence — revenue trends, profitability, cash flow, and AR health in one view.

ACCA Professional
Xero Certified Advisor
QuickBooks Certified
Kathmandu, Nepal
FY2025 Revenue
$319,840
▲ +38.8% YoY
vs FY2024: $230,350  ·  12-month full year
Gross Margin
65.0%
Growth YoY
+38.8%
AR Outstanding
$64,560
8 Open
$2,420 at 90+ days · Requires attention
Cash (Apr-26)
$6,187
DSO
38 Days
$549K
Total Revenue Analysed
90+
Invoices Processed
28
Months of Data
6
Interactive Charts
About This Project

Institutional-Grade Financial Analysis for Growing Businesses

This dashboard was built using live Xero accounting data, covering 28 months of financial history across FY2024, FY2025, and 2026 YTD.

Built to demonstrate the same methodology used in outsourcing and professional services firms: automated data extraction, structured P&L modelling, AR aging analysis, and executive-ready visualisation.

Xero Accounting
Financial Modelling
AR Aging Analysis
P&L Modelling
Data Visualisation
Cash Flow Analysis
IFRS Reporting
Credentials & Projects
ACCA — Professional Level StudentIn Progress
Advanced financial management, strategic business reporting, and audit & assurance. Global accounting qualification recognised in 180+ countries.
Nepal Telecom (NTC) — DCF Valuation Model✓ Independent Project
8-sheet Excel DCF model built from NTC's official financial statements. Bull/Base/Bear scenario toggle, sensitivity heatmaps, PP&E roll-forward, and a 15-page valuation report. Implied price: NPR 532 vs market ~NPR 880.
Executive Financial Dashboard (This Project)✓ Independent Project
End-to-end financial analytics pipeline — Xero data extraction, structured P&L modelling, AR aging analysis, cash flow tracking, and interactive CEO-grade dashboard. Zero external dependencies.
Xero Advisor Certification✓ Certified
Xero platform setup, client management, bank reconciliation, and financial reporting.
QuickBooks ProAdvisor Certification✓ Certified
QuickBooks Online accounting, payroll management, and financial reporting workflows.
Interactive Dashboard

Full Financial Intelligence,
One Click Away

7 interactive charts, 6 KPI cards, AR aging table, P&L waterfall, and real-time filters. Zero installs, runs in any browser.

📊
Revenue Trend Analysis
FY2024 vs FY2025 monthly comparison with YoY overlay and metric toggle
💰
P&L Waterfall
Revenue → COGS → Gross Profit → EBITDA bridge with all expense lines
🏦
Cash Flow Tracking
28-month closing cash position with positive/negative colour coding
📋
AR Aging Detail
Every open invoice bucketed by days overdue with risk flags
👥
Customer Revenue Mix
Top 6 clients ranked by revenue with concentration risk visibility
📉
EBITDA Margin Trend
Monthly margin analysis with FY comparison and 10% target benchmark
← Back
Sudin Neupane, Prajwal Dhamala, Sanchit Bhattarai · Portfolio
Demo Company (Global) · Executive Dashboard · 16 April 2026
Demo Company (Global) — Executive Financial Dashboard
Source: Xero  |  Currency: USD  |  FY2024–FY2026 YTD
Report Date: 16 April 2026
● LIVE DATA
Year
Metric
Compare
FY2025 Revenue
$319,840
▲ +38.8% vs FY2024 $230,350
Gross Profit Margin
65.0%
GP: $207,896 | FY24: 65.0%
EBITDA Margin
–4.5%
EBITDA: –$14,348 | Opex heavy
Revenue Growth YoY
+38.8%
FY24 → FY25 | Strong trajectory
AR Outstanding
$64,560
8 open invoices | ⚠ $2,420 critical
Cash Position
$6,187
Apr 2026 closing | ⚠ Low
Monthly Revenue — FY2025 vs FY2024
USD · Hover bars for detail · Use filters above
▲ +38.8% YoY
Expense Breakdown
FY2025 Operating Costs — USD
Opex Mix
EBITDA Margin Trend
Monthly % · FY2024 (dashed gold) vs FY2025 (navy)
Avg: –4.5% FY25
Cash Position
Monthly closing balance — 28 months
$6,187 Apr-26
Top Customers by Revenue
FY2025 — USD · % of total shown
6 clients
P&L Waterfall — FY2025
Revenue → Gross Profit → EBITDA bridge
EBITDA: –$14,348
Accounts Receivable Aging Report
Reference Date: 16 April 2026  ·  8 Open Invoices  ·  Total Outstanding: $64,560
✓ $23,320 Current ⚠ $38,820 Overdue 🔴 $2,420 Critical
Current
$23,320
36.1% of AR · 2 invoices
1–30 Days
$14,190
22.0% of AR · 2 invoices
31–60 Days
$8,250
12.8% of AR · 1 invoice
61–90 Days
$16,380
25.4% of AR · 2 invoices
90+ Days ⚠
$2,420
3.75% of AR · 1 invoice
Distribution by Bucket
Invoice # Contact Invoice Date Due Date Total (USD) Outstanding (USD) Days Overdue Bucket Risk Level
🔴
Action Required
INV-0089 (Basket Case — $2,420 — 103 days): Issue formal 7-day demand notice. Place on stop-supply until cleared.  ·  INV-0088 (Bayside Club — $12,100 — 77 days): Escalate to senior management. Combined risk exposure: $14,520.
Demo Company (Global)  |  Xero Demo Company (CA)  |  Currency: USD  |  Source: Xero  |  16 April 2026