Forward Sports (Pvt.) Ltd — Dynamic 5-Year Three-Statement Financial Model A fully-linked, scenario-driven financial model built in Excel for Forward Sports (Pvt.) Ltd, a Sialkot, Pakistan–based sporting goods manufacturer and exporter — forecasting FY2026–FY2030 off a FY2025 actual base year. Scope of work: 1.Scenario-Driven Assumptions — built a live scenario switch (Base / Upside / Downside) driving revenue growth (3%–13%) and COGS as a % of revenue (59%–64%) through OFFSET + MATCH formulas, so the entire model recalculates from a single dropdown input 2.Operating Expense Build-Up — modeled SG&A, R&D, and Marketing as % of revenue over the forecast period, feeding directly into the income statement 3.Income Statement — fully linked 6-year P&L (2025A–2030F) from revenue through COGS, gross profit, operating expenses, and net income, all formula-driven off the assumptions tab 4.Balance Sheet — dynamic 5-year balance sheet with automatic balance checks tying back to the income statement and cash flow 5.Cash Flow Statement — indirect-method cash flow statement (CFO/CFI/CFF), reconciling net income to the change in cash and linking to the Balance Sheet 6.Ratios & Summary — a KPI panel with margin, efficiency, and return ratios, plus SUMIFS-based period totals for revenue, net income, and marketing spend 7.Dashboard — a forecast-summary dashboard with a scenario selector and revenue/net income/EBITDA-margin charts (Base case: ~19% EBITDA margin through the forecast, Net Income growing from ~$5.0M to $5.8M FY2026F–FY2028F) Why it matters: Every figure flows from a single set of assumptions — change the active scenario and the entire model, from the P&L down to the dashboard chart, updates automatically. Nothing is hardcoded, which is exactly what makes it defensible in front of a client or professor. Skills demonstrated: Financial modeling · Three-statement integration · Scenario/sensitivity analysis · Advanced Excel (OFFSET, MATCH, SUMIFS, dynamic named ranges) · Dashboard design · Forecasting

1

16

Title: UrbanMart Retail — Complete Monthly Bookkeeping & Financial Reporting (Excel) Description: A full-cycle monthly bookkeeping package built in Excel for a fictional retail business, showcasing end-to-end accounting workflow from raw transactions to finished financial statements. What's included: * Chart of Accounts — structured account codes, types, and normal balances * General Journal — 27+ dated transaction entries with debit/credit logic and memos * General Ledger — auto-posting from the journal with running balances per account * Trial Balance — pulled directly from the ledger, verified to balance to the cent * Bank Reconciliation — deposits in transit, outstanding checks, adjusted balances tying out to $0 difference * Income Statement — revenue, COGS, gross profit, and operating expenses * Balance Sheet — assets, liabilities, and owner's equity, with a built-in check that Assets = Liabilities + Equity * Statement of Cash Flows — indirect method, reconciling net income to ending cash Every statement is fully linked with live formulas — no hardcoded numbers — so the workbook updates automatically as transactions change, and every total is traceable back to its source. Skills demonstrated: double-entry bookkeeping, Excel formula design (cross-sheet references, IF logic), financial statement preparation, bank reconciliation, and accounting workflow documentation. (Sample project — all figures are illustrative for demonstration purposes.)

0

19

Zenith Industries — Integrated Three-Statement Financial Model: Built a fully integrated, formula-driven financial model for Zenith Industries in Excel, designed so that changes to transactions, assumptions, or accounting entries automatically flow through the entire model. The model connects the complete accounting and financial reporting process, with complex formulas and linked schedules ensuring that the financial statements update dynamically whenever the underlying inputs are changed. Key Features: *Structured Chart of Accounts *Automated Journal Entries *Formula-driven General Ledger *Automated Trial Balance *Integrated Income Statement *Integrated Balance Sheet *Integrated Cash Flow Statement *Dynamic financial assumptions *Interactive financial dashboard *Cross-linked statements with automatic updates *Built-in formulas and accounting logic to maintain consistency across the model What makes this model different? The model is dynamic rather than static. Changing an entry at the source automatically updates the relevant accounts, ledgers, trial balance, and financial statements. This creates a connected financial system that can be used for financial analysis, forecasting, scenario testing, and decision-making. This project demonstrates advanced Excel financial modeling, accounting integration, formula development, and automation.

1

39

Organic Skincare Web Collateral for Modern Royal Life Store

1

0

Account Sphere

Helping Businesses Grow Through Accounting