Autoliv Financial Model & Report
Budget: ₹1,500 – ₹12,500 INR
I need a fully linked Excel model on Autoliv (ALV) built from scratch using the data available in the Investor Relations section of https://www.autoliv.com/investor-relations. Please pull a minimum of two historical years and project five annual periods forward.
All three core statements—Income Statement, Balance Sheet and Cash Flow—must flow together seamlessly. Revenue and cost assumptions should go beyond a high-level view; I want a detailed breakdown that is clearly tied to the best KPIs you can source at the company, industry or macro level (units shipped, ASPs, raw-material indices, safety-system penetration rates, etc.). Add supporting schedules (working capital, capex & depreciation, debt, equity, tax) so each forecast line is transparent and auditable, and include ratio analysis wherever it improves insight.
Once the operating model is solid, layer on valuation: run a discounted cash-flow with clearly stated assumptions and triangulate that with relative multiples to arrive at a defensible target price. Summarise your conclusions in a concise 2–3-page investment report.
Deliverables:
• Excel workbook with dynamic links across IS, BS and CF, driver tabs, schedules and valuation sheets
• Word investment note (2–3 pages) summarising key findings, assumptions, valuation outputs and target price
Acceptance criteria will be the integrity of the links (no hard-codes where formulas should sit), clarity of driver logic, and a valuation section that reconciles to the model. The timeline is urgent—ASAP—so let me know how quickly you can turn the first draft and what interim checkpoints you propose.
All three core statements—Income Statement, Balance Sheet and Cash Flow—must flow together seamlessly. Revenue and cost assumptions should go beyond a high-level view; I want a detailed breakdown that is clearly tied to the best KPIs you can source at the company, industry or macro level (units shipped, ASPs, raw-material indices, safety-system penetration rates, etc.). Add supporting schedules (working capital, capex & depreciation, debt, equity, tax) so each forecast line is transparent and auditable, and include ratio analysis wherever it improves insight.
Once the operating model is solid, layer on valuation: run a discounted cash-flow with clearly stated assumptions and triangulate that with relative multiples to arrive at a defensible target price. Summarise your conclusions in a concise 2–3-page investment report.
Deliverables:
• Excel workbook with dynamic links across IS, BS and CF, driver tabs, schedules and valuation sheets
• Word investment note (2–3 pages) summarising key findings, assumptions, valuation outputs and target price
Acceptance criteria will be the integrity of the links (no hard-codes where formulas should sit), clarity of driver logic, and a valuation section that reconciles to the model. The timeline is urgent—ASAP—so let me know how quickly you can turn the first draft and what interim checkpoints you propose.