case study on project finance

• ATM locations
• ATM locator

Estás ingresando al nuevo sitio web de U.S. Bank en español.

Easing complex transactions: project finance case studies, project finance is complex, which is a why a corporate trust partner with comprehensive capabilities is a critical piece of the puzzle..

Improving the country’s aging infrastructure is a top priority, and the $1 trillion Congress recently committed to infrastructure spending will likely kickstart a host of new building projects. At the same time, the American Society of Civil Engineers estimates that the United States needs to spend $4.5 trillion by 2025 to “fix” the country’s infrastructure.

What that means for stakeholders across the infrastructure industry is a growing pipeline of projects, along with the need for project finance expertise to help move projects forward. Bringing those projects to a successful close requires proven expertise, experience and strong communication processes, as well as an ability to work seamlessly with a number of parties and an ability to understand and navigate project finance risks.

As a leading global corporate trust provider , U.S. Bank has experience working on many complex transactions.

“We’ve seen many different approaches to these financings, and we have the ability to come to the table, apply our expertise from prior transactions in the documentation process, and help our clients reach the best outcome on how they’re going to put these complex financing packages together,” says Bob Kocher, managing director, U.S. Bank Global Corporate Trust.

That expertise was recently highlighted in two major project finance projects, where U.S. Bank served as a trustee in bond issuances in the capital stack of the Red River Diversion Project at the Minnesota/North Dakota border and the Central 70 Project in Colorado.

Red River Diversion project

In an infrastructure industry that is no stranger to large, complex projects, the Red River Diversion Project is a notable standout. The $3 billion project is more than a decade in the making, with numerous stakeholders and a mix of funding sources. It’s also a landmark public-private partnership (P3) project in the water infrastructure industry.  

The Red River Diversion project represents the first use of the U.S. Army Corps of Engineers’ P3 Pilot Program to reach financial close. The aim of the program is to improve collaboration between the public and private sectors, as well as develop a more efficient alternative financing model for future Corps infrastructure projects.  

The Red River Diversion project intends to provide permanent, reliable flood protection to the Fargo-Moorhead metropolitan area. The Red River serves as the state border for much of Minnesota and North Dakota and cuts through the center of Moorhead, Minnesota, and Fargo, North Dakota. Spring flooding in the Fargo-Moorhead metro has been a chronic problem for decades.  

The solution is the development of a 30-mile diversion channel. The Army Corps of Engineers is overseeing design and construction, with completion scheduled in 2027.  

The Red River Diversion project involved a number of intricate financing sources that were woven together, including developer equity, federal and state funding and $1.1 billion from local tax levies. The Metro Flood Diversion Authority worked with the U.S. Environmental Protection Agency to obtain one of the largest Water Infrastructure Finance Innovation Act (WIFIA) loans in the program’s history, at $569 million. In addition, project financing included $273 million in tax-exempt senior bonds issued through the Wisconsin-based Public Finance Authority.  

According to the Corps , the Red River Diversion P3 was an “innovative approach leading to significant gains in efficiency, productivity and resiliency” that saved the federal government $277 million and shortened the construction time by 10 years.  

As part of a competitive bid process, U.S. Bank was selected in April 2021 to serve as the bond trustee on the bonds issued by the Wisconsin Public Finance Authority, as well as filling additional roles as the account bank, collateral agent and dissemination agent.  

Once U.S. Bank was selected as trustee, it needed to get up to speed quickly with all documents, provide comments regarding duties and liability and communicate to all parties its views on how the transaction should work as it related to the daily activities of the trustee.  

“This trustee deal had a tremendous amount of document turnarounds as a result of the complexity of the transaction. It required attention to detail to ensure changes were consistent throughout all the documents,” says Angela Davis, relationship manager, Global Corporate Trust at U.S. Bank.  

Keeping communication and workflow on track is a testament to the U.S. Bank team’s diligence in tracking documents, as well as its proactive approach to the collection and distribution of project information and covenants.  

“Through our hands-on partnership and ability to work efficiently with other business lines inside of U.S. Bank, our client received everything they needed to keep this project moving forward,” says Davis.  

Collectively, the U.S. Bank team will serve as the operational and administrative end of the financing, following the documents, administering the movement of funds and making sure the money is moved from account to account properly. U.S. Bank will be responsible for the billing and collecting funds to pay holders of the bonds and senior notes through 2056.  

“P3 projects are the wave of the future, and U.S. Bank is at the forefront of that shift in how infrastructure projects are financed,” says Kocher.

“We can come to the table, apply our expertise from prior transactions in the documentation process, and help our clients reach the best outcome.” Bob Kocher, managing director, U.S. Bank

Central 70 project

Interstate 70, between I-25 and Chambers Road in Denver, is a key corridor that services nearly 1,200 businesses and provides an important regional connection to Denver International Airport. The  Central 70 Project  will reconstruct a 10-mile stretch of I-70, add one new Express Lane in each direction, remove the aging viaduct and create a four-acre park over a portion of the lowered interstate between Brighton and Colorado Boulevards.  

The Central 70 Project involves the refinancing of a 2017 Transportation Infrastructure Finance and Innovation Act (TIFIA) loan, along with the financing of additional costs. As part of the refinancing, the U.S. Department of Transportation’s (DOT) Build America Bureau provided a new TIFIA direct loan with a reduced interest rate, allowing for additional loan principal increase to facilitate project completion.  

Besides TlFIA, the project is backed by the proceeds of tax-exempt private activity bond and taxable bond issuances, as well as contributions from the state DOT, the Colorado Bridge and Tunnel Enterprise, the High Performance Transportation Enterprise, and local and state entities .  The Series A bond issuance totaled $51,670,000 and the Series B bond issuance totaled $464,955,000.  

U.S. Bank served as bond trustee and acted in ancillary roles as the collateral agent and intercreditor agent, paying agent, registrar, transfer agent and dissemination agent. In addition, because bondholder approval was needed to issue the new debt in 2021, U.S. Bank stepped in and served as the tabulation agent for the existing investors.  

Key to a successful project finance deal is finding a partner with the expertise, resources and systems to streamline the process, such as tracking necessary compliance requirements and providing online reporting for the client. In addition, these complex deals often require a higher level of client relationship management.  

“There is a lot more client interaction than a typical municipal financing, because there is always something going on, whether it is requisitions being paid or the sponsor needing to post financials or updates that need to be disseminated to the market,” says Gretchen Middents, relationship manager, Global Corporate Trust at U.S. Bank. “So, it is a much more hands-on relationship as compared with other assignments that don’t have the same scope of documents and requirements.”  

In addition, working with a third-party trustee and agent to perform all project finance roles can produce numerous efficiencies, such as streamlining operations, coordinating workstreams from various parties and providing assistance for investors at every stage of the project lifecycle. Finding a partner with extensive experience servicing all debt vehicles can help guide decision-making with strategic insights and proactive solutions.  

“These projects are more of a team effort because of the complexity,” adds Middents, “and being able to rely on others within our organization is key to our success.”

U.S. Bank administers a variety of infrastructure asset types and has the dedicated expertise to assist investors at every stage of the project finance lifecycle. See our extensive suite of services for debt financing  here  or contact Lars Anderson at  [email protected]  or Alejandro Hoyos at  [email protected] .

Learn about U.S. Bank

Related content.

High-yield bond issuance: 5 traits lawyers should look for in a service provider

Top 3 considerations when selecting an IPA partner

Case study: U.S. asset manager expands to Europe

High-yield bond issuance: how to avoid 5 common pain points

Programme debt clients want reliable service – no matter where they’re based

3 innovative approaches to ESG investing in Europe

European outlook: Trustee experience more important than ever

The ongoing evolution of custody: Tips for renewing your custody contract

Emerging trends in Europe: An outlook from multiple perspectives

The benefit of a multi-jurisdictional European trustee

Maximizing your infrastructure finance project with a full suite trustee and agent

Employee benefit plan management: trustee vs. custodian

4 benefits of independent loan agents

Digital processes streamline M&A transactions

An asset manager’s secret to saving time and money

At your service: outsourcing loan agency work

Middle-market direct lending: Obstacles and opportunities

Managing complex transactions: what your corporate trustee should be doing

Depositary bank and collateral agent

Disclosures.

Loan approval is subject to credit approval and program guidelines. Not all loan programs are available in all states for all loan amounts. Interest rates and program terms are subject to change without notice. Mortgage, home equity and credit products are offered by U.S. Bank National Association. Deposit products are offered by U.S. Bank National Association. Member FDIC.

• Project Finance

Structuring, Valuation and Risk Management for Major Projects

• © 2022
• B Rajesh Kumar 0

Dubai International Academic City, Institute of Management Technology, Dubai, United Arab Emirates

You can also search for this author in PubMed   Google Scholar

• Includes insightful case studies on finance in major projects
• Discusses both theoretical perspectives and practical aspects of project finance
• Presents a framework for evaluating structure, value and risk

Part of the book series: Management for Professionals (MANAGPROF)

95k Accesses

11 Citations

This is a preview of subscription content, log in via an institution to check access.

Access this book

• Available as EPUB and PDF
• Read on any device
• Instant download
• Own it forever
• Compact, lightweight edition
• Dispatched in 3 to 5 business days
• Free shipping worldwide - see info
• Durable hardcover edition

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (54 chapters)

Front matter, trends in infrastructure industry.

B Rajesh Kumar

Infrastructure Financing Instruments

Risks inherent in project finance and its mitigation, structuring and implementation of the project, case 1: the chuo shinkansen project, japan, case 2: developing the world’s largest passenger aircraft-airbus a3xx, case 3: south north water transfer project china, case 4: dubailand project, case 5: international space station, case 6: al maktoum international airport, case 7: california high speed rail project, case 8: london cross rail project, case 9: beijing daxing international airport, case: 10 jubail ii industrial city, case 11: hong kong zhuhai macao bridge (hzmb), case 12: gotthard base tunnel (gbt), case 13: channel tunnel uk, case 14: doha metro, case 15: panama canal expansion.

• Structured Finance
• Financial Engineering
• Corporate Finance
• Project Management

About this book

Large projects are defining moments for companies and countries. When large projects succeed, they can dramatically improve the social and economic conditions in a region. This book focuses on major aspects of the world’s largest infrastructural, industrial and public service projects through the lens of structuring, valuing, managing risk and financing projects. The book analyses and discuss large projects in government, private and public and private partnership. The author sheds light into the attributes of project finance which have unique structural elements. The book focuses on case studies related to 50 mega projects which includes infrastructural projects, energy related projects, industrial projects, roads, ports and bridges among others. This book covers both the theoretical aspects of financing of mega projects and the practical applications by including case studies of the world’s largest projects in terms of value.

Authors and Affiliations

About the author.

B. Rajesh Kumar  is a professor of finance at IMT Dubai (UAE). He received his Ph.D. from the Indian Institute of Technology Kharagpur (IIT Kharagpur, India). His research interests are in areas of applied corporate finance, valuation, M&A   and sustainability.  He has authored over 65 empirical research papers in refereed journals and seven scholarly books published by publishers such as Springer, Academic Press-Elsevier, Palgrave Macmillan and McGraw-Hill.

Bibliographic Information

Book Title : Project Finance

Book Subtitle : Structuring, Valuation and Risk Management for Major Projects

Authors : B Rajesh Kumar

Series Title : Management for Professionals

DOI : https://doi.org/10.1007/978-3-030-96725-3

Publisher : Springer Cham

eBook Packages : Economics and Finance , Economics and Finance (R0)

Copyright Information : The Editor(s) (if applicable) and The Author(s), under exclusive license to Springer Nature Switzerland AG 2022

Hardcover ISBN : 978-3-030-96724-6 Published: 04 May 2022

Softcover ISBN : 978-3-030-96727-7 Published: 05 May 2023

eBook ISBN : 978-3-030-96725-3 Published: 03 May 2022

Series ISSN : 2192-8096

Series E-ISSN : 2192-810X

Edition Number : 1

Number of Pages : XV, 332

Topics : Business Finance , Risk Management , Project Management , Industries

• Publish with us

Policies and ethics

• Find a journal
• Track your research

• Harvard Business School →
• Faculty & Research →

Project Finance Portal

• Format: Print
• | Language: English

About The Author

Benjamin C. Esty

More from the author.

• January 2024
• Faculty Research

Pioneer Natural Resources: Enhancing the Capital Return Strategy with Variable Dividends

• December 2023 (Revised April 2024)

Yellow Corporation: On the Verge of Bankruptcy

• Pioneer Natural Resources: Enhancing the Capital Return Strategy with Variable Dividends  By: Benjamin C. Esty, Elisabeth Kempf and Scott Mayfield
• Yellow Corporation: On the Verge of Bankruptcy  By: Benjamin C. Esty and Edward A. Meyer

• Browse All Articles
• Newsletter Sign-Up

• 22 Apr 2024
• Research & Ideas

When Does Impact Investing Make the Biggest Impact?

More investors want to back businesses that contribute to social change, but are impact funds the only approach? Research by Shawn Cole, Leslie Jeng, Josh Lerner, Natalia Rigol, and Benjamin Roth challenges long-held assumptions about impact investing and reveals where such funds make the biggest difference.

• 23 Jan 2024

More Than Memes: NFTs Could Be the Next Gen Deed for a Digital World

Non-fungible tokens might seem like a fad approach to selling memes, but the concept could help companies open new markets and build communities. Scott Duke Kominers and Steve Kaczynski go beyond the NFT hype in their book, The Everything Token.

• 12 Sep 2023

How Can Financial Advisors Thrive in Shifting Markets? Diversify, Diversify, Diversify

Financial planners must find new ways to market to tech-savvy millennials and gen Z investors or risk irrelevancy. Research by Marco Di Maggio probes the generational challenges that advisory firms face as baby boomers retire. What will it take to compete in a fintech and crypto world?

• 17 Aug 2023

‘Not a Bunch of Weirdos’: Why Mainstream Investors Buy Crypto

Bitcoin might seem like the preferred tender of conspiracy theorists and criminals, but everyday investors are increasingly embracing crypto. A study of 59 million consumers by Marco Di Maggio and colleagues paints a shockingly ordinary picture of today's cryptocurrency buyer. What do they stand to gain?

• 17 Jul 2023

Money Isn’t Everything: The Dos and Don’ts of Motivating Employees

Dangling bonuses to checked-out employees might only be a Band-Aid solution. Brian Hall shares four research-based incentive strategies—and three perils to avoid—for leaders trying to engage the post-pandemic workforce.

• 20 Jun 2023
• Cold Call Podcast

Elon Musk’s Twitter Takeover: Lessons in Strategic Change

In late October 2022, Elon Musk officially took Twitter private and became the company’s majority shareholder, finally ending a months-long acquisition saga. He appointed himself CEO and brought in his own team to clean house. Musk needed to take decisive steps to succeed against the major opposition to his leadership from both inside and outside the company. Twitter employees circulated an open letter protesting expected layoffs, advertising agencies advised their clients to pause spending on Twitter, and EU officials considered a broader Twitter ban. What short-term actions should Musk take to stabilize the situation, and how should he approach long-term strategy to turn around Twitter? Harvard Business School assistant professor Andy Wu and co-author Goran Calic, associate professor at McMaster University’s DeGroote School of Business, discuss Twitter as a microcosm for the future of media and information in their case, “Twitter Turnaround and Elon Musk.”

• 06 Jun 2023

The Opioid Crisis, CEO Pay, and Shareholder Activism

In 2020, AmerisourceBergen Corporation, a Fortune 50 company in the drug distribution industry, agreed to settle thousands of lawsuits filed nationwide against the company for its opioid distribution practices, which critics alleged had contributed to the opioid crisis in the US. The $6.6 billion global settlement caused a net loss larger than the cumulative net income earned during the tenure of the company’s CEO, which began in 2011. In addition, AmerisourceBergen’s legal and financial troubles were accompanied by shareholder demands aimed at driving corporate governance changes in companies in the opioid supply chain. Determined to hold the company’s leadership accountable, the shareholders launched a campaign in early 2021 to reject the pay packages of executives. Should the board reduce the executives’ pay, as of means of improving accountability? Or does punishing the AmerisourceBergen executives for paying the settlement ignore the larger issue of a business’s responsibility to society? Harvard Business School professor Suraj Srinivasan discusses executive compensation and shareholder activism in the context of the US opioid crisis in his case, “The Opioid Settlement and Controversy Over CEO Pay at AmerisourceBergen.”

• 16 May 2023
• In Practice

After Silicon Valley Bank's Flameout, What's Next for Entrepreneurs?

Silicon Valley Bank's failure in the face of rising interest rates shook founders and funders across the country. Julia Austin, Jeffrey Bussgang, and Rembrand Koning share key insights for rattled entrepreneurs trying to make sense of the financing landscape.

• 27 Apr 2023

Equity Bank CEO James Mwangi: Transforming Lives with Access to Credit

James Mwangi, CEO of Equity Bank, has transformed lives and livelihoods throughout East and Central Africa by giving impoverished people access to banking accounts and micro loans. He’s been so successful that in 2020 Forbes coined the term “the Mwangi Model.” But can we really have both purpose and profit in a firm? Harvard Business School professor Caroline Elkins, who has spent decades studying Africa, explores how this model has become one that business leaders are seeking to replicate throughout the world in her case, “A Marshall Plan for Africa': James Mwangi and Equity Group Holdings.” As part of a new first-year MBA course at Harvard Business School, this case examines the central question: what is the social purpose of the firm?

• 25 Apr 2023

Using Design Thinking to Invent a Low-Cost Prosthesis for Land Mine Victims

Bhagwan Mahaveer Viklang Sahayata Samiti (BMVSS) is an Indian nonprofit famous for creating low-cost prosthetics, like the Jaipur Foot and the Stanford-Jaipur Knee. Known for its patient-centric culture and its focus on innovation, BMVSS has assisted more than one million people, including many land mine survivors. How can founder D.R. Mehta devise a strategy that will ensure the financial sustainability of BMVSS while sustaining its human impact well into the future? Harvard Business School Dean Srikant Datar discusses the importance of design thinking in ensuring a culture of innovation in his case, “BMVSS: Changing Lives, One Jaipur Limb at a Time.”

• 18 Apr 2023

What Happens When Banks Ditch Coal: The Impact Is 'More Than Anyone Thought'

Bank divestment policies that target coal reduced carbon dioxide emissions, says research by Boris Vallée and Daniel Green. Could the finance industry do even more to confront climate change?

The Best Person to Lead Your Company Doesn't Work There—Yet

Recruiting new executive talent to revive portfolio companies has helped private equity funds outperform major stock indexes, says research by Paul Gompers. Why don't more public companies go beyond their senior executives when looking for top leaders?

• 11 Apr 2023

A Rose by Any Other Name: Supply Chains and Carbon Emissions in the Flower Industry

Headquartered in Kitengela, Kenya, Sian Flowers exports roses to Europe. Because cut flowers have a limited shelf life and consumers want them to retain their appearance for as long as possible, Sian and its distributors used international air cargo to transport them to Amsterdam, where they were sold at auction and trucked to markets across Europe. But when the Covid-19 pandemic caused huge increases in shipping costs, Sian launched experiments to ship roses by ocean using refrigerated containers. The company reduced its costs and cut its carbon emissions, but is a flower that travels halfway around the world truly a “low-carbon rose”? Harvard Business School professors Willy Shih and Mike Toffel debate these questions and more in their case, “Sian Flowers: Fresher by Sea?”

Is Amazon a Retailer, a Tech Firm, or a Media Company? How AI Can Help Investors Decide

More companies are bringing seemingly unrelated businesses together in new ways, challenging traditional stock categories. MarcAntonio Awada and Suraj Srinivasan discuss how applying machine learning to regulatory data could reveal new opportunities for investors.

• 07 Apr 2023

When Celebrity ‘Crypto-Influencers’ Rake in Cash, Investors Lose Big

Kim Kardashian, Lindsay Lohan, and other entertainers have been accused of promoting crypto products on social media without disclosing conflicts. Research by Joseph Pacelli shows what can happen to eager investors who follow them.

• 31 Mar 2023

Can a ‘Basic Bundle’ of Health Insurance Cure Coverage Gaps and Spur Innovation?

One in 10 people in America lack health insurance, resulting in $40 billion of care that goes unpaid each year. Amitabh Chandra and colleagues say ensuring basic coverage for all residents, as other wealthy nations do, could address the most acute needs and unlock efficiency.

• 23 Mar 2023

As Climate Fears Mount, More Investors Turn to 'ESG' Funds Despite Few Rules

Regulations and ratings remain murky, but that's not deterring climate-conscious investors from paying more for funds with an ESG label. Research by Mark Egan and Malcolm Baker sizes up the premium these funds command. Is it time for more standards in impact investing?

• 14 Mar 2023

What Does the Failure of Silicon Valley Bank Say About the State of Finance?

Silicon Valley Bank wasn't ready for the Fed's interest rate hikes, but that's only part of the story. Victoria Ivashina and Erik Stafford probe the complex factors that led to the second-biggest bank failure ever.

• 13 Mar 2023

What Would It Take to Unlock Microfinance's Full Potential?

Microfinance has been seen as a vehicle for economic mobility in developing countries, but the results have been mixed. Research by Natalia Rigol and Ben Roth probes how different lending approaches might serve entrepreneurs better.

• 16 Feb 2023

ESG Activists Met the Moment at ExxonMobil, But Did They Succeed?

Engine No. 1, a small hedge fund on a mission to confront climate change, managed to do the impossible: Get dissident members on ExxonMobil's board. But lasting social impact has proved more elusive. Case studies by Mark Kramer, Shawn Cole, and Vikram Gandhi look at the complexities of shareholder activism.

• International Center for Finance
• ICF Case Studies

Finance Case Studies

Featured finance case studies:.

Canary Wharf: Financing and Placemaking

Fondaco dei Tedeschi: A New Luxury Shopping Destination for Venice

Nathan Cummings Foundation: Mission-Driven Investing

The Decline of Malls

Expand the sections below to read more about each case study:, nathan cummings foundation, ellie campion, dwayne edwards, brad wayman, anna williams, william goetzmann, and jean rosenthal.

Asset Management, Investor/Finance, Leadership & Teamwork, Social Enterprise, Sourcing/Managing Funds

The Nathan Cummings Foundation Investment Committee and Board of Trustees had studied the decision to go “all in” on a mission-related investment approach. The Board voted 100% to support this new direction and new goals for financial investments, but many questions remained. How could NCF operationalize and integrate this new strategy? What changes would it need to make to support the investment strategies' long-term success? How could NCF measure and track its progress and success with this new strategy?

William Goetzmann, Jean Rosenthal, Jaan Elias, Edoardo Pasinato, Lukas Cejnar, Ellie Campion

Business History, Competitor/Strategy, Customer/Marketing, Innovation & Design, Investor/Finance, Sourcing/Managing Funds, State & Society

The renovation of the Fondaco dei Tedeschi in Venice represented a grand experiment. Should an ancient building in the midst of a world heritage site be transformed into a modern mall for luxury goods? How best to achieve the transformation and make it economically sustainable? Would tourists walk to the mall? And would they buy or just look? What could each stakeholder learn from their experiences with the Fondaco dei Tedeschi?

Gardner Denver

James quinn, adam blumenthal, and jaan elias.

Asset Management, Employee/HR, Investor/Finance, Leadership & Teamwork

As KKR, a private equity firm, prepared to take Gardner-Denver, one of its portfolio companies, public in mid-2017, a discussion arose on the Gardner-Denver board about the implications of granting approximately $110 million in equity to its global employee base as part of its innovative "broad-based employee ownership program." Was the generous equity package that Pete Stavros proposed be allotted to 6,100 employees the wisest move and the right timing for Gardner Denver and its new shareholders?

Home Health Care

Jean rosenthal, jaan elias, adam blumenthal, and jeremy kogler.

Asset Management, Competitor/Strategy, Healthcare, Investor/Finance

Blue Wolf Capital Partners was making major investments in the home health care sector. The private equity fund had purchased two U.S. regional companies in the space. The plan was to merge the two organizations, creating opportunities for shared expertise and synergies in reducing management costs. Two years later, the management team was considering adding a third company. Projected revenues for the combined organization would top $1 billion annually. What was the likelihood that this opportunity would succeed?

Suwanee Lumber Company

Jaan elias, adam blumenthal, james shovlin, and heather e. tookes.

Asset Management, Investor/Finance, Sustainability

In 2016, Blue Wolf, a private equity firm headquartered in New York City, confronted a number of options when it came to its lumber business. They could put their holdings in the Suwanee Lumber Company (SLC), a sawmill they had purchased in 2013, up for sale. Or they could continue to hold onto SLC and run it as a standalone business. Or they could double down on the lumber business by buying an idle mill in Arkansas to run along with SLC.

Alternative Meat Industry: How Should Beyond Meat be Valued?

Nikki springer, leon van wyk, jacob thomas, k. geert rouwenhorst and jaan elias.

Competitor/Strategy, Customer/Marketing, Investor/Finance, Sourcing/Managing Funds, Sustainability

In 2009, when experienced entrepreneur Ethan Brown decided to build a better veggie burger, he set his sights on an exceptional goal – create a plant-based McDonald’s equally beloved by the American appetite. To do this, he knew he needed to transform the idea of plant-based meat alternatives from the sleepy few veggie burger options in the grocer’s freezer case into a fundamentally different product. Would further investments in research and development help give Beyond Meat an edge? Would Americans continue to embrace meat alternatives, or would the initial fanfare subside below investor expectations?

Hertz Global Holdings (A): Uses of Debt and Equity

Jean rosenthal, geert rouwenhorst, jacob thomas, allen xu.

Asset Management, Financial Regulation, Sourcing/Managing Funds

By 2019, Hertz CEO Kathyrn Marinello and CFO Jamere Jackson had managed to streamline the venerable car rental firm's operations. Their next steps were to consider ways to fine-tune Hertz's capital structure. Would it make sense for Marinello and Jackson to lead Hertz to issue more equity to re-balance the structure? One possibility was a stock rights offering, but an established company issuing equity was not generally well-received by investors. How well would the market respond to an attempt by Hertz management to increase shareholder equity?

Twining-Hadley Incorporated

Jaan elias, k geert rouwenhorst, jacob thomas.

Employee/HR, Investor/Finance, Metrics & Data, Sourcing/Managing Funds

Jessica Austin has been asked to compute THI's Weighted Average Cost of Capital, a key measure for making investments and deciding executive compensation. What should she consider in making her calculation?

Shake Shack IPO

Vero bourg-meyer, jaan elias, jake thomas and geert rouwenhorst.

Competitor/Strategy, Innovation & Design, Investor/Finance, Leadership & Teamwork, Sourcing/Managing Funds, Sustainability

Shake Shack's long lines of devoted fans made investors salivate when the company went public in 2015 and shares soared above expectations. Was the enthusiasm justified? Could the company maintain its edge in the long run?

Strategy for Norway's Pension Fund Global

Jean rosenthal, william n. goetzmann, olav sorenson, andrew ang, and jaan elias.

Asset Management, Investor/Finance, Sourcing/Managing Funds

Norway's Pension Fund Global was the largest sovereign wealth fund in the world. With questions in 2014 on policies, ethical investment, and other concerns, what was the appropriate investment strategy for the Fund?

Factor Investing for Retirement

Jean rosenthal, jaan elias and william goetzmann.

Asset Management, Investor/Finance

Should this investor look for a portfolio of factor funds to meet his goals for his 401(k) Retirement Plan?

Bank of Ireland

Jean w. rosenthal, eamonn walsh, matt spiegel, will goetzmann, david bach, damien p. mcloughlin, fernando fernandez, gayle allard, and jaan elias.

Asset Management, Financial Regulation, Investor/Finance, Leadership & Teamwork, Macroeconomics, State & Society

In August 2011, Wilbur Ross, an American investor specializing in distressed and bankrupt companies, purchased 35% of the stock of Bank of Ireland. Even for Ross, investing in an Irish bank seemed risky. Observers wondered if the investment made sense.

Commonfund ESG

Jaan elias, sarah friedman hersh, maggie chau, logan ashcraft, and pamela jao.

Asset Management, Investor/Finance, Metrics & Data, Social Enterprise

ESG (Environmental Social and Governance) investing had become an increasingly hot topic in the financial community. Could Commonfund offer its endowment clients some investment vehicle that would satisfy ESG concerns while producing sufficient returns?

Glory, Glory Man United!

Charles euvhner, jacob thomas, k. geert rouwenhorst, and jaan elias.

Competitor/Strategy, Employee/HR, Investor/Finance, Leadership & Teamwork, Sourcing/Managing Funds

Manchester United might be the greatest English sports dynasty of all time. But valuation poses unique challenges. How much should a team's success on the pitch count toward its net worth?

Walmart de México: Investing in Renewable Energy

Jean rosenthal, k. geert rouwenhorst, isabel studer, jaan elias, and juan carlos rivera.

Investor/Finance, Operations, State & Society, Sustainability

Walmart de México y Centroamérica contracted for power from EVM's wind farm, saving energy costs and improving sustainability. What should the company's next steps be to advance its goals?

Voltaire, Casanova, and 18th-Century Lotteries

Jean rosenthal and william n. goetzmann.

Business History, State & Society

Gambling has been a part of human activity since earliest recorded history, and governments have often attempted to turn that impulse to benefit the state.  The development of lotteries in the 18th century helped to develop the study of probabilities and enabled the financial success of some of the leading figures of that era.

Alexander Hamilton and the Origin of American Finance

Andrea nagy smith, william goetzmann, and jeffrey levick.

Business History, Financial Regulation, Investor/Finance

Alexander Hamilton is said to have invented the future. At a time when the young United States of America was disorganized and bankrupt, Hamilton could see that the nation would become a powerful economy.

Kmart Bankruptcy

Jean rosenthal, heather tookes, henry s. miller, and jaan elias.

Asset Management, Financial Regulation, Investor/Finance

Less than 18 months after Kmart entered Chapter 11, the company emerged and its stocked soared. Why had the chain entered Chapter 11 in the first place and how had the bankruptcy process allowed the company to right itself?

Oil, ETFs, and Speculation

So alex roelof, k. geert rouwenhorst, and jaan elias.

Since the markets' origins, traders sought standardized wares to increase market liquidity. In the 1960s and later, they sought assets uncorrelated to traditional bonds and equities. By late 2004, commodity-based exchange-traded securities emerged.

Newhall Ranch Land Parcel

Acquired by a partnership of two closely intertwined homebuilders, Newhall Ranch was the last major tract of undeveloped land in Los Angeles County in 2003.

Brandeis and the Rose Museum

Arts Management, Asset Management, Investor/Finance, Social Enterprise, Sourcing/Managing Funds

The question of the role museums should play in university life became urgent for Brandeis in early 2009. Standard portfolios of investments had just taken a beating. Given that environment, should Brandeis sell art in order to save its other programs?

Taking EOP Private

Allison mitkowski, william goetzmann, and jaan elias.

Asset Management, Financial Regulation, Investor/Finance, Leadership & Teamwork

With 594 properties nationwide, EOP was the nation’s largest office landlord.  Despite EOP's dominance of the REIT market, analysts had historically undervalued EOP. However, Blackstone saw something in EOP that the analysts didn’t, and in November, Blackstone offered to buy EOP for $48.50 per share. What did Blackstone and Vornado see that the market didn’t?

Subprime Lending Crisis

Jaan elias and william n. goetzmann.

Asset Management, Financial Regulation, Investor/Finance, State & Society

To understand the collapse of the subprime mortgage market, we look at a failing Mortgage Backed Security (MBS) and then drill down to look at a single loan that has gone bad.

William N. Goetzmann, Jean Rosenthal, and Jaan Elias

Asset Management, Business History, Customer/Marketing, Entrepreneurship, Innovation & Design, Investor/Finance, Sourcing/Managing Funds, State & Society

The financial engineering of London's Canary Wharf was as impressive as the structural engineering. However, Brexit and the rise of fintech represented new challenges. Would financial firms leave the U.K.? Would fintech firms seek new kinds of space? How should the Canary Wharf Group respond?

The Future of Malls: Was Decline Inevitable?

Jean rosenthal, anna williams, brandon colon, robert park, william goetzmann, jessica helfand  .

Business History, Customer/Marketing, Innovation & Design, Investor/Finance

Shopping malls became the "Main Street" of US suburbs beginning in the mid-20th century. But will they persist into the 21st?

Hirtle Callaghan & Co

James quinn, jaan elias, and adam blumenthal.

Asset Management, Investor/Finance, Leadership & Teamwork

In August 2019, Stephen Vaccaro, Yale MBA ‘03, became the director of private equity at Hirtle, Callaghan & Co., LLC (HC), a leading investment management firm associated with pioneering the outsourced chief investment office (OCIO) model for college endowments, foundations, and wealthy families. Vaccaro was tasked with spearheading efforts to grow HC’s private equity (PE) market value from $1 billion to a new target of roughly $3 billion in order to contribute to the effort of generating higher long-term returns for clients. Would investment committees overseeing endowments typically in the 10s or 100s of millions embrace this shift, and, more pointedly, was this the best move for client portfolios?

The Federal Reserve Response to 9-11

Jean rosenthal, william b. english, jaan elias.

Financial Regulation, Investor/Finance, Leadership & Teamwork, State & Society

The attacks on New York City and the Pentagon in Washington, DC, on September 11, 2001, shocked the nation and the world. The attacks crippled the nerve center of the U.S. financial system. Information flow among banks, traders in multiple markets, and regulators was interrupted. Under Roger Ferguson's leadership, the Federal Reserve made a series of decisions designed to provide confidence and increase liquidity in a severely damaged financial system. In hindsight, were these the best approaches? Were there other options that could have taken place?

Suwanee Lumber Company (B)

In early 2018, Blue Wolf Capital Management received an offer to sell both its mill in Arkansas (Caddo) and its mill in Florida (Suwanee) to Conifex, an upstart Canadian lumber company. Blue Wolf hadn’t planned to put both mills up for sale yet, but was the deal too good to pass up? Blue Wolf had invested nearly $36.5 million into rehabilitating the Suwanee and Caddo mills. However, neither was fully operational yet. Did the offer price fairly value the prospects of the mills? How should Blue Wolf consider the Conifex stock? Should Blue Wolf conduct a more extensive sales process rather than settle for this somewhat unexpected offer?

Occidental Petroleum's Acquisition of Anadarko

Jaan elias, piyush kabra, jacob thomas, k. geert rouwenhorst.

Asset Management, Competitor/Strategy, Investor/Finance, Sourcing/Managing Funds

In May of 2019, Vicki Hollub, the CEO of Occidental Petroleum (Oxy), pulled off a blockbuster. Bidding against Chevron, one of the world's largest oil firms, she had managed to buy Anadarko, another oil company that was roughly the size of Oxy. Hollub believed that the combination of the two firms brought the possibility for billions of dollars in synergies, more than offsetting the cost of the acquisition. Had Hollub hurt shareholder value with Oxy's ambitious deal, or had she bolstered a mid-size oil firm and made it a major player in the petroleum industry? Why didn't investors see the tremendous synergies in which Hollub fervently believed?

Hertz Global Holdings (B): Uses of Debt and Equity 2020

In 2019, Hertz held a successful rights offering and restructured some of its debt. CEO Kathyrn Marinello and CFO Jamere Jackson were moving the company toward what seemed to be sustainable profitability, having implemented major structural and financial reforms. Analysts predicted a rosy future. Travel, particularly corporate travel, was increasing as the economy grew. With all the creativity that the company had shown in its financial arrangements, did it have any options remaining, even while under the court-led reorganization?

Prodigy Finance

Vero bourg-meyer, javier gimeno, jaan elias, florian ederer.

Competitor/Strategy, Investor/Finance, Social Enterprise, State & Society, Sustainability

Having pioneered a successful financing model for student loans, Prodigy also was considering other financial services that could make use of the company’s risk model. What new products could Prodigy offer to support its student borrowers? What strategy should guide the company’s new product development? Or should the company stick to the educational loans it pioneered and knew best?

tronc: Valuing the Future of Newspapers

Jean rosenthal, heather e. tookes, and jaan elias.

Business History, Competitor/Strategy, Investor/Finance, Leadership & Teamwork

Gannet offered Tribune Publishing an all-cash buyout offer. Tribune then made a strategic pivot: new stock listing, new name "tronc," and a goal of posting 1,000 videos/day. Should the Tribune board take the buyout opportunity? What was the right price?

Role of Hedge Funds in Institutional Portfolios: Florida Retirement System

Jaan elias, william goetzmann and lloyd baskin.

Asset Management, Financial Regulation, Investor/Finance, Metrics & Data, State & Society

The Florida Retirement System, one of the country’s largest state pensions, had been slow to embrace hedge funds, but by 2015, they had 7% of their assets in the category. How should they manage their program?

Social Security 1935

Jean rosenthal, william n. goetzmann, and jaan elias.

Business History, Financial Regulation, Innovation & Design, Investor/Finance, State & Society

Frances Perkins, Franklin Roosevelt's Secretary of Labor, shaped the Social Security Act of 1935, changing America’s pension landscape. What might she have done differently?

Ant Financial: Flourishing Farmer Loans at MYbank

Jingyue xu, jean rosenthal, k. sudhir, hua song, xia zhang, yuanfang song, xiaoxi liu, and jaan elias.

Competitor/Strategy, Customer/Marketing, Entrepreneurship, Innovation & Design, Investor/Finance, Leadership & Teamwork, Operations, State & Society

In 2015 Ant Financial's MYbank (an offshoot of Jack Ma’s Alibaba company) created the Flourishing Farmer Loan program, an all-internet banking service for China's rural areas. Could MYbank use financial technology to create a program with competitive costs and risk management?

Low-Carbon Investing: Commonfund & GPSU

Jaan elias, william goetzmann, and k. geert rouwenhorst.

Asset Management, Ethics & Religion, Investor/Finance, Social Enterprise, State & Society, Sustainability

In August of 2014, the movement to divest fossil fuel investments from endowment portfolios was sweeping campuses across the United States, including Gifford Pinchot State University (GPSU). How should GPSU and its investment partner Commonfund react?

360 State Street: Real Options

Andrea nagy smith and mathew spiegel.

Asset Management, Investor/Finance, Metrics & Data, Sourcing/Managing Funds

360 State Street proved successful, but what could Bruce Becker construct on the 6,000-square-foot vacant lot at the southwest corner of the project? Under what set of circumstances and at what time would it be most advantageous to proceed? Or should he build anything at all?

Centerbridge

Jean rosenthal and olav sorensen.

When Jeffrey Aronson and Mark Gallogly founded Centerbridge, they hoped to grow the firm, but not to a point that it would lose its culture. Having added an office in London, could the firm add more locations and maintain its collegial character?

George Hudson and the 1840s Railway Mania

Andrea nagy smith, james chanos, and james spellman.

Business History, Financial Regulation, Investor/Finance, Metrics & Data

Railways were one of the original disruptive technologies: they transformed England from an island of slow, agricultural villages into a fast, urban, industrialized nation.  George Hudson was the central figure in the mania for railroad shares in England. After the share value crashed, some analysts blamed Hudson, others pointed to irrational investors and still others maintained the crash was due to macroeconomic factors.

Demosthenes and Athenian Finance

Andrea nagy smith and william goetzmann.

Business History, Financial Regulation, Law & Contracts

Demosthenes' Oration 35, "Against Lacritus," contains the only surviving maritime loan contract from the fourth century B.C., proving that the ancient Greeks had devised a commercial code to link the economic lives of people from all over the Greek world.   Athenians and non-Athenians alike came to the port of Piraeus to trade freely.

South Sea Bubble

Frank newman and william goetzmann.

Business History, Financial Regulation

The story of the South Sea Company and its seemingly absurd stock price levels always enters into conversations about modern valuation bubbles.  Because of its modern application, discerning what was at the root of the world's first stock market crash merits considerable attention. What about the South Sea Company and the political, economic and social context in which it operated led to its stunning collapse?

Jean W. Rosenthal, Jaan Elias, William N. Goetzmann, Stanley Garstka, and Jacob Thomas

Asset Management, Healthcare, Investor/Finance, Sourcing/Managing Funds, State & Society

A centerpiece of the 2007 contract negotiations between the UAW and GM - and later with Chrysler and Ford - was establishing a Voluntary Employee Beneficiary Association (VEBA) to provide for retiree healthcare costs. The implications were substantial.

Northern Pulp: A Private Equity Firm Resurrects a Troubled Paper Company

Heather tookes, peter schott, francesco bova, jaan elias and andrea nagy smith.

Investor/Finance, Macroeconomics, State & Society, Sustainability

In 2008, the lumber industry was in a severe recession, yet Blue Wolf Capital Management was considering investment in a paper mill in Nova Scotia. How should they proceed?

Lahey Clinic: North Shore Expansion

Jaan elias, andrea r. nagy, jessica p. strauss, and william n. goetzmann.

Asset Management, Financial Regulation, Healthcare, Investor/Finance

In early 2007 the Lahey Clinic in Massachusetts believed that expansion of its North Shore facility was not only a smart strategy but also a business necessity.  The two years of turmoil in the Massachusetts health care market prompted observers to question Lahey's 2007 decisions. Did the expansion strategy still make sense?

Carry Trade ETF

K. geert rouwenhorst, jean w. rosenthal, and jaan elias.

Innovation & Design, Investor/Finance, Macroeconomics, Sourcing/Managing Funds

In 2006 Deutsche Bank (DB) brought a new product to market – an exchange traded fund (ETF) based on the carry trade, a strategy of buying and selling currency futures. The offering received the William F. Sharpe Indexing Achievement Award for “Most Innovative Index Fund or ETF” at the 2006 Sharpe Awards. These awards are presented annually by IndexUniverse.com and Information Management Network for innovative advances in the indexing industry. The carry trade ETF shared the award with another DB/PowerShares offering, a Commodity Index Tracking Fund. Jim Wiandt, publisher of IndexUniverse.com, said, "These innovators are shaping the course of the index industry, creating new tools and providing new insights for the benefit of all investors." What was it that made this financial innovation successful?

William Goetzmann and Jaan Elias

Asset Management, Business History

Hawara is the site of the massive pyramid of Amenemhat III, a XII Dynasty [Middle Kingdom, 1204 – 1604 B.C.E.] pharaoh.  The Hawara Labyrinth and Pyramid Complex present a wealth of information about the Middle Kingdom.  Among its treasures are papyri covering property rights and transfers of ownership.

Edward Bodmer – Project and Corporate Finance

Resolving BS in Project Finance

Project Finance Model Case Study of Solar

This page includes a couple of case studies on creating a solar project finance model, about the simplest model structure you can imagine.  I have put together a file with titles that illustrate how you can start from the fundamental operations and end up with investor returns and credit risk measures.  I have also put some other simple solar models on this page. My hope is that this exercise will not take too long.  I have also included a case write-up that is used in testing people. Below the simple solar project model I have put in a more complex case for a thermal construction project.

A-Z Exercise with Selected Existing Titles for Solar Model

I was asked to prepare an exercise where people could quickly make a model that evaluates bid prices and other model aspects and can get you most of the result without spending too much time on some of the horrible details that can make project finance modelling so difficult.  I was told that making a relatively simple project finance model could not be taught in a single day.  This is not true.  You can see the essentials of making a model including describing inputs, establishing operating cash flow, computing depreciation and project IRR, incorporating debt, making a cash flow waterfall and computing some key financial ratios in a morning.

The file available for download does this for a simple solar case.  To make it really simple I have not even included a construction period and made the model and annual model.  For some items I have not included titles so that you can do the really important part of a model which is to structure the model.  For other parts, I have included titles so that you do not have to waste a lot of time typing.  The exercise hopefully applies some of the fast modelling religion, meaning that it is flexible (except for the one period construction), it is accurate — the balance sheet balances and the debt is paid off; it is structured, where you start with physical operations and then move to revenues, expenses and capital expenditures and then to depreciation which allows you to compute operating taxes and project cash flow.  After project cash flow you incorporate debt with a sources and uses of funds statement, and a debt schedule.  Only after the debt schedule do you create the financial statements.  To download the file, press on the button below.

Excel File with Exercise to Create Basic Solar Project Finance Model Demonstrating Structuring Issues

Part 1: Timing

In the second part make a timing switch and use the EDATE function (FETCHA.MOIS) to compute the annual dates.  I have put some summary outputs at the top of the page.  Use the ALT and –> to group the rows and choose to not show the outputs.  In English you can use ALT, E, I, S to get the model started for 40 years.  With the GENERIC MACROS open, you can use the ALT, S combination.  The timing parts of the model are shown on the screenshot below (note that the latest version of the model has some different line items — I moved some of the stuff to the summary page.)

Part 2: Define Inputs

In the first part, you go to the operating data.  You use the INDEX function so you can select one of the scenarios.  Also put the developer tab in your excel and make a spinner box with the windscreen wiper method to use the form in other sheets.

After setting up the time line, pull the relevant inputs from the model from the operating page and from the debt page. The inputs should be discussed and you should see how to change the scenarios with your spinner box.  You should understand that the inputs are arranged in a proper order that separates operation from financing; that begins with physical operations; that includes ways to back into the contract price and that includes logical differentiation of the debt parts of the model.  When you have linked the outputs, use the CNTL, ALT, C sequence from the GENERIC MACROS to show the location of the inputs and to illustrate the structure of the model. The input section is shown on the screenshot below.

Part 3: Construct the Operations Section of the Model

In the first part of the model I have not provided the titles.  You are supposed to get to the volumes produced in MWH which is the basis for revenues.  To do this you need to know how much the solar capacity factor or yield will be.  I suggest you enter the driver of the formula in a left hand column, that you put in the units in a left hand column and that you use SHIFT, CNTL, R to quickly copy things to the right. You should also compute an index for degradation that begins in year 1 by taking the prior period and multiplying it by (1+degradation). Then you can divide the capacity by degradation and compute the capacity after degradation.  You can use whatever method you want to insert the rows.  You can create your own short-cut key for the underline.

Part 4: Revenues, Expenses, Capital Expenditures and Free Cash Flow

In any corporate finance model, M&A model, real estate model or project finance model, you will need revenues, expenses and capital expenditures.  The assumptions that create these three items (along with working capital) will drive all of the rest of the analysis.  In the next section you are to compute revenues, expenses and capital expenditures from the inputs.  I think it is a really good idea to put the drivers of each formula in a left hand column so you can be transparent (I hate looking around for where the numbers came from).  In this part of the analysis I have given you the titles as shown on the screenshot below. Once you have computed the project IRR you can use a goal seek and a macro to evaluate the required price.

Part 5: Depreciation, Operating Taxes and After Tax Free Cash Flow

If there were no taxes and you did not want to show a profit and loss statement you could eliminate this part of the model. With taxes, the shield from depreciation is an important item. Compute the depreciation by setting up an account with the balance of plant as shown below.  When you compute depreciation you can use the MIN function to make sure the depreciation does not exceed the net plant balance. Once you have the depreciation you can compute the EBIT, the taxes on EBIT, the after tax project cash flow and the project IRR.  The screenshot below illustrates this part of the model.

Part 6: Sources and Uses Prior to COD

Once you have completed the operating cash flow and operating taxes you can move to incorporating debt in the model.  In every project finance model there should be a sources and uses of funds for evaluating cash flows during the construction period.  You can think of this as a way to evaluate debt sizing.  In the example, you can fill in items on the sources and uses of funds from the inputs and items above the sources and uses.  Note that this is not realistic as items such as interest during construction and fees come from below not above and you get a circular reference.

Part 7: Debt Schedule

The debt schedule must have calculations for debt repayment, interest expenses and fees.  Repayment is often the most difficult aspect of a model.  There are alternative methods demonstrated to compute the repayment including flat repayment, mortgage repayment and inflated repayment that matches the cash flow when inflation is applied in the price.  Use the INDEX Function to select one of the three methods of repayment.  A screenshot is shown below.

Part 8: Profit and Loss Statement and Cash Flow Statement

Now you are to the easy part.  The only reason that an income statement is necessary in a project finance model is to compute taxes and to compute net income for purposes of balancing the balance sheet.  The cash flow statement can be more complex if there are cash sweeps, covenants and other items.

Part 9: Balance Sheet and Financial Ratios

The final part of the exercise is to put together a balance sheet and compute a couple of financial ratios. The balance sheet components should all come from items in the model and the equity balance should be computed.  Ratios like IRR, DSCR and LLCR come from the cash flow statement.

Exercise that Includes Construction Period

I was asked to prepare an exercise where people could quickly make a model that evaluates bid prices and other model aspects and can get you most of the result without spending too much time on some of the horrible details that can make project finance modelling so difficult.  I was told that making a relatively simple project finance model could not be taught in a single day.  This is not true.  You can see

Excel File with Exercise for Creating Combined Cycle Model with Timing and Construction Issues

Case Study Exercise on How You Can Evaluate and Existing Model

Some unlucky people have to create models and deal with circular references and many horrible details like withholding taxes on four tranches of debt.  More people have to interpret and use models that is arguably even more disagreeable because of the way models have become cumbersome and overly detailed.

This case study and exercise is designed so that you can more efficiently evaluate models created by other people including dissecting cash flow in the models, computing alternative financial ratios, adding your own scenario analysis, dissecting the model with sensitivity analysis, creating an summary page the conveys the transaction, making effective graphs the illustrate risks and finally formatting the model with nice colours and titles. My hope is that this exercise will be practical for you and that you can use some of the ideas in your current job immediately.

The file that I have used for this case is the completed case from the above model.  But it could be just about any project finance model, corporate model, M&A model or other financial analysis that has a few inputs and outputs.  The base model that I have chosen for this exercise is available for download by clicking on the button below.

Introduction to the Model Review Assignment

I have structured this assignment by attempting to explain the details of how to complete the excel stuff.  Then I have included questions that should be completed with only one or two sentences where you tell me the implications of the modelling tasks.  I have also provided titles for many of the items so that you do not have to waste a lot of time typing stuff and the exercise will not take too much time.  I strongly suggest that you do not do this exercise on an Apple computer; that you open and use the GENERIC MACRO file, the LOOKUP INTERPOLATE file and the SCENARIO REPORTER file to make the case go faster.  These three files are available for download below.

Generic Macro File that Allows you to Copy to the Right (Shift, CNTL, R) and to Colour and Format Sheets (CNTL, ALT, C)

Download Excel File with the Function for Interpolation Using Either Compound Growth or Linear Interpolation

Scenario Reporter File - With this File, you Open the File, then Copy the Scenario Sheet to Your File and Use the Buttons

Part 1: Dissecting Cash flow

Use the SUMIF function to get the data to annual amounts. When you use the SUMIF, click on the entire row.  Question – how does the IRR on the project and equity compare to overall stock market returns. Do you think this is realistic.

Part 2: Computing Alternative Financial Ratios

I hope that you learn to look at ratios other than the DSCR.  In this case you can examine the LLCR and the PLCR.  The only calculation you have to make for this is to use the SUMPRODUCT function below the cash flow statement with the interest rate index and to find the debt at COD from the sources and uses. Explain how to interpret the DSCR, LLCR and PLCR.

Part 3: Adding your Own Scenario Analysis

Use the scenario manager to add a scenario. In this case could you invent a few cases with different inputs.  To do this, you should first copy the scenario reporter from the scenario reporter file to the file used for the analysis. Then, you can add different scenarios with the following: the project cost, the life of the plant, the availability.  Then open the scenario reporter and create a scenario report.

Part 4: Dissecting the Model with Sensitivity Analysis

I have provided a scenario analysis with a base case, a downside case and an upside case.  I have also used the INDEX function to link the cases to the model inputs. Thirdly, I have used the TRANSPOSE function to isolate different variables so that you can compute the effect on the DSCR, LLCR and different IRR’s.  In this task you are to finish the sensitivity analysis and create a tornado diagram.  To finish the data table, you should select the area of the data table as illustrates on the screenshot below.

Part 5: Making Effective Graphs that Illustrate Cash Flow and Risks

In this part of the assignment I would like you to create a flexible graph that you can use to look at different cash flows and combinations of cash flow. Use the INDEX Function to make select different cash flows.

Part 6: Creating an Summary Page the Conveys Key Aspects of the Transaction

In this part of the assignment I would like you to create a summary page that can be used to illustrate the risks and the structure of the project finance transaction.  Unlike other parts of the assignment I have left this one open ended.

Part 7: Formatting the Model with Nice Colours and Titles

Review concepts.

In this final section I have included a couple of ideas that I think are important in financial modelling for finance analysis.  I have listed a couple of bullet points and some ways that you may think about the issues.  I have also included references to my set of power point slides that describe project finance theory.

• Essence of Project Finance Model versus Corporate Finance Model, see slides 36 to 43 in the presentation below.
• The philosophy of FAST. The philosophy of FAST is discusses on slides 8-23 in the slides below.
• Structure of Models. Explanation of the structure of a project finance model is in slides 68 to 72
• Scenario Analysis.  Explanation of scenario analysis can be found on a few slides in the file below: Slides 73 to 78

Power point slides where you can find discussion of these items is included in the file that you can download below.

Power Point Slides that Accompany Project Finance Modelling A-Z Analysis and On-line Course

Example of Actual Model for Solar Project Demonstrating Complexity and Size of Real Models

Office Hours - Mon:Sat - 9:00 AM : 7:00 PM

Project Finance case study

Robert owns an automotive manufacturing company known as ‘RD Manufacturing Private Limited’. He started the company 10 years ago. The company is doing very well with a turnover of 75 crores this year. The company is into manufacturing automobile parts and other essential components. Some of the best automotive brands in India are clients of ‘RD manufacturing’.

Till now, Robert’s company had an office in Mumbai and a manufacturing plant in Pune. Now, due to the rapid growth of the business, Robert’s clients have spoken to him about opening another plant in Jamshedpur. Therefore, now Robert is looking forward to expanding his business by opening another manufacturing unit at Jamshedpur. But he is worried about the funds for his new project. Taking the funds out of working capital will create a challenge for the existing customer and will hamper the working capital cycle.

Strategic Financial Decision

As a good businessman, this is not a good course of action. So he started to explore the options of raising the funds from the debt market, without disturbing the existing fund flow. He has good credit and can repay the loan from the revenue he gets from his project finance case study after completion. He foresees very good profit and rapid growth if he expands his company now. Thus, Robert’s rating as a business person and his extensive experience in the manufacturing industry is well known.

Read more about effective management of the working capital cycle here.

Financial Snapshots

Analysis from inputs.

Robert is especially looking for Non-recourse funding as a feature of the loan. Non-recourse funding means that he and the other shareholders of the borrower will have no personal liability in case of monetary default. Any recourse the lender may have will be limited primarily or entirely to the project assets if the project company defaults on the debt.

He didn’t know which loan to apply for or which financial institution to contact. While discussing his problem with a business friend, the name Terkar Capital came across. Thus, Robert approached Terkar Capital and we set up a meeting with him to understand the process of project financing.

Financial Analysis

Our executives met Robert and understood his requirements for the funding and his business. So, after a detailed discussion, we suggested that he should take Project Finance . This type of funding would be a perfect fit for him considering the viability of his project, payback period, and his personal experience and profile. 

The financial institution has to show that the project finance case study is viable to receive the loan. Therefore, we helped Robert prepare a report explaining his project and the financial position of the company. And that he is capable of paying off the loan from the revenue, that project generates. He also would not require any separate mortgage for the funding as the project itself will act as a mortgage for the loan. In the case of project funding , the funds can be generated as per the requirement, be it periodically or all at the same time. 

Robert got his project funding sanctioned in just 20 working days after approaching us. Robert’s new manufacturing plant has been doing very well now and he has almost repaid the entire loan amount. So, now, he is one of our loyal customers at Terkar Capital.

Project Financing at Terkar Capital

Terkar Capital understands the needs of entrepreneurs like Robert, who are seeking project funding services. With a personalized and human approach, our executives took the time to listen to Robert’s requirements and thoroughly assessed his business.

Recognizing the potential for growth and Robert’s credibility, we recommended Project Finance as the ideal solution. This allowed Robert to secure the necessary funds without disrupting his existing operations. Today, Robert’s manufacturing plant thrives, and he stands as a testament to our commitment to our loyal customers at Terkar Capital.

Our Operational Presence

Leave us your info

Do reach out to us with any questions or doubts. To ensure that you get the best service, please contact us before visiting.

Terkar Capital is a registered brand of Terkar Global Financial Development Pvt Ltd , is an Investment Banking Firm with a national footprint. We work extensively with professionals and businesses of all sizes to arrange debt funding instruments.

Financial Products

Unsecured debt funding, secured debt funding, professionals funding, cgtmse loan, machinery loan, financial instruments, book a call, emi calculator, download company profile, terkar capital.

In Association with:

Head Office

Castle Eleganza, 103, Bhonde Colony, Dr.Ketkar Road, Erandwane, Pune – 411004 [MH-India]

Mail Id: [email protected]

Cell: +91 8308629820, corporate office.

The Capital, Level 7, B-Wing, Plot C – 70, G Block, Bandra Kurla Complex, Bandra (East), Mumbai – 400051 [MH-India]

Mail: [email protected]

Cell: +91 7414973455, branch offices.

Nashik | Nagpur | Chhatrapati Sambhaji Nagar

Operational Presence

Delhi | Bengaluru | Chennai | Hyderabad | Kolkata | Ahmedabad | Surat 

© Terkar Capital 2024

CIN No: U70200PN2023PTC224016

• Consult with Expert
• Follow us on Linkedin

• Today's news
• Reviews and deals
• Climate change
• 2024 election
• Fall allergies
• Health news
• Mental health
• Sexual health
• Family health
• So mini ways
• Unapologetically
• Buying guides

Entertainment

• How to Watch
• My watchlist
• Stock market
• Biden economy
• Personal finance
• Stocks: most active
• Stocks: gainers
• Stocks: losers
• Trending tickers
• World indices
• US Treasury bonds
• Top mutual funds
• Highest open interest
• Highest implied volatility
• Currency converter
• Basic materials
• Communication services
• Consumer cyclical
• Consumer defensive
• Financial services
• Industrials
• Real estate
• Mutual funds
• Credit cards
• Balance transfer cards
• Cash back cards
• Rewards cards
• Travel cards
• Online checking
• High-yield savings
• Money market
• Home equity loan
• Personal loans
• Student loans
• Options pit
• Fantasy football
• Pro Pick 'Em
• College Pick 'Em
• Fantasy baseball
• Fantasy hockey
• Fantasy basketball
• Download the app
• Daily fantasy
• Scores and schedules
• GameChannel
• World Baseball Classic
• Premier League
• CONCACAF League
• Champions League
• Motorsports
• Horse racing
• Newsletters

New on Yahoo

• CA Privacy Notice

100,000 Black women are being asked to take part in cancer study

It's expected to be the largest behavioral and environmental-focused population study of cancer risk when it comes to Black women, according to a news release. Click here to learn more about the study. Researchers are seeking 100,000 Black women to participate. Enrollment opened on May 6 for a number of states including California. Data shows Black women continue to have the highest death rate and the shortest survival of any racial or ethnic group in the U.S. for most cancers. The lead researcher on the project and Senior Vice President of Population Science, Dr. Alpa Patel, joined KCRA 3 to discuss the project. Full coverage: http://www.kcra.com/article/american-cancer-society-black-women-asked-for-cancer-study/60777504

Select Region or Brand

• Charleston, SC
• Columbia, SC
• Lehigh Valley, PA
• Long Island
• New Orleans, LA
• Long Island, NY
• Mecklenburg, NC
• Oklahoma City, OK
• Rochester, NY
• South Carolina
• Greenville, SC
• Color Magazine
• Massachusetts
• North Carolina
• Rhode Island
• Milwaukee, WI
• Designers Today
• Furniture Today
• Gifts & Decorative Accessories
• Home Accents Today
• Home Furnishings News
• Home Textiles Today
• Manage Print or Online Subscription
• Manage Email Subscription

Upcoming Event

• Top Projects
• Submit a public notice
• My Projects
• My Preferences
• Event Sponsorship
• Classified Advertising
• Editorial and Special Products Calendar
• Real Estate
• Construction & Development
• Economic Development
• Finance & Banking
• Business & Economy
• Regional Planning & Transit
• Nation & World
• Business calendar
• Top Women in Finance
• Reader Rankings
• The Power 30 Comercial Real Estate
• The Power 30 Developers
• The Power 30 M&A
• The Power 30 Construction & Real Estate Law
• Empowering Women
• Women Who Lead
• Minnesota Icon
• Rising Young Professionals
• Top Women in Construction
• Experts Forum
• Partner Content
• M&A Monthly
• Twin Cities Apartment Sales Tracker
• Twin Cities Apartment Development Tracker
• Twin Cities Hotel Sales Tracker
• Twin Cities Hotel Development Tracker
• Rochester Sales Tracker
• Rochester Development Tracker
• Submit a Public Notice
• Professional Announcements
• Professional Announcements submissions
• Plaques & Permissions

Outdoor skateboard park could be new draw for Burnsville Center

Brian Johnson // May 13, 2024 //

A 50-foot-long, 17-foot-high vertical ramp currently located in Hopkins would be the centerpiece of SkaterApolis’ proposed outdoor park at Burnsville Center in Burnsville. (Submitted photo: City of Burnsville)

Share this!

Related Content

Brooklyn Park project could be a case study for prevailing wage

Brooklyn Park’s affordable housing stock is about to get bigger with help from[...]

May 9, 2024

Ryan’s high-level concept for Thomson Reuters campus advances

Ryan Cos.’ plan to redevelop part of the Thomson Reuters campus in Eagan with [...]

May 8, 2024

Ninth building coming to Arbor Lakes Business Park

The Arbor Lakes Business Park in Maple Grove continues to expand its footprint a[...]

Groundbreaking set for BIPOC affordable housing

The Black Lives of Unitarian Universalism (BLUU) Cooperative Housing Initiative [...]

Highland Bridge housing projects open in St. Paul

Two new housing projects are complete at the Highland Bridge site in St. Paul.

New lodging, ‘short course’ planned for Hazeltine

Building on its stature as a magnet for big tournaments and corporate events, Ha[...]

May 7, 2024

Finance & Commerce Daily Newsletter

Sign up for your daily digest of Minnesota News.

• By signing up you agree to our
• Privacy Policy

Upcoming business events

See the full list of events here

Editor’s Picks

Golden Valley office building sold for $11.9M

Transformed Schurmeier Lofts in St. Paul sold for $9.3M

Q&A: Ryan’s new initiative combats drug overdoses on jobsites

Young athletes with dreams of being the next Tony Hawk may soon have another reason to visit the sou[...]

A fully leased Golden Valley office building has fetched $11.9 million in a deal finalized last week[...]

Fed officials expect rates to stay high for longer

The sharp interest rate hikes of the past two years will likely take longer than previously expected[...]

Older Americans wanting to age-in-place splurge to make homes more accessible

An increasing number of older Americans are adapting their homes to make them more accessible.

Northwestern Mutual office renovation exceeds business and workforce goals

Northwestern Mutual’s $500 million renovation of the North Office building has surpassed local bus[...]

Wisconsin students build stadium facility, launch careers

Fifteen Oak Creek High School students on Thursday cut the ribbon to the new stadium entrance they h[...]

Intel expands education programs to help implement AI in workplaces

Christy Pambianchi, chief people officer at Intel, recently spoke with The Associated Press about ho[...]

Most U.S. parents still don’t have paid family leave despite revived efforts

The majority of working U.S. parents still must forego pay to care for new babies or other loved one[...]

Roadways require host of engineering feats

Scholars and engineeers are working to develop materials that can make roads stronger and last longe[...]

U.S. dedicates $60M to water projects along Rio Grande

The U.S. government is dedicating $60 million over the next few years to projects along the Rio Gran[...]

Special Publications

Finance & Commerce announces Top Projects of 2023

Earth Day 2024

Top Women in Construction 2024

Proud to highlight female business leadership for International Women’s Da[...]

Beyond The Skyline Podcast

Beyond the Skyline is a podcast and video interview about economic development, real estate and construction in Minnesota.

Listen here

Privacy Overview