
Closed
Posted
Paid on delivery
I need a fully linked Excel model on Autoliv (ALV) built from scratch using the data available in the Investor Relations section of [login to view URL] 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.
Project ID: 40370296
10 proposals
Remote project
Active 6 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
10 freelancers are bidding on average ₹6,672 INR for this job

* PLEASE CHECK OUT MY PORTFOLIO TO SEE PREVIOUS WORK SAMPLES * Hello, With an MBA in Strategy & Finance and experience as an Investment Banker, I specialize in building robust, investor-ready financial models. I can develop a comprehensive model for your Autoliv project with strong analytical depth and clear linkage across all financial statements. Key Highlights: >Expertise in 3-statement modeling with integrated supporting schedules >Detailed KPI-driven assumptions (units, ASPs, cost drivers, industry indices) >Strong experience in DCF valuation and relative multiples >Clear, transparent model logic with investor-focused outputs >Concise 2–3 page investment report with key insights >Timely delivery with interim checkpoints and strict confidentiality I deliver accurate, structured, and insight-driven models that support effective investment decisions. Regards, S. Singh
₹7,777 INR in 5 days
7.4
7.4

With over 7+ years in delivering top-quality support services, my expertise leads me to believe that I am the best fit for your financial modeling project. As an Excel specialist, I have a wealth of experience in creating intricate and fully linked financial models. I remain dedicated to accuracy and timely delivery, ensuring that all data is well-structured, transparent, and rigorously auditable. Using the latest Microsoft Office tools and my skills in data analysis and financial research, I will deliver a comprehensive package as per your specifications. My raw material indices and industry-specific KPIs sourcing abilities will be crucial in developing your Autoliv financial model with a deeper level of detail than just high-level assumptions. With resources from Autoliv's Investor Relations and robust knowledge of Excel functions, formulas, timelines, pivot tables, etc., rest assured: no driver logic will be left unscrutinized. I also speak English and Hindi proficiently and offer translation services should you require them. Given the urgency of this project, I am fully committed to working quickly without compromising on quality - providing meaningful interim checkpoints to ensure you are satisfied at every stage. Choose me for accurate forecasting, transparent valuation reports, expedient delivery while maintaining exceptional quality. Partner with me now - Let's chart Autoliv's course together!
₹7,000 INR in 1 day
4.8
4.8

Hi Three quick questions 1 Is this for a college project or professional investment analysis as I have assisted in many similar projects 2 Do you want detailed KPI based drivers or a simplified revenue model 3 What is your expected timeline for first draft and final delivery About me I am a Chartered Accountant and CPA having 8 plus years of experience. I have worked with clients in USA, Singapore, Australia and the UK. I specialise in financial modelling including projections, 3 statement model, sales and expenses forecasting and linking graphs to Excel. Though my presence is new here but I have served more than 300 clients till date.
₹7,000 INR in 7 days
4.1
4.1

Hi there, I will build a fully linked, auditable financial model for Autoliv (ALV) using historical data from the Autoliv Investor Relations site and public KPIs, my combination of financial modelling discipline and systems-for-reliability experience ensures clean formulas, version control and traceable driver logic. - Excel workbook: IS, BS and CF fully linked across driver tabs (units, ASP, raw-material indices), working capital, capex & depreciation, debt schedule, tax schedule, and ratio analysis. - Detailed driver mapping: unit volumes, ASPs, safety-system penetration, commodity indices and margin drivers with source references and assumptions per line. - Valuation pack: DCF with sensitivity table, comparables multiples reconciliation, and target price rationale. - Quality control & delivery: formula integrity checks, no hard-coded outputs, staged drafts (first draft in 48 hours), rollback/version notes and a short audit sheet. Skills: ✅ Financial Modeling ✅ Excel (formulas + VBA where needed) ✅ Driver-based forecasting & KPI integration ✅ Valuation & comparables, model deployment ✅ Ratio analysis, validation, and audit logging ✅ Data sourcing and documentation Certificates: ✅ Microsoft® Certified: MCSA | MCSE | MCT ✅ cPanel® & WHM Certified CWSA-2 I am available and can deliver the first draft within 48 hours; do you want the model to use constant currency or local reporting FX assumptions, and do you have preferred peer comps for the multiples? Which peers would you li
₹12,500 INR in 1 day
3.4
3.4

As a highly experienced finance professional with a knack for complex financial modeling, I am confident that I possess the comprehensive technical skills and meticulous attention to detail that your project demands. My proficiency in Excel and VBA, coupled with my extensive experience in creating dynamic, interconnected financial models and producing actionable insights using large datasets, makes me the ideal candidate for this job. In addition to a strong set of foundational financial skills, I bring an added advantage of having expertise in automation using VBA. This enables me to optimize routine tasks, streamline analysis, reduce errors, and deliver results in tight deadlines without compromising quality. With this in mind, I am not only able to provide you with robust core statements but also ensure seamless integration of data across all sheets by avoiding any hard-codes where formulas should sit. Moreover, my ability to transform raw numbers into visual representations using tools like Power BI can enhance the understanding of your financial model at both micro and macro levels. Thus, I can provide a clean and intuitive interface to make your Autoliv financial model easy to navigate while highlighting key insights. With my unique skill-set in analyzing large datasets and creating value-driven reports, I am poised to deliver an accurate model with defensible valuation estimates alongside concise yet comprehensive investment findings on Autoliv in record time.
₹7,000 INR in 1 day
2.9
2.9

I build fully integrated, institutional-grade financial models—linking IS, BS, and CF with detailed driver-based assumptions, clean schedules, and zero hard-coding to ensure auditability and accuracy. I’ll deliver a robust Autoliv model with DCF + comps valuation and a sharp 2–3 page investment note. Let’s get this moving ASAP—share any preferences and I’ll deliver a first draft within 48–72 hours ??
₹3,000 INR in 3 days
0.0
0.0

Hi, The biggest pitfall in building a linked 3-statement model from scratch is broken circular references between the debt schedule and the income statement — especially when interest expense feeds into net income, which feeds into retained earnings, which feeds back into the balance sheet. I'll structure the model to handle this cleanly from day one. Here's my build plan: Historical data (2 years minimum) — I'll pull directly from Autoliv's 10-K/annual reports on their IR page. Revenue breakdown by segment (Airbags, Seatbelts, Active Safety), COGS, SGA, R&D. Driver-based forecast (5 years forward): - Revenue: units shipped x ASP per segment, tied to global light vehicle production forecasts and safety penetration rates - Costs: raw material indices (steel, nylon, propellant), labor cost trends, operating leverage assumptions - Working capital: DSO, DIO, DPO modeled separately with historical trends Supporting schedules — capex & depreciation (PP&E rollforward), debt schedule with interest calc, equity rollforward, deferred tax schedule. Valuation: - DCF with explicit WACC build (CAPM for cost of equity, after-tax cost of debt) - Sensitivity table on WACC vs terminal growth - Relative valuation: EV/EBITDA, P/E vs peers (Joyson, ZF, Aptiv) - Football field chart showing valuation range Investment report (2-3 pages) — thesis, key assumptions, risk factors, target price with upside/downside scenarios. All formulas dynamically linked — zero hardcodes in forecast cells. Color-coded: blue = input, black = formula. Delivery: 4 days Day 1: Historical data pull + model architecture Day 2: Forecast drivers + 3-statement linkage Day 3: Valuation (DCF + multiples) + sensitivity Day 4: Investment report + final QA What's your primary use case — equity research, credit analysis, or academic? This will help me calibrate the level of detail in the driver assumptions. Best regards, Eric
₹7,000 INR in 4 days
0.0
0.0

New Delhi, India
Payment method verified
Member since Nov 13, 2025
₹1500-12500 INR
₹1500-12500 INR
$10-30 USD
€30-250 EUR
$30-250 USD
₹12500-37500 INR
₹12500-37500 INR
₹75000-150000 INR
$10-30 USD
min $50 USD / hour
$30-250 AUD
£20-250 GBP
$10-30 USD
$10-30 USD
$10-30 USD
$250-750 USD
$10-30 AUD
$30-250 USD
$10-30 USD
₹100-400 INR / hour
$30-250 USD
$10-30 USD