• 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

      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. Forgot password?... memories fade
      3. Subscribe... to receive our mailings
      4. Contact us... if you have any questions, just ask
      5. 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 - Commercial Real Estate

  1. Home
  2. Communications
  3. Instructor Blog
  4. Commercial Real Estate

Questions: Commercial Real Estate


  • admin

  • 6/19/2019 7:58:03 AM

  • 57

  • Commercial Real Estate

Q: Why do you need to use a debt service constant?

A: The debt constant gives us great precision in identifying annual debt service for any combination of interest rates, amortization periods, and payment frequency. It is very easy to use.

Shockproof! Training has developed an Excel worksheet designed to calculate the unique debt service constant associated with any combination of loan terms. We’ll be glad to send the worksheet to you if you wish; please send your email request to instructor@shockproof.com and we’ll get it to you.

To use the worksheet, simply enter the interest rate, the debt amortization period, and the payment frequency, e.g., annually, semi-annually, quarterly, or monthly. The Excel function will produce the debt constant for this unique combination of interest rate, amortization period, and payment frequency. Multiply the debt constant by the loan amount to arrive at the annual debt service amount.

When the annual debt service has been determined in this way, simply divide the annual debt service by the number of payments that you’ve specified in your input. Divide by 12 for monthly debt service payments, divide by 4 for quarterly payments, and divide by 2 for semiannual payments. Use the value produced by the worksheet – prior to any division – for annual payment frequency.

Categories
  • Accounting Essentials(93)
  • Business Income Tax Returns(118)
  • Commercial Real Estate(30)
  • Communications(10)
  • Contractors(43)
  • Courses(1)
  • Covenants(7)
  • Credit Basics(80)
  • Credit College - Cash Flow(9)
  • Credit College - Commercial Business(195)
  • Credit College - CRE(199)
  • Credit College - Taxes(70)
  • Credit Curriculum(1)
  • Credit Write Up(30)
  • Debt Capacity(9)
  • EBITDA(25)
  • FASB95(10)
  • Financial Analysis(50)
  • Five Cs of Credit(10)
  • Fund Accounting(49)
  • General(0)
  • Global Cash Flow(46)
  • Healthcare(17)
  • Loan Documentation(45)
  • Minimum Financial Data(12)
  • Not for Profit Analysis(22)
  • Personal Income Tax Returns and Cash Flow(65)
  • Problem Loans - Loan Classification(2)
  • Projections(22)
  • Statement Spreading(5)
  • Stress Testing(1)
  • Technical Issues(8)
  • Testing(1)
  • Tools(1)
  • Trusts(3)
  • UCA Cash Flow(56)
  • User Community(6)
  • Working Capital and Cash Flow(26)
Shockproof! Training

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

  • About
  • Career Opportunities

© Copyright 2001-2022 Shockproof! Training