• Shockproof! Training
  • 1.866.237.7228
  • Non-Member

    Membership Check

    Please enter your email address and we will check to see if a membership exists for your organization.

    Check Cancel
  • Account
    • Sign in

      If you have an account, please enter your login information.

      Sign-in

      Find Enrollments

      To quickly access links to materials or Session Access instructions, enter the email address used when enrollment was performed.

      Click "Find Now" to begin search.

      Find Now

      Forgot your password?

      Please provide your email address and we'll email you a reminder.

      Send it to me!

      Subscribe

      Please provide the information below to receive our mailings.

      Subscribe!
      Account Options
      1. Sign In... enter the resource center
      2. Access Materials... find my enrollments
      3. Forgot password?... memories fade
      4. Subscribe... to receive our mailings
      5. Contact us... if you have any questions, just ask
      6. Create a User Account* requires membership
  • Sign-in
  • Home
  • Products
  • Learning Paths
  • Calendar
  • Pricing
  • Communications
  • Contact Us
  • Help
  • About Us
  • Membership Check
  • Account

Instructor Blog - Credit College - CRE

  1. Home
  2. Communications
  3. Instructor Blog
  4. Credit College - CRE

Management Assessment, Competitive Forces, and Projected Performance


  • admin

  • 9/17/2019 10:26:58 PM

  • 799

  • Credit College - CRE
  • Copy / Share Link

Q: Couldn't we ask for trailing twelve months (TTM) profit and loss statement or, at a minimum, the same YTD period from last year so we could create projections without relying on annualized data?

A:  Absolutely. You can ask for a TTM. However a TTM is not a profit and loss statement that most businesses routinely produce. If you were to receive the TTM or the same interim profit and loss statement for the prior year, you would certainly have better information upon which to base your annualized projection – especially if it were early in the year. Nonetheless, you would still be estimating, which may or may not involve annualizing the current year information as part of your process since you would not want to use the TTM in lieu of a forward-looking one- year projection. Ideally, the prior three years of historical information would already be part of your historical basis, or reference points, for supporting NOI projections.

Q: You mentioned the debt service constant is something we could get with an Excel spreadsheet from Shockproof! Training? Is there an Excel spreadsheet that has inputs for all of the values we discussed as a short cut?

A: If you would like a copy of the debt service constant Excel spreadsheet that we use at Shockproof! Training, please email us at instructor@shockproof.com. Its focus is on computing a unique debt service constant for any combination of interest rates, amortization periods, and payment frequencies, which can then be applied to a proposed term loan amount to determine annual debt service on that loan amount.

The spreadsheet does not include a separate function for establishing a maximum term loan amount, given a property’s NOI, the lender’s minimum DSC, and the debt service constant for the loan terms.

Recall that the Excel spreadsheet allows you to quickly calculate the unique debt service constant for any combination of interest rates, amortization periods, and payment frequencies. With the debt service constant in hand, you use it to calculate the annual debt service on a specific loan amount by multiplying the proposed loan amount by the debt service constant. If you subsequently want to change loan terms, you simply recalculate the debt service constant in the top of the spreadsheet using the revised loan terms and recalculate the annual debt service in the bottom portion of the spreadsheet.

If you want to change the loan amount while the terms remain constant, you use the spreadsheet to again quickly recalculate the annual debt service given the existing debt service constant applied to a different loan amount.

You can use the debt service constant to calculate the maximum term debt that a given NOI can support once you adjust the given NOI by a DSC ratio. For example, if the DSC minimum is 1.25, divide NOI by 1.25 and multiply the result by the debt service constant to arrive at the maximum term debt that the available risk adjusted NOI will support. There are examples of maximum term debt calculations on Slides 22 and 25 in the Session 6 slide deck.

Categories
  • Accounting Essentials(106)
  • Business Income Tax Returns(118)
  • Commercial Real Estate(32)
  • Communications(10)
  • Contractors(48)
  • Courses(1)
  • Covenants(9)
  • Credit Basics(89)
  • Credit College - Cash Flow(12)
  • Credit College - Commercial Business(203)
  • Credit College - CRE(213)
  • Credit College - Taxes(82)
  • Credit Curriculum(1)
  • Credit Write Up(31)
  • Debt Capacity(9)
  • EBITDA(25)
  • FASB95(10)
  • Financial Analysis(51)
  • Five Cs of Credit(10)
  • Fund Accounting(51)
  • General(0)
  • Global Cash Flow(49)
  • Healthcare(18)
  • Loan Documentation(50)
  • Minimum Financial Data(14)
  • Not for Profit Analysis(22)
  • Personal Income Tax Returns and Cash Flow(65)
  • Problem Loans - Loan Classification(2)
  • Projections(22)
  • Statement Spreading(6)
  • Stress Testing(1)
  • Technical Issues(8)
  • Testing(1)
  • Tools(1)
  • Trusts(3)
  • UCA Cash Flow(57)
  • User Community(6)
  • Working Capital and Cash Flow(27)
Shockproof! Training

PO Box 30304 Walnut Creek, CA 94598
1.866.237.7228 support@shockproof.com

  • About
  • Career Opportunities

© Copyright 2001-2023 Shockproof! Training