• 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 Real Estate

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

Session #3: Guarantor Analysis, Global Cash Flow, and the Second Way Out


  • admin

  • 2/7/2020 4:10:32 PM

  • 732

  • Credit College - Commercial Real Estate
  • Copy / Share Link

Q: In calculating Mr. Schumacher’s personal cash flow you deduct taxes paid for FICA ($3,720); Medicare ($870); and City/SDI ($232). Why aren’t social security taxes withheld also deducted? Also, if Mr. Schumacher hypothetically were to provide his W-2 and it showed a deduction for amounts contributed to a 401-K or similar qualified retirement plan should that amount also be deducted from his personal cash flow since it is not cash that is available to him? Or does it not apply because it is a pre-tax contribution? Suppose it is a Roth contribution, does that make any difference?

A: FICA usually refers to both social security and Medicare taxes. Both are generally included in the term "FICA". In this instance, FICA really refers to social security taxes. It's mis-labled, in effect, in Statement 1.

If we had information about a contribution to a 401k, we should use it since it reduces the taxpayer's cash available to service debt. Cash revenue would be decreased by the amount of the contribution. Pre-tax isn't relevant because any tax impact would be picked up in computing cash taxes paid for the year. The same considerations apply to a Roth IRA.

Q: In order to find the amount of taxes paid for FICA, Medicare, and City/SDI you need Form 1040 Statement 1. In other words, in the case of Schumacher’s 2014 personal tax return the taxes he paid for FICA, Medicare, and City/SDI would not appear/are not included on page 2 of the Form 1040. Only the federal income taxes he paid are shown on Page 2. Correct?

A: FICA taxes (including Medicare) are not captured on the 1040. Very likely they will not be included in any Statement, which means that an analyst will need to estimate them, using the self-employment tax rates and thresh hold amounts for the year in question. We set up such a computation in Session 4 in the Tax College.


Q: A recent commercial loan request will be personally guaranteed by the business owner. In calculating his personal cash flow for 2018 (with respect to federal cash taxes paid) I followed the example provided for Mr. Schumacher in Exercise #3:  

Prior Year (2017) federal income tax refund: $411,572
2018 Federal income tax withheld from W-2: 353,000
2018 Estimated federal income tax payments: $75,000
= Total federal cash taxes paid in 2018: $16,428

A: Correct, but check the 2017 return to see if there is any refund amount desginated to be applied to the 2018 federal income tax obligation. If so, use only the amount not applied as cash flow to him in 2018. For example, if he specified $200,000 of the 2017 refund to be applied to 2018 federal income taxes, then we can assume the IRS wrote him a check for $211,572 which he received and cashed in 2018.

Q: If the guarantor had applied the full amount of the 2017 tax refund to his 2018 estimated tax would I remove the refund from my numbers above or would the net effect be the same? In addition, if our guarantor receives any state income tax refunds in 2018 can I include them when calculating his total personal revenue for that year?

A: Yes, remove the full amount if he applied it all to his 2018 federal income taxes. If the taxpayer receives any state income tax refunds, use them to reduce the total of Cash Taxes Paid.

Q: On Mr. Schumacher’s 2014 1040 Schedule A (Itemized Deductions) he reports on line 14 investment interest of $9,728. Is there ever a scenario whereby this investment interest should be added back when calculating Mr. Schumacher’s annual revenue?

A: The $9,728 represents interest expense he paid on his margin account and it is included as a cash outflow in the Personal Debt Service section on the Schumacher personal cash flow statement.

Q: You mentioned to me that a Subchapter S, Partnership, or LLC will never show the Section 179 expense deduction deduction on its tax return. However, in reviewing Mr. Schumacher’s 2014 1040 Schedule E (Part II) he is reporting for Clovis Supply, LTD and Modesto Services, Inc. Section 179 expense deductions of $27,844 and $86,100 respectively. These amounts are also included on the K-1 (Form 1120S) for both Clovis Supply and Modesto Services. I’m confused? Why is this? Is there ever a scenario whereby the Section 179 expense appearing on Mr. Schumacher’s Form 1040 should be added back when calculating his personal cash flow or added back when calculating the business cash flow of Clovis Supply or Modesto Services?

A: The reference to the Section 179 Deduction never appearing on the tax returns was to the business income tax returns for a Sub S, partnership, and LLC. That is, the Section 179 Deduction never appears as an expense in computing ordinary business income for those three types of business organizations. Therefore, it is not - and cannot - be added back in computing traditional cash flow or EBITDA based only on the business income tax returns. Further, it never appears - is disallowed by GAAP - as an expense on an accrual income statement.

Re the personal cash flow statement, the Section 179 Deduction is used only to reduce ordinary business income reported by an owner of partner of an S Corp, partnership,or LLC on his or her Schedule E. The resulting number is non-cash to the taxpayer and is not used in computing a personal cash flow statement.

The Section 179 Deduction is never used in computing cash flow for a Sub S, partnership, or LLC. Nor is it ever used in computing the personal cash flow statement for owners of a Sub S, partnership, or LLC.
 

Categories
  • Commercial Real Estate(33)
    • Commercial Real Estate(32)
    • Questions: Commercial Real Estate - Hands On(1)
  • Contractors(52)
    • Understanding and Analyzing Contractor Financial Statements: Part I of II(32)
    • Understanding and Analyzing Contractor Financial Statements: Part II of II(20)
  • Covenants(11)
    • Complex Loan Structuring(1)
    • Covenant Testing(1)
    • Covenant Use in Controlling Cash Outflows(5)
    • Financial Gap Ratio(1)
    • Financing Gap revisited(1)
    • The Financing Gap Ratio - defined(1)
    • UCA cash flow and debt service coverage?(1)
  • Credit College - Accounting Essentials(107)
    • Session #1: Financial Statement Structure and Composition(39)
    • Session #2: Double Entry Accounting, the Accounting Equation, and Debits and Credits(24)
    • Session #3: Critical Accounting Principles and Assumptions and More Debits and Credits(23)
    • Session #4: Recording Transactions and Creating the Balance Sheet and Income Statement(21)
  • Credit College - Cash Flow(14)
    • Session #1: UCA Cash Flow Statement, Traditional "Cash Flow," and EBITDA(8)
    • Session #2: Cash Impact Analysis, Borrowing Causes Revisited, and Management Assessment(2)
    • Session #3: FASB 95 Statement of Cash Flows Conversion to UCA Cash Flow Statement(1)
    • Session #4: Cash Flow Proxies, Debt Capacity, and the UCA Cash Flow Statement(3)
  • Credit College - Commercial Business(208)
    • Session #1: Analytical Decision Tree and the Credit Write-Up(29)
    • Session #2: Financial Statement Review and Ratio Analysis(43)
    • Session #3: Cash Flow Analysis and Borrowing Causes(34)
    • Session #4: Management Assessment, Projected Cash Flow, and the First Way Out(20)
    • Session #5: Guarantor Analysis and the Second Way Out(30)
    • Session #6: Non-Financial Red Flags and Performance Implications(13)
    • Session #7: Identifying and Mitigating Repayment Risks(21)
    • Session #8: The Credit Write-Up Again(18)
  • Credit College - Commercial Real Estate(218)
    • Session #1: The Credit Write-Up and the CRE Analytical Process(28)
    • Session #2: Ratios, Borrower Cash Flow, and the First Way Out(33)
    • Session #3: Guarantor Analysis, Global Cash Flow, and the Second Way Out(40)
    • Session #4: The Appraisal Report and Approaches to Market Value(9)
    • Session #5: The Income Capitalization Approach and the Cap Rate(24)
    • Session #6: Underwriting Standards. Actual vs. Stabilized NOI, and Breakeven Analysis(54)
    • Session #7: Management Assessment, Competitive Forces, and Projected Performance(16)
    • Session #8: Repayment Risks, Covenants, and the Credit Write-Up Revisited(14)
  • Credit College - Credit Basics(93)
    • General(1)
    • Session #1: Understanding Financial Statements and Business Organizations(34)
    • Session #2: Personal Qualities and Competitive Advantages(8)
    • Session #3: Critical Ratios and The First Necessary Condition for Business Success(28)
    • Session #4: Non-Financial Red Flags, Cash Flow and Second Necessary Condition for Business Success(22)
  • Credit College - Taxes(213)
    • Analysis Using Business Tax Returns(1)
    • Converting business income tax returns into accrual financial statements(1)
    • Employee Retention Credit (ERC)(1)
    • Session #1: Business Income Tax Returns(21)
    • Session #2: The Section 179 Deduction(29)
    • Session #3: Understanding Schedules K-1(19)
    • Session #4: Personal Income Tax Returns and Cash Flow(14)
    • Session #5: Schedule M-1 and the Accrual Income Statement(25)
    • Session #6: Business Income Tax Returns and Ratio Analysis(58)
    • Session #7: Business Income Tax Returns and Cash Flow Analysis(23)
    • Session #8: Cash Based Income Tax Returns(21)
  • Credit Curriculum(1)
  • Credit Write Up(33)
    • Analytical Focus in the Credit Write Up(27)
    • Description and Analysis in the Credit Write-Up(6)
  • Debt Capacity(9)
  • Financial Analysis(55)
    • ACS (Accounting Standards Codification) 842(1)
    • Analysis when one spouse is not a guarantor(1)
    • Auto Dealer analysis(1)
    • Auto Dealership/UCA/Floor-Plan debt(1)
    • Capital Gains(1)
    • Cash distributions, Business cash flow and Guarantor global cash flow(1)
    • Corporate tax return or CPA prepared financial statements?(1)
    • CPA firms and legal firms(1)
    • Credit Analysis Question(1)
    • CSVLI - Cash Surrender Value of Life Insurance(1)
    • Depreciation FAQ(1)
    • Distributions(1)
    • Distributions taken from prior year earnings(1)
    • EBITDA, Defined(1)
    • ESOP financing(1)
    • FAQ - calculating Business Profit (1)
    • Financing Needs(2)
    • Flooring Lines(1)
    • Funded Debt to EBITDA(1)
    • Gain on sale and traditional cash flow(1)
    • Insurance Company statements(1)
    • Language of Business On-Line Classroom Q & A(1)
    • Lending to a Start-up(1)
    • Market and industry data sources(1)
    • More on Depreciation(1)
    • Participations and private equity firms(1)
    • Pitfalls of Partial Analysis(4)
    • Prior Period Adjustments to Retained Earnings(1)
    • Ratios and Messages about Profitability and Cash Flow(12)
    • Schedule L(1)
    • Section 263A(1)
    • Self-Employment Tax(1)
    • Session #1: Business Income Tax Returns(1)
    • Session #2: The Section 179 Deduction(1)
    • SG&A% - Another FAQ(1)
    • SG&BC Course Progress Check Question(1)
    • Syndicated Loans(1)
    • Tax Returns vs. Accrual Statements in Assessing Borrower Risk(2)
    • UCA debt coverage ratio for an interim(1)
  • Five Cs of Credit(10)
  • Fund Accounting(52)
    • Fund Accounting and Municipality Analysis: Part I of II(31)
    • Fund Accounting and Municipality Analysis: Part II of II(20)
    • GASB 68(1)
  • Global Cash Flow(51)
    • Borrower with many corporations(1)
    • Global Cash Flow(50)
  • Healthcare(18)
    • Assessing Hospital Financial Performance(6)
    • Assessing Medical Practices(9)
    • Forces Impacting Hospital Financial Performance(3)
  • Loan Documentation(53)
    • Commercial Loan Documentation(30)
    • Commercial Real Estate Loan Documentation(23)
  • Minimum Financial Data(14)
  • Not for Profit Analysis(24)
  • Personal Income Tax Returns and Cash Flow(65)
    • Session #3: Understanding Schedules K-1(27)
    • Session #4: Personal Income Tax Returns and Cash Flow(38)
  • Problem Loans - Loan Classification(2)
  • Projections(22)
    • Projections and Repayment Sources: Part I of II(13)
    • Projections and Repayment Sources: Part II of II(9)
  • Spreading Financial Statements(6)
  • Stress Testing(1)
  • Testing(2)
    • Exams(1)
    • How do the Credit College exams work?(1)
  • Trusts(2)
    • Trust Returns(1)
    • Trusts(1)
  • UCA Cash Flow(58)
    • Advanced UCA Cash Flow: Part I of II(51)
    • Advanced UCA Cash Flow: Part II of II(4)
    • Related Party Transactions and the UCA Cash Flow Statement(1)
    • Sales Neutral Business Cash Income(1)
    • UCA Cash Flow and Agricultural Loans(1)
  • Working Capital and UCA Cash Flow(27)
Shockproof! Training

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

  • About
  • Career Opportunities

© Copyright 2001-2025 Shockproof! Training