- Home
- Skills
- Finance & Accounting
- Purchase Price Allocation (Ind AS 103 / IFRS 3)
More screenshots
Works with the AI Agents you already use
Purchase Price Allocation (Ind AS 103 / IFRS 3)
Runs a full acquisition PPA: consideration, fair-valued net assets, intangibles via MPEEM and relief-from-royalty, DTL, goodwill and WARA reconciliation, as a live-formula Excel model.
$5
Purchase Price Allocation (Ind AS 103 / IFRS 3)
Example session with this skill installed
We bought 100% of a SaaS company for Rs 120 cr (Rs 100 cr cash + Rs 20 cr earn-out at 50% probability in 2 years). Net assets Rs 18 cr. 400 customers, about 12% annual churn, a strong brand. Do the PPA.
- Read your context and instructions
- Compiled the purchase price allocation
Consideration at fair value, with the earn-out probability-weighted and discounted. Net assets are fair-valued line by line. Customer relationships are valued by MPEEM at 12% attrition with contributory asset charges, and the brand by relief-from-royalty. The deferred tax liability is booked on the step-ups and goodwill is the residual. A WARA table reconciles to the deal IRR. Also included: a 10-year amortisation schedule, sensitivities, the acquisition journal entry and a report outline, all in a live-formula Excel workbook.
Connects securely to your tools. The creator never sees your data.
About this skill
Auditors challenge three things in a PPA: missed intangibles, the royalty and attrition assumptions, and whether the rates of return reconcile. Built by a former valuation advisory professional (PPA, business and intangible valuation) who is now a CFO.
From the SPA, the target's balance sheet and the deal business plan, the skill works out purchase consideration, including earn-outs, deferred consideration and employment-linked payments. It then fair-values net assets line by line and screens the full intangibles list.
Valuation methods:
- Customer relationships: MPEEM, with contributory asset charges and tax amortisation benefit
- Brand and technology: relief-from-royalty, with a profit-split sense check
- Non-competes: with-and-without
- Order backlog: margin on contracted, unbilled work
It computes the deferred tax liability, goodwill or bargain purchase, and the WARA vs deal IRR reconciliation. Output is a live-formula Excel model with amortisation schedules and sensitivities, the acquisition-date journal entry, a report outline for the valuer and auditor, and the audit questions to expect.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Finance & Accounting.
Valuation working for financial reporting; a signed report from a registered or independent valuer may still be required. Assumptions such as attrition, royalty and WACC need your evidence.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 23 days ago
- Software
Python 3openpyxl
- Optional
- LibreOffice
Python and openpyxl build the Excel model; LibreOffice recalculates and verifies it.
Permissions
No special permissions declared or detected