LoanVibe Worksheet - Mr Bill Johnson

July 5, 2004
Mr Bill Johnson 1234 Oak Street Torrance, CA 90503 Dear Mr Bill Johnson, Mortgage loans operate as simple interest loans. That is, interest is charged against the current outstanding balance at any given time. This means that your own particular re-payment habits can have a tremendous impact on both the term of the loan and its total interest charges. The following table shows the current payment schedule for your existing loan in the first row. The next four rows show four alternative payment schedules and their effect on costs and term.
Re-payment Option Analysis
Options	Terms	Payment	Add to Pmt	New Term	Ttl Pmts	Ttl Costs
Original Pmt Schedule	30 year fixed rate	$1,216		360	$437,776	$202,576
Option 1	30 year fixed rate	$1,466	$250	255	$373,841	$137,541
Option 2	30 year fixed rate	$1,216	*PPS	335	$418,375	$182,407
Option 3	30 year fixed rate	$1,216	x26	332	$403,727	$167,955
Option 4	30 year fixed rate	$1,216	x24	359	$435,952	$200,312
	*PPS for option 2- 012:1000,024:1000,036:1000,048:1000,060:1000,072:1000,084:1000,096:1000,108:1000,120:1000,132:1000
	BOTTOM LINE Option 1 provides the quickest payoff in month 255 saving $65,035



The following pages will provide a detailed description of each loan considered as well as additional performance estimates. If you have any questions please call me at 310-555-1234. Thank you for considering ACME Mortgage. Sincerely, Joe Officer

prepared for:	prepared by:
Mr Bill Johnson 1234 Oak Street Torrance CA 90503 310-555-0000, 310-328-6200 testcust@loanvibe.com	Joe Officer ACME Mortgage 1234 Main Street Torrance, CA 90503 310-555-1234, 310-555-6525 joe@perfectfinancial.com


Transaction Descriptions	Loan 1	Loan 2	Loan 3	Loan 4	Loan 5

Loan Name:	Standard Fixed	Standard Add_2_Pmt	Standard PPS	Standard BiWeekly	Standard Semi_month
Lender Name:	In House	In House	In House	In House	In House
Type:	30 year FIXED	30 year FIXED	30 year FIXED	30 year FIXED	30 year FIXED

Start Rate:	4.500%	4.500%	4.500%	4.500%	4.500%
Points:	2.000%	2.000%	2.000%	2.000%	2.000%
Adjustable Description: [adjs,caps]	Fixed	Fixed	Fixed	Fixed	Fixed

APR:	4.67%	4.67%	4.67%	4.67%	4.67%
Loan Amount:	$240,000	$240,000	$240,000	$240,000	$240,000
Closing Costs:	$4,800	$4,800	$4,800	$4,800	$4,800

Last Payment Month:	360	255	335	332	359
Return on Refinance- Costs [ROR]:	0	96	167	1	1
Total Return on Refinance- Costs [TRR]:	$0	$69,835	$24,970	$39,421	$7,064

Return on Refinance- Payment:	0	259	339	336	361
Total Return on Refinance- Payments:	$0	$132,485	$35,201	$38,849	$6,624
Income Required to Qualify:	$4,285	$4,285	$4,285	$4,285	$4,285

Qualify Ratios:	14/14%	14/14%	14/14%	14/14%	14/14%
Start Payment [PITI]:	$1,414	$1,414	$1,414	$1,414	$1,414
Refinance Cash-Out:	$0	($4,800)	($4,800)	($4,800)	($4,800)

Borrower's Monthly Income:	$10,417	$10,417	$10,417	$10,417	$10,417
Borrower's Tax Bracket:	30%	30%	30%	30%	30%
Adjustment- Add to Payment Amount:	$0	$250	$0	$0	$0

Adjustment- Principal Payment Schedule [PPS]:	not used	not used	schedule used	not used	not used
Adjustment- Accelerated Payments:	none	none	none	Bi-weekly pmts	Semi-month pmts

prepared for:	prepared by:
Mr Bill Johnson 1234 Oak Street Torrance CA 90503 310-555-0000, 310-328-6200 testcust@loanvibe.com	Joe Officer ACME Mortgage 1234 Main Street Torrance, CA 90503 310-555-1234, 310-555-6525 joe@perfectfinancial.com


Worksheet	Loan 1	Loan 2	Loan 3	Loan 4	Loan 5
Evaluation for month: 096
Accum Costs	$85,101	$80,277	$83,690	$77,515	$84,692
Accum Costs Compare	higher by $7,586	higher by $2,762	higher by $6,175	lowest	higher by $7,177
Accum Payment	$116,740	$140,740	$124,740	$116,740	$116,740
Accum Payment Compare	higher by $0	higher by $24,000	higher by $8,000	lowest	lowest
Payment	$1,216	$1,466	$2,216	$608	$608
Evaluation for month: 255
Accum Costs	$180,276	$137,541	$169,234	$156,622	$178,897
Accum Costs Compare	higher by $42,735	lowest	higher by $31,693	higher by $19,081	higher by $41,357
Accum Payment	$310,091	$373,841	$321,091	$310,091	$310,091
Accum Payment Compare	lowest	higher by $63,750	higher by $11,000	higher by $0	higher by $0
Payment	$1,216	$1,466	$1,216	$608	$608
Evaluation for month: 332
Accum Costs	$200,792	$137,541	$182,388	$167,955	$198,783
Accum Costs Compare	higher by $63,251	lowest	higher by $44,847	higher by $30,414	higher by $61,242
Accum Payment	$403,727	$373,841	$414,727	$403,727	$403,727
Accum Payment Compare	higher by $29,885	lowest	higher by $40,885	higher by $29,885	higher by $29,885
Payment	$1,216	$0	$1,216	$608	$608
Evaluation for month: 335
Accum Costs	$201,143	$137,541	$182,407	$167,955	$199,106
Accum Costs Compare	higher by $63,602	lowest	higher by $44,866	higher by $30,414	higher by $61,565
Accum Payment	$407,375	$373,841	$418,375	$403,727	$407,375
Accum Payment Compare	higher by $33,534	lowest	higher by $44,534	higher by $29,885	higher by $33,534
Payment	$1,216	$0	$1,216	$0	$608
Evaluation for month: 359
Accum Costs	$202,572	$137,541	$182,407	$167,955	$200,312
Accum Costs Compare	higher by $65,031	lowest	higher by $44,866	higher by $30,414	higher by $62,771
Accum Payment	$436,560	$373,841	$418,375	$403,727	$435,952
Accum Payment Compare	higher by $62,719	lowest	higher by $44,534	higher by $29,885	higher by $62,111
Payment	$1,216	$0	$0	$0	$0
Evaluation for month: 360
Accum Costs	$202,576	$137,541	$182,407	$167,955	$200,312
Accum Costs Compare	higher by $65,035	lowest	higher by $44,866	higher by $30,414	higher by $62,771
Accum Payment	$437,776	$373,841	$418,375	$403,727	$435,952
Accum Payment Compare	higher by $63,935	lowest	higher by $44,534	higher by $29,885	higher by $62,111
Payment	$1,216	$0	$0	$0	$0

prepared for:	prepared by:
Mr Bill Johnson 1234 Oak Street Torrance CA 90503 310-555-0000, 310-328-6200 testcust@loanvibe.com	Joe Officer ACME Mortgage 1234 Main Street Torrance, CA 90503 310-555-1234, 310-555-6525 joe@perfectfinancial.com


Chart
Chart based on Accum Costs