Docstoc

Closed End

Document Sample
Closed End Powered By Docstoc
					                                          CLOSED-END
CU Name: Example 1 CU                                                      Loan Portfolio                          Notes:
Loan Amount                               $ 500.00                 Credit Union # Members                 26,700
Loan Term in days                                90                % of Members Using PDL Product         1.00%
# days between payments                          30                # Members Using PDL Product               267   # Members using PDL over 1 yr
Number of payments                                3                % of Consistent Users                    75%    % Members consistently using product
Number of loan periods/yr                         4                # of Consistent Users                     200   # Members consistently using product
Annual Interest Rate                           18%                 Average Loan Amount              $       300    Avg rather than max
Periodic Interest Rate                       1.50%                 Average # Advances/Yr                       3
Periodic Payment                           $171.69                 Total # Loans/Yr                          601   # Consistent users X avg advances
Cost of Funds                                   2%                 Total $ Loans Made               $   180,225    # Loans X avg loan amount
                                                                   Avg Outstanding Balance          $    45,056    Total $ loans/# loan periods/yr
Income:                                                            Income from Loans                $     8,110    Avg outstanding X APR
  Interest Income                                         $15.07   Income from App Fees             $    12,015    Total # loans X app fees
  Application Fee                                     $    20.00   Other Fee Income                 $       360    Total # loans X late fee/loan
  Other Fee Income                                                 Total Income                     $    20,486
    Late Fee                              $   15.00   $     0.60
Total Income per Loan Advance                             $35.67   Expenses:
                                                                    Credit Checks                   $       601    Cost of credit check X total # loans made
Expenses:                                                           Loan Labor Costs                $     4,355    Labor costs X total # loans made
 Credit Check                                         $     1.00    Collection Labor Costs          $       523    Collection costs X total # loans made
 Time to generate/service a loan in hrs        0.50                 Loan Loss Expenses              $     3,965    Total $ loans made X loss ratio
 Hourly salary                            $   14.50                 Cost of Funds Expenses          $       901    Avg Outstanding Bal X COF ratio
 Loan Labor Costs                                     $     7.25   Total Expenses                   $    10,345
 Cost of Funds                                        $     0.83
 Other Overhead                                       $      -     Total Income                     $    10,141
Delinquency Ratio/Mo/# Borrowers               12%
Collection time per deliq loan in hrs           0.5
 Collection Expenses per loan                         $     0.87
Loan Loss Ratio/Total $ Loans Made            2.20%
 Loan Losses per loan                                 $    11.00
Total Loan Expenses per Loan                          $    20.95

Total Income per Loan Advance                             $14.72
                                            OPEN-END
CU Name: Example 2 CU                                                      Loan Portfolio                          Notes:
Loan Amount                               $ 500.00                 Credit Union # Members                 26,700
Loan Term in days                                90                % of Members Using PDL Product         1.00%
# days between payments                          30                # Members Using PDL Product               267   # Members using PDL over 1 yr
Number of payments                                3                % of Consistent Users                    90%    % Members consistently using product
Number of loan periods/yr                         4                # of Consistent Users                     240   # Members consistently using product
Annual Interest Rate                           18%                 Average Loan Amount              $       300    Avg rather than max
Periodic Interest Rate                       1.50%                 Average # Advances/Yr                       3
Periodic Payment                           $171.69                 Total # Loans/Yr                          721   # Consistent users X avg advances
Cost of Funds                                   2%                 Total $ Loans Made               $   216,270    # Loans X avg loan amount
                                                                   Avg Outstanding Balance          $    54,068    Total $ loans/# loan periods/yr
Income:                                                            Income from Loans                $     9,732    Avg outstanding X APR
  Interest Income                                      $15.07      Income from Annual Fees          $    13,350    Total # users X annual fees
  Annual Fee                                          $ 50.00      Other Fee Income                 $       433    Total # loans X late fee/loan
  Other Fee Income                                                 Total Income                     $    23,515
    Late Fee                              $ 15.00     $     0.60
Total Income per Loan Advance                             $65.67   Expenses:
                                                                    Credit Checks                   $       267    Cost of credit check X total # users
Expenses:                                                           Loan Labor Costs                $     2,613    Labor costs X total # loans made
 Credit Check                                         $     1.00    Collection Labor Costs          $       627    Collection costs X total # loans made
 Time to generate/service a loan in hrs      0.25                   Loan Loss Expenses              $     4,758    Total $ loans made X loss ratio
 Hourly salary                            $ 14.50                   Cost of Funds Expenses          $     1,081    Avg Outstanding Bal X COF ratio
 Loan Labor Costs                                     $     3.63   Total Expenses                   $     9,347
 Cost of Funds                                        $     0.83
 Other Overhead                                       $      -     Total Income                     $    14,168
Delinquency Ratio/Mo/# Borrowers              12%
Collection time per deliq loan in hrs          0.5
 Collection Expenses per loan                         $     0.87
Loan Loss Ratio/Total $ Loans Made           2.20%
 Loan Losses per loan                                 $ 11.00
Total Loan Expenses per Loan                          $ 17.33

Total Income per Loan Advance                             $48.35
                                                  CLOSED-END
CU Name: Example 1 CU                                                                Loan Portfolio
Loan Amount                               500                                Credit Union # Members           26700
Loan Term in days                         90                                 % of Members Using PDL Product   0.01
# days between payments                   30                                 # Members Using PDL Product      =E3*E4
Number of payments                        =B4/B5                             % of Consistent Users            0.75
Number of loan periods/yr                 4                                  # of Consistent Users            =E5*E6
Annual Interest Rate                      0.18                               Average Loan Amount              300
Periodic Interest Rate                    =(B8/360)*B5                       Average # Advances/Yr            3
Periodic Payment                          =PMT(B9,B6,-B3)                    Total # Loans/Yr                 =E7*E9
Cost of Funds                             0.02                               Total $ Loans Made               =E10*E8
                                                                             Avg Outstanding Balance          =E11/B7
Income:                                                                      Income from Loans                =E12*B8
  Interest Income                                           =B10*B6-B3       Income from App Fees             =E10*C15
  Application Fee                                           20               Other Fee Income                 =E10*C17
  Other Fee Income                                                           Total Income                     =SUM(E13:E15)
    Late Fee                              15                =(B27*B17)/B6
Total Income per Loan Advance                               =C14+C15+C17 Expenses:
                                                                              Credit Checks                   =C21*E10
Expenses:                                                                     Loan Labor Costs                =C24*E10
 Credit Check                                               1                 Collection Labor Costs          =C29*E10
 Time to generate/service a loan in hrs   0.5                                 Loan Loss Expenses              =E11*B30
 Hourly salary                            14.5                                Cost of Funds Expenses          =E12*B11
 Loan Labor Costs                                           =B23*B22         Total Expenses                   =SUM(E19:E23)
 Cost of Funds                                              =((B3/B7)*B11/B6)
 Other Overhead                                             0               Total Income                      =E16-E24
Delinquency Ratio/Mo/# Borrowers          0.12
Collection time per deliq loan in hrs     0.5
 Collection Expenses per loan                               =(B23*B28)*B27
Loan Loss Ratio/Total $ Loans Made        0.022
 Loan Losses per loan                                       =B3*B30
Total Loan Expenses per Loan                                =SUM(C21:C31)

Total Income per Loan Advance                               =C18-C32
                                                  OPEN-END
CU Name: Example 2 CU                                                                Loan Portfolio
Loan Amount                               500                                Credit Union # Members           26700
Loan Term in days                         90                                 % of Members Using PDL Product   0.01
# days between payments                   30                                 # Members Using PDL Product      =E3*E4
Number of payments                        =B4/B5                             % of Consistent Users            0.9
Number of loan periods/yr                 4                                  # of Consistent Users            =E5*E6
Annual Interest Rate                      0.18                               Average Loan Amount              300
Periodic Interest Rate                    =(B8/360)*B5                       Average # Advances/Yr            3
Periodic Payment                          =PMT(B9,B6,-B3)                    Total # Loans/Yr                 =E7*E9
Cost of Funds                             0.02                               Total $ Loans Made               =E10*E8
                                                                             Avg Outstanding Balance          =E11/B7
Income:                                                                      Income from Loans                =E12*B8
  Interest Income                                           =B10*B6-B3       Income from Annual Fees          =E5*C15
  Annual Fee                                                50               Other Fee Income                 =E10*C17
  Other Fee Income                                                           Total Income                     =SUM(E13:E15)
    Late Fee                              15                =(B27*B17)/B6
Total Income per Loan Advance                               =C14+C15+C17 Expenses:
                                                                              Credit Checks                   =C21*E5
Expenses:                                                                     Loan Labor Costs                =C24*E10
 Credit Check                                               1                 Collection Labor Costs          =C29*E10
 Time to generate/service a loan in hrs   0.25                                Loan Loss Expenses              =E11*B30
 Hourly salary                            14.5                                Cost of Funds Expenses          =E12*B11
 Loan Labor Costs                                           =B23*B22         Total Expenses                   =SUM(E19:E23)
 Cost of Funds                                              =((B3/B7)*B11/B6)
 Other Overhead                                             0                Total Income                     =E16-E24
Delinquency Ratio/Mo/# Borrowers          0.12
Collection time per deliq loan in hrs     0.5
 Collection Expenses per loan                               =(B23*B28)*B27
Loan Loss Ratio/Total $ Loans Made        0.022
 Loan Losses per loan                                       =B3*B30
Total Loan Expenses per Loan                                =SUM(C21:C31)

Total Income per Loan Advance                               =C18-C32

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:11
posted:3/1/2010
language:English
pages:6