Skip to content
Commercial Real Estate Investing

User Stats

5
Posts
1
Votes
Ryan Marchand
  • Investor
  • Detroit, MI
1
Votes |
5
Posts

Professional Deal Analysis - Impact of Prepaids on CCR, Proformas

Ryan Marchand
  • Investor
  • Detroit, MI
Posted Jun 16 2022, 09:46

Situation:

We're acquiring properties at a steady rate (2-4 per month) and I'm looking to improve our cash management. The ultimate goal is to reduce the likelihood of capital calls, while at the same time streamlining work for the bookkeeping team.

Example: 

We're buying a 40-unit apartment complex (in Michigan) with an annual property tax bill in year 1 of approximately $50,000. Let's assume all other "Uses" equate to $350,000 in this particular example. Let's also assume that cash flow after debt service is $75,000 (NOI less CAPEX) and debt service is $60,000 per year. All figures are generated for illustration purposes only and do not reflect actual figures of any of our current/past transactions.

Questions:

1-If our debt package requires 3 months of prepaid P&I ($15,000), should we increase our Sources & Uses schedule to account for this figure, or do we anticipate the property to perform & simply borrow funds short-term from ourselves or 3rd party credit until operating incomes can pay back the short-term loan? I don't want to get in the habit of depending upon future incomes to prepay bills if it means we're now "dependent" upon the property to perform. 

2-Are there 3rd party vendor that offers nationwide property tax payment plan solutions for commercial properties? 

3-A property acquired in August would require far more cash at closing for prepaid taxes versus the same property acquired in June of the same calendar year. How does this impact the pro-forma and budgeting leg of your acquisitions & bookkeeping workflows, respectively?

4-If in Q#1 the S/U increases by $15k, then our Cash on Cash Return ("CCR") would decrease proportionally due to having a larger denominator. However, if we are prepaying $15k of the year 1 opex, should we deduct that $15k in the proforma for year 1? In this scenario, the CCR increases because we've reduced opex that will be paid during year 1 by prepaying at closing as part of our initial cash investment.

Photo is of one of our properties; not impacted by this post.

User Stats

7,028
Posts
3,638
Votes
Drew Sygit#2 Managing Your Property Contributor
  • Property Manager
  • Royal Oak, MI
3,638
Votes |
7,028
Posts
Drew Sygit#2 Managing Your Property Contributor
  • Property Manager
  • Royal Oak, MI
Replied Jun 17 2022, 07:34

@Ryan Marchand will answer what we are familiar with:

1) Would depend on projections on how long it should take for operating income to repay any borrowed funds. Establish a baseline and stick to it.
Also, look into getting a line of credit to tap for short-term cash requirements. You can then also use the rate to establish IRS required "fair market rate" if you also want to lend money from yourselves. 

2) This would just be another form of borrowering, increasing your costs. Would only do if it's cheaper than own line of credit or as last resort.

3) Shouldn't impact the pro forma at all. Will obviously affect budgeting though. 

4) If you're S/U is only covering actual prepaids, it should be settled in the current year, so it shouldn't affect your CCR. If you choose to borrow the funds to pay it, then only the interest expense should affect your CCR.

Hopefully, others with additional expertise will respond:)

User Stats

5,049
Posts
2,075
Votes
Ronald Rohde
Pro Member
#3 Commercial Real Estate Investing Contributor
  • Attorney
  • Dallas, TX
2,075
Votes |
5,049
Posts
Ronald Rohde
Pro Member
#3 Commercial Real Estate Investing Contributor
  • Attorney
  • Dallas, TX
Replied Jun 20 2022, 08:37

I would try to view the problem over a longer term lens. Pay the bills when due, its always better to hold cash than distribute to investors too early. If not, do you have liquidity to lend?

RE: IRS, you should look up the AFR Applicable Federal Rate, thats the legal term.

FlipSystem logo
FlipSystem
|
Sponsored
Learn From Our Team. Earn 100% of the Profits. Join our community of 500+ investors! Avg profit per flip: $14k, Avg effort per week: 4hrs

User Stats

5
Posts
1
Votes
Ryan Marchand
  • Investor
  • Detroit, MI
1
Votes |
5
Posts
Ryan Marchand
  • Investor
  • Detroit, MI
Replied Feb 7 2024, 20:34

thanks for the feedback. since this post, our models have become much more sophisticated, but even then, your advice is helpful! 

-our new underwriting standards account for pre-funding partial years for property taxes

-we also have a much more sophisticated capex review process that builds annual reserve budgets

-the biggest challenge now is just "enforcing" the budget across multiple teams. 

User Stats

5,049
Posts
2,075
Votes
Ronald Rohde
Pro Member
#3 Commercial Real Estate Investing Contributor
  • Attorney
  • Dallas, TX
2,075
Votes |
5,049
Posts
Ronald Rohde
Pro Member
#3 Commercial Real Estate Investing Contributor
  • Attorney
  • Dallas, TX
Replied Feb 12 2024, 09:04
Quote from @Ryan Marchand:

thanks for the feedback. since this post, our models have become much more sophisticated, but even then, your advice is helpful! 

-our new underwriting standards account for pre-funding partial years for property taxes

-we also have a much more sophisticated capex review process that builds annual reserve budgets

-the biggest challenge now is just "enforcing" the budget across multiple teams. 


 great to hear, yep, always new challenges, but progress is the goal, not perfection