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.
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.

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

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.

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.

The following values are system-calculated:

Total Funds Required (column D)
Total Fixed Asset Acquisition
Total Debt Payment
Total Working Capital
Total Funds

All other fields are editable.

Schedule of Fixed Obligations

Note the following:

Year 1/New SBA Loan - populates from the Amortization Schedule. It is Total Payment for Period 12 (or sum of Payments from periods 1 through 12).
Year 2/New SBA Loan - populates from the Amortization Schedule. It is the sum of Payments from periods 13 through 24.
Year 3/New SBA Loan - populates from the Amortization Schedule. It is the sum of Payments from periods 25 through 36.
4/New SBA Loan - populates from the Amortization Schedule. It is the sum of Payments from periods 37 through 48.

The following items are editable:

Existing SBA Loan
Notes
Rent/Lease
Blank descriptions and values (multiple rows)

The following items are system-calculated:

Total Fixed Obligations