Project 09  ·  CE 502

Construction Accounting, Finance & Strategy

CE 502 · Construction Accounting, Finance & Strategy · University of Southern California · 2024–2025

Financial Analysis Project Finance SPV Structure DSCR / IRR Sensitivity Analysis Corporate Strategy Construction Industry Failure Analysis

Course

CE 502 — Construction Accounting, Finance & Strategy

Projects

3 — LEGO, Skanska, Nava Bharat

Tools

Excel, PowerPoint, Financial Modeling

Focus

Corporate Finance, Strategy, Project Finance

Contents

  1. Course Overview
  2. Project 1 — LEGO Failure Analysis
  3. Project 2 — Skanska Term Paper
  4. Project 3 — Nava Bharat Financial Analysis
  5. All Downloads

Course Overview

CE 502 is a graduate-level course covering the financial and strategic dimensions of construction and engineering firms. Topics span corporate accounting, financial statement analysis, project finance structures, capital budgeting, and competitive strategy within the construction industry. Work in this course required both quantitative financial modeling in Excel and written strategic analysis through team presentations and research papers.

The three major deliverables covered here are: a failure analysis of LEGO examining how the company nearly went bankrupt in 2003–2004 and the financial ratios behind its recovery; a term paper on Skanska, a global construction giant, analyzing its industry position, financials, strategy, and competitive outlook; and a project finance case study on Nava Bharat Energy India Limited (NBEIL), a coal-fired power plant SPV, involving DSCR and IRR calculations, waterfall analysis, and a full sensitivity analysis built in Excel.

Project 1

Team Presentation · CE 502

LEGO — Financial Failure Analysis & Turnaround

This team presentation analyzed LEGO's near-bankruptcy in 2003–2004 and its remarkable financial recovery. At its lowest point, LEGO posted a net loss of 1.07 billion DKK with an operating margin of –16.7% and a return on equity of –46.3%. The analysis traced the collapse to overexpansion into non-core businesses, bloated product lines, and loss of brand focus — and then examined the strategic decisions that turned the company around.

The recovery was driven by aggressive cost cutting, a refocus on the core brick product, licensing deals (Star Wars, Harry Potter), and digital expansion. From 1998 to 2023, LEGO grew revenue and EBIT at a 9% CAGR — reaching DKK 74.3 billion in revenue and DKK 18.7 billion in operating profit in the most recent reported period, a +13% growth year-over-year. The analysis used income statements, financial ratio tables, and multi-year trend charts to quantify each phase.

LEGO Failure Analysis — Team Presentation

CE 502 · Team 2 · Full slide deck with financial statements, ratio analysis, and turnaround strategy

Download Presentation

Project 2

Term Paper & Presentation · CE 502

Skanska — Strategic & Financial Analysis of a Global Construction Firm

This term paper and presentation provided a comprehensive analysis of Skanska, one of the world's largest construction and project development companies, founded in 1887 and operating across the US, Europe, and beyond. The analysis covered industry context, company financials, competitive positioning, and forward-looking strategy.

The US construction industry was framed using market data: private nonresidential construction valued at $667.3 billion in 2025 (forecast $746.4B by 2030), residential construction at $763.2 billion, and local/state government investment at $463.6 billion. Within that landscape, Skanska USA generates $8.2 billion in annual revenue with 6,300+ employees, while the Skanska Group reaches $16.8 billion globally with 26,300+ employees.

Financial highlights include a 14% profit margin (above sector average), an average wage of $109k (above sector), and wages representing 41.6% of revenue as the largest cost driver. Order backlog and bookings show steady growth through 2025. The paper concluded with a strategy assessment examining Skanska's diversification across construction, residential development, commercial property development, and investment properties.

Skanska — Term Paper Final Presentation

CE 502 · Team 2 · Full slide deck with industry analysis, company financials, strategy, and competitive outlook

Download Presentation

Homework Case Study · CE 502

Nava Bharat Energy India Limited — Project Finance Case Study

This case study analyzed the project financing structure of Nava Bharat Energy India Limited (NBEIL), a coal-fired power plant in India structured as a Special Purpose Vehicle (SPV) of its parent company, Nava Bharat Ventures Limited (NBVL). The analysis covered the rationale for the SPV structure, the waterfall cash distribution mechanism, and quantitative financial modeling of the project's viability.

Key findings: the SPV structure isolates project risk from NBVL's balance sheet, protecting the parent company's assets while enabling off-balance-sheet financing of a capital-intensive infrastructure project. The waterfall mechanism requires NBEIL to satisfy operating expenses, full debt service, a Debt Service Reserve Account (DSRA) of two quarters of loan payments, and six months of interest before any cash can be distributed to NBVL — ensuring lenders are protected throughout the project lifecycle.

The DSCR was calculated starting from the first operating year (2013), using Cash Flow Available for Debt Service (CFADS). While above the minimum threshold of 1.20x, it fell below the target of 1.50x, indicating moderate financial risk. The IRR of 18% — calculated by solving for the discount rate at which the total project cost equals the sum of discounted free cash flows (PBDIT − Tax) over 15 operating years — falls within the acceptable 15–25% range, confirming the project's financial feasibility. A sensitivity analysis adjusting fuel cost (±10%), plant load factor (±10%), and interest rate (+1%) was performed in Excel to stress-test the base case.

Part 4 — Nava Bharat Homework

Written answers — SPV rationale, waterfall mechanism, DSCR/IRR, sensitivity analysis, project evaluation

View PDF

Nava Bharat — Completed Financial Model

Excel model — DSCR, IRR, sensitivity analysis on fuel cost, PLF, and interest rate · Presented in class

Download Excel

All Downloads

LEGO Failure Analysis — Team Presentation

Financial statements, ratio analysis, turnaround strategy · Team 2

Download

Skanska Term Paper — Final Presentation

Industry analysis, company financials, strategy · Team 2

Download

Part 4 — Nava Bharat Homework Answers

SPV structure, waterfall, DSCR/IRR, sensitivity analysis, project evaluation

View PDF

Nava Bharat — Completed Financial Model (Excel)

DSCR, IRR, sensitivity analysis — fuel cost, plant load factor, interest rate

Download Excel