|
|
|
LoanMaker® 27B for Palm Handhelds
Loan Routines - Retail & Balloon Loans
|
|
The LoanMaker has very complete loan calculation routines: you can calculate monthly,
weekly and biweekly payments. Through the setup screen, you can select a variety of
interest calculation methods, the use of prepaid charges, and two types of balloon
loans in addition to conventional retail installment loans.
For retail installment contracts, the program will calculate loans with sales tax (all
states), detailed unpaid balance calculations including cash down payments, cash rebates,
and trade-in allowances with optional payoff amounts. The sales tax can be financed or
paid at signing.
Using the Short Loan option, you can skip the unpaid balance calculation and enter the
amount directly. This makes for very fast and easy calculations.
Tapping the "Calc Loan" button computes the payment and displays an abbreviated
summary of the loan.
Tapping the "Details..." button provides a complete Truth-in-Lending disclosure of the loan.
(See "Loan Details" screen image below.)
Once you've found the payment, Tapping the "Am Schedule..." button generates a complete
amortization schedule of the loan. (See "Amortization" screen image below.)
Interest is calculated by the U.S. Escrow Rule using any of three different calendar systems: Federal (360) calendar, Actual/ 365, or Actual to 1st.
(See Samples.)
The resulting payment can be truncated or rounded, enabling you to match most payment
calculation systems.
A loan fee (prepaid finance charge) can be included in the
loan calculation and the A.P.R. is calculated.
The loan is amortized using the calendar
system selected on the Setup screen (see below).
The payment dates are shown in the left column, and the balance after the payment is
made in the right column. Loans up to 360 months can be amortized.
You can scroll up and down the schedule to look at any portion of the loan.
By tapping "Copy" at the top of the screen, the entire schedule is copied to the Palm
clipboard.
You can then paste it into a Memo or email message, and print it if your Palm is
connected to a PC.
|
Fuel Cost Comparison Routine
|
|
This routine enables you to quickly calculate the savings by moving to a
vehicle with better mileage. The savings is calculated by comparing two vehicles.
Based on the annual miles driven, the routine computes the annual amount of fuel for
each vehicle and the annual costs. The savings per year and per month is calculated.
Even though the monthly payment on a new vehicle may be higher, the borrower could
have a net savings because of a reduction in monthly fuel costs.
In the example at the left, there is a savings of $51.16 per month by moving from a 20-mpg
vehicle to a 28-mpg one.
The routine can also be used to illustrate that fuel savings of small vehicles can be
illusionary if too much of a premium is paid for the vehicle. A larger vehicle with
poorer mileage but with a substantial discount and/or cash back may be a better choice.
|
Lease Routines
Setup & Configuration Screen
|
|
The Setup screen has several options for both leases and loans. Extensive help is
built right into the program which provides a detailed explantion of the various
setup options.
There are several choices for loans:
You can elect to calculate two different types of balloon loans as well as regular
installment loans. Traditional as well as "Plus" balloons (one extra monthly
payment) can be calculated.
You can select amongst three interest calendars: Actual/365 (for simple interest),
Actual-to-First, or Federal Calendar (often used for precomputed and indirect loans).
All interest calculations are done by the US Rule which requires that unpaid interest
be held aside and not compounded.
The computed payment is truncated to the lower whole cent by default -- this is to
make sure that the entered interest rate is not exceeded even if only by a fraction. By
checking the "Round Pmt" box, you can elect to round the computed payment to the
nearest whole cent.
By enabling the Prepaid Charge option, you can use a loan or prepaid finance charge on
a loan. The APR and Finance Charge are adjusted to reflect the prepaid charge. (Note that
not all states allow a prepaid finance charge.)
By default the loan routine is designed to compute conditional sales contracts, including
downpayments, rebates, sales tax and so forth. By selecting the "Short Loan" option, you
can eliminate these extra items.
Detailed information on both the loan and lease options is available through the Help
button at the top of the screen.
|
Sample Loans with Amortization Schedules
|
The LeaseMaker 27B for Palm Handhelds supports three calendar systems:
-
Actual/365
-
Actual-to-first-payment
-
"Fed" Calendar.
To illustrate the differences, we've selected the following sample loan and have
computed it using each of the three systems:
-
Loan: $125,000
-
Term: 180 months
-
Rate: 15.000%
-
Loan Date: 5/25/04
-
First Due Date: 7/1/04
-
Payment is Rounded (not truncated)
The following table shows the payment calculated by each of the three calendar
systems.
|
|
Actual/365
|
Actual-to-First
|
"Fed" Cal
|
|
Payment
|
1,755.24
|
1,754.13
|
1,754.49
|
|
Sample Balloon Loan with Odd Days & Excess Mileage
|
The loan to the right was calculated with a conventional balloon and the Federal
interest calendar.
The $1000 rebate is applied to the cash downpayment and is not taxed.
The $50 Loan Fee is a prepaid finance charge and affects the A.P.R.
|
|
4.977 % APR
3475.68 Finance Chg
25727.80 Amt Financed
29203.48 Total Pmts
42103.48 Total Sale Price
38 Monthly Payments
322.46 Payment Amount
16950.00 Final Payment
7/29/04 Loan Date
9/1/04 First Due
11/1/07 Maturity Date
39 Term (months)
37500.00 Price
-21000.00 Trade
11800.00 Payoff
-2700.00 Cash Down
-1000.00 Rebate (not taxed)
40.00 Other-1 (taxed)
1087.80 CO 7.000% Tax
50.00 Loan Fee
25777.80 Note Amount
4.900 % Interest Rate
37500.00 MSRP
53 RV Percent
18000 Expected Mi/yr
12000 Allowed Mi/yr
19500 Tot excess miles
2925.00 Excess chg @ 0.15
16950.00 Final Pmt
15540.00 Taxed Amount
2700.00 Cash Down
1000.00 Rebate
3700.00 Total Drive-off
|
Sample Lease Disclosure
|
This sample lease disclosure is based on New York Tax law.
The disclosure will vary from state to state based on their sales tax
laws.
|
|
37500.00 Price
1922.83 NY 8.125% Tax
325.00 NY 8.125% Tax (on downpayment)
120.00 Other-1 (taxed)
650.00 Other-2 ~ (not taxed)
499.00 Bank Fee
41016.83 Gross Cap
2000.00 Cash Down
2000.00 Rebate
2250.00 Trade Equity
6250.00 Cap Reduction
34766.83 Adjusted Cap
37500.00 MSRP
800.00 Hard Adds
53 RV Percent
20299.00 Adj Residual
14467.83 Depreciation
55065.83 Cap + Resid
0.00500 Factor
10737.87 Total Rent
25205.70 Tot Base Pmts
39 Term
646.30 Total payment
7/28/04 Lease Date
10/28/07 Matures
20299.00 Purchase Opt
6250.00 Cap Reduction
646.30 Adv Payment
6896.30 Total Drive Off
|
Software Updates
|
Notice: The LoanMaker 27B is no longer available for sale -- Palm has discontinued the machines
that this program is designed to run on and the newer machines are not compatible. This
page is left here for reference purposes only.
This is a list of the most recent changes together with the date they
were made and the software version. The most recent version is at the top of the
list.
|
|
Date
|
Series
|
Changes
|
|
Aug 2008
|
2.2.52
|
Add Fuel Cost Comparison Routine
Update Loan routines
|
|
Sep 2007
|
2.0.49
|
Update to work with new Palm devices
|
|
Jul 2007
|
2.0.48
|
New version that runs from memory card
|
|
Oct 2005
|
1.0.44
|
Update Minnesota sales tax method for leases.
|
|
Oct 2005
|
1.0.43
|
Update New Jersey sales tax method for leases.
|
|
Dec 2004
|
1.0.42
|
Initial release.
|
22 Feb 2010
|