lease financial modeling
How should a lease model be presented to a client?
How should a lease model be presented to a client?
Show the inputs, the year-by-year cash, and one worse case. Keep the rate on the page. Leave the formula cells off the slide.
This page belongs to a validation / pilot concept. It is not generally available. Payment is not collected.
Questions this page also answers
What is the short answer?
Show the inputs, the year-by-year cash, and one worse case. Keep the rate on the page. Leave the formula cells off the slide.
What should you change first?
Change this page's input and hold the rate still.
What must stay visible?
The rate, the extras, and the year the credit lands.
What should you open next?
Open how to communicate lease economics to a cfo and keep the same stack.
Plain-language definition
Show the inputs, the year-by-year cash, and one worse case. Keep the rate on the page. Leave the formula cells off the slide.
Start with cash you can date. Leave slogans off the sheet.
Add extras the tenant still pays.
Keep one visible rate so a later reader can check the work.
Name the method in plain words.
This page sits under Lease financial modeling.
Need the next step? Open how to communicate lease economics to a cfo.
See What are common lease-analysis mistakes when you want the nearby walk.
Open How should you present lease scenarios to a CFO if this page is not the last step.
Investopedia defines net present value as later cash brought back to today. See Investopedia on NPV.
Why it matters
This question still needs a dated cash walk: How should a lease model be presented to a client?
A short recap cannot carry a year-by-year example.
The rank can flip when this input moves.
A finance lead will ask which line changed the number.
How it works
- Put the numbers on one year list with rent.
- Hold the other assumptions still.
- Use one named method to shrink or spread the cash.
- Show a second path so the gap is visible.
- Keep the rate on the same page as the pick.
Formula in words. Model-presentation uses one shared rate and one dated list.
| Input | Meaning |
|---|---|
| Start rent | First-year rent before extras |
| Extras | CAM, tax, or insurance the tenant still pays |
| Credits | Free rent or build-out money |
| Term | How many years the cash list runs |
| Discount rate | How hard later cash is shrunk |
Worked example
Here is a teaching sample. It is not customer data and not a result from a live client.
| Metric | Path A | Path B |
|---|---|---|
| Start rent | $45,000 | $41,850 |
| Year-1 extras | $10,200 | $10,914 |
| Year-1 credit | $8,500 | $4,675 |
| Sample NPV | $408,894 | $394,044 |
| Year | Rent | Extras | Credit | Cash out | Value today |
|---|---|---|---|---|---|
| Year 1 | $45,000 | $10,200 | $8,500 | $46,700 | $43,241 |
| Year 2 | $46,350 | $10,506 | $0 | $56,856 | $48,745 |
| Year 3 | $47,741 | $10,821 | $0 | $58,562 | $46,488 |
| Year 4 | $49,173 | $11,146 | $0 | $60,319 | $44,336 |
| Year 5 | $50,648 | $11,480 | $0 | $62,128 | $42,283 |
| Year 6 | $52,167 | $11,824 | $0 | $63,991 | $40,325 |
| Year 7 | $53,732 | $12,179 | $0 | $65,911 | $38,458 |
| Year 8 | $55,344 | $12,544 | $0 | $67,888 | $36,678 |
| Year 9 | $57,004 | $12,920 | $0 | $69,924 | $34,979 |
| Year 10 | $58,714 | $13,308 | $0 | $72,022 | $33,360 |
| Sample NPV | — | — | — | — | $408,894 |
Sample NPV for Model-presentation sample is about $408,894. A second path lands near $394,044.
Year 1 of Model-presentation sample has rent of $45,000.
Shared building cost is $10,200.
A credit of $8,500 lowers the cash you pay that year.
Cash out this year is about $46,700. Year one carries the Model-presentation sample credit.
Later cash gets a shrink for time. At 8 percent, year 1 is worth about $43,241 today.
Next, year 2 rent is $46,350.
Assumptions
- The Model-presentation sample uses one visible 8 percent rate.
- Credits hit in year one unless the page says otherwise.
- Both options share the same extra basis.
- No percentage rent sits in this teaching walk.
Edge cases
A mid-year start needs a stub period, not a fake full year.
A credit that pays later must move to that later year.
A cap on extras changes the later risk, not the first sticker.
Common mistakes
- Copying a nearby page and only changing the title.
- Hiding the rate.
- Dropping extras on a net path.
- Calling the teaching sample a live client result.
Decision implications
Show the inputs, the year-by-year cash, and one worse case. Keep the rate on the page. Leave the formula cells off the slide.
If the gap is thin, show a second rate before anyone picks.
If one path wins only from a mistimed credit, rebuild the list.
This page answers one question. Nearby pages cover the next step.
See how to communicate lease economics to a cfo when you need that next step. Open What are common lease-analysis mistakes for the nearby walk. Use How should you present lease scenarios to a CFO if you want a second path.
Limits
- The number does not score daylight, transit, or floor plate.
- The number does not replace a legal read.
- Do not let one metric pick a space the team cannot use.
- Do not use this page as a clone of a nearby question.
U.S. BLS describes how brokers advise clients on property deals. See BLS broker occupation data.
Next step
This site is a validation / pilot concept. It is not generally available. Payment is not collected.
Ready for a bounded next step? Request Pilot Access or see how it works and compare commercial leases.
What are common lease-analysis mistakes? · What inputs belong in a commercial lease model? · How do you build a lease cash-flow model? · What is a commercial lease financial model? · How should free rent sit in a lease model? · How should a TI allowance sit in a lease model? · How should rent escalations sit in a lease model? · How do you run scenario analysis in a lease model?
Trusted sources
These are public references. They are not endorsements and not client results.