• 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 - Commercial Business

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

Analytical Decision Tree and the Credit Write-Up


  • admin

  • 1/30/2020 10:14:47 AM

  • 922

  • Credit College - Commercial Business
  • Copy / Share Link

Q: How would we verify what portion of prepaid expenses should have been expensed?

A: To determine what portion of prepaid expenses should have been expensed requires a conversation with someone at the company who is knowledgeable about the account. We could ask the company accountant or bookkeeper a) to assure the lender that all prepaid expenses had been properly brought into the income statement or b) to provide a detailed breakout of the prepaid expenses account.  If a proper prepaid expenses balance were the only issue, or one of only a few issues, we would do so. However, given all the other red flags for Sequoia Properties, it is probably not worth the time and effort to pursue this particular issue.

Q: Given that the $1,230,735 reduction in the Due to Clovis Supply balance represents a cash outflow, should we be looking to verify this in the cash flow statement?

A: The cash flow statement included with the accrual financial statements – the Statements of Cash Flows – should highlight the change in the Due to Clovis Supply account. In this case, the change in Due to Clovis Supply is not readily apparent from the Statements of Cash Flow in the accrual financial statement package. The change in the Due to Clovis Supply balance is not broken out separately, but is included in the Change in Long-Term Financing, which is not, to anyone’s surprise, calculated correctly.  

The change in long-term debt should be the entire amount of long term debt outstanding at the end of 2014, which is the sum of the current and long-term portion, less the long-term portion of 2013 long-term debt at the end of 2013. The current portion of 2013 long-term debt was paid down in 2014, so the appropriate measure for new long-term debt is a) total 2014 long-term debt less b) 2013 long-term debt excluding the 2013 current portion. We will review the new long-term debt calculation in Session 3, which focuses on constructing and using the UCA cash flow statement.

The bookkeeper or accountant who prepared the Statements of Cash Flows calculated the change in long-term debt using both the current and long-term portion at the end of 2013 and comparing that to the current and long-term portion at the end of 2014. To that change, he or she added the cash outflow of $1,230,735 from the reduction in the Due to Clovis Supply balance. This is all perfectly proper in accordance to guidelines for preparing a FASB 95 statement of cash flows, which is what we have in the Sequoia Properties’ financial statements. But the change in long-term debt from one period to the next is not the same as new long-term debt, which is the real issue we want to address.

The calculations for Long-Term Financing in the Sequoia Properties’ Statements of Cash Flows – a FASB 95 indirect cash flow statement – are as follows:

  • 2014 CPLTD of $1,084,569 plus long-term portion of $20,910,939 = $21,995,508
  • 2013 CPLTD of $70,418 plus long-term portion of $18.930,965 = $19,001,383

The difference is a cash inflow of $2,994,125. Combining that inflow with the $1,230,735 outflow from the change in Due to Clovis Supply results in the reported cash inflow from Long Term Financing reflected in the Sequoia Properties’ 2014 Statements of Cash flows of $1,763,390.

Again, the $70,418 CPLTD in 2013 should not have been included in the calculation of the change in long-term debt if the objective were to determine the amount of new long-term debt for 2014 because that $70,418 was paid down during the year. The proper calculation for 2014 new long-term debt should be:

  • 2014 CPLTD of $1,084,569 plus long-term portion of $20,910,939 = $21,995,508.
  • $21,995,508 minus the 2013 long-term portion of $18,930,965 = $3,064,543 of new Long-Term debt.

If the $1,230,735 change in the Due to Clovis Supply balance were included, the number would be $1,833,808.

The calculation of new long-term debt is complicated by the conversion of Schumacher’s $4,112,432 of personal loans from long-term debt to equity in 2014. That $4,112,432 was included in long-term debt at the end of 2013, but not included in long-term debt at the end of 2014. The conversion was a non-cash event, and so the true amount of new long-term debt acquired by Sequoia Properties is $4,112,432 higher, i.e., $3,064,543 plus $4,112,432 = $7,176,975 of new long-term debt in 2014.

Course overview: Analytical Decision Tree and the Credit Write-Up

 

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