Hi there,
I need help calculating the PV of contracted rent given the information below.
Demise: 10,000 sf Face rent (p.a.): £20 psf* Lease term: 5 years Discount rate: 8% * Assumed paid quarterly in advance.
The answer is: £838,080.
Could someone please explain how this answer has been reached?
Many thanks
| +59 | Development Fees > Sponsor Equity Contribution | 18 | 20h |
| +57 | What's an Undergrad to Do? | 21 | 2d |
| +43 | Advice to Job Seekers: Don't Sleep on Asset Management | 13 | 1d |
| +24 | Mid Sized REPE firm for first job in RE | 10 | 17m |
| +10 | Full-Time RE Acquisitions Analyst Recruiting - Class of 2028 | 4 | 1d |
| +3 | Tishman Speyer Debt Fund | 0 | 4d |
| +3 | Debt fund jobs | 1 | 4d |
| +3 | Thoughts on CIM Group today? | 11 | 1d |
| +3 | LDG Development wins $36.3M Lawsuit | 1 | 17h |
| +1 | Equity Waterfall - Market Standard | 2 | 2d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
My answer came out to $833,923.10. It is an annuity due because the payments are at the beginning of the period, so that increases the PV of the stream of cash flows.
EDIT: The formula for an annuity due is:
PVAdue = (pmt / disount rate) * (1 - (1 / ((1 + discount rate)^number of periods))) * (1 + discount rate)
Atque animi mollitia voluptatibus sit consequatur incidunt. Quis recusandae aut sapiente qui quod. Iste adipisci inventore dolorum consectetur delectus. Dolor et laborum perferendis officia doloribus.
Quia similique exercitationem ut harum alias suscipit facilis. Et ut nemo rem voluptate tenetur voluptatibus neque aspernatur. Odit sit ea voluptatem illum. Omnis vero dolorem et fuga eos cumque a.
Qui cumque consequuntur commodi optio. Repellendus est ad repellendus aut quae totam ut. Voluptas officiis quos aut iste ducimus impedit voluptas.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...