eFinancialModels

Startseite
Schweiz
Zürich
eFinancialModels

eFinancialModels offers a marketplace to share and sell industry specific financial model templates

eFinancialModels provides a marketplace to share and sell industry specific financial model templates and excel spreadsheets

20/07/2026

Purpose-built student accommodation has some of the strongest occupancy fundamentals in European real estate — but the acquisition economics depend heavily on room-type mix, operating cost structure, and the financing assumptions you use at entry.

This pro forma models the full PBSA acquisition — revenue by room type, operating expenses, NOI, cap rate at purchase and exit, debt service, IRR, and equity multiple — giving you a complete picture before you commit.

📥 Download: https://www.efinancialmodels.com/downloads/real-estate-student-accommodation-acquisition-pro-forma-632432/

What yield threshold are you currently using for PBSA acquisitions in your target markets?

16/07/2026

Three tariff changes have simultaneously realigned Scotch whisky export demand — and the base case is more bullish than market consensus.

The events:

— US 10% tariff on Scotch dropped (April 2026): removes the largest single drag on volume since 2018

— UK-India trade agreement in force Q1 2026: tariff cut from 150% to 40%; Scotch Whisky Association forecasts +£1 billion over five years; 220 million bottles shipped to India in 2025 (+15% year-on-year)

— China cut its spirits import tariff to 5% (February 2026): reopens the single largest addressable market for premium whisky

EFM base case: 5.5% annual growth 2026–2031, reaching £6.8 billion in export value by 2031. Bear case: £5.8 billion. Bull case: £7.6 billion.

The supply picture: 152 operating distilleries, approximately 22 million aging casks — roughly nine years of supply at current export rates. Single-malt volume declined 14% at Diageo in FY2025, but The Macallan remains the largest single malt by value ($1.26 billion). The premiumization story is intact — just narrower.

Decarbonization is the key 2026–2028 operational decision: moving to hydrogen, biomass, or heat recovery systems costs £1.05–£4.80 per liter of production capacity installed.

30 pages. 12 charts. 9 data tables. Three scenarios with explicit probabilities.

Template link in the comments 👇

📚 We publish free market studies across solar energy, beverages, distilleries, mining, and more.

Browse all beverage studies → https://www.efinancialmodels.com/downloads/tag/free/

All market studies & use cases → https://www.efinancialmodels.com/financial-model-by-use-case/

This study is for informational purposes only. All projections are based on publicly available data and assumptions. Actual results may vary.

15/07/2026

Depreciation looks simple until you're managing multiple assets across different methods, useful lives, and residual values — and your P&L, tax, and balance sheet all need to tie out.

This Excel calculator handles it automatically — straight-line, declining balance, units of production, and more — with clean, auditable output schedules ready to plug into any financial model.

📥 Download: https://www.efinancialmodels.com/downloads/depreciation-amortisation-excel-calculator-633837/

What depreciation method causes you the most reconciliation headaches?

14/07/2026

Nigeria's beverage sector — the largest in sub-Saharan Africa — is inside a triple shift that reshapes every line of the unit economics model.

The three shocks:

Currency: Nigeria's naira was floated in June 2023, moving from approximately ₦460 to a 2024 peak above ₦1,800 before settling near ₦1,580 by mid-2026. For companies importing plastic bottles, malt, or other ingredients, costs rose 250–300% in naira terms since 2022.

Beer excise duty: Nigeria's 2025 Tax Act sets ₦72 per liter in 2026, rising to ₦80 per liter by 2028. This compresses brewery operating margins by an estimated 200–400 basis points before any price increases are passed through.

Sugary drinks tax: The current ₦10 per liter specific rate (in force since 2021) is under active legislative review. Our modeling runs scenarios from the current flat rate through a percentage-based rate of 7–8% (most likely) up to 20% or more (worst case), with detailed price pass-through analysis for each.

Market structure: Three companies — Tolaram (former Guinness Nigeria), Heineken's NB Plc (72.9% stake after a ₦599 billion rights issue in September 2024), and AB InBev's International Breweries — control approximately 98% of formal beer volume. Sachet water: 2.5 billion liters per year across 32,000+ small producers — the largest packaged beverage format by volume.

Template link in the comments 👇

📚 We publish free market studies across solar energy, beverages, distilleries, mining, and more.

Browse all beverage studies → https://www.efinancialmodels.com/downloads/tag/free/

All market studies & use cases → https://www.efinancialmodels.com/financial-model-by-use-case/

This study is for informational purposes only. All projections are based on publicly available data and assumptions. Actual results may vary.

13/07/2026

Every commercial office deal starts with the same question: what's the most you can pay for the land and still hit your required return?

This one-page residual appraisal model works backwards from GDV — stripping out build cost, finance cost, and profit margin — to give you the maximum viable land price before you submit an offer.

One page. Instant output. No room for guesswork.

📥 Download: https://www.efinancialmodels.com/downloads/commercial-office-residual-development-appraisal-one-pager-633602/

What's your minimum profit on cost threshold for a commercial office deal?

09/07/2026

Australia's beverage manufacturing sector enters 2026 with the clearest sub-category growth divergence in years.

The data:

— Beer: -2.0% volume per year, base case 14.3 million hectoliters (2025) declining to 12.9 million hectoliters by 2031; Endeavour and Coles Liquor together control 59% of liquor retail

— Non-alcoholic beer: +7% per year through 2028; share roughly doubles from ~2.6% to ~5% of total beer by 2031

— Ready-to-drink spirits: +12% on-premise year-on-year (2025); AU$4.5 billion by 2031 base case; Suntory Oceania's AU$400 million Brisbane facility commissioned September 2024

— Bottled water: modest growth plateau at AU$2.40 billion by 2031 base case

Two regulatory catalysts reshape cost structures in 2026–2027:

— Draught beer excise freeze through August 2027: approximately 7–8% cumulative pricing gap versus packaged beer, favoring on-premise brewery margins

— Container deposit scheme expansion to wine and spirits from 1 July 2026: 1.5–2 billion additional containers per year

36 pages. 13 charts. 9 data tables. Three probability-weighted scenarios.

Template link in the comments 👇

📚 We publish free market studies across solar energy, beverages, distilleries, mining, and more.

Browse all beverage studies → https://www.efinancialmodels.com/downloads/tag/free/

All market studies & use cases → https://www.efinancialmodels.com/financial-model-by-use-case/

This study is for informational purposes only. All projections are based on publicly available data and assumptions. Actual results may vary.

07/07/2026

Mobile home parks are one of the most cash-flow-stable asset classes in US real estate — but modelling them at the fund level requires handling park-level operations, acquisition assumptions, and LP/GP waterfall mechanics all in one model.

This investment fund model was built specifically for MHP development and acquisition — from individual park NOI to fund-level returns, with a full LP/GP distribution waterfall built in.

📥 Download: https://www.efinancialmodels.com/downloads/re-investment-fund-model-mobile-home-park-development-632791/

What cap rate are you underwriting for MHP acquisitions right now?

02/07/2026

Japan's beverage export story is structurally strong — even as domestic headwinds accumulate.

Tea exports grew 16% in volume and 25% in value in 2024. Itoen's overseas sales grew 60% in the first quarter of FY2025, with North America up 44%. A bilateral trade agreement eliminating tariffs on Japanese green tea continues to underpin this export run through 2031.

Three supply-side and regulatory developments define the 2026 planning window:

— Uji matcha production fell 40% (hand-picked first harvest) in 2025; matcha prices roughly doubled year-on-year — the most significant supply-side shock in the premium ready-to-drink tea segment in recent memory

— New rules from Japan's Ministry of Economy, Trade and Industry require at least 15% certified recycled plastic in drink bottles from January 2026

— New government enforcement rules for functional health drinks — drinks marketed for specific health benefits — take effect September 2026, benefiting large established operators

Japan's functional health drinks market reached ¥686.5 billion in 2023, with 1,584 new products notified in the most recent government reporting period.

35 pages. 13 charts. Four sub-segments. Three scenarios through 2031.

Template link in the comments 👇

📚 We publish free market studies across solar energy, beverages, distilleries, mining, and more.

Browse all beverage studies → https://www.efinancialmodels.com/downloads/tag/free/

All market studies & use cases → https://www.efinancialmodels.com/financial-model-by-use-case/

This study is for informational purposes only. All projections are based on publicly available data and assumptions. Actual results may vary.

30/06/2026

A hardware business case isn't like a SaaS model. You have COGS, tooling, inventory, channel margins, and development costs that all hit differently depending on where and how you sell.

This model gives you a 5-year monthly P&L broken down by sales channel — direct, retail, distributor, OEM — with development costs, gross margin by channel, and a clear path to profitability.

📥 Download: https://www.efinancialmodels.com/downloads/product-business-case-financial-model-5-year-monthly-pl-channels-and-development-for-hardware-physical-products-632778/

What's the biggest modelling challenge you face when building a hardware business case?

Adresse

Max-Högger-Strasse 6
Zürich

Webseite

http://www.efinancialmodels.com/

Benachrichtigungen

Lassen Sie sich von uns eine E-Mail senden und seien Sie der erste der Neuigkeiten und Aktionen von eFinancialModels erfährt. Ihre E-Mail-Adresse wird nicht für andere Zwecke verwendet und Sie können sich jederzeit abmelden.