DCF Excel Model Vastgoed | Complete Investeringsanalyse, NCW, IRR & Scenarioanalyse

$10.79

Preview 4 out of 48 pages

Other

DCF Excel Model Vastgoed | Complete Investeringsanalyse, NCW, IRR & Scenarioanalyse

0.0

(0 reviews)

- sold

48 pages

2025/2026

Institution

Course

Preview 4 out of 48 pages

Dit document bevat een compleet uitgewerkt DCF Excel-model voor vastgoedinvesterings- en renovatieanalyses. Het model is ontwikkeld als onderdeel van een HBO-afstudeeronderzoek en bevat een volledige financiële onderbouwing van meerdere renovatiescenario's. Het model berekent automatisch onder andere de Netto Contante Waarde (NCW), Internal Rate of Return (IRR), terugverdientijd, kasstromen, investeringskosten, exploitatiekosten, huurinkomsten, subsidies en scenariovergelijkingen over een exploitatieperiode van 30 jaar. Dankzij de overzichtelijke opbouw is het model geschikt als voorbeeld of hulpmiddel voor studenten Vastgoedkunde, Built Environment, Facility Management, Bouwkunde en andere opleidingen waarin DCF-berekeningen, vastgoedrekenen of investeringsanalyses worden toegepast. Het Excel-bestand kan eenvoudig worden aangepast voor eigen vastgoedprojecten of scripties.

Content preview

FINANCIEEL MODEL — RENOVAT
DUWO · Vastgoedkunde HBO A

RESULTATEN OVER

S1 — Minimale S2 — Direct Paris S3 — Actieve
Resultaatvariabele
Renovatie Proof Plint

INVESTERINGEN
Bruto investering €3,227,183 €6,912,853 €7,914,870
Totaal subsidies (SAH+ISDE+RHA) €72,000 €113,513 €1,134,000
Netto investering €3,155,183 €6,799,340 €6,780,870

JAARLIJKSE EXPLOITATIE (JAAR 1)
Extra huurinkomsten (incrementeel) €163,535 €267,330 €304,987
Energiebesparing €46,919 €70,275 €70,275
Plinthuur S3 / overig - - €5,238
SDE++ opbrengst jaar 1 €8,550 €13,050 €13,050
Onderhoudskosten - - -
Netto cashflow jaar 1 €219,004 €350,655 €393,550

DCF RESULTATEN
NCW — Netto Contante Waarde €137,196 €130,020 €1,473,662
IRR — Intern Rendement 4.4% 4.1% 5.6%
Verdisconteerde TVT (jaren) >30 >30 >30
Gewone Terugverdientijd (jaren) >30 >30 >30
CASHFLOW CHECKPOINTS
Cashflow jaar 1 €219,004 €350,655 €393,550
Cashflow jaar 5 €235,981 €378,407 €425,755
Cashflow jaar 10 €253,042 €412,347 €465,917
Cashflow jaar 20 (€66,646) (€839,858) (€81,284)
Cashflow jaar 30 €381,578 €617,341 €705,122

,KLEURLEGENDA
■ Invoercel — aanpasbaar
■ Aanname / toggle — aanpasbaar
■ Resultaat — automatisch berekend
■ Subtotaal / eindresultaat

,L MODEL — RENOVATIESCENARIO'S RIJN- EN SCHIEKADE 100-110 LEIDEN
UWO · Vastgoedkunde HBO Afstudeerscriptie · Extern Adviesrapport · Alle bedragen excl. btw

RESULTATEN OVERZICHT — DIRECT GEKOPPELD AAN INVOERPARAMETERS

S4 — Community
Floor

A. FINANCIËLE PARAMETERS
€7,275,339 Disconteringsvoet 4.0%
€1,152,000 Huurindexatie per jaar 2.5%
€6,123,339 Inflatie (kosten/MJOP) 2.5%
Startjaar renovatie 2028
Exploitatieperiode (jaren) 30
€321,126
€70,275 B. BIJKOMENDE KOSTEN & ONVOORZIEN
- Bijkomende kosten (%) 20.0%
€13,050 Onvoorzien (%) 25.0%
-
€404,451 C. LEEGSTAND & BEWONERSKOSTEN
Leegstandskosten/maand (€) € 53,933
Verhuiskosten totaal (€) € 115,587
€2,387,933 Leegstandsduur S1 (mnd) 5 4 – 6 mnd
6.7% Leegstandsduur S2 (mnd) 7 5 – 8 mnd
>30 Leegstandsduur S3 (mnd) 9 7 – 10 mnd
>30 Leegstandsduur S4 (mnd) 10 8 – 12 mnd

€404,451 D. HUIDIGE SITUATIE (NULBASIS)
€437,788 Huidige huurinkomsten (€/jr) € 647,202
€479,530 Huidige energiekosten (€/jr) € 128,896
(€63,857)
€727,430 G. SUBSIDIES — MASTER TOGGLE
ALLE SUBSIDIES AAN/UIT (1=aan | 0=uit) 1

H. SUBSIDIE-TOGGLES (1=aan | 0=uit)
SDE++ dak-PV (alle scenario's) 1
SDE++ gevel-PV (S2/3/4) 1
SAH — warmtenet (S3 en S4) 1
ISDE — warmtepomp (S2 LWP) 1

, RHA — fietsenstalling (alle) 1

I. SUBSIDIE PARAMETERS
SDE++ tarief (€/kWh) € 0.150
SAH bedrag per woning (€) € 6,000
ISDE bedrag indicatief (€) € 41,513
RHA bedrag indicatief (€) € 72,000

Document information

Study: Vastgoedkunde
Uploaded on: July 16, 2026
Number of pages: 48
Written in: 2025/2026
Type: Other
Person: Unknown

Report Copyright Violation

$10.79

Written by students who passed

Immediately available after payment

Read online or as PDF

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Frequently asked questions

Can't I just make this for free with AI?

AI tools give you vast, general information. They don't know your course, your professor, or what actually gets asked in your exam. This document was written by a fellow student who understood the nuances of exactly this course and passed it. You get focused, curated study material, not a generic starting point you still have to rework.

Is this document still relevant for my course?

Every document shows the academic year, the linked textbook, and the institution, so you can check upfront whether it matches your course. Take a look at the free preview too to see if it fits.

What if the document isn't what I hoped?

No worries! If you change your mind within 14 days of purchase and have not downloaded the document yet, you will get a refund. Your purchase is completely risk-free.

Who am I actually buying from?

Stuvia is a marketplace: you buy directly from the student who created the document. Stuvia handles payment securely and backs every purchase with the free exchange guarantee, so you never take on any risk.

Will I be stuck with a subscription?

No. You pay $10.79 once for this document and nothing more. No subscription, no auto-renewal, no fine print.

What do I get when I buy this document?

You get a PDF that is available immediately after payment. You can read the document online or download it, and it stays accessible through your profile indefinitely.

Why can I trust Stuvia?

4.6 stars on Google and Trustpilot from over 2,000 reviews. In the past 30 days 31289 documents were sold through Stuvia internationally. And we have been doing this for 16 years now. Every document also shows its rating and how many times it has been sold.

DCF Excel Model Vastgoed | Complete Investeringsanalyse, NCW, IRR & Scenarioanalyse

Content preview

Document information

More like this

Why students choose Stuvia

Created by fellow students, verified by reviews

Didn't get what you expected? Choose another document

Pay as you like, start learning right away

Working on your references?

Frequently asked questions

Can't I just make this for free with AI?

Is this document still relevant for my course?

What if the document isn't what I hoped?

Who am I actually buying from?

Will I be stuck with a subscription?

What do I get when I buy this document?

Why can I trust Stuvia?

DCF Excel Model Vastgoed | Complete Investeringsanalyse, NCW, IRR & Scenarioanalyse

Content preview

Document information

Browse related subjects

Subjects

Why students choose Stuvia

Created by fellow students, verified by reviews

Didn't get what you expected? Choose another document

Pay as you like, start learning right away

Working on your references?

Frequently asked questions

Can't I just make this for free with AI?

Is this document still relevant for my course?

What if the document isn't what I hoped?

Who am I actually buying from?

Will I be stuck with a subscription?

What do I get when I buy this document?

Why can I trust Stuvia?