Docstoc

Analysis of Cash Flow - RMIC - Republic Mortgage Insurance Company

Document Sample
Analysis of Cash Flow - RMIC - Republic Mortgage Insurance Company Powered By Docstoc
					                      Cash Flow Analysis Calculator
This Cash Flow Analysis Calculator and accompanying guidelines have been designed to assist in the development of
qualifying income for situations in which tax return analysis is typically required. Examples include borrowers who
have 25% or greater interest in a business, are employed by a family member, are paid commission, own rental
property, receive variable income, have earnings reported on IRS Form 1099, or income that cannot otherwise be
verified by an independent, knowledgeable source. For additional information and complete underwriting guidelines,
go to http://www.efanniemae.com.
A value must be entered in each cell to correctly calculate income. If there is no value related to a specific
cell, enter "0".

                                                                               Year                    Year
                                                                          20                      20
Form 1040 - Individual Income Tax Return
  1 Total Income                                                                      $0.00                   $0.00
  2 Wages, Salaries, Tips Considered Elsewhere                        (               $0.00 ) (               $0.00 )
  3 Tax-Exempt Interest Income                                                        $0.00                   $0.00
  4 State and Local Tax Refunds                                       (               $0.00 ) (               $0.00 )
  5 Nonrecurring Alimony Received                                     (               $0.00 ) (               $0.00 )
  6 Negate Schedule D (Income) Loss                                                   $0.00                   $0.00
  7 Negate Form 4797 other gains and losses                                           $0.00                   $0.00
  8 Pension and/or IRA Distributions
                                                       if recurring                   $0.00                   $0.00
                                                  if nonrecurring     (               $0.00 ) (               $0.00 )
  9 Negate Schedule E (Income) Loss                                                   $0.00                   $0.00
 10 Nonrecurring Unemployment Compensation                            (               $0.00 ) (               $0.00 )
 11 Social Security Benefits
                                                      If recurring                    $0.00                   $0.00
                                                  if nonrecurring     (               $0.00 ) (               $0.00 )
 12 Nonrecurring Other (Income) Loss                                                  $0.00                   $0.00
 13 Other                                                                             $0.00                   $0.00

Form 2106 - Employee Business Expenses
  1 Total Expenses                                                    (               $0.00 ) (               $0.00 )
  2 Depreciation                                                                      $0.00                   $0.00

Schedule B - Interest and Dividends
  1 Nonrecurring Interest Income                                      (               $0.00 ) (               $0.00 )
  2 Nonrecurring Dividend Income                                      (               $0.00 ) (               $0.00 )

Schedule C - Sole Proprietorship
  1 Nonrecurring Other (Income) Loss/Expense                                          $0.00                   $0.00
  2 Depletion                                                                         $0.00                   $0.00
  3 Depreciation                                                                      $0.00                   $0.00
  4 Meals and Entertainment Exclusion                                 (               $0.00 ) (               $0.00 )
  5 Business Use of Home                                                              $0.00                   $0.00
  6 Amortization/Casualty Loss/One Time Expenses                                      $0.00                   $0.00
  7 Mileage Depreciation                                                              $0.00                   $0.00

Schedule D - Capital Gains and Losses
  1 Recurring Capital Gains/(Loss)                                                    $0.00                   $0.00

Form 4797 - Sales of Business Property
  1 Recurring Capital Gains/(Loss)                                                    $0.00                   $0.00

Form 6252 - Installment Sale Income
  1 Principal Payments Received                                                       $0.00                   $0.00

Schedule E - Rent and Royalty Income
  1 Gross Rents and Royalties Received                                                $0.00                   $0.00
  2 Total Expenses before Depreciation                                (               $0.00 ) (               $0.00 )
  3 Amortization/Casualty Loss/One-Time Expenses                                      $0.00                   $0.00
  4 Insurance, Mortgage Interest, & Taxes                                             $0.00                   $0.00
  5 Annualized Mortgage Payment                                       (               $0.00 ) (               $0.00 )
Schedule F - Profit or Loss for Farming
  1 Non-Tax Portion Ongoing Coop and CCC Pmts                                   $0.00        $0.00
  2 Nonrecurring Other (Income) Loss                                            $0.00        $0.00
  3 Depreciation                                                                $0.00        $0.00
  4 Amortization/Casualty Loss/Depletion                                        $0.00        $0.00
  5 Business use of Home                                                        $0.00        $0.00

Partners Share of Income - Schedule K-1 (Form 1065)
  1 Ordinary Income (Loss)                                                      $0.00        $0.00
  2 Net Income (Loss)                                                           $0.00        $0.00
  3 Guaranteed Payments to Partner                                              $0.00        $0.00

Shareholders Share of Income - Schedule K-1 (Form 1120s)
  1 Ordinary Income (Loss)                                                      $0.00        $0.00
  2 Net Income (Loss)                                                           $0.00        $0.00

                           Total Income for Personal Returns                    $0.00        $0.00

Partnership (Form 1065)
  1 Pass-Through (Income) Loss From Other Partnerships                          $0.00        $0.00
  2 Nonrecurring Other (Income) Loss                                            $0.00        $0.00
  3 Depreciation                                                                $0.00        $0.00
  4 Depletion                                                                   $0.00        $0.00
  5 Amortization/Casualty Loss                                                  $0.00        $0.00
  6 Mortgage/Notes Payable in Less than 1 Year                    (             $0.00 ) (    $0.00 )
  7 Meals and entertainment Exclusion                             (             $0.00 ) (    $0.00 )
  8 Subtotal                                                                    $0.00        $0.00
  9 Ownership Percentage Listed on Schedule K-1                                 0.00%        0.00%
 10 Total Partnership Income                                                    $0.00        $0.00

S-Corporation (Form 1120s)
  1 Nonrecurring Other (Income) Loss                                            $0.00        $0.00
  2 Depreciation                                                                $0.00        $0.00
  3 Depletion                                                                   $0.00        $0.00
  4 Amortization/Casulty Loss                                                   $0.00        $0.00
  5 Mortgage/Notes Payable in Less than 1 Year                    (             $0.00 ) (    $0.00 )
  6 Meals and Entertainment Exclusion                             (             $0.00 ) (    $0.00 )
  7 Subtotal                                                                    $0.00        $0.00
  8 Ownership Percentage Listed on Schedule K-1                                 0.00%        0.00%
  9 Total S-Corporation Income                                                  $0.00        $0.00

Corporation (Form 1120)
  1 Taxable Income                                                              $0.00        $0.00
  2 Total Tax                                                     (             $0.00   )(   $0.00   )
  3 Nonrecurring (Gains) Loss                                                   $0.00        $0.00
  4 Nonrecurring Other (Income) Loss                                            $0.00        $0.00
  5 Depreciation                                                                $0.00        $0.00
  6 Depletion                                                                   $0.00        $0.00
  7 Amortization/Casualty Loss                                                  $0.00        $0.00
  8 Net Operating Loss and Special Deductions                                   $0.00        $0.00
  9 Mortgages/Notes Payable in Less than 1 Year                   (             $0.00   )(   $0.00   )
 10 Meals and entertainment Exclusion                             (             $0.00   )(   $0.00   )
 11 Subtotal                                                                    $0.00        $0.00
 12 Ownership Percentage Listed on Page 2, Schedule E                           0.00%   )(   0.00%   )
    Modified Subtotal                                                           $0.00        $0.00
 13 Dividends Paid to Borrower                                    (             $0.00   )(   $0.00   )
 14 Total Corporation Income                                                    $0.00        $0.00

Totals
  1 Total Income from Personal Return                                           $0.00        $0.00
  2 Total Income from Partnership                                               $0.00        $0.00
  3 Total income from S-Corporation                                             $0.00        $0.00
  4 Total Income from Corporation                                               $0.00        $0.00
  5 Grand Total                                                                 $0.00        $0.00

           Key in number of months in order to annualize income          0
                      Applicable income Grand Total First Year         $0.00
                    Applicable income Grand Total Second Year          $0.00
                                                Monthly Income        #DIV/0!