Attronica Externship via ExternAccounting junior building practical skills in FP&A and private company valuation through an Attronica externship.
Projects focus on financial planning and private company valuation methods practiced during the Attronica externship, showing hands-on modeling and analysis I completed while still a student.
.png)
Attronica · ✅ Verified by Extern · ⏱️ In progress
A 40-year-old, $80M family-owned IT firm is preparing to sell — and they need real FP&A work to back it: clean financials, a defensible forecast, and a valuation. Organize the books, model the forecast, and deliver a valuation that lands on the CEO's desk and on a buyer's table.
Built and analysed 15+ financial ratios using Excel from profitability, liquidity, efficiency, leverage and investment categories using financial statements across five years (2021-2025). Analysed financial performance and capital efficiency, including reconciling internally calculated ROCE against the reported figure, identifying varying methodology of capital employed. Presented findings through an Excel dashboard and written report, translating the 5-year financial analysis into recommendations on deleveraging, working capital monitoring and the investigation of operating-margin decline.
Accounting junior building practical skills in FP&A and private company valuation through an Attronica externship.
I am Kellan Rebello, a junior accounting student pursuing a bachelor’s degree. I have limited formal work experience and I completed the Attronica Financial Planning & Analysis and Private Company Valuation externship to gain hands-on exposure to financial modeling and valuation methods.
Externships
Attronica Financial Planning & Analysis and Private Company Valuation Externship
In progress
Experience
Barista
Caff e8 Nero · Mar 2025-Apr 2025
Education
Brunel University London
BSc Accounting and Business Management (Hons)
Skills
✅ Verified by Extern · ⏱️ In progress
A 40-year-old, $80M family-owned IT firm is preparing to sell — and they need real FP&A work to back it: clean financials, a defensible forecast, and a valuation. Organize the books, model the forecast, and deliver a valuation that lands on the CEO's desk and on a buyer's table.
The externship produced FP&A deliverables for a family-owned IT firm preparing for a sale, focusing on financial cleanup, forecasting, and valuation. The work involved organizing historical financials, building a defensible forecast model, and producing a valuation report suitable for executive review.
I transformed five years of audited statements into a single, reconciled financial model with linked income statement, balance sheet, cash flow, equity rollforward tabs, eight FP&A ratios, audit checks, and a formatted presentation.
I read five years of audited statements, built linked income statement, balance sheet, cash flow, and equity rollforward tabs, calculated eight FP&A ratios, and produced a reconciled workbook with audit checks and formatted presentation.
The project reviewed customer lists, expense tables, and balance-sheet metrics, then wrote a concise memo. I diagnosed customer concentration, decomposed SG&A and margin swings, calculated a long cash conversion cycle, and recommended targeted actions.
Built and analysed 15+ financial ratios using Excel from profitability, liquidity, efficiency, leverage and investment categories using financial statements across five years (2021-2025). Analysed financial performance and capital efficiency, including reconciling internally calculated ROCE against the reported figure, identifying varying methodology of capital employed. Presented findings through an Excel dashboard and written report, translating the 5-year financial analysis into recommendations on deleveraging, working capital monitoring and the investigation of operating-margin decline.
Building a financial forecasting model incorporating revenue drivers and scenario analysis. Applying DCF and comparable company valuation methods to a real business, relevant to the Data and Analysis rotation. Analysed and reconciled five years of data across 50+ customer accounts, identifying inconsistencies and supporting accurate financial insights and recommendations to department heads.
Worked with data sets, building an independent expectation of revenue from underlying data across 32 locations totalling
Analysed financial statements and reviewed internal controls across a client s business process, identifying risks including fraud and unrecorded liabilities. Reviewed output from a data analysis tool, forming conclusions on a US$1m balance sheet imbalance. Reviewed a 5-year cash flow forecast, evaluating management assumptions and summarising conclusions.
