REPE Modeling Test Example

Thanks!

This is pretty good,

Personal opinion is that keep the inputs on top rows instead of to the right of cash flows.

following, and appreciate you sharing so openly

Thanks for this! Could you maybe share some of your other models/case studies?

Glad you guys like it, I'll try to add the case studies sometime this week to this post. Hope you all find the model helpful and feel free to reach out with any questions.

Very nice! Can you share the initial data you had starting off the model so I can practice and build it myself with another approach? I'll post what I get afterwards.

Thanks.

Thanks for sharing. Is there any reason why you're not using the IPMT formula to calculate interest? As simply multiplying the rate by outstanding balance increases the total debt service over time (arguably not by much but still)

How is the sensitivity table at celll AG53 calculated? Was trying to figure out the inputs by following the logic but it looks like a function was used.

Thanks in advnace!

I noticed that you applied your acquisition fee to the Total Costs to lever against - said another way, the 70% LTV was the purchase price and the acquisition fee.

Does this logic apply when you have debt origination fees, IS broker fees, etc.? I know the money has to come from somewhere, so it makes sense to loop them in.

.

Thank you for sharing.

Can you share the case study and the additional models that you have?

Thank you for sharing.
i was doing a modeling ex. earlier & encountered some difficulties.. would be grateful if someone could give me some insights!

1. • 10-year quarterly cash flow with rent roll that drive the top line of the cash flow
     (what does it "rent roll that drive the top line of the cash flow" mean ?)
2. Leased-up Schedule: Leased to 4 tenants at future market rent; 25% of the area to each tenant; 3-year lease terms; Tenancy starts 3, 6, 9 and 12 months from acquisition in June 30, 2014; Tenant renewal probability 50%. Downtime for new leases 3 is months.
   (how to model the tenant renewal probability ?)

thank you so much

Thank you for sharing. Can you share the initial case inputs?

Can you also send the additional models which you have?

Apologies for the late response, made a different account. Due to circumstance, I am not allowed to share the case study prompt.

Was pretty basic, a NNN industrial deal with some rollover/growth assumptions. Gave financing, cap rate, etc.

Asked you calculate Unlevered & Levered IRR, ROE, EMx, and Sensitivities.

Link to model does not work. Would you mind sending? I could use some guidance for this!

I agree - link does not work for me. Would love to access a modeling test.