Home
Procedures
Working With Financial Analysis Spreadsheets
This section is provided help while working with the financial spreadsheets for the Financial Analysis and Authorization screen.
Executive Summary - Affiliate 1-20

Procedures
- New Loan Workflow
- Adding a Loan Party
- Adding an Individual Party
- Adding an Entity Party
- Adding a Sole Proprietorship Party
- Adding a Related Party
- Using Nested Entities
- Working with Loans
- Quick Quotes
  This procedure explains how to create a quick quote.
- Working With Financial Analysis Spreadsheets
  This section is provided help while working with the financial spreadsheets for the Financial Analysis and Authorization screen.
  - Opening the Financial Analysis Spreadsheet
    This section is provided help opening the financial analysis spreadsheets.
  - Importing a Financial Analysis Spreadsheet
  - Spread Setup
    The Spread Setup spreadsheet allows you to enter information for each period that you plan to enter financial information
  - Balance Sheet – Historical
    Use the Balance Sheet spreadsheet to enter the applicant's historical balance sheet information.
  - Balance Sheet - Pro Forma
    The Balance Sheet - Pro Forma tab is provided to compile the information from the Lender's Guaranty page.
  - Profit and Loss – Historical
    The Profit and Loss - Historical spreadsheet is provided to enter the three-year Historical P&L information and the interim information.
  - Profit and Loss - Pro Forma
    The Balance Sheet - Pro Forma tab is provided to compile the information from the Lender's Guaranty page.
  - Sales Schedule
  - COGS Schedule
  - Other Expense Schedule – Historical
  - Other Expense Schedule – Projections
  - Executive Summary
  - Financial Ratios
  - Net Worth Reconciliation
  - UCA Cash Flow
  - Business Valuation Tab 1
  - Business Valuation Tab 2
  - Monthly Profit and Loss
  - Monthly Cash Flow
  - Accts Receivable/ Pay Aging
    The purpose of the Accts Receivable/ Pay Aging form is to provide an exhibit to detail the age of the borrower's accounts receivable and accounts payable.
  - Statement of Financial Need
    This spreadsheet provides lenders in SBA Region 4 with the required SBA form for detailing the sources and uses of funds for startup businesses that are applying for a SBA loan.
  - Bal Sheet – Hist – Affiliate 1-20
  - P&L-Hist-Affiliate 1-20
  - Executive Summary - Affiliate 1-20
  - Personal Cash Flow - Principal 1-10
  - Global Cash Flow
  - Debt Summary
    The Debt Summary is used to provide one location to input all of the borrower's debts.
  - Collateral Summary
    The Collateral Summary is used to provide one location to input all of the borrower's collateral.
  - Income Statement
    Information entered into the Income Statement tab is used in the Credit Memo.
  - Credit Memo
    The Credit Memo tab contains the SBA Loan Report, allowing you to print the report when required.
  - Disbursement Schedule
    The purpose of this form is to help keep track of disbursements.
- Importing Loans
  Data must first be in an XML format that conforms to our Import schema, which can be found on our Software support web site.
- Importing Transaction Data
- Exporting Transaction Data
- Updating TSoftPlus
- Creating Submitting a Loan from TSoftPlus to ETran
  add short description here

Executive Summary - Affiliate 1-20

The Executive Summary is a central collection point for the balance sheet, financial ratios, cash flow coverage calculations and debt summary for an Affiliate.

Note the following:

The Use of Proceeds/Lender is automatically populated by TSoftPlus and cannot be edited. It is a combination of the following different Use of Proceeds found on the Loan Information tab.
- Land Acquisition
  - Purchase Land only
  - Land and Improvements
  - Purchase Improvements
- Construction
  - Construct a Building
  - Add to Existing Building
  - Renovate Existing Building
  - Pay Off Interim Construction Loan
  - Pay Off Lender's Interim Loan
  - Leasehold Improvements
- Machinery & Equipment
  - Purchase Equipment
  - Purchase Furniture and Fixtures
- Inventory Purchase
  - Purchase Inventory
  - Pay Trade or Accounts Payable
- Working Capital
  - Working Capital
  - SBA Guaranty Fee
- Acquisition of Business
  - Purchase Business Asset
  - Purchase Business Stock
- Payoff SBA Loan
  - Refinance SBA Loan (Not Same Institution Debt)
  - Refinance SBA Loan (Same Institution Debt)
- Payoff Bank Loan
  - Pay Notes Payable (not same Institution Debt)
- Other Debt Repayment
  - Pay Notes Payable (Same Institution Debt)
- Other
  - Other
Prfma Yr 1/New SBA Loan (P + I) - Populates from the SBA Lending Amortization Schedule. It is the Total Payment for Period 12 (or sum of Payments from periods 1 through 12).
Prfma Yr 2/New SBA Loan (P + I) - Populates from the SBA Lending Amortization Schedule. It is the sum of Payments from periods 13 through 24.
Balance Sheet - populates from data entered in the "Bal Sheet - Hist- Affiliate 1-20".
Cash Flow/Coverage - populates from data entered in the "P & Loss- Hist - Affiliate 1-20".