FINANCE ASSIGNMENT

Leila@

the_real_estate_project.zip

Home >Business & Finance homework help >FINANCE ASSIGNMENT

320 Assignment #1 Process A - Budget.ppt

Assignment #1
Buying your First Home

Take a deep breath, and do not shop yet!

Develop a Household Budget

Determine Your Mortgage Amount

What should you borrow

What is the maximum you can borrow

Estimate Expenses & Initial Closing Costs

Finalize How Much Home You Can Buy

NOW – you are ready to look for property!

Assignment #1
Buying your First Home

Take a deep breath, and do not shop yet!

Develop a Household Budget

Determine Your Mortgage Amount

What should you borrow

What is the maximum you can borrow

Estimate Expenses & Initial Closing Costs

Finalize How Much Home You Can Buy

NOW – you are ready to look for property!

Group Profile

Sheet1

REAL 320 Principles of Real Estate
Assignment #1
PROJECT PROFILE
	Group 1	Group 2	Group 3	Group 4	Group 5	Group 6	Group 7	Group 8	Group 9
Adults in Household	1	2	2	1	2	1	2	2	2
Children in Household	- 0	- 0	1	1	- 0	- 0	2	1	3
Desire to have children	None	Start in 2 years, wants 3 children	Pregnant, only want 2 kids total	No more	None	Fiancé has child; wants 2nd child	No more	No more	No more
Working Adults	1	2	1	1	2	1	2	2	1
Household Income (Annual)	72,000	114,000	78,000	78,000	108,000	66,000	102,000	84,000	84,000
Credit Score	Good	Good	Good	Good	Good	Good	Good	Good	Good
Student Loans	60,000	80,000	10,000	30,000	25,000	None	30,000	40,000	None
Car Loans	20,000	35,000	10,000	None	None	5,000	30,000	20,000	None
Condition of Cars	1 Good	2 Good	1 Bad 1 Good	1 Good	2 Bad	1 Bad	1 Bad 1 Good	2 Bad	2 Good
Credit Card Bills	8,000	15,000	4,000	None	11,000	9,000	20,000	10,000	None
Amount in Savings	50,000	35,000	30,000	45,000	25,000	15,000	5,000	10,000	125,000
Gift from Parent for use to purchase home	35,000	50,000	45,000	45,000	45,000	60,000	60,000	80,000	None
Total Savings & Parent Gift (Cash On Hand)	85,000	85,000	75,000	90,000	70,000	75,000	65,000	90,000	125,000

Sheet2

Sheet3

BUDGET BASICS

GROSS INCOME – Negotiated Salary
Less TAX WITHHOLDING

15% Federal

7% State of California

0.08% CASDI: (CA State Disability Insurance)

7.65% FICA (Double if self-employed)

6.2% Social Security

1.45% Medicare

30.75% of Gross Income to Taxes
69.25% of Gross Income Available After Tax

BUDGET BASICS

69.25% Gross Income After Tax Withholding
Less OTHER EMPLOYER DEDUCTIONS

Medical Insurance Premium

Dental & Vision Insurance Premium

Disability Insurance (Long-Term, Short-Term)

Gross Up Life Insurance over 50K, Voluntary Life

Union Dues, Parking Permit

Health Care/Dependent Care Spending Account

Retirement Account (401k, 403b)

NET PAY – Your Check

BUDGET BASICS

NET PAY – Your Check
EXPENSES (Consumer Credit Counseling - Percentages of Net Pay)

Housing (20%-35%): Rent or Ownership Expenses

Food (15%-30%): Groceries & Eating out

Transportation (6%-20%): Car Payment, Insurance, Gas, Maintenance

Medical Costs (2%-6%): Medical/Dental/Vision/Chiropractor Office Visits, Rx, Glasses

Insurance (4%-6%): Life, Disability, Renters, Umbrella

Utilities (4%-7%): Water, Power, Cable, Internet, Phone, Cell

Clothing (3%-10%): Professional, Casual

Personal Care (2%-4%): WalMart/Target Supplies

Miscellaneous (1%-4%): Recreation, Travel, Vacation, Culture, Furniture

Savings (10%+)

Charitable Giving (10%)

Child Care and/or Private Education for Children

Debt Repayment (Credit Cards, Other Debt)

CASH FLOW (Net Pay less Expenses)

BUDGET BASICS

Assignment #1: Develop a Five Year Budget for your Group’s Profile

Annual Budget – Adjust for increases in wages, taxes, payroll expenses, and other expenses

Calculate Monthly Averages (to compare with mortgage payment)

Use the Internet and Excel to find market costs, and to help organize your budget

Back Up Your Numbers

How does your PERSONAL BUDGET compare?

REAL 320 Principles of Real Estate

Assignment #1

PROJECT PROFILE

Group 1Group 2Group 3Group 4Group 5Group 6Group 7Group 8Group 9

Adults in Household 1 2 2 1 2 1 2 2 2

Children in Household - - 1 1 - - 2 1 3

Desire to have children None

Start in 2

years,

wants 3

children

Pregnant,

only want

2 kids

total No more None

Fiancé

has child;

wants 2nd

child No more No more No more

Working Adults 1 2 1 1 2 1 2 2 1

Household Income (Annual) 72,000 114,000 78,000 78,000 108,000 66,000 102,000 84,000 84,000

Credit Score Good Good Good Good Good Good Good Good Good

Student Loans 60,000 80,000 10,000 30,000 25,000 None 30,000 40,000 None

Car Loans 20,000 35,000 10,000 None None 5,000 30,000 20,000 None

Condition of Cars 1 Good 2 Good

1 Bad

1 Good 1 Good 2 Bad 1 Bad

1 Bad

1 Good 2 Bad 2 Good

Credit Card Bills 8,000 15,000 4,000 None 11,000 9,000 20,000 10,000 None

Amount in Savings 50,000 35,000 30,000 45,000 25,000 15,000 5,000 10,000 125,000

Gift from Parent for use to

purchase home 35,000 50,000 45,000 45,000 45,000 60,000 60,000 80,000 None

Total Savings & Parent Gift

(Cash On Hand)

85,000 85,000 75,000 90,000 70,000 75,000 65,000 90,000 125,000

320 Assignment #1 Process B - Loan Amort.ppt

Assignment #1
Buying your First Home

Take a deep breath, and do not shop yet!

Develop a Household Budget

Determine Your Mortgage Amount

What should you borrow

What is the maximum you can borrow

Estimate Expenses & Initial Closing Costs

Finalize How Much Home You Can Buy

NOW – you are ready to look for property!

Group Profile

Sheet1

REAL 320 Principles of Real Estate
Assignment #1
PROJECT PROFILE
	Group 1	Group 2	Group 3	Group 4	Group 5	Group 6	Group 7	Group 8	Group 9
Adults in Household	1	2	2	1	2	1	2	2	2
Children in Household	- 0	- 0	1	1	- 0	- 0	2	1	3
Desire to have children	None	Start in 2 years, wants 3 children	Pregnant, only want 2 kids total	No more	None	Fiancé has child; wants 2nd child	No more	No more	No more
Working Adults	1	2	1	1	2	1	2	2	1
Household Income (Annual)	72,000	114,000	78,000	78,000	108,000	66,000	102,000	84,000	84,000
Credit Score	Good	Good	Good	Good	Good	Good	Good	Good	Good
Student Loans	60,000	80,000	10,000	30,000	25,000	None	30,000	40,000	None
Car Loans	20,000	35,000	10,000	None	None	5,000	30,000	20,000	None
Condition of Cars	1 Good	2 Good	1 Bad 1 Good	1 Good	2 Bad	1 Bad	1 Bad 1 Good	2 Bad	2 Good
Credit Card Bills	8,000	15,000	4,000	None	11,000	9,000	20,000	10,000	None
Amount in Savings	50,000	35,000	30,000	45,000	25,000	15,000	5,000	10,000	125,000
Gift from Parent for use to purchase home	35,000	50,000	45,000	45,000	45,000	60,000	60,000	80,000	None
Total Savings & Parent Gift (Cash On Hand)	85,000	85,000	75,000	90,000	70,000	75,000	65,000	90,000	125,000

Sheet2

Sheet3

AMORTIZATION SCHEDULE BASICS

How Much Does your BUDGET allow you to borrow

How do your current costs compare with Consumer Credit Counseling averages?

How far can your budget comfortably stretch without changing your standard of living – or are you willing to change your standard of living to buy a home?

AMORTIZATION SCHEDULE BASICS

Determine Market Interest Rates

Example: Using Bank of America

www.bankofamerica.com Select Mortgages

Types of Loans:

FRM vs. ARM

Length of Time

Interest Only (All/Portion of Loan Term)

Mortgage v. HELOC

Negative Amortization

Effect of Points on Promissory Note Rate Amount

Impact of Fees (Looking at the APR)

Comparing no points/no cost mortgages between vendors (No Points/Cost means Promissory Note rate = APR)

AMORTIZATION SCHEDULE BASICS

Developing a Simple Excel Spreadsheet

Assignment #1 Amortization Schedule

Assumptions

Additional Formulas

Sensitivity Analysis with additional payment amounts as the variable

How Much CAN You Borrow?

Expense Ratios for Conforming Loans To Avoid Private Mortgage Insurance (PMI)

Mortgage Pmt/Gross Income 25-28%

Mortgage Pmt: Amortized Principal & Interest

PITI/Gross Income 28-30%

PITI: Principal, Interest, Prop Taxes & Insurance

All Housing Costs/Gross Income 36-40%

All Housing plus alimony and other debt obligations/Gross Income 40-50%

THESE ARE MAXIMUM RATIOS!!!

REAL 320 Principles of Real Estate

Assignment #1

PROJECT PROFILE

Group 1Group 2Group 3Group 4Group 5Group 6Group 7Group 8Group 9

Adults in Household 1 2 2 1 2 1 2 2 2

Children in Household - - 1 1 - - 2 1 3

Desire to have children None

Start in 2

years,

wants 3

children

Pregnant,

only want

2 kids

total No more None

Fiancé

has child;

wants 2nd

child No more No more No more

Working Adults 1 2 1 1 2 1 2 2 1

Household Income (Annual) 72,000 114,000 78,000 78,000 108,000 66,000 102,000 84,000 84,000

Credit Score Good Good Good Good Good Good Good Good Good

Student Loans 60,000 80,000 10,000 30,000 25,000 None 30,000 40,000 None

Car Loans 20,000 35,000 10,000 None None 5,000 30,000 20,000 None

Condition of Cars 1 Good 2 Good

1 Bad

1 Good 1 Good 2 Bad 1 Bad

1 Bad

1 Good 2 Bad 2 Good

Credit Card Bills 8,000 15,000 4,000 None 11,000 9,000 20,000 10,000 None

Amount in Savings 50,000 35,000 30,000 45,000 25,000 15,000 5,000 10,000 125,000

Gift from Parent for use to

purchase home 35,000 50,000 45,000 45,000 45,000 60,000 60,000 80,000 None

Total Savings & Parent Gift

(Cash On Hand)

85,000 85,000 75,000 90,000 70,000 75,000 65,000 90,000 125,000

320 Assignment #1 Process C - Expenses & Costs.ppt

Assignment #1
Buying your First Home

Take a deep breath, and do not shop yet!

Develop a Household Budget

Determine Your Mortgage Amount

What should you borrow

What is the maximum you can borrow

Estimate Expenses & Initial Closing Costs

Finalize How Much Home You Can Buy

NOW – you are ready to look for property!

ONGOING PROPERTY EXPENSES

Property Tax
Insurance
Homeowners Association (HOA)
Maintenance
Mortgage (Principal & Interest)

Property Tax

Base Rate 1%
Additional Fees (Effective Rate to 1.1%)
Proposition 13
Mello-Roos

Insurance

Property Insurance (Property & Casualty)
Earthquake Insurance
Umbrella Insurance

COMPARE

Mortgage Insurance (FHA)

Private Mortgage Insurance (PMI)

Title Insurance

INITIAL PROPERTY EXPENSES

See Escrow SellBuy Settlement Statement

Purchase Price

Earnest Money Deposit

Prorations: Property Tax, HOA Dues

New Loan & New Loan Charges

Loan Payoff & Payoff Fees

Title Insurance: Owners & Lender’s Policy

Documentary Transfer Tax

Recording Fees

INITIAL PROPERTY EXPENSES

Escrow SellBuy Settlement Stmt Continued

Escrow Fee

Property Taxes paid up to date with County Tax Assessor/Collector

Misc Disbursements:

New Fire Insurance,

RE Broker Commission,

Home Warranty

Termite Report, Termite Section 1 & 2

Zone Disclosure Report

Water Conservation & Local Compliance

320 Assignment #1 Process D - Finalize.ppt

Assignment #1
Buying your First Home

Take a deep breath, and do not shop yet!

Develop a Household Budget

Determine Your Mortgage Amount

What should you borrow

What is the maximum you can borrow

Estimate Expenses & Initial Closing Costs

Finalize How Much Home You Can Buy

NOW – you are ready to look for property!

Sample Class ProForma

Year Zero Entries – Money Due at Close of Escrow when Purchasing

ProForma – Cash Flow During Holding Period

Chapter 14 – 9 Step Process

Amortization Schedule Integrated into Model

Tax Section Adjusted for Residence Purchase

Final Year Disposition Expenses

Assignment #1
Buying your First Home

Take a deep breath, and do not shop yet!

Develop a Household Budget

Determine Your Mortgage Amount

What should you borrow

What is the maximum you can borrow

Estimate Expenses & Initial Closing Costs

Finalize How Much Home You Can Buy

NOW – you are ready to look for property!

320 LP05 Assignment #1 - BUY YOUR FIRST HOME.docx

REAL 320 – Principles of Real Estate

ASSIGNMENT #1 – Buy Your First Home

Its time to buy your first home in San Diego. You’ve graduated, have landed your first job, and are anxious to become the owner of a new home. Your task is to work with your group to find a feasible purchase, if possible.

You believing that home ownership will provide you with a way to stay in your beloved San Diego. You may want to consider homes less than the average price – but if you wouldn’t want your mother, sister or grandmother living in your neighborhood of choice, then justify your neighborhood of choice.

1. You should prepare a spreadsheet detailing your household budget, being sure to compare your expenses to your income. You should also demonstrate that you qualify for a conforming loan. Don’t eliminate all recreational spending from your budget just to force the purchase – life needs to be lived in balance. But, that balance might involve scaling back spending and coming up with a plan to eliminate debt. Maybe your purchase will be delayed a year or two. You should also verify and confirm your ability to maintain the property over a five year period of time – and show how you will pay for unanticipated repairs.

2. In addition to the budget spreadsheet, you will also provide a written analysis of your financial situation, which should detail the facts and circumstances surrounding your lifestyle and the impact your purchase will make. You should be able to show a market rate of interest, an appropriate loan amount, the cost of PMI (Private Mortgage Insurance) if you do not make a down payment of 20%, and your ability to show your ability to repay the loan using appropriate debt-income ratios.

3. You will need to tell me what your first starter home will look like. You should focus on a “starter” home, and your space should reflect any changes in lifestyle for a five year period of time. You should provide a sample home and explain how that home will be used. Don’t tell me you are going to home-school three children in a studio apartment with 600 square feet alongside your work-from-home job. Be realistic!

Use internet sources, talk with real estate agents, network among industry professionals and use course materials to provide your answer. Be you’re your personal situation can be applied to your group’s setting before finalizing your answer. Please submit your answer using the Written Submissions criteria outlined in the Syllabus.

You should expect the length of your analysis (in addition to the spreadsheet) to be between 2-3 pages. Be sure to attach any backup you use, including printouts of internet sites, articles and other information you have accumulated for your analysis. Show me how you are backing up your assertions. Also, individually complete the Comprehensive Peer Evaluation.

320 LP05 Assignment #1 Amortization Schedule.xlsx

Sample Investment Amort Sch

	Assumptions for Using this Amortization Schedule
	Full Amortized Loan
		Fixed Rate Mortgage
		Not a Revolving Line of Credit [not a HELOC - Home Equity Line of Credit]
		No Loan Acquisition Costs Included (Points, Loan Fees, Costs)
		No Balloon Payments
		No Loan Payoff Costs Included (Prepayment Penalty, Demand Fee, Reconveyance Fee)
	Annual Principal & Interest Calculations
		Beginning of Period 1, 13, 25, (+12 etc) is January 1, a legal holiday
		Ending of Period 12, 24, 36, (+12 etc) is December 31
		30 Years Maximum Allowed without having to alter formulas
	Formula for Calculating Payment: =PMT(rate, nper, pv, [fv], [type])
		FV: Enter only to enter a Balloon Payment; End Balance at end of NPER will be Balloon Pmt
		TYPE: Default is Payments in Arrears; Change Type for Payments in advance
		HINT: Rate is the Promissory Note Rate, NOT the APR (which takes into account other fees)
		HINT: if you want a monthly PMT, then RATE and NPER should also be monthly
	Loan Amount	400,000.00
		Annual	Monthly
	Term	30	360
	Interest Rate	6.00%	0.50%
	Payment	(28,778.40)	(2,398.20)		Add as Negative Number
Per	Beginning Bal	Interest	Principal	Payment	Addt Pymt	End Bal	Annual Principal	Annual Interest
1	400,000.00	(2,000.00)	(398.20)	(2,398.20)	0.00	399,601.80
2	399,601.80	(1,998.01)	(400.19)	(2,398.20)	0.00	399,201.61
3	399,201.61	(1,996.01)	(402.19)	(2,398.20)	0.00	398,799.42
4	398,799.42	(1,994.00)	(404.20)	(2,398.20)	0.00	398,395.22
5	398,395.22	(1,991.98)	(406.22)	(2,398.20)	0.00	397,989.00
6	397,989.00	(1,989.95)	(408.25)	(2,398.20)	0.00	397,580.75
7	397,580.75	(1,987.90)	(410.30)	(2,398.20)	0.00	397,170.45
8	397,170.45	(1,985.85)	(412.35)	(2,398.20)	0.00	396,758.10
9	396,758.10	(1,983.79)	(414.41)	(2,398.20)	0.00	396,343.69
10	396,343.69	(1,981.72)	(416.48)	(2,398.20)	0.00	395,927.21
11	395,927.21	(1,979.64)	(418.56)	(2,398.20)	0.00	395,508.65
12	395,508.65	(1,977.54)	(420.66)	(2,398.20)	0.00	395,087.99	(4,912.01)	(23,866.39)
13	395,087.99	(1,975.44)	(422.76)	(2,398.20)	0.00	394,665.23
14	394,665.23	(1,973.33)	(424.87)	(2,398.20)	0.00	394,240.36
15	394,240.36	(1,971.20)	(427.00)	(2,398.20)	0.00	393,813.36
16	393,813.36	(1,969.07)	(429.13)	(2,398.20)	0.00	393,384.23
17	393,384.23	(1,966.92)	(431.28)	(2,398.20)	0.00	392,952.95
18	392,952.95	(1,964.76)	(433.44)	(2,398.20)	0.00	392,519.51
19	392,519.51	(1,962.60)	(435.60)	(2,398.20)	0.00	392,083.91
20	392,083.91	(1,960.42)	(437.78)	(2,398.20)	0.00	391,646.13
21	391,646.13	(1,958.23)	(439.97)	(2,398.20)	0.00	391,206.16
22	391,206.16	(1,956.03)	(442.17)	(2,398.20)	0.00	390,763.99
23	390,763.99	(1,953.82)	(444.38)	(2,398.20)	0.00	390,319.61
24	390,319.61	(1,951.60)	(446.60)	(2,398.20)	0.00	389,873.01	(5,214.98)	(23,563.42)
25	389,873.01	(1,949.37)	(448.83)	(2,398.20)	0.00	389,424.18
26	389,424.18	(1,947.12)	(451.08)	(2,398.20)	0.00	388,973.10
27	388,973.10	(1,944.87)	(453.33)	(2,398.20)	0.00	388,519.77
28	388,519.77	(1,942.60)	(455.60)	(2,398.20)	0.00	388,064.17
29	388,064.17	(1,940.32)	(457.88)	(2,398.20)	0.00	387,606.29
30	387,606.29	(1,938.03)	(460.17)	(2,398.20)	0.00	387,146.12
31	387,146.12	(1,935.73)	(462.47)	(2,398.20)	0.00	386,683.65
32	386,683.65	(1,933.42)	(464.78)	(2,398.20)	0.00	386,218.87
33	386,218.87	(1,931.09)	(467.11)	(2,398.20)	0.00	385,751.76
34	385,751.76	(1,928.76)	(469.44)	(2,398.20)	0.00	385,282.32
35	385,282.32	(1,926.41)	(471.79)	(2,398.20)	0.00	384,810.53
36	384,810.53	(1,924.05)	(474.15)	(2,398.20)	0.00	384,336.38	(5,536.63)	(23,241.77)
37	384,336.38	(1,921.68)	(476.52)	(2,398.20)	0.00	383,859.86
38	383,859.86	(1,919.30)	(478.90)	(2,398.20)	0.00	383,380.96
39	383,380.96	(1,916.90)	(481.30)	(2,398.20)	0.00	382,899.66
40	382,899.66	(1,914.50)	(483.70)	(2,398.20)	0.00	382,415.96
41	382,415.96	(1,912.08)	(486.12)	(2,398.20)	0.00	381,929.84
42	381,929.84	(1,909.65)	(488.55)	(2,398.20)	0.00	381,441.29
43	381,441.29	(1,907.21)	(490.99)	(2,398.20)	0.00	380,950.30
44	380,950.30	(1,904.75)	(493.45)	(2,398.20)	0.00	380,456.85
45	380,456.85	(1,902.28)	(495.92)	(2,398.20)	0.00	379,960.93
46	379,960.93	(1,899.80)	(498.40)	(2,398.20)	0.00	379,462.53
47	379,462.53	(1,897.31)	(500.89)	(2,398.20)	0.00	378,961.64
48	378,961.64	(1,894.81)	(503.39)	(2,398.20)	0.00	378,458.25	(5,878.13)	(22,900.27)
49	378,458.25	(1,892.29)	(505.91)	(2,398.20)	0.00	377,952.34
50	377,952.34	(1,889.76)	(508.44)	(2,398.20)	0.00	377,443.90
51	377,443.90	(1,887.22)	(510.98)	(2,398.20)	0.00	376,932.92
52	376,932.92	(1,884.66)	(513.54)	(2,398.20)	0.00	376,419.38
53	376,419.38	(1,882.10)	(516.10)	(2,398.20)	0.00	375,903.28
54	375,903.28	(1,879.52)	(518.68)	(2,398.20)	0.00	375,384.60
55	375,384.60	(1,876.92)	(521.28)	(2,398.20)	0.00	374,863.32
56	374,863.32	(1,874.32)	(523.88)	(2,398.20)	0.00	374,339.44
57	374,339.44	(1,871.70)	(526.50)	(2,398.20)	0.00	373,812.94
58	373,812.94	(1,869.06)	(529.14)	(2,398.20)	0.00	373,283.80
59	373,283.80	(1,866.42)	(531.78)	(2,398.20)	0.00	372,752.02
60	372,752.02	(1,863.76)	(534.44)	(2,398.20)	0.00	372,217.58	(6,240.67)	(22,537.73)
61	372,217.58	(1,861.09)	(537.11)	(2,398.20)	0.00	371,680.47
62	371,680.47	(1,858.40)	(539.80)	(2,398.20)	0.00	371,140.67
63	371,140.67	(1,855.70)	(542.50)	(2,398.20)	0.00	370,598.17
64	370,598.17	(1,852.99)	(545.21)	(2,398.20)	0.00	370,052.96
65	370,052.96	(1,850.26)	(547.94)	(2,398.20)	0.00	369,505.02
66	369,505.02	(1,847.53)	(550.67)	(2,398.20)	0.00	368,954.35
67	368,954.35	(1,844.77)	(553.43)	(2,398.20)	0.00	368,400.92
68	368,400.92	(1,842.00)	(556.20)	(2,398.20)	0.00	367,844.72
69	367,844.72	(1,839.22)	(558.98)	(2,398.20)	0.00	367,285.74
70	367,285.74	(1,836.43)	(561.77)	(2,398.20)	0.00	366,723.97
71	366,723.97	(1,833.62)	(564.58)	(2,398.20)	0.00	366,159.39
72	366,159.39	(1,830.80)	(567.40)	(2,398.20)	0.00	365,591.99	(6,625.59)	(22,152.81)
73	365,591.99	(1,827.96)	(570.24)	(2,398.20)	0.00	365,021.75
74	365,021.75	(1,825.11)	(573.09)	(2,398.20)	0.00	364,448.66
75	364,448.66	(1,822.24)	(575.96)	(2,398.20)	0.00	363,872.70
76	363,872.70	(1,819.36)	(578.84)	(2,398.20)	0.00	363,293.86
77	363,293.86	(1,816.47)	(581.73)	(2,398.20)	0.00	362,712.13
78	362,712.13	(1,813.56)	(584.64)	(2,398.20)	0.00	362,127.49
79	362,127.49	(1,810.64)	(587.56)	(2,398.20)	0.00	361,539.93
80	361,539.93	(1,807.70)	(590.50)	(2,398.20)	0.00	360,949.43
81	360,949.43	(1,804.75)	(593.45)	(2,398.20)	0.00	360,355.98
82	360,355.98	(1,801.78)	(596.42)	(2,398.20)	0.00	359,759.56
83	359,759.56	(1,798.80)	(599.40)	(2,398.20)	0.00	359,160.16
84	359,160.16	(1,795.80)	(602.40)	(2,398.20)	0.00	358,557.76	(7,034.23)	(21,744.17)
85	358,557.76	(1,792.79)	(605.41)	(2,398.20)	0.00	357,952.35
86	357,952.35	(1,789.76)	(608.44)	(2,398.20)	0.00	357,343.91
87	357,343.91	(1,786.72)	(611.48)	(2,398.20)	0.00	356,732.43
88	356,732.43	(1,783.66)	(614.54)	(2,398.20)	0.00	356,117.89
89	356,117.89	(1,780.59)	(617.61)	(2,398.20)	0.00	355,500.28
90	355,500.28	(1,777.50)	(620.70)	(2,398.20)	0.00	354,879.58
91	354,879.58	(1,774.40)	(623.80)	(2,398.20)	0.00	354,255.78
92	354,255.78	(1,771.28)	(626.92)	(2,398.20)	0.00	353,628.86
93	353,628.86	(1,768.14)	(630.06)	(2,398.20)	0.00	352,998.80
94	352,998.80	(1,764.99)	(633.21)	(2,398.20)	0.00	352,365.59
95	352,365.59	(1,761.83)	(636.37)	(2,398.20)	0.00	351,729.22
96	351,729.22	(1,758.65)	(639.55)	(2,398.20)	0.00	351,089.67	(7,468.09)	(21,310.31)
97	351,089.67	(1,755.45)	(642.75)	(2,398.20)	0.00	350,446.92
98	350,446.92	(1,752.23)	(645.97)	(2,398.20)	0.00	349,800.95
99	349,800.95	(1,749.00)	(649.20)	(2,398.20)	0.00	349,151.75
100	349,151.75	(1,745.76)	(652.44)	(2,398.20)	0.00	348,499.31
101	348,499.31	(1,742.50)	(655.70)	(2,398.20)	0.00	347,843.61
102	347,843.61	(1,739.22)	(658.98)	(2,398.20)	0.00	347,184.63
103	347,184.63	(1,735.92)	(662.28)	(2,398.20)	0.00	346,522.35
104	346,522.35	(1,732.61)	(665.59)	(2,398.20)	0.00	345,856.76
105	345,856.76	(1,729.28)	(668.92)	(2,398.20)	0.00	345,187.84
106	345,187.84	(1,725.94)	(672.26)	(2,398.20)	0.00	344,515.58
107	344,515.58	(1,722.58)	(675.62)	(2,398.20)	0.00	343,839.96
108	343,839.96	(1,719.20)	(679.00)	(2,398.20)	0.00	343,160.96	(7,928.71)	(20,849.69)
109	343,160.96	(1,715.80)	(682.40)	(2,398.20)	0.00	342,478.56
110	342,478.56	(1,712.39)	(685.81)	(2,398.20)	0.00	341,792.75
111	341,792.75	(1,708.96)	(689.24)	(2,398.20)	0.00	341,103.51
112	341,103.51	(1,705.52)	(692.68)	(2,398.20)	0.00	340,410.83
113	340,410.83	(1,702.05)	(696.15)	(2,398.20)	0.00	339,714.68
114	339,714.68	(1,698.57)	(699.63)	(2,398.20)	0.00	339,015.05
115	339,015.05	(1,695.08)	(703.12)	(2,398.20)	0.00	338,311.93
116	338,311.93	(1,691.56)	(706.64)	(2,398.20)	0.00	337,605.29
117	337,605.29	(1,688.03)	(710.17)	(2,398.20)	0.00	336,895.12
118	336,895.12	(1,684.48)	(713.72)	(2,398.20)	0.00	336,181.40
119	336,181.40	(1,680.91)	(717.29)	(2,398.20)	0.00	335,464.11
120	335,464.11	(1,677.32)	(720.88)	(2,398.20)	0.00	334,743.23	(8,417.73)	(20,360.67)
121	334,743.23	(1,673.72)	(724.48)	(2,398.20)	0.00	334,018.75
122	334,018.75	(1,670.09)	(728.11)	(2,398.20)	0.00	333,290.64
123	333,290.64	(1,666.45)	(731.75)	(2,398.20)	0.00	332,558.89
124	332,558.89	(1,662.79)	(735.41)	(2,398.20)	0.00	331,823.48
125	331,823.48	(1,659.12)	(739.08)	(2,398.20)	0.00	331,084.40
126	331,084.40	(1,655.42)	(742.78)	(2,398.20)	0.00	330,341.62
127	330,341.62	(1,651.71)	(746.49)	(2,398.20)	0.00	329,595.13
128	329,595.13	(1,647.98)	(750.22)	(2,398.20)	0.00	328,844.91
129	328,844.91	(1,644.22)	(753.98)	(2,398.20)	0.00	328,090.93
130	328,090.93	(1,640.45)	(757.75)	(2,398.20)	0.00	327,333.18
131	327,333.18	(1,636.67)	(761.53)	(2,398.20)	0.00	326,571.65
132	326,571.65	(1,632.86)	(765.34)	(2,398.20)	0.00	325,806.31	(8,936.92)	(19,841.48)
133	325,806.31	(1,629.03)	(769.17)	(2,398.20)	0.00	325,037.14
134	325,037.14	(1,625.19)	(773.01)	(2,398.20)	0.00	324,264.13
135	324,264.13	(1,621.32)	(776.88)	(2,398.20)	0.00	323,487.25
136	323,487.25	(1,617.44)	(780.76)	(2,398.20)	0.00	322,706.49
137	322,706.49	(1,613.53)	(784.67)	(2,398.20)	0.00	321,921.82
138	321,921.82	(1,609.61)	(788.59)	(2,398.20)	0.00	321,133.23
139	321,133.23	(1,605.67)	(792.53)	(2,398.20)	0.00	320,340.70
140	320,340.70	(1,601.70)	(796.50)	(2,398.20)	0.00	319,544.20
141	319,544.20	(1,597.72)	(800.48)	(2,398.20)	0.00	318,743.72
142	318,743.72	(1,593.72)	(804.48)	(2,398.20)	0.00	317,939.24
143	317,939.24	(1,589.70)	(808.50)	(2,398.20)	0.00	317,130.74
144	317,130.74	(1,585.65)	(812.55)	(2,398.20)	0.00	316,318.19	(9,488.12)	(19,290.28)
145	316,318.19	(1,581.59)	(816.61)	(2,398.20)	0.00	315,501.58
146	315,501.58	(1,577.51)	(820.69)	(2,398.20)	0.00	314,680.89
147	314,680.89	(1,573.40)	(824.80)	(2,398.20)	0.00	313,856.09
148	313,856.09	(1,569.28)	(828.92)	(2,398.20)	0.00	313,027.17
149	313,027.17	(1,565.14)	(833.06)	(2,398.20)	0.00	312,194.11
150	312,194.11	(1,560.97)	(837.23)	(2,398.20)	0.00	311,356.88
151	311,356.88	(1,556.78)	(841.42)	(2,398.20)	0.00	310,515.46
152	310,515.46	(1,552.58)	(845.62)	(2,398.20)	0.00	309,669.84
153	309,669.84	(1,548.35)	(849.85)	(2,398.20)	0.00	308,819.99
154	308,819.99	(1,544.10)	(854.10)	(2,398.20)	0.00	307,965.89
155	307,965.89	(1,539.83)	(858.37)	(2,398.20)	0.00	307,107.52
156	307,107.52	(1,535.54)	(862.66)	(2,398.20)	0.00	306,244.86	(10,073.33)	(18,705.07)
157	306,244.86	(1,531.22)	(866.98)	(2,398.20)	0.00	305,377.88
158	305,377.88	(1,526.89)	(871.31)	(2,398.20)	0.00	304,506.57
159	304,506.57	(1,522.53)	(875.67)	(2,398.20)	0.00	303,630.90
160	303,630.90	(1,518.15)	(880.05)	(2,398.20)	0.00	302,750.85
161	302,750.85	(1,513.75)	(884.45)	(2,398.20)	0.00	301,866.40
162	301,866.40	(1,509.33)	(888.87)	(2,398.20)	0.00	300,977.53
163	300,977.53	(1,504.89)	(893.31)	(2,398.20)	0.00	300,084.22
164	300,084.22	(1,500.42)	(897.78)	(2,398.20)	0.00	299,186.44
165	299,186.44	(1,495.93)	(902.27)	(2,398.20)	0.00	298,284.17
166	298,284.17	(1,491.42)	(906.78)	(2,398.20)	0.00	297,377.39
167	297,377.39	(1,486.89)	(911.31)	(2,398.20)	0.00	296,466.08
168	296,466.08	(1,482.33)	(915.87)	(2,398.20)	0.00	295,550.21	(10,694.65)	(18,083.75)
169	295,550.21	(1,477.75)	(920.45)	(2,398.20)	0.00	294,629.76
170	294,629.76	(1,473.15)	(925.05)	(2,398.20)	0.00	293,704.71
171	293,704.71	(1,468.52)	(929.68)	(2,398.20)	0.00	292,775.03
172	292,775.03	(1,463.88)	(934.32)	(2,398.20)	0.00	291,840.71
173	291,840.71	(1,459.20)	(939.00)	(2,398.20)	0.00	290,901.71
174	290,901.71	(1,454.51)	(943.69)	(2,398.20)	0.00	289,958.02
175	289,958.02	(1,449.79)	(948.41)	(2,398.20)	0.00	289,009.61
176	289,009.61	(1,445.05)	(953.15)	(2,398.20)	0.00	288,056.46
177	288,056.46	(1,440.28)	(957.92)	(2,398.20)	0.00	287,098.54
178	287,098.54	(1,435.49)	(962.71)	(2,398.20)	0.00	286,135.83
179	286,135.83	(1,430.68)	(967.52)	(2,398.20)	0.00	285,168.31
180	285,168.31	(1,425.84)	(972.36)	(2,398.20)	0.00	284,195.95	(11,354.26)	(17,424.14)
181	284,195.95	(1,420.98)	(977.22)	(2,398.20)	0.00	283,218.73
182	283,218.73	(1,416.09)	(982.11)	(2,398.20)	0.00	282,236.62
183	282,236.62	(1,411.18)	(987.02)	(2,398.20)	0.00	281,249.60
184	281,249.60	(1,406.25)	(991.95)	(2,398.20)	0.00	280,257.65
185	280,257.65	(1,401.29)	(996.91)	(2,398.20)	0.00	279,260.74
186	279,260.74	(1,396.30)	(1,001.90)	(2,398.20)	0.00	278,258.84
187	278,258.84	(1,391.29)	(1,006.91)	(2,398.20)	0.00	277,251.93
188	277,251.93	(1,386.26)	(1,011.94)	(2,398.20)	0.00	276,239.99
189	276,239.99	(1,381.20)	(1,017.00)	(2,398.20)	0.00	275,222.99
190	275,222.99	(1,376.11)	(1,022.09)	(2,398.20)	0.00	274,200.90
191	274,200.90	(1,371.00)	(1,027.20)	(2,398.20)	0.00	273,173.70
192	273,173.70	(1,365.87)	(1,032.33)	(2,398.20)	0.00	272,141.37	(12,054.58)	(16,723.82)
193	272,141.37	(1,360.71)	(1,037.49)	(2,398.20)	0.00	271,103.88
194	271,103.88	(1,355.52)	(1,042.68)	(2,398.20)	0.00	270,061.20
195	270,061.20	(1,350.31)	(1,047.89)	(2,398.20)	0.00	269,013.31
196	269,013.31	(1,345.07)	(1,053.13)	(2,398.20)	0.00	267,960.18
197	267,960.18	(1,339.80)	(1,058.40)	(2,398.20)	0.00	266,901.78
198	266,901.78	(1,334.51)	(1,063.69)	(2,398.20)	0.00	265,838.09
199	265,838.09	(1,329.19)	(1,069.01)	(2,398.20)	0.00	264,769.08
200	264,769.08	(1,323.85)	(1,074.35)	(2,398.20)	0.00	263,694.73
201	263,694.73	(1,318.47)	(1,079.73)	(2,398.20)	0.00	262,615.00
202	262,615.00	(1,313.08)	(1,085.12)	(2,398.20)	0.00	261,529.88
203	261,529.88	(1,307.65)	(1,090.55)	(2,398.20)	0.00	260,439.33
204	260,439.33	(1,302.20)	(1,096.00)	(2,398.20)	0.00	259,343.33	(12,798.04)	(15,980.36)
205	259,343.33	(1,296.72)	(1,101.48)	(2,398.20)	0.00	258,241.85
206	258,241.85	(1,291.21)	(1,106.99)	(2,398.20)	0.00	257,134.86
207	257,134.86	(1,285.67)	(1,112.53)	(2,398.20)	0.00	256,022.33
208	256,022.33	(1,280.11)	(1,118.09)	(2,398.20)	0.00	254,904.24
209	254,904.24	(1,274.52)	(1,123.68)	(2,398.20)	0.00	253,780.56
210	253,780.56	(1,268.90)	(1,129.30)	(2,398.20)	0.00	252,651.26
211	252,651.26	(1,263.26)	(1,134.94)	(2,398.20)	0.00	251,516.32
212	251,516.32	(1,257.58)	(1,140.62)	(2,398.20)	0.00	250,375.70
213	250,375.70	(1,251.88)	(1,146.32)	(2,398.20)	0.00	249,229.38
214	249,229.38	(1,246.15)	(1,152.05)	(2,398.20)	0.00	248,077.33
215	248,077.33	(1,240.39)	(1,157.81)	(2,398.20)	0.00	246,919.52
216	246,919.52	(1,234.60)	(1,163.60)	(2,398.20)	0.00	245,755.92	(13,587.41)	(15,190.99)
217	245,755.92	(1,228.78)	(1,169.42)	(2,398.20)	0.00	244,586.50
218	244,586.50	(1,222.93)	(1,175.27)	(2,398.20)	0.00	243,411.23
219	243,411.23	(1,217.06)	(1,181.14)	(2,398.20)	0.00	242,230.09
220	242,230.09	(1,211.15)	(1,187.05)	(2,398.20)	0.00	241,043.04
221	241,043.04	(1,205.22)	(1,192.98)	(2,398.20)	0.00	239,850.06
222	239,850.06	(1,199.25)	(1,198.95)	(2,398.20)	0.00	238,651.11
223	238,651.11	(1,193.26)	(1,204.94)	(2,398.20)	0.00	237,446.17
224	237,446.17	(1,187.23)	(1,210.97)	(2,398.20)	0.00	236,235.20
225	236,235.20	(1,181.18)	(1,217.02)	(2,398.20)	0.00	235,018.18
226	235,018.18	(1,175.09)	(1,223.11)	(2,398.20)	0.00	233,795.07
227	233,795.07	(1,168.98)	(1,229.22)	(2,398.20)	0.00	232,565.85
228	232,565.85	(1,162.83)	(1,235.37)	(2,398.20)	0.00	231,330.48	(14,425.44)	(14,352.96)
229	231,330.48	(1,156.65)	(1,241.55)	(2,398.20)	0.00	230,088.93
230	230,088.93	(1,150.44)	(1,247.76)	(2,398.20)	0.00	228,841.17
231	228,841.17	(1,144.21)	(1,253.99)	(2,398.20)	0.00	227,587.18
232	227,587.18	(1,137.94)	(1,260.26)	(2,398.20)	0.00	226,326.92
233	226,326.92	(1,131.63)	(1,266.57)	(2,398.20)	0.00	225,060.35
234	225,060.35	(1,125.30)	(1,272.90)	(2,398.20)	0.00	223,787.45
235	223,787.45	(1,118.94)	(1,279.26)	(2,398.20)	0.00	222,508.19
236	222,508.19	(1,112.54)	(1,285.66)	(2,398.20)	0.00	221,222.53
237	221,222.53	(1,106.11)	(1,292.09)	(2,398.20)	0.00	219,930.44
238	219,930.44	(1,099.65)	(1,298.55)	(2,398.20)	0.00	218,631.89
239	218,631.89	(1,093.16)	(1,305.04)	(2,398.20)	0.00	217,326.85
240	217,326.85	(1,086.63)	(1,311.57)	(2,398.20)	0.00	216,015.28	(15,315.20)	(13,463.20)
241	216,015.28	(1,080.08)	(1,318.12)	(2,398.20)	0.00	214,697.16
242	214,697.16	(1,073.49)	(1,324.71)	(2,398.20)	0.00	213,372.45
243	213,372.45	(1,066.86)	(1,331.34)	(2,398.20)	0.00	212,041.11
244	212,041.11	(1,060.21)	(1,337.99)	(2,398.20)	0.00	210,703.12
245	210,703.12	(1,053.52)	(1,344.68)	(2,398.20)	0.00	209,358.44
246	209,358.44	(1,046.79)	(1,351.41)	(2,398.20)	0.00	208,007.03
247	208,007.03	(1,040.04)	(1,358.16)	(2,398.20)	0.00	206,648.87
248	206,648.87	(1,033.24)	(1,364.96)	(2,398.20)	0.00	205,283.91
249	205,283.91	(1,026.42)	(1,371.78)	(2,398.20)	0.00	203,912.13
250	203,912.13	(1,019.56)	(1,378.64)	(2,398.20)	0.00	202,533.49
251	202,533.49	(1,012.67)	(1,385.53)	(2,398.20)	0.00	201,147.96
252	201,147.96	(1,005.74)	(1,392.46)	(2,398.20)	0.00	199,755.50	(16,259.78)	(12,518.62)
253	199,755.50	(998.78)	(1,399.42)	(2,398.20)	0.00	198,356.08
254	198,356.08	(991.78)	(1,406.42)	(2,398.20)	0.00	196,949.66
255	196,949.66	(984.75)	(1,413.45)	(2,398.20)	0.00	195,536.21
256	195,536.21	(977.68)	(1,420.52)	(2,398.20)	0.00	194,115.69
257	194,115.69	(970.58)	(1,427.62)	(2,398.20)	0.00	192,688.07
258	192,688.07	(963.44)	(1,434.76)	(2,398.20)	0.00	191,253.31
259	191,253.31	(956.27)	(1,441.93)	(2,398.20)	0.00	189,811.38
260	189,811.38	(949.06)	(1,449.14)	(2,398.20)	0.00	188,362.24
261	188,362.24	(941.81)	(1,456.39)	(2,398.20)	0.00	186,905.85
262	186,905.85	(934.53)	(1,463.67)	(2,398.20)	0.00	185,442.18
263	185,442.18	(927.21)	(1,470.99)	(2,398.20)	0.00	183,971.19
264	183,971.19	(919.86)	(1,478.34)	(2,398.20)	0.00	182,492.85	(17,262.65)	(11,515.75)
265	182,492.85	(912.46)	(1,485.74)	(2,398.20)	0.00	181,007.11
266	181,007.11	(905.04)	(1,493.16)	(2,398.20)	0.00	179,513.95
267	179,513.95	(897.57)	(1,500.63)	(2,398.20)	0.00	178,013.32
268	178,013.32	(890.07)	(1,508.13)	(2,398.20)	0.00	176,505.19
269	176,505.19	(882.53)	(1,515.67)	(2,398.20)	0.00	174,989.52
270	174,989.52	(874.95)	(1,523.25)	(2,398.20)	0.00	173,466.27
271	173,466.27	(867.33)	(1,530.87)	(2,398.20)	0.00	171,935.40
272	171,935.40	(859.68)	(1,538.52)	(2,398.20)	0.00	170,396.88
273	170,396.88	(851.98)	(1,546.22)	(2,398.20)	0.00	168,850.66
274	168,850.66	(844.25)	(1,553.95)	(2,398.20)	0.00	167,296.71
275	167,296.71	(836.48)	(1,561.72)	(2,398.20)	0.00	165,734.99
276	165,734.99	(828.67)	(1,569.53)	(2,398.20)	0.00	164,165.46	(18,327.39)	(10,451.01)
277	164,165.46	(820.83)	(1,577.37)	(2,398.20)	0.00	162,588.09
278	162,588.09	(812.94)	(1,585.26)	(2,398.20)	0.00	161,002.83
279	161,002.83	(805.01)	(1,593.19)	(2,398.20)	0.00	159,409.64
280	159,409.64	(797.05)	(1,601.15)	(2,398.20)	0.00	157,808.49
281	157,808.49	(789.04)	(1,609.16)	(2,398.20)	0.00	156,199.33
282	156,199.33	(781.00)	(1,617.20)	(2,398.20)	0.00	154,582.13
283	154,582.13	(772.91)	(1,625.29)	(2,398.20)	0.00	152,956.84
284	152,956.84	(764.78)	(1,633.42)	(2,398.20)	0.00	151,323.42
285	151,323.42	(756.62)	(1,641.58)	(2,398.20)	0.00	149,681.84
286	149,681.84	(748.41)	(1,649.79)	(2,398.20)	0.00	148,032.05
287	148,032.05	(740.16)	(1,658.04)	(2,398.20)	0.00	146,374.01
288	146,374.01	(731.87)	(1,666.33)	(2,398.20)	0.00	144,707.68	(19,457.78)	(9,320.62)
289	144,707.68	(723.54)	(1,674.66)	(2,398.20)	0.00	143,033.02
290	143,033.02	(715.17)	(1,683.03)	(2,398.20)	0.00	141,349.99
291	141,349.99	(706.75)	(1,691.45)	(2,398.20)	0.00	139,658.54
292	139,658.54	(698.29)	(1,699.91)	(2,398.20)	0.00	137,958.63
293	137,958.63	(689.79)	(1,708.41)	(2,398.20)	0.00	136,250.22
294	136,250.22	(681.25)	(1,716.95)	(2,398.20)	0.00	134,533.27
295	134,533.27	(672.67)	(1,725.53)	(2,398.20)	0.00	132,807.74
296	132,807.74	(664.04)	(1,734.16)	(2,398.20)	0.00	131,073.58
297	131,073.58	(655.37)	(1,742.83)	(2,398.20)	0.00	129,330.75
298	129,330.75	(646.65)	(1,751.55)	(2,398.20)	0.00	127,579.20
299	127,579.20	(637.90)	(1,760.30)	(2,398.20)	0.00	125,818.90
300	125,818.90	(629.09)	(1,769.11)	(2,398.20)	0.00	124,049.79	(20,657.89)	(8,120.51)
301	124,049.79	(620.25)	(1,777.95)	(2,398.20)	0.00	122,271.84
302	122,271.84	(611.36)	(1,786.84)	(2,398.20)	0.00	120,485.00
303	120,485.00	(602.43)	(1,795.77)	(2,398.20)	0.00	118,689.23
304	118,689.23	(593.45)	(1,804.75)	(2,398.20)	0.00	116,884.48
305	116,884.48	(584.42)	(1,813.78)	(2,398.20)	0.00	115,070.70
306	115,070.70	(575.35)	(1,822.85)	(2,398.20)	0.00	113,247.85
307	113,247.85	(566.24)	(1,831.96)	(2,398.20)	0.00	111,415.89
308	111,415.89	(557.08)	(1,841.12)	(2,398.20)	0.00	109,574.77
309	109,574.77	(547.87)	(1,850.33)	(2,398.20)	0.00	107,724.44
310	107,724.44	(538.62)	(1,859.58)	(2,398.20)	0.00	105,864.86
311	105,864.86	(529.32)	(1,868.88)	(2,398.20)	0.00	103,995.98
312	103,995.98	(519.98)	(1,878.22)	(2,398.20)	0.00	102,117.76	(21,932.03)	(6,846.37)
313	102,117.76	(510.59)	(1,887.61)	(2,398.20)	0.00	100,230.15
314	100,230.15	(501.15)	(1,897.05)	(2,398.20)	0.00	98,333.10
315	98,333.10	(491.67)	(1,906.53)	(2,398.20)	0.00	96,426.57
316	96,426.57	(482.13)	(1,916.07)	(2,398.20)	0.00	94,510.50
317	94,510.50	(472.55)	(1,925.65)	(2,398.20)	0.00	92,584.85
318	92,584.85	(462.92)	(1,935.28)	(2,398.20)	0.00	90,649.57
319	90,649.57	(453.25)	(1,944.95)	(2,398.20)	0.00	88,704.62
320	88,704.62	(443.52)	(1,954.68)	(2,398.20)	0.00	86,749.94
321	86,749.94	(433.75)	(1,964.45)	(2,398.20)	0.00	84,785.49
322	84,785.49	(423.93)	(1,974.27)	(2,398.20)	0.00	82,811.22
323	82,811.22	(414.06)	(1,984.14)	(2,398.20)	0.00	80,827.08
324	80,827.08	(404.14)	(1,994.06)	(2,398.20)	0.00	78,833.02	(23,284.74)	(5,493.66)
325	78,833.02	(394.17)	(2,004.03)	(2,398.20)	0.00	76,828.99
326	76,828.99	(384.14)	(2,014.06)	(2,398.20)	0.00	74,814.93
327	74,814.93	(374.07)	(2,024.13)	(2,398.20)	0.00	72,790.80
328	72,790.80	(363.95)	(2,034.25)	(2,398.20)	0.00	70,756.55
329	70,756.55	(353.78)	(2,044.42)	(2,398.20)	0.00	68,712.13
330	68,712.13	(343.56)	(2,054.64)	(2,398.20)	0.00	66,657.49
331	66,657.49	(333.29)	(2,064.91)	(2,398.20)	0.00	64,592.58
332	64,592.58	(322.96)	(2,075.24)	(2,398.20)	0.00	62,517.34
333	62,517.34	(312.59)	(2,085.61)	(2,398.20)	0.00	60,431.73
334	60,431.73	(302.16)	(2,096.04)	(2,398.20)	0.00	58,335.69
335	58,335.69	(291.68)	(2,106.52)	(2,398.20)	0.00	56,229.17
336	56,229.17	(281.15)	(2,117.05)	(2,398.20)	0.00	54,112.12	(24,720.90)	(4,057.50)
337	54,112.12	(270.56)	(2,127.64)	(2,398.20)	0.00	51,984.48
338	51,984.48	(259.92)	(2,138.28)	(2,398.20)	0.00	49,846.20
339	49,846.20	(249.23)	(2,148.97)	(2,398.20)	0.00	47,697.23
340	47,697.23	(238.49)	(2,159.71)	(2,398.20)	0.00	45,537.52
341	45,537.52	(227.69)	(2,170.51)	(2,398.20)	0.00	43,367.01
342	43,367.01	(216.84)	(2,181.36)	(2,398.20)	0.00	41,185.65
343	41,185.65	(205.93)	(2,192.27)	(2,398.20)	0.00	38,993.38
344	38,993.38	(194.97)	(2,203.23)	(2,398.20)	0.00	36,790.15
345	36,790.15	(183.95)	(2,214.25)	(2,398.20)	0.00	34,575.90
346	34,575.90	(172.88)	(2,225.32)	(2,398.20)	0.00	32,350.58
347	32,350.58	(161.75)	(2,236.45)	(2,398.20)	0.00	30,114.13
348	30,114.13	(150.57)	(2,247.63)	(2,398.20)	0.00	27,866.50	(26,245.62)	(2,532.78)
349	27,866.50	(139.33)	(2,258.87)	(2,398.20)	0.00	25,607.63
350	25,607.63	(128.04)	(2,270.16)	(2,398.20)	0.00	23,337.47
351	23,337.47	(116.69)	(2,281.51)	(2,398.20)	0.00	21,055.96
352	21,055.96	(105.28)	(2,292.92)	(2,398.20)	0.00	18,763.04
353	18,763.04	(93.82)	(2,304.38)	(2,398.20)	0.00	16,458.66
354	16,458.66	(82.29)	(2,315.91)	(2,398.20)	0.00	14,142.75
355	14,142.75	(70.71)	(2,327.49)	(2,398.20)	0.00	11,815.26
356	11,815.26	(59.08)	(2,339.12)	(2,398.20)	0.00	9,476.14
357	9,476.14	(47.38)	(2,350.82)	(2,398.20)	0.00	7,125.32
358	7,125.32	(35.63)	(2,362.57)	(2,398.20)	0.00	4,762.75
359	4,762.75	(23.81)	(2,374.39)	(2,398.20)	0.00	2,388.36
360	2,388.36	(11.94)	(2,388.36)	(2,398.20)	0.00	0.00	(27,866.50)	(914.00)
Totals		(463,354.10)	(400,000.00)	(863,352.00)	0.00		(400,000.00)	(463,354.10)

&14&USample Proforma Amortization Schedule

Page &P of &N &D

320 LP05 Assignment #1 Profiles.xls

Sheet1

REAL 320 Principles of Real Estate
Assignment #1
PROJECT PROFILE
Adults in Household	1
Children in Household	- 0
Desire to have children	None
Working Adults	1
Household Income (Annual)	72,000
Credit Score	Good
Student Loans	60,000
Car Loans	20,000
Condition of Cars	1 Good
Credit Card Bills	8,000
Amount in Savings	50,000
Gift from Parent for use to purchase home	35,000
Total Savings & Parent Gift (Cash On Hand)	85,000

Sheet2

Sheet3

320 LP05 Assignment #1 Residence ProForma Example 31 Years.xls

Sample HomeBuy Property

Average Inland San Diego Home				ASSUMPTIONS: No CAPX (Capital Expenses) - As some analysis puts them above NOI, and others below NOI
Purchase Price		$ (500,000.00)
Building Value	68%	$ 340,000.00
Loan to Value		80%		Maximum for Investment Property: 70%
Loan Amount		$ 400,000.00
Down Payment		$ (100,000.00)
Loan Costs	2.0%	$ (8,000.00)
Interest Rate	Annual	6.500%
Loan Term	Months	360
Closing Costs	2.0%	$ (10,000.00)		See Estimated Settlement Statement for Detailed Breakdown
Total Costs at Acquisition		$ (118,000.00)
PROFORMA		Year 0	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10	Year 11	Year 12	Year 13	Year 14	Year 15	Year 16	Year 17	Year 18	Year 19	Year 20	Year 21	Year 22	Year 23	Year 24	Year 25	Year 26	Year 27	Year 28	Year 29	Year 30	Year 31
Gross Rent	0%		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Vacancy	0.0%		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other Income	0%		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Effective Gross Income			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
OPERATING EXPENSES
Property Taxes 1.1%	2%		$ (5,500.00)	$ (5,610.00)	$ (5,722.20)	$ (5,836.64)	$ (5,953.37)	$ (6,072.44)	$ (6,193.89)	$ (6,317.77)	$ (6,444.13)	$ (6,573.01)	$ (6,704.47)	$ (6,838.56)	$ (6,975.33)	$ (7,114.84)	$ (7,257.14)	$ (7,402.28)	$ (7,550.33)	$ (7,701.34)	$ (7,855.37)	$ (8,012.48)	$ (8,172.73)	$ (8,336.18)	$ (8,502.90)	$ (8,672.96)	$ (8,846.42)	$ (9,023.35)	$ (9,203.82)	$ (9,387.90)	$ (9,575.66)	$ (9,767.17)	$ (9,962.51)
Insurance: Fire	3%		$ (1,000.00)	$ (1,030.00)	$ (1,060.90)	$ (1,092.73)	$ (1,125.51)	$ (1,159.28)	$ (1,194.06)	$ (1,229.88)	$ (1,266.78)	$ (1,304.78)	$ (1,343.92)	$ (1,384.24)	$ (1,425.77)	$ (1,468.54)	$ (1,512.60)	$ (1,557.98)	$ (1,604.72)	$ (1,652.86)	$ (1,702.45)	$ (1,753.52)	$ (1,806.13)	$ (1,860.31)	$ (1,916.12)	$ (1,973.60)	$ (2,032.81)	$ (2,093.79)	$ (2,156.60)	$ (2,221.30)	$ (2,287.94)	$ (2,356.58)	$ (2,427.28)
Insurance: EQ	3%		$ (650.00)	$ (669.50)	$ (689.59)	$ (710.28)	$ (731.59)	$ (753.54)	$ (776.15)	$ (799.43)	$ (823.41)	$ (848.11)	$ (873.55)	$ (899.76)	$ (926.75)	$ (954.55)	$ (983.19)	$ (1,012.69)	$ (1,043.07)	$ (1,074.36)	$ (1,106.59)	$ (1,139.79)	$ (1,173.98)	$ (1,209.20)	$ (1,245.48)	$ (1,282.84)	$ (1,321.33)	$ (1,360.97)	$ (1,401.80)	$ (1,443.85)	$ (1,487.17)	$ (1,531.79)	$ (1,577.74)
Insurance: Umbrella	3%		$ (250.00)	$ (257.50)	$ (265.23)	$ (273.19)	$ (281.39)	$ (289.83)	$ (298.52)	$ (307.48)	$ (316.70)	$ (326.20)	$ (335.99)	$ (346.07)	$ (356.45)	$ (367.14)	$ (378.15)	$ (389.49)	$ (401.17)	$ (413.21)	$ (425.61)	$ (438.38)	$ (451.53)	$ (465.08)	$ (479.03)	$ (493.40)	$ (508.20)	$ (523.45)	$ (539.15)	$ (555.32)	$ (571.98)	$ (589.14)	$ (606.81)
Homeowners Assoc	3%		$ (1,200.00)	$ (1,236.00)	$ (1,273.08)	$ (1,311.27)	$ (1,350.61)	$ (1,391.13)	$ (1,432.86)	$ (1,475.85)	$ (1,520.13)	$ (1,565.73)	$ (1,612.70)	$ (1,661.08)	$ (1,710.91)	$ (1,762.24)	$ (1,815.11)	$ (1,869.56)	$ (1,925.65)	$ (1,983.42)	$ (2,042.92)	$ (2,104.21)	$ (2,167.34)	$ (2,232.36)	$ (2,299.33)	$ (2,368.31)	$ (2,439.36)	$ (2,512.54)	$ (2,587.92)	$ (2,665.56)	$ (2,745.53)	$ (2,827.90)	$ (2,912.74)
Maintenance	3%		$ (3,000.00)	$ (3,090.00)	$ (3,182.70)	$ (3,278.18)	$ (3,376.53)	$ (3,477.83)	$ (3,582.16)	$ (3,689.62)	$ (3,800.31)	$ (3,914.32)	$ (4,031.75)	$ (4,152.70)	$ (4,277.28)	$ (4,405.60)	$ (4,537.77)	$ (4,673.90)	$ (4,814.12)	$ (4,958.54)	$ (5,107.30)	$ (5,260.52)	$ (5,418.34)	$ (5,580.89)	$ (5,748.32)	$ (5,920.77)	$ (6,098.39)	$ (6,281.34)	$ (6,469.78)	$ (6,663.87)	$ (6,863.79)	$ (7,069.70)	$ (7,281.79)
Landscape	0%		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Utilities	0%		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Management Fee 10%	4%		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Operating Expenses			$ (11,600.00)	$ (11,893.00)	$ (12,193.70)	$ (12,502.29)	$ (12,819.00)	$ (13,144.05)	$ (13,477.64)	$ (13,820.03)	$ (14,171.46)	$ (14,532.15)	$ (14,902.38)	$ (15,282.41)	$ (15,672.49)	$ (16,072.91)	$ (16,483.96)	$ (16,905.90)	$ (17,339.06)	$ (17,783.73)	$ (18,240.24)	$ (18,708.90)	$ (19,190.05)	$ (19,684.02)	$ (20,191.18)	$ (20,711.88)	$ (21,246.51)	$ (21,795.44)	$ (22,359.07)	$ (22,937.80)	$ (23,532.07)	$ (24,142.28)	$ (24,768.87)
NET OPERATING INCOME			$ (11,600.00)	$ (11,893.00)	$ (12,193.70)	$ (12,502.29)	$ (12,819.00)	$ (13,144.05)	$ (13,477.64)	$ (13,820.03)	$ (14,171.46)	$ (14,532.15)	$ (14,902.38)	$ (15,282.41)	$ (15,672.49)	$ (16,072.91)	$ (16,483.96)	$ (16,905.90)	$ (17,339.06)	$ (17,783.73)	$ (18,240.24)	$ (18,708.90)	$ (19,190.05)	$ (19,684.02)	$ (20,191.18)	$ (20,711.88)	$ (21,246.51)	$ (21,795.44)	$ (22,359.07)	$ (22,937.80)	$ (23,532.07)	$ (24,142.28)	$ (24,768.87)
Debt Service
Interest			$ (25,868.38)	$ (25,568.95)	$ (25,249.47)	$ (24,908.59)	$ (24,544.89)	$ (24,156.86)	$ (23,742.79)	$ (23,301.03)	$ (22,829.66)	$ (22,326.71)	$ (21,790.11)	$ (21,217.57)	$ (20,606.68)	$ (19,954.84)	$ (19,259.38)	$ (18,517.35)	$ (17,725.63)	$ (16,880.87)	$ (15,979.51)	$ (15,017.84)	$ (13,991.75)	$ (12,896.91)	$ (11,728.76)	$ (10,482.37)	$ (9,152.52)	$ (7,733.63)	$ (6,219.69)	$ (4,604.34)	$ (2,880.83)	$ (1,041.90)	$ - 0
Principal			$ (4,470.86)	$ (4,770.29)	$ (5,089.77)	$ (5,430.65)	$ (5,794.35)	$ (6,182.38)	$ (6,596.45)	$ (7,038.21)	$ (7,509.58)	$ (8,012.53)	$ (8,549.13)	$ (9,121.67)	$ (9,732.56)	$ (10,384.40)	$ (11,079.86)	$ (11,821.89)	$ (12,613.61)	$ (13,458.37)	$ (14,359.73)	$ (15,321.40)	$ (16,347.49)	$ (17,442.33)	$ (18,610.48)	$ (19,856.87)	$ (21,186.72)	$ (22,605.61)	$ (24,119.55)	$ (25,734.90)	$ (27,458.41)	$ (29,299.95)	$ - 0
Total Debt Service		$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,341.85)	$ - 0
BTCF (Before Tax Cash Flow)			$ (41,939.24)	$ (42,232.24)	$ (42,532.94)	$ (42,841.53)	$ (43,158.24)	$ (43,483.29)	$ (43,816.88)	$ (44,159.27)	$ (44,510.70)	$ (44,871.39)	$ (45,241.62)	$ (45,621.65)	$ (46,011.73)	$ (46,412.15)	$ (46,823.20)	$ (47,245.14)	$ (47,678.30)	$ (48,122.97)	$ (48,579.48)	$ (49,048.14)	$ (49,529.29)	$ (50,023.26)	$ (50,530.42)	$ (51,051.12)	$ (51,585.75)	$ (52,134.68)	$ (52,698.31)	$ (53,277.04)	$ (53,871.31)	$ (54,484.13)	$ (24,768.87)
BTCF (Before Tax Cash Flow)			$ (41,939.24)	$ (42,232.24)	$ (42,532.94)	$ (42,841.53)	$ (43,158.24)	$ (43,483.29)	$ (43,816.88)	$ (44,159.27)	$ (44,510.70)	$ (44,871.39)	$ (45,241.62)	$ (45,621.65)	$ (46,011.73)	$ (46,412.15)	$ (46,823.20)	$ (47,245.14)	$ (47,678.30)	$ (48,122.97)	$ (48,579.48)	$ (49,048.14)	$ (49,529.29)	$ (50,023.26)	$ (50,530.42)	$ (51,051.12)	$ (51,585.75)	$ (52,134.68)	$ (52,698.31)	$ (53,277.04)	$ (53,871.31)	$ (54,484.13)	$ (24,768.87)
Tax Calculation - 1040 Sched A
Property Taxes			$ (5,500.00)	$ (5,610.00)	$ (5,722.20)	$ (5,836.64)	$ (5,953.37)	$ (6,072.44)	$ (6,193.89)	$ (6,317.77)	$ (6,444.13)	$ (6,573.01)	$ (6,704.47)	$ (6,838.56)	$ (6,975.33)	$ (7,114.84)	$ (7,257.14)	$ (7,402.28)	$ (7,550.33)	$ (7,701.34)	$ (7,855.37)	$ (8,012.48)	$ (8,172.73)	$ (8,336.18)	$ (8,502.90)	$ (8,672.96)	$ (8,846.42)	$ (9,023.35)	$ (9,203.82)	$ (9,387.90)	$ (9,575.66)	$ (9,767.17)	$ (9,962.51)
Interest Deduction			$ (25,868.38)	$ (25,568.95)	$ (25,249.47)	$ (24,908.59)	$ (24,544.89)	$ (24,156.86)	$ (23,742.79)	$ (23,301.03)	$ (22,829.66)	$ (22,326.71)	$ (21,790.11)	$ (21,217.57)	$ (20,606.68)	$ (19,954.84)	$ (19,259.38)	$ (18,517.35)	$ (17,725.63)	$ (16,880.87)	$ (15,979.51)	$ (15,017.84)	$ (13,991.75)	$ (12,896.91)	$ (11,728.76)	$ (10,482.37)	$ (9,152.52)	$ (7,733.63)	$ (6,219.69)	$ (4,604.34)	$ (2,880.83)	$ (1,041.90)	$ - 0
* Ignores Standard Deduction Opportunity Cost *			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Deductions			$ (31,368.38)	$ (31,178.95)	$ (30,971.67)	$ (30,745.23)	$ (30,498.26)	$ (30,229.30)	$ (29,936.68)	$ (29,618.80)	$ (29,273.79)	$ (28,899.72)	$ (28,494.58)	$ (28,056.13)	$ (27,582.01)	$ (27,069.68)	$ (26,516.52)	$ (25,919.63)	$ (25,275.96)	$ (24,582.21)	$ (23,834.88)	$ (23,030.32)	$ (22,164.48)	$ (21,233.09)	$ (20,231.66)	$ (19,155.33)	$ (17,998.94)	$ (16,756.98)	$ (15,423.51)	$ (13,992.24)	$ (12,456.49)	$ (10,809.07)	$ (9,962.51)
Tax Paid (Tax Reduction)	35%	Tax Rate	$ (10,978.93)	$ (10,912.63)	$ (10,840.08)	$ (10,760.83)	$ (10,674.39)	$ (10,580.26)	$ (10,477.84)	$ (10,366.58)	$ (10,245.83)	$ (10,114.90)	$ (9,973.10)	$ (9,819.65)	$ (9,653.70)	$ (9,474.39)	$ (9,280.78)	$ (9,071.87)	$ (8,846.59)	$ (8,603.77)	$ (8,342.21)	$ (8,060.61)	$ (7,757.57)	$ (7,431.58)	$ (7,081.08)	$ (6,704.37)	$ (6,299.63)	$ (5,864.94)	$ (5,398.23)	$ (4,897.28)	$ (4,359.77)	$ (3,783.17)	$ (3,486.88)
AFTER TAX CASH FLOW			$ (30,960.31)	$ (31,319.61)	$ (31,692.86)	$ (32,080.70)	$ (32,483.85)	$ (32,903.04)	$ (33,339.04)	$ (33,792.69)	$ (34,264.87)	$ (34,756.49)	$ (35,268.52)	$ (35,802.00)	$ (36,358.03)	$ (36,937.76)	$ (37,542.42)	$ (38,173.27)	$ (38,831.71)	$ (39,519.20)	$ (40,237.27)	$ (40,987.53)	$ (41,771.72)	$ (42,591.68)	$ (43,449.34)	$ (44,346.75)	$ (45,286.12)	$ (46,269.74)	$ (47,300.08)	$ (48,379.76)	$ (49,511.54)	$ (50,700.96)	$ (21,281.99)
Property Value	10.0%	$ 500,000.00	$ 550,000.00	$ 605,000.00	$ 665,500.00	$ 732,050.00	$ 805,255.00	$ 885,780.50	$ 974,358.55	$ 1,071,794.41	$ 1,178,973.85	$ 1,296,871.23	$ 1,426,558.35	$ 1,569,214.19	$ 1,726,135.61	$ 1,898,749.17	$ 2,088,624.08	$ 2,297,486.49	$ 2,527,235.14	$ 2,779,958.66	$ 3,057,954.52	$ 3,363,749.97	$ 3,700,124.97	$ 4,070,137.47	$ 4,477,151.22	$ 4,924,866.34	$ 5,417,352.97	$ 5,959,088.27	$ 6,554,997.10	$ 7,210,496.81	$ 7,931,546.49	$ 8,724,701.13	$ 9,597,171.25
Loan Payoff		Match with Amortization Schedule																															$ (0.00)
Commissions	6.0%																																$ (575,830.27)
Closing Costs	2.0%																																$ (191,943.42)
Before Tax Sale Proceeds																																	$ 8,829,397.55
INCOME TAX CALULATION FOR CAPITAL APPRECIATION
Sale Price		$ 9,597,171.25
minus Purchase Price		$ (500,000.00)
minus Acquisition Costs		$ (10,000.00)
minus Commissions		$ (575,830.27)
minus Sales Costs		$ (191,943.42)
Total Capital Gain (Sale Price - Adj Basis)		$ 8,319,397.55
Exclusion for Sale of Home		$ (250,000.00)	1	Enter "1" for Single, "2" for Married, "0" if used in previous two years
Depreciation Recapture		NONE - No Depreciation for Residence																															$ - 0
Income Tax: Cap Gain		$ 8,069,397.55	15%																														$ (1,210,409.63)
Total Income Tax		$ 8,069,397.55																															$ (1,210,409.63)
Net After Tax Sale Proceeds																																	$ 7,618,987.92
TOTAL CASH FLOW		$ (118,000.00)	$ (30,960.31)	$ (31,319.61)	$ (31,692.86)	$ (32,080.70)	$ (32,483.85)	$ (32,903.04)	$ (33,339.04)	$ (33,792.69)	$ (34,264.87)	$ (34,756.49)	$ (35,268.52)	$ (35,802.00)	$ (36,358.03)	$ (36,937.76)	$ (37,542.42)	$ (38,173.27)	$ (38,831.71)	$ (39,519.20)	$ (40,237.27)	$ (40,987.53)	$ (41,771.72)	$ (42,591.68)	$ (43,449.34)	$ (44,346.75)	$ (45,286.12)	$ (46,269.74)	$ (47,300.08)	$ (48,379.76)	$ (49,511.54)	$ (50,700.96)	$ 7,597,705.92
IRR																																	9.43%
Hurdle Rate		Alternative Investment OR "Risk Free" Interest Rate - Remember to adjust for value of housing services/opportunity cost																															9.0%
IRR in excess of Hurdle Rate		FINAL DECISION: If positive, then invest																															0.43%
NOTE: To Reduce Number of Years in ProForma, take the following steps: (Example reducing ProForma to 6 years)
1. Delete Columns for Year 6 through Year 30 (Column I through AG inclusive)
2. Copy Fill from H17-H59 inclusive to I17-I59 Inclusive to re-establish formulas from 2nd-to-last-year column
3. Fix Last Year Interest by adding 12 to the link from H39 into I39 (Cell I39 becomes [='Sample HomeBuy Amort Sch'!I86]
3. Fix Last Year Principal by adding 12 to the link from H40 into I40 (Cell I40 becomes [='Sample HomeBuy Amort Sch'!H86]

&C&14&USample Class Proforma&R&18Name: ________________________

&LPage &P of &N&R&D &T

Sample HomeBuy Amort Sch


	Assumptions in Proforma:	Stable compounding rate for income, expenses & prices
		Expenses are a function of rent price
		Acqusition on Jan 1 of Year
		Disposition on Dec 31 of Year
		Tax Reductions are fully offset by other income (otherwise lost)
		Straight Line Depreciation & Amortization
	Loan Amount	400,000.00
	Term	360	30
	Interest Rate	0.54%	6.50%
	Payment	(2,528.27)	(30,339.24)		Add as Negative Number
Period	Beginning Bal	Interest	Principal	Payment	Addt Pymt	End Bal	Annual Principal	Annual Interest
1	400,000.00	(2,166.67)	(361.60)	(2,528.27)	0.00	399,638.40
2	399,638.40	(2,164.71)	(363.56)	(2,528.27)	0.00	399,274.84
3	399,274.84	(2,162.74)	(365.53)	(2,528.27)	0.00	398,909.31
4	398,909.31	(2,160.76)	(367.51)	(2,528.27)	0.00	398,541.80
5	398,541.80	(2,158.77)	(369.50)	(2,528.27)	0.00	398,172.30
6	398,172.30	(2,156.77)	(371.50)	(2,528.27)	0.00	397,800.80
7	397,800.80	(2,154.75)	(373.52)	(2,528.27)	0.00	397,427.28
8	397,427.28	(2,152.73)	(375.54)	(2,528.27)	0.00	397,051.74
9	397,051.74	(2,150.70)	(377.57)	(2,528.27)	0.00	396,674.17
10	396,674.17	(2,148.65)	(379.62)	(2,528.27)	0.00	396,294.55
11	396,294.55	(2,146.60)	(381.67)	(2,528.27)	0.00	395,912.88
12	395,912.88	(2,144.53)	(383.74)	(2,528.27)	0.00	395,529.14	(4,470.86)	(25,868.38)
13	395,529.14	(2,142.45)	(385.82)	(2,528.27)	0.00	395,143.32
14	395,143.32	(2,140.36)	(387.91)	(2,528.27)	0.00	394,755.41
15	394,755.41	(2,138.26)	(390.01)	(2,528.27)	0.00	394,365.40
16	394,365.40	(2,136.15)	(392.12)	(2,528.27)	0.00	393,973.28
17	393,973.28	(2,134.02)	(394.25)	(2,528.27)	0.00	393,579.03
18	393,579.03	(2,131.89)	(396.38)	(2,528.27)	0.00	393,182.65
19	393,182.65	(2,129.74)	(398.53)	(2,528.27)	0.00	392,784.12
20	392,784.12	(2,127.58)	(400.69)	(2,528.27)	0.00	392,383.43
21	392,383.43	(2,125.41)	(402.86)	(2,528.27)	0.00	391,980.57
22	391,980.57	(2,123.23)	(405.04)	(2,528.27)	0.00	391,575.53
23	391,575.53	(2,121.03)	(407.24)	(2,528.27)	0.00	391,168.29
24	391,168.29	(2,118.83)	(409.44)	(2,528.27)	0.00	390,758.85	(4,770.29)	(25,568.95)
25	390,758.85	(2,116.61)	(411.66)	(2,528.27)	0.00	390,347.19
26	390,347.19	(2,114.38)	(413.89)	(2,528.27)	0.00	389,933.30
27	389,933.30	(2,112.14)	(416.13)	(2,528.27)	0.00	389,517.17
28	389,517.17	(2,109.88)	(418.39)	(2,528.27)	0.00	389,098.78
29	389,098.78	(2,107.62)	(420.65)	(2,528.27)	0.00	388,678.13
30	388,678.13	(2,105.34)	(422.93)	(2,528.27)	0.00	388,255.20
31	388,255.20	(2,103.05)	(425.22)	(2,528.27)	0.00	387,829.98
32	387,829.98	(2,100.75)	(427.52)	(2,528.27)	0.00	387,402.46
33	387,402.46	(2,098.43)	(429.84)	(2,528.27)	0.00	386,972.62
34	386,972.62	(2,096.10)	(432.17)	(2,528.27)	0.00	386,540.45
35	386,540.45	(2,093.76)	(434.51)	(2,528.27)	0.00	386,105.94
36	386,105.94	(2,091.41)	(436.86)	(2,528.27)	0.00	385,669.08	(5,089.77)	(25,249.47)
37	385,669.08	(2,089.04)	(439.23)	(2,528.27)	0.00	385,229.85
38	385,229.85	(2,086.66)	(441.61)	(2,528.27)	0.00	384,788.24
39	384,788.24	(2,084.27)	(444.00)	(2,528.27)	0.00	384,344.24
40	384,344.24	(2,081.86)	(446.41)	(2,528.27)	0.00	383,897.83
41	383,897.83	(2,079.45)	(448.82)	(2,528.27)	0.00	383,449.01
42	383,449.01	(2,077.02)	(451.25)	(2,528.27)	0.00	382,997.76
43	382,997.76	(2,074.57)	(453.70)	(2,528.27)	0.00	382,544.06
44	382,544.06	(2,072.11)	(456.16)	(2,528.27)	0.00	382,087.90
45	382,087.90	(2,069.64)	(458.63)	(2,528.27)	0.00	381,629.27
46	381,629.27	(2,067.16)	(461.11)	(2,528.27)	0.00	381,168.16
47	381,168.16	(2,064.66)	(463.61)	(2,528.27)	0.00	380,704.55
48	380,704.55	(2,062.15)	(466.12)	(2,528.27)	0.00	380,238.43	(5,430.65)	(24,908.59)
49	380,238.43	(2,059.62)	(468.65)	(2,528.27)	0.00	379,769.78
50	379,769.78	(2,057.09)	(471.18)	(2,528.27)	0.00	379,298.60
51	379,298.60	(2,054.53)	(473.74)	(2,528.27)	0.00	378,824.86
52	378,824.86	(2,051.97)	(476.30)	(2,528.27)	0.00	378,348.56
53	378,348.56	(2,049.39)	(478.88)	(2,528.27)	0.00	377,869.68
54	377,869.68	(2,046.79)	(481.48)	(2,528.27)	0.00	377,388.20
55	377,388.20	(2,044.19)	(484.08)	(2,528.27)	0.00	376,904.12
56	376,904.12	(2,041.56)	(486.71)	(2,528.27)	0.00	376,417.41
57	376,417.41	(2,038.93)	(489.34)	(2,528.27)	0.00	375,928.07
58	375,928.07	(2,036.28)	(491.99)	(2,528.27)	0.00	375,436.08
59	375,436.08	(2,033.61)	(494.66)	(2,528.27)	0.00	374,941.42
60	374,941.42	(2,030.93)	(497.34)	(2,528.27)	0.00	374,444.08	(5,794.35)	(24,544.89)
61	374,444.08	(2,028.24)	(500.03)	(2,528.27)	0.00	373,944.05
62	373,944.05	(2,025.53)	(502.74)	(2,528.27)	0.00	373,441.31
63	373,441.31	(2,022.81)	(505.46)	(2,528.27)	0.00	372,935.85
64	372,935.85	(2,020.07)	(508.20)	(2,528.27)	0.00	372,427.65
65	372,427.65	(2,017.32)	(510.95)	(2,528.27)	0.00	371,916.70
66	371,916.70	(2,014.55)	(513.72)	(2,528.27)	0.00	371,402.98
67	371,402.98	(2,011.77)	(516.50)	(2,528.27)	0.00	370,886.48
68	370,886.48	(2,008.97)	(519.30)	(2,528.27)	0.00	370,367.18
69	370,367.18	(2,006.16)	(522.11)	(2,528.27)	0.00	369,845.07
70	369,845.07	(2,003.33)	(524.94)	(2,528.27)	0.00	369,320.13
71	369,320.13	(2,000.48)	(527.79)	(2,528.27)	0.00	368,792.34
72	368,792.34	(1,997.63)	(530.64)	(2,528.27)	0.00	368,261.70	(6,182.38)	(24,156.86)
73	368,261.70	(1,994.75)	(533.52)	(2,528.27)	0.00	367,728.18
74	367,728.18	(1,991.86)	(536.41)	(2,528.27)	0.00	367,191.77
75	367,191.77	(1,988.96)	(539.31)	(2,528.27)	0.00	366,652.46
76	366,652.46	(1,986.03)	(542.24)	(2,528.27)	0.00	366,110.22
77	366,110.22	(1,983.10)	(545.17)	(2,528.27)	0.00	365,565.05
78	365,565.05	(1,980.14)	(548.13)	(2,528.27)	0.00	365,016.92
79	365,016.92	(1,977.17)	(551.10)	(2,528.27)	0.00	364,465.82
80	364,465.82	(1,974.19)	(554.08)	(2,528.27)	0.00	363,911.74
81	363,911.74	(1,971.19)	(557.08)	(2,528.27)	0.00	363,354.66
82	363,354.66	(1,968.17)	(560.10)	(2,528.27)	0.00	362,794.56
83	362,794.56	(1,965.14)	(563.13)	(2,528.27)	0.00	362,231.43
84	362,231.43	(1,962.09)	(566.18)	(2,528.27)	0.00	361,665.25	(6,596.45)	(23,742.79)
85	361,665.25	(1,959.02)	(569.25)	(2,528.27)	0.00	361,096.00
86	361,096.00	(1,955.94)	(572.33)	(2,528.27)	0.00	360,523.67
87	360,523.67	(1,952.84)	(575.43)	(2,528.27)	0.00	359,948.24
88	359,948.24	(1,949.72)	(578.55)	(2,528.27)	0.00	359,369.69
89	359,369.69	(1,946.59)	(581.68)	(2,528.27)	0.00	358,788.01
90	358,788.01	(1,943.44)	(584.83)	(2,528.27)	0.00	358,203.18
91	358,203.18	(1,940.27)	(588.00)	(2,528.27)	0.00	357,615.18
92	357,615.18	(1,937.08)	(591.19)	(2,528.27)	0.00	357,023.99
93	357,023.99	(1,933.88)	(594.39)	(2,528.27)	0.00	356,429.60
94	356,429.60	(1,930.66)	(597.61)	(2,528.27)	0.00	355,831.99
95	355,831.99	(1,927.42)	(600.85)	(2,528.27)	0.00	355,231.14
96	355,231.14	(1,924.17)	(604.10)	(2,528.27)	0.00	354,627.04	(7,038.21)	(23,301.03)
97	354,627.04	(1,920.90)	(607.37)	(2,528.27)	0.00	354,019.67
98	354,019.67	(1,917.61)	(610.66)	(2,528.27)	0.00	353,409.01
99	353,409.01	(1,914.30)	(613.97)	(2,528.27)	0.00	352,795.04
100	352,795.04	(1,910.97)	(617.30)	(2,528.27)	0.00	352,177.74
101	352,177.74	(1,907.63)	(620.64)	(2,528.27)	0.00	351,557.10
102	351,557.10	(1,904.27)	(624.00)	(2,528.27)	0.00	350,933.10
103	350,933.10	(1,900.89)	(627.38)	(2,528.27)	0.00	350,305.72
104	350,305.72	(1,897.49)	(630.78)	(2,528.27)	0.00	349,674.94
105	349,674.94	(1,894.07)	(634.20)	(2,528.27)	0.00	349,040.74
106	349,040.74	(1,890.64)	(637.63)	(2,528.27)	0.00	348,403.11
107	348,403.11	(1,887.18)	(641.09)	(2,528.27)	0.00	347,762.02
108	347,762.02	(1,883.71)	(644.56)	(2,528.27)	0.00	347,117.46	(7,509.58)	(22,829.66)
109	347,117.46	(1,880.22)	(648.05)	(2,528.27)	0.00	346,469.41
110	346,469.41	(1,876.71)	(651.56)	(2,528.27)	0.00	345,817.85
111	345,817.85	(1,873.18)	(655.09)	(2,528.27)	0.00	345,162.76
112	345,162.76	(1,869.63)	(658.64)	(2,528.27)	0.00	344,504.12
113	344,504.12	(1,866.06)	(662.21)	(2,528.27)	0.00	343,841.91
114	343,841.91	(1,862.48)	(665.79)	(2,528.27)	0.00	343,176.12
115	343,176.12	(1,858.87)	(669.40)	(2,528.27)	0.00	342,506.72
116	342,506.72	(1,855.24)	(673.03)	(2,528.27)	0.00	341,833.69
117	341,833.69	(1,851.60)	(676.67)	(2,528.27)	0.00	341,157.02
118	341,157.02	(1,847.93)	(680.34)	(2,528.27)	0.00	340,476.68
119	340,476.68	(1,844.25)	(684.02)	(2,528.27)	0.00	339,792.66
120	339,792.66	(1,840.54)	(687.73)	(2,528.27)	0.00	339,104.93	(8,012.53)	(22,326.71)
121	339,104.93	(1,836.82)	(691.45)	(2,528.27)	0.00	338,413.48
122	338,413.48	(1,833.07)	(695.20)	(2,528.27)	0.00	337,718.28
123	337,718.28	(1,829.31)	(698.96)	(2,528.27)	0.00	337,019.32
124	337,019.32	(1,825.52)	(702.75)	(2,528.27)	0.00	336,316.57
125	336,316.57	(1,821.71)	(706.56)	(2,528.27)	0.00	335,610.01
126	335,610.01	(1,817.89)	(710.38)	(2,528.27)	0.00	334,899.63
127	334,899.63	(1,814.04)	(714.23)	(2,528.27)	0.00	334,185.40
128	334,185.40	(1,810.17)	(718.10)	(2,528.27)	0.00	333,467.30
129	333,467.30	(1,806.28)	(721.99)	(2,528.27)	0.00	332,745.31
130	332,745.31	(1,802.37)	(725.90)	(2,528.27)	0.00	332,019.41
131	332,019.41	(1,798.44)	(729.83)	(2,528.27)	0.00	331,289.58
132	331,289.58	(1,794.49)	(733.78)	(2,528.27)	0.00	330,555.80	(8,549.13)	(21,790.11)
133	330,555.80	(1,790.51)	(737.76)	(2,528.27)	0.00	329,818.04
134	329,818.04	(1,786.51)	(741.76)	(2,528.27)	0.00	329,076.28
135	329,076.28	(1,782.50)	(745.77)	(2,528.27)	0.00	328,330.51
136	328,330.51	(1,778.46)	(749.81)	(2,528.27)	0.00	327,580.70
137	327,580.70	(1,774.40)	(753.87)	(2,528.27)	0.00	326,826.83
138	326,826.83	(1,770.31)	(757.96)	(2,528.27)	0.00	326,068.87
139	326,068.87	(1,766.21)	(762.06)	(2,528.27)	0.00	325,306.81
140	325,306.81	(1,762.08)	(766.19)	(2,528.27)	0.00	324,540.62
141	324,540.62	(1,757.93)	(770.34)	(2,528.27)	0.00	323,770.28
142	323,770.28	(1,753.76)	(774.51)	(2,528.27)	0.00	322,995.77
143	322,995.77	(1,749.56)	(778.71)	(2,528.27)	0.00	322,217.06
144	322,217.06	(1,745.34)	(782.93)	(2,528.27)	0.00	321,434.13	(9,121.67)	(21,217.57)
145	321,434.13	(1,741.10)	(787.17)	(2,528.27)	0.00	320,646.96
146	320,646.96	(1,736.84)	(791.43)	(2,528.27)	0.00	319,855.53
147	319,855.53	(1,732.55)	(795.72)	(2,528.27)	0.00	319,059.81
148	319,059.81	(1,728.24)	(800.03)	(2,528.27)	0.00	318,259.78
149	318,259.78	(1,723.91)	(804.36)	(2,528.27)	0.00	317,455.42
150	317,455.42	(1,719.55)	(808.72)	(2,528.27)	0.00	316,646.70
151	316,646.70	(1,715.17)	(813.10)	(2,528.27)	0.00	315,833.60
152	315,833.60	(1,710.77)	(817.50)	(2,528.27)	0.00	315,016.10
153	315,016.10	(1,706.34)	(821.93)	(2,528.27)	0.00	314,194.17
154	314,194.17	(1,701.89)	(826.38)	(2,528.27)	0.00	313,367.79
155	313,367.79	(1,697.41)	(830.86)	(2,528.27)	0.00	312,536.93
156	312,536.93	(1,692.91)	(835.36)	(2,528.27)	0.00	311,701.57	(9,732.56)	(20,606.68)
157	311,701.57	(1,688.38)	(839.89)	(2,528.27)	0.00	310,861.68
158	310,861.68	(1,683.83)	(844.44)	(2,528.27)	0.00	310,017.24
159	310,017.24	(1,679.26)	(849.01)	(2,528.27)	0.00	309,168.23
160	309,168.23	(1,674.66)	(853.61)	(2,528.27)	0.00	308,314.62
161	308,314.62	(1,670.04)	(858.23)	(2,528.27)	0.00	307,456.39
162	307,456.39	(1,665.39)	(862.88)	(2,528.27)	0.00	306,593.51
163	306,593.51	(1,660.71)	(867.56)	(2,528.27)	0.00	305,725.95
164	305,725.95	(1,656.02)	(872.25)	(2,528.27)	0.00	304,853.70
165	304,853.70	(1,651.29)	(876.98)	(2,528.27)	0.00	303,976.72
166	303,976.72	(1,646.54)	(881.73)	(2,528.27)	0.00	303,094.99
167	303,094.99	(1,641.76)	(886.51)	(2,528.27)	0.00	302,208.48
168	302,208.48	(1,636.96)	(891.31)	(2,528.27)	0.00	301,317.17	(10,384.40)	(19,954.84)
169	301,317.17	(1,632.13)	(896.14)	(2,528.27)	0.00	300,421.03
170	300,421.03	(1,627.28)	(900.99)	(2,528.27)	0.00	299,520.04
171	299,520.04	(1,622.40)	(905.87)	(2,528.27)	0.00	298,614.17
172	298,614.17	(1,617.49)	(910.78)	(2,528.27)	0.00	297,703.39
173	297,703.39	(1,612.56)	(915.71)	(2,528.27)	0.00	296,787.68
174	296,787.68	(1,607.60)	(920.67)	(2,528.27)	0.00	295,867.01
175	295,867.01	(1,602.61)	(925.66)	(2,528.27)	0.00	294,941.35
176	294,941.35	(1,597.60)	(930.67)	(2,528.27)	0.00	294,010.68
177	294,010.68	(1,592.56)	(935.71)	(2,528.27)	0.00	293,074.97
178	293,074.97	(1,587.49)	(940.78)	(2,528.27)	0.00	292,134.19
179	292,134.19	(1,582.39)	(945.88)	(2,528.27)	0.00	291,188.31
180	291,188.31	(1,577.27)	(951.00)	(2,528.27)	0.00	290,237.31	(11,079.86)	(19,259.38)
181	290,237.31	(1,572.12)	(956.15)	(2,528.27)	0.00	289,281.16
182	289,281.16	(1,566.94)	(961.33)	(2,528.27)	0.00	288,319.83
183	288,319.83	(1,561.73)	(966.54)	(2,528.27)	0.00	287,353.29
184	287,353.29	(1,556.50)	(971.77)	(2,528.27)	0.00	286,381.52
185	286,381.52	(1,551.23)	(977.04)	(2,528.27)	0.00	285,404.48
186	285,404.48	(1,545.94)	(982.33)	(2,528.27)	0.00	284,422.15
187	284,422.15	(1,540.62)	(987.65)	(2,528.27)	0.00	283,434.50
188	283,434.50	(1,535.27)	(993.00)	(2,528.27)	0.00	282,441.50
189	282,441.50	(1,529.89)	(998.38)	(2,528.27)	0.00	281,443.12
190	281,443.12	(1,524.48)	(1,003.79)	(2,528.27)	0.00	280,439.33
191	280,439.33	(1,519.05)	(1,009.22)	(2,528.27)	0.00	279,430.11
192	279,430.11	(1,513.58)	(1,014.69)	(2,528.27)	0.00	278,415.42	(11,821.89)	(18,517.35)
193	278,415.42	(1,508.08)	(1,020.19)	(2,528.27)	0.00	277,395.23
194	277,395.23	(1,502.56)	(1,025.71)	(2,528.27)	0.00	276,369.52
195	276,369.52	(1,497.00)	(1,031.27)	(2,528.27)	0.00	275,338.25
196	275,338.25	(1,491.42)	(1,036.85)	(2,528.27)	0.00	274,301.40
197	274,301.40	(1,485.80)	(1,042.47)	(2,528.27)	0.00	273,258.93
198	273,258.93	(1,480.15)	(1,048.12)	(2,528.27)	0.00	272,210.81
199	272,210.81	(1,474.48)	(1,053.79)	(2,528.27)	0.00	271,157.02
200	271,157.02	(1,468.77)	(1,059.50)	(2,528.27)	0.00	270,097.52
201	270,097.52	(1,463.03)	(1,065.24)	(2,528.27)	0.00	269,032.28
202	269,032.28	(1,457.26)	(1,071.01)	(2,528.27)	0.00	267,961.27
203	267,961.27	(1,451.46)	(1,076.81)	(2,528.27)	0.00	266,884.46
204	266,884.46	(1,445.62)	(1,082.65)	(2,528.27)	0.00	265,801.81	(12,613.61)	(17,725.63)
205	265,801.81	(1,439.76)	(1,088.51)	(2,528.27)	0.00	264,713.30
206	264,713.30	(1,433.86)	(1,094.41)	(2,528.27)	0.00	263,618.89
207	263,618.89	(1,427.94)	(1,100.33)	(2,528.27)	0.00	262,518.56
208	262,518.56	(1,421.98)	(1,106.29)	(2,528.27)	0.00	261,412.27
209	261,412.27	(1,415.98)	(1,112.29)	(2,528.27)	0.00	260,299.98
210	260,299.98	(1,409.96)	(1,118.31)	(2,528.27)	0.00	259,181.67
211	259,181.67	(1,403.90)	(1,124.37)	(2,528.27)	0.00	258,057.30
212	258,057.30	(1,397.81)	(1,130.46)	(2,528.27)	0.00	256,926.84
213	256,926.84	(1,391.69)	(1,136.58)	(2,528.27)	0.00	255,790.26
214	255,790.26	(1,385.53)	(1,142.74)	(2,528.27)	0.00	254,647.52
215	254,647.52	(1,379.34)	(1,148.93)	(2,528.27)	0.00	253,498.59
216	253,498.59	(1,373.12)	(1,155.15)	(2,528.27)	0.00	252,343.44	(13,458.37)	(16,880.87)
217	252,343.44	(1,366.86)	(1,161.41)	(2,528.27)	0.00	251,182.03
218	251,182.03	(1,360.57)	(1,167.70)	(2,528.27)	0.00	250,014.33
219	250,014.33	(1,354.24)	(1,174.03)	(2,528.27)	0.00	248,840.30
220	248,840.30	(1,347.88)	(1,180.39)	(2,528.27)	0.00	247,659.91
221	247,659.91	(1,341.49)	(1,186.78)	(2,528.27)	0.00	246,473.13
222	246,473.13	(1,335.06)	(1,193.21)	(2,528.27)	0.00	245,279.92
223	245,279.92	(1,328.60)	(1,199.67)	(2,528.27)	0.00	244,080.25
224	244,080.25	(1,322.10)	(1,206.17)	(2,528.27)	0.00	242,874.08
225	242,874.08	(1,315.57)	(1,212.70)	(2,528.27)	0.00	241,661.38
226	241,661.38	(1,309.00)	(1,219.27)	(2,528.27)	0.00	240,442.11
227	240,442.11	(1,302.39)	(1,225.88)	(2,528.27)	0.00	239,216.23
228	239,216.23	(1,295.75)	(1,232.52)	(2,528.27)	0.00	237,983.71	(14,359.73)	(15,979.51)
229	237,983.71	(1,289.08)	(1,239.19)	(2,528.27)	0.00	236,744.52
230	236,744.52	(1,282.37)	(1,245.90)	(2,528.27)	0.00	235,498.62
231	235,498.62	(1,275.62)	(1,252.65)	(2,528.27)	0.00	234,245.97
232	234,245.97	(1,268.83)	(1,259.44)	(2,528.27)	0.00	232,986.53
233	232,986.53	(1,262.01)	(1,266.26)	(2,528.27)	0.00	231,720.27
234	231,720.27	(1,255.15)	(1,273.12)	(2,528.27)	0.00	230,447.15
235	230,447.15	(1,248.26)	(1,280.01)	(2,528.27)	0.00	229,167.14
236	229,167.14	(1,241.32)	(1,286.95)	(2,528.27)	0.00	227,880.19
237	227,880.19	(1,234.35)	(1,293.92)	(2,528.27)	0.00	226,586.27
238	226,586.27	(1,227.34)	(1,300.93)	(2,528.27)	0.00	225,285.34
239	225,285.34	(1,220.30)	(1,307.97)	(2,528.27)	0.00	223,977.37
240	223,977.37	(1,213.21)	(1,315.06)	(2,528.27)	0.00	222,662.31	(15,321.40)	(15,017.84)
241	222,662.31	(1,206.09)	(1,322.18)	(2,528.27)	0.00	221,340.13
242	221,340.13	(1,198.93)	(1,329.34)	(2,528.27)	0.00	220,010.79
243	220,010.79	(1,191.73)	(1,336.54)	(2,528.27)	0.00	218,674.25
244	218,674.25	(1,184.49)	(1,343.78)	(2,528.27)	0.00	217,330.47
245	217,330.47	(1,177.21)	(1,351.06)	(2,528.27)	0.00	215,979.41
246	215,979.41	(1,169.89)	(1,358.38)	(2,528.27)	0.00	214,621.03
247	214,621.03	(1,162.53)	(1,365.74)	(2,528.27)	0.00	213,255.29
248	213,255.29	(1,155.13)	(1,373.14)	(2,528.27)	0.00	211,882.15
249	211,882.15	(1,147.69)	(1,380.58)	(2,528.27)	0.00	210,501.57
250	210,501.57	(1,140.22)	(1,388.05)	(2,528.27)	0.00	209,113.52
251	209,113.52	(1,132.70)	(1,395.57)	(2,528.27)	0.00	207,717.95
252	207,717.95	(1,125.14)	(1,403.13)	(2,528.27)	0.00	206,314.82	(16,347.49)	(13,991.75)
253	206,314.82	(1,117.54)	(1,410.73)	(2,528.27)	0.00	204,904.09
254	204,904.09	(1,109.90)	(1,418.37)	(2,528.27)	0.00	203,485.72
255	203,485.72	(1,102.21)	(1,426.06)	(2,528.27)	0.00	202,059.66
256	202,059.66	(1,094.49)	(1,433.78)	(2,528.27)	0.00	200,625.88
257	200,625.88	(1,086.72)	(1,441.55)	(2,528.27)	0.00	199,184.33
258	199,184.33	(1,078.92)	(1,449.35)	(2,528.27)	0.00	197,734.98
259	197,734.98	(1,071.06)	(1,457.21)	(2,528.27)	0.00	196,277.77
260	196,277.77	(1,063.17)	(1,465.10)	(2,528.27)	0.00	194,812.67
261	194,812.67	(1,055.24)	(1,473.03)	(2,528.27)	0.00	193,339.64
262	193,339.64	(1,047.26)	(1,481.01)	(2,528.27)	0.00	191,858.63
263	191,858.63	(1,039.23)	(1,489.04)	(2,528.27)	0.00	190,369.59
264	190,369.59	(1,031.17)	(1,497.10)	(2,528.27)	0.00	188,872.49	(17,442.33)	(12,896.91)
265	188,872.49	(1,023.06)	(1,505.21)	(2,528.27)	0.00	187,367.28
266	187,367.28	(1,014.91)	(1,513.36)	(2,528.27)	0.00	185,853.92
267	185,853.92	(1,006.71)	(1,521.56)	(2,528.27)	0.00	184,332.36
268	184,332.36	(998.47)	(1,529.80)	(2,528.27)	0.00	182,802.56
269	182,802.56	(990.18)	(1,538.09)	(2,528.27)	0.00	181,264.47
270	181,264.47	(981.85)	(1,546.42)	(2,528.27)	0.00	179,718.05
271	179,718.05	(973.47)	(1,554.80)	(2,528.27)	0.00	178,163.25
272	178,163.25	(965.05)	(1,563.22)	(2,528.27)	0.00	176,600.03
273	176,600.03	(956.58)	(1,571.69)	(2,528.27)	0.00	175,028.34
274	175,028.34	(948.07)	(1,580.20)	(2,528.27)	0.00	173,448.14
275	173,448.14	(939.51)	(1,588.76)	(2,528.27)	0.00	171,859.38
276	171,859.38	(930.90)	(1,597.37)	(2,528.27)	0.00	170,262.01	(18,610.48)	(11,728.76)
277	170,262.01	(922.25)	(1,606.02)	(2,528.27)	0.00	168,655.99
278	168,655.99	(913.55)	(1,614.72)	(2,528.27)	0.00	167,041.27
279	167,041.27	(904.81)	(1,623.46)	(2,528.27)	0.00	165,417.81
280	165,417.81	(896.01)	(1,632.26)	(2,528.27)	0.00	163,785.55
281	163,785.55	(887.17)	(1,641.10)	(2,528.27)	0.00	162,144.45
282	162,144.45	(878.28)	(1,649.99)	(2,528.27)	0.00	160,494.46
283	160,494.46	(869.34)	(1,658.93)	(2,528.27)	0.00	158,835.53
284	158,835.53	(860.36)	(1,667.91)	(2,528.27)	0.00	157,167.62
285	157,167.62	(851.32)	(1,676.95)	(2,528.27)	0.00	155,490.67
286	155,490.67	(842.24)	(1,686.03)	(2,528.27)	0.00	153,804.64
287	153,804.64	(833.11)	(1,695.16)	(2,528.27)	0.00	152,109.48
288	152,109.48	(823.93)	(1,704.34)	(2,528.27)	0.00	150,405.14	(19,856.87)	(10,482.37)
289	150,405.14	(814.69)	(1,713.58)	(2,528.27)	0.00	148,691.56
290	148,691.56	(805.41)	(1,722.86)	(2,528.27)	0.00	146,968.70
291	146,968.70	(796.08)	(1,732.19)	(2,528.27)	0.00	145,236.51
292	145,236.51	(786.70)	(1,741.57)	(2,528.27)	0.00	143,494.94
293	143,494.94	(777.26)	(1,751.01)	(2,528.27)	0.00	141,743.93
294	141,743.93	(767.78)	(1,760.49)	(2,528.27)	0.00	139,983.44
295	139,983.44	(758.24)	(1,770.03)	(2,528.27)	0.00	138,213.41
296	138,213.41	(748.66)	(1,779.61)	(2,528.27)	0.00	136,433.80
297	136,433.80	(739.02)	(1,789.25)	(2,528.27)	0.00	134,644.55
298	134,644.55	(729.32)	(1,798.95)	(2,528.27)	0.00	132,845.60
299	132,845.60	(719.58)	(1,808.69)	(2,528.27)	0.00	131,036.91
300	131,036.91	(709.78)	(1,818.49)	(2,528.27)	0.00	129,218.42	(21,186.72)	(9,152.52)
301	129,218.42	(699.93)	(1,828.34)	(2,528.27)	0.00	127,390.08
302	127,390.08	(690.03)	(1,838.24)	(2,528.27)	0.00	125,551.84
303	125,551.84	(680.07)	(1,848.20)	(2,528.27)	0.00	123,703.64
304	123,703.64	(670.06)	(1,858.21)	(2,528.27)	0.00	121,845.43
305	121,845.43	(660.00)	(1,868.27)	(2,528.27)	0.00	119,977.16
306	119,977.16	(649.88)	(1,878.39)	(2,528.27)	0.00	118,098.77
307	118,098.77	(639.70)	(1,888.57)	(2,528.27)	0.00	116,210.20
308	116,210.20	(629.47)	(1,898.80)	(2,528.27)	0.00	114,311.40
309	114,311.40	(619.19)	(1,909.08)	(2,528.27)	0.00	112,402.32
310	112,402.32	(608.85)	(1,919.42)	(2,528.27)	0.00	110,482.90
311	110,482.90	(598.45)	(1,929.82)	(2,528.27)	0.00	108,553.08
312	108,553.08	(588.00)	(1,940.27)	(2,528.27)	0.00	106,612.81	(22,605.61)	(7,733.63)
313	106,612.81	(577.49)	(1,950.78)	(2,528.27)	0.00	104,662.03
314	104,662.03	(566.92)	(1,961.35)	(2,528.27)	0.00	102,700.68
315	102,700.68	(556.30)	(1,971.97)	(2,528.27)	0.00	100,728.71
316	100,728.71	(545.61)	(1,982.66)	(2,528.27)	0.00	98,746.05
317	98,746.05	(534.87)	(1,993.40)	(2,528.27)	0.00	96,752.65
318	96,752.65	(524.08)	(2,004.19)	(2,528.27)	0.00	94,748.46
319	94,748.46	(513.22)	(2,015.05)	(2,528.27)	0.00	92,733.41
320	92,733.41	(502.31)	(2,025.96)	(2,528.27)	0.00	90,707.45
321	90,707.45	(491.33)	(2,036.94)	(2,528.27)	0.00	88,670.51
322	88,670.51	(480.30)	(2,047.97)	(2,528.27)	0.00	86,622.54
323	86,622.54	(469.21)	(2,059.06)	(2,528.27)	0.00	84,563.48
324	84,563.48	(458.05)	(2,070.22)	(2,528.27)	0.00	82,493.26	(24,119.55)	(6,219.69)
325	82,493.26	(446.84)	(2,081.43)	(2,528.27)	0.00	80,411.83
326	80,411.83	(435.56)	(2,092.71)	(2,528.27)	0.00	78,319.12
327	78,319.12	(424.23)	(2,104.04)	(2,528.27)	0.00	76,215.08
328	76,215.08	(412.83)	(2,115.44)	(2,528.27)	0.00	74,099.64
329	74,099.64	(401.37)	(2,126.90)	(2,528.27)	0.00	71,972.74
330	71,972.74	(389.85)	(2,138.42)	(2,528.27)	0.00	69,834.32
331	69,834.32	(378.27)	(2,150.00)	(2,528.27)	0.00	67,684.32
332	67,684.32	(366.62)	(2,161.65)	(2,528.27)	0.00	65,522.67
333	65,522.67	(354.91)	(2,173.36)	(2,528.27)	0.00	63,349.31
334	63,349.31	(343.14)	(2,185.13)	(2,528.27)	0.00	61,164.18
335	61,164.18	(331.31)	(2,196.96)	(2,528.27)	0.00	58,967.22
336	58,967.22	(319.41)	(2,208.86)	(2,528.27)	0.00	56,758.36	(25,734.90)	(4,604.34)
337	56,758.36	(307.44)	(2,220.83)	(2,528.27)	0.00	54,537.53
338	54,537.53	(295.41)	(2,232.86)	(2,528.27)	0.00	52,304.67
339	52,304.67	(283.32)	(2,244.95)	(2,528.27)	0.00	50,059.72
340	50,059.72	(271.16)	(2,257.11)	(2,528.27)	0.00	47,802.61
341	47,802.61	(258.93)	(2,269.34)	(2,528.27)	0.00	45,533.27
342	45,533.27	(246.64)	(2,281.63)	(2,528.27)	0.00	43,251.64
343	43,251.64	(234.28)	(2,293.99)	(2,528.27)	0.00	40,957.65
344	40,957.65	(221.85)	(2,306.42)	(2,528.27)	0.00	38,651.23
345	38,651.23	(209.36)	(2,318.91)	(2,528.27)	0.00	36,332.32
346	36,332.32	(196.80)	(2,331.47)	(2,528.27)	0.00	34,000.85
347	34,000.85	(184.17)	(2,344.10)	(2,528.27)	0.00	31,656.75
348	31,656.75	(171.47)	(2,356.80)	(2,528.27)	0.00	29,299.95	(27,458.41)	(2,880.83)
349	29,299.95	(158.71)	(2,369.56)	(2,528.27)	0.00	26,930.39
350	26,930.39	(145.87)	(2,382.40)	(2,528.27)	0.00	24,547.99
351	24,547.99	(132.97)	(2,395.30)	(2,528.27)	0.00	22,152.69
352	22,152.69	(119.99)	(2,408.28)	(2,528.27)	0.00	19,744.41
353	19,744.41	(106.95)	(2,421.32)	(2,528.27)	0.00	17,323.09
354	17,323.09	(93.83)	(2,434.44)	(2,528.27)	0.00	14,888.65
355	14,888.65	(80.65)	(2,447.62)	(2,528.27)	0.00	12,441.03
356	12,441.03	(67.39)	(2,460.88)	(2,528.27)	0.00	9,980.15
357	9,980.15	(54.06)	(2,474.21)	(2,528.27)	0.00	7,505.94
358	7,505.94	(40.66)	(2,487.61)	(2,528.27)	0.00	5,018.33
359	5,018.33	(27.18)	(2,501.09)	(2,528.27)	0.00	2,517.24
360	2,517.24	(13.64)	(2,517.24)	(2,528.27)	0.00	0.00	(29,299.95)	(1,041.90)
Totals		(510,179.81)	(400,000.00)	(910,177.20)	0.00		(400,000.00)	(510,179.81)

&C&14&USample Proforma Amortization Schedule

&LPage &P of &N&R&D

320 LP05 Assignment #1 Residence ProForma Example 6 Years.xls

Sample HomeBuy Property

Average Inland San Diego Home				ASSUMPTIONS: No CAPX (Capital Expenses) - As some analysis puts them above NOI, and others below NOI
Purchase Price		$ (500,000.00)
Building Value	68%	$ 340,000.00
Loan to Value		80%		Maximum for Investment Property: 70%
Loan Amount		$ 400,000.00
Down Payment		$ (100,000.00)
Loan Costs	2.0%	$ (8,000.00)
Interest Rate	Annual	6.500%
Loan Term	Months	360
Closing Costs	2.0%	$ (10,000.00)		See Estimated Settlement Statement for Detailed Breakdown
Total Costs at Acquisition		$ (118,000.00)
PROFORMA		Year 0	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6
Gross Rent	0%		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Vacancy	0.0%		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other Income	0%		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Effective Gross Income			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
OPERATING EXPENSES
Property Taxes 1.1%	2%		$ (5,500.00)	$ (5,610.00)	$ (5,722.20)	$ (5,836.64)	$ (5,953.37)	$ (6,072.44)
Insurance: Fire	3%		$ (1,000.00)	$ (1,030.00)	$ (1,060.90)	$ (1,092.73)	$ (1,125.51)	$ (1,159.28)
Insurance: EQ	3%		$ (650.00)	$ (669.50)	$ (689.59)	$ (710.28)	$ (731.59)	$ (753.54)
Insurance: Umbrella	3%		$ (250.00)	$ (257.50)	$ (265.23)	$ (273.19)	$ (281.39)	$ (289.83)
Homeowners Assoc	3%		$ (1,200.00)	$ (1,236.00)	$ (1,273.08)	$ (1,311.27)	$ (1,350.61)	$ (1,391.13)
Maintenance	3%		$ (3,000.00)	$ (3,090.00)	$ (3,182.70)	$ (3,278.18)	$ (3,376.53)	$ (3,477.83)
Landscape	0%		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Utilities	0%		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Management Fee 10%	4%		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Operating Expenses			$ (11,600.00)	$ (11,893.00)	$ (12,193.70)	$ (12,502.29)	$ (12,819.00)	$ (13,144.05)
NET OPERATING INCOME			$ (11,600.00)	$ (11,893.00)	$ (12,193.70)	$ (12,502.29)	$ (12,819.00)	$ (13,144.05)
Debt Service
Interest			$ (25,868.38)	$ (25,568.95)	$ (25,249.47)	$ (24,908.59)	$ (24,544.89)	$ (24,156.86)
Principal			$ (4,470.86)	$ (4,770.29)	$ (5,089.77)	$ (5,430.65)	$ (5,794.35)	$ (6,182.38)
Total Debt Service		$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)	$ (30,339.24)
BTCF (Before Tax Cash Flow)			$ (41,939.24)	$ (42,232.24)	$ (42,532.94)	$ (42,841.53)	$ (43,158.24)	$ (43,483.29)
BTCF (Before Tax Cash Flow)			$ (41,939.24)	$ (42,232.24)	$ (42,532.94)	$ (42,841.53)	$ (43,158.24)	$ (43,483.29)
Tax Calculation - 1040 Sched A
Property Taxes			$ (5,500.00)	$ (5,610.00)	$ (5,722.20)	$ (5,836.64)	$ (5,953.37)	$ (6,072.44)
Interest Deduction			$ (25,868.38)	$ (25,568.95)	$ (25,249.47)	$ (24,908.59)	$ (24,544.89)	$ (24,156.86)
* Ignores Standard Deduction Opportunity Cost *			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ 1.00
Total Deductions			$ (31,368.38)	$ (31,178.95)	$ (30,971.67)	$ (30,745.23)	$ (30,498.26)	$ (30,228.30)
Tax Paid (Tax Reduction)	35%	Tax Rate	$ (10,978.93)	$ (10,912.63)	$ (10,840.08)	$ (10,760.83)	$ (10,674.39)	$ (10,579.90)
AFTER TAX CASH FLOW			$ (30,960.31)	$ (31,319.61)	$ (31,692.86)	$ (32,080.70)	$ (32,483.85)	$ (32,903.39)
Property Value	10.0%	$ 500,000.00	$ 550,000.00	$ 605,000.00	$ 665,500.00	$ 732,050.00	$ 805,255.00	$ 885,780.50
Loan Payoff		Match with Amortization Schedule						$ (368,261.70)
Commissions	6.0%							$ (53,146.83)
Closing Costs	2.0%							$ (17,715.61)
Before Tax Sale Proceeds								$ 446,656.36
INCOME TAX CALULATION FOR CAPITAL APPRECIATION
Sale Price		$ 885,780.50
minus Purchase Price		$ (500,000.00)
minus Acquisition Costs		$ (10,000.00)
minus Commissions		$ (53,146.83)
minus Sales Costs		$ (17,715.61)
Total Capital Gain (Sale Price - Adj Basis)		$ 304,918.06
Exclusion for Sale of Home		$ (250,000.00)	1	Enter "1" for Single, "2" for Married, "0" if used in previous two years
Depreciation Recapture		NONE - No Depreciation for Residence						$ - 0
Income Tax: Cap Gain		$ 54,918.06	15%					$ (8,237.71)
Total Income Tax		$ 54,918.06						$ (8,237.71)
Net After Tax Sale Proceeds								$ 438,418.65
TOTAL CASH FLOW		$ (118,000.00)	$ (30,960.31)	$ (31,319.61)	$ (31,692.86)	$ (32,080.70)	$ (32,483.85)	$ 405,515.27
IRR								9.07%
Hurdle Rate		Alternative Investment OR "Risk Free" Interest Rate - Remember to adjust for value of housing services/opportunity cost						9.0%
IRR in excess of Hurdle Rate		FINAL DECISION: If positive, then invest						0.07%
NOTE: To Reduce Number of Years in ProForma, take the following steps: (Example reducing ProForma to 6 years)
1. Delete Columns for Year 6 through Year 30 (Column I through AG inclusive)
2. Copy Fill from H17-H59 inclusive to I17-I59 Inclusive to re-establish formulas from 2nd-to-last-year column
3. Fix Last Year Interest by adding 12 to the link from H39 into I39 (Cell I39 becomes [='Sample HomeBuy Amort Sch'!I86]
3. Fix Last Year Principal by adding 12 to the link from H40 into I40 (Cell I40 becomes [='Sample HomeBuy Amort Sch'!H86]

&C&14&USample Class Proforma&R&18Name: ________________________

&LPage &P of &N&R&D &T

Sample HomeBuy Amort Sch


	Assumptions in Proforma:	Stable compounding rate for income, expenses & prices
		Expenses are a function of rent price
		Acqusition on Jan 1 of Year
		Disposition on Dec 31 of Year
		Tax Reductions are fully offset by other income (otherwise lost)
		Straight Line Depreciation & Amortization
	Loan Amount	400,000.00
	Term	360	30
	Interest Rate	0.54%	6.50%
	Payment	(2,528.27)	(30,339.24)		Add as Negative Number
Period	Beginning Bal	Interest	Principal	Payment	Addt Pymt	End Bal	Annual Principal	Annual Interest
1	400,000.00	(2,166.67)	(361.60)	(2,528.27)	0.00	399,638.40
2	399,638.40	(2,164.71)	(363.56)	(2,528.27)	0.00	399,274.84
3	399,274.84	(2,162.74)	(365.53)	(2,528.27)	0.00	398,909.31
4	398,909.31	(2,160.76)	(367.51)	(2,528.27)	0.00	398,541.80
5	398,541.80	(2,158.77)	(369.50)	(2,528.27)	0.00	398,172.30
6	398,172.30	(2,156.77)	(371.50)	(2,528.27)	0.00	397,800.80
7	397,800.80	(2,154.75)	(373.52)	(2,528.27)	0.00	397,427.28
8	397,427.28	(2,152.73)	(375.54)	(2,528.27)	0.00	397,051.74
9	397,051.74	(2,150.70)	(377.57)	(2,528.27)	0.00	396,674.17
10	396,674.17	(2,148.65)	(379.62)	(2,528.27)	0.00	396,294.55
11	396,294.55	(2,146.60)	(381.67)	(2,528.27)	0.00	395,912.88
12	395,912.88	(2,144.53)	(383.74)	(2,528.27)	0.00	395,529.14	(4,470.86)	(25,868.38)
13	395,529.14	(2,142.45)	(385.82)	(2,528.27)	0.00	395,143.32
14	395,143.32	(2,140.36)	(387.91)	(2,528.27)	0.00	394,755.41
15	394,755.41	(2,138.26)	(390.01)	(2,528.27)	0.00	394,365.40
16	394,365.40	(2,136.15)	(392.12)	(2,528.27)	0.00	393,973.28
17	393,973.28	(2,134.02)	(394.25)	(2,528.27)	0.00	393,579.03
18	393,579.03	(2,131.89)	(396.38)	(2,528.27)	0.00	393,182.65
19	393,182.65	(2,129.74)	(398.53)	(2,528.27)	0.00	392,784.12
20	392,784.12	(2,127.58)	(400.69)	(2,528.27)	0.00	392,383.43
21	392,383.43	(2,125.41)	(402.86)	(2,528.27)	0.00	391,980.57
22	391,980.57	(2,123.23)	(405.04)	(2,528.27)	0.00	391,575.53
23	391,575.53	(2,121.03)	(407.24)	(2,528.27)	0.00	391,168.29
24	391,168.29	(2,118.83)	(409.44)	(2,528.27)	0.00	390,758.85	(4,770.29)	(25,568.95)
25	390,758.85	(2,116.61)	(411.66)	(2,528.27)	0.00	390,347.19
26	390,347.19	(2,114.38)	(413.89)	(2,528.27)	0.00	389,933.30
27	389,933.30	(2,112.14)	(416.13)	(2,528.27)	0.00	389,517.17
28	389,517.17	(2,109.88)	(418.39)	(2,528.27)	0.00	389,098.78
29	389,098.78	(2,107.62)	(420.65)	(2,528.27)	0.00	388,678.13
30	388,678.13	(2,105.34)	(422.93)	(2,528.27)	0.00	388,255.20
31	388,255.20	(2,103.05)	(425.22)	(2,528.27)	0.00	387,829.98
32	387,829.98	(2,100.75)	(427.52)	(2,528.27)	0.00	387,402.46
33	387,402.46	(2,098.43)	(429.84)	(2,528.27)	0.00	386,972.62
34	386,972.62	(2,096.10)	(432.17)	(2,528.27)	0.00	386,540.45
35	386,540.45	(2,093.76)	(434.51)	(2,528.27)	0.00	386,105.94
36	386,105.94	(2,091.41)	(436.86)	(2,528.27)	0.00	385,669.08	(5,089.77)	(25,249.47)
37	385,669.08	(2,089.04)	(439.23)	(2,528.27)	0.00	385,229.85
38	385,229.85	(2,086.66)	(441.61)	(2,528.27)	0.00	384,788.24
39	384,788.24	(2,084.27)	(444.00)	(2,528.27)	0.00	384,344.24
40	384,344.24	(2,081.86)	(446.41)	(2,528.27)	0.00	383,897.83
41	383,897.83	(2,079.45)	(448.82)	(2,528.27)	0.00	383,449.01
42	383,449.01	(2,077.02)	(451.25)	(2,528.27)	0.00	382,997.76
43	382,997.76	(2,074.57)	(453.70)	(2,528.27)	0.00	382,544.06
44	382,544.06	(2,072.11)	(456.16)	(2,528.27)	0.00	382,087.90
45	382,087.90	(2,069.64)	(458.63)	(2,528.27)	0.00	381,629.27
46	381,629.27	(2,067.16)	(461.11)	(2,528.27)	0.00	381,168.16
47	381,168.16	(2,064.66)	(463.61)	(2,528.27)	0.00	380,704.55
48	380,704.55	(2,062.15)	(466.12)	(2,528.27)	0.00	380,238.43	(5,430.65)	(24,908.59)
49	380,238.43	(2,059.62)	(468.65)	(2,528.27)	0.00	379,769.78
50	379,769.78	(2,057.09)	(471.18)	(2,528.27)	0.00	379,298.60
51	379,298.60	(2,054.53)	(473.74)	(2,528.27)	0.00	378,824.86
52	378,824.86	(2,051.97)	(476.30)	(2,528.27)	0.00	378,348.56
53	378,348.56	(2,049.39)	(478.88)	(2,528.27)	0.00	377,869.68
54	377,869.68	(2,046.79)	(481.48)	(2,528.27)	0.00	377,388.20
55	377,388.20	(2,044.19)	(484.08)	(2,528.27)	0.00	376,904.12
56	376,904.12	(2,041.56)	(486.71)	(2,528.27)	0.00	376,417.41
57	376,417.41	(2,038.93)	(489.34)	(2,528.27)	0.00	375,928.07
58	375,928.07	(2,036.28)	(491.99)	(2,528.27)	0.00	375,436.08
59	375,436.08	(2,033.61)	(494.66)	(2,528.27)	0.00	374,941.42
60	374,941.42	(2,030.93)	(497.34)	(2,528.27)	0.00	374,444.08	(5,794.35)	(24,544.89)
61	374,444.08	(2,028.24)	(500.03)	(2,528.27)	0.00	373,944.05
62	373,944.05	(2,025.53)	(502.74)	(2,528.27)	0.00	373,441.31
63	373,441.31	(2,022.81)	(505.46)	(2,528.27)	0.00	372,935.85
64	372,935.85	(2,020.07)	(508.20)	(2,528.27)	0.00	372,427.65
65	372,427.65	(2,017.32)	(510.95)	(2,528.27)	0.00	371,916.70
66	371,916.70	(2,014.55)	(513.72)	(2,528.27)	0.00	371,402.98
67	371,402.98	(2,011.77)	(516.50)	(2,528.27)	0.00	370,886.48
68	370,886.48	(2,008.97)	(519.30)	(2,528.27)	0.00	370,367.18
69	370,367.18	(2,006.16)	(522.11)	(2,528.27)	0.00	369,845.07
70	369,845.07	(2,003.33)	(524.94)	(2,528.27)	0.00	369,320.13
71	369,320.13	(2,000.48)	(527.79)	(2,528.27)	0.00	368,792.34
72	368,792.34	(1,997.63)	(530.64)	(2,528.27)	0.00	368,261.70	(6,182.38)	(24,156.86)
73	368,261.70	(1,994.75)	(533.52)	(2,528.27)	0.00	367,728.18
74	367,728.18	(1,991.86)	(536.41)	(2,528.27)	0.00	367,191.77
75	367,191.77	(1,988.96)	(539.31)	(2,528.27)	0.00	366,652.46
76	366,652.46	(1,986.03)	(542.24)	(2,528.27)	0.00	366,110.22
77	366,110.22	(1,983.10)	(545.17)	(2,528.27)	0.00	365,565.05
78	365,565.05	(1,980.14)	(548.13)	(2,528.27)	0.00	365,016.92
79	365,016.92	(1,977.17)	(551.10)	(2,528.27)	0.00	364,465.82
80	364,465.82	(1,974.19)	(554.08)	(2,528.27)	0.00	363,911.74
81	363,911.74	(1,971.19)	(557.08)	(2,528.27)	0.00	363,354.66
82	363,354.66	(1,968.17)	(560.10)	(2,528.27)	0.00	362,794.56
83	362,794.56	(1,965.14)	(563.13)	(2,528.27)	0.00	362,231.43
84	362,231.43	(1,962.09)	(566.18)	(2,528.27)	0.00	361,665.25	(6,596.45)	(23,742.79)
85	361,665.25	(1,959.02)	(569.25)	(2,528.27)	0.00	361,096.00
86	361,096.00	(1,955.94)	(572.33)	(2,528.27)	0.00	360,523.67
87	360,523.67	(1,952.84)	(575.43)	(2,528.27)	0.00	359,948.24
88	359,948.24	(1,949.72)	(578.55)	(2,528.27)	0.00	359,369.69
89	359,369.69	(1,946.59)	(581.68)	(2,528.27)	0.00	358,788.01
90	358,788.01	(1,943.44)	(584.83)	(2,528.27)	0.00	358,203.18
91	358,203.18	(1,940.27)	(588.00)	(2,528.27)	0.00	357,615.18
92	357,615.18	(1,937.08)	(591.19)	(2,528.27)	0.00	357,023.99
93	357,023.99	(1,933.88)	(594.39)	(2,528.27)	0.00	356,429.60
94	356,429.60	(1,930.66)	(597.61)	(2,528.27)	0.00	355,831.99
95	355,831.99	(1,927.42)	(600.85)	(2,528.27)	0.00	355,231.14
96	355,231.14	(1,924.17)	(604.10)	(2,528.27)	0.00	354,627.04	(7,038.21)	(23,301.03)
97	354,627.04	(1,920.90)	(607.37)	(2,528.27)	0.00	354,019.67
98	354,019.67	(1,917.61)	(610.66)	(2,528.27)	0.00	353,409.01
99	353,409.01	(1,914.30)	(613.97)	(2,528.27)	0.00	352,795.04
100	352,795.04	(1,910.97)	(617.30)	(2,528.27)	0.00	352,177.74
101	352,177.74	(1,907.63)	(620.64)	(2,528.27)	0.00	351,557.10
102	351,557.10	(1,904.27)	(624.00)	(2,528.27)	0.00	350,933.10
103	350,933.10	(1,900.89)	(627.38)	(2,528.27)	0.00	350,305.72
104	350,305.72	(1,897.49)	(630.78)	(2,528.27)	0.00	349,674.94
105	349,674.94	(1,894.07)	(634.20)	(2,528.27)	0.00	349,040.74
106	349,040.74	(1,890.64)	(637.63)	(2,528.27)	0.00	348,403.11
107	348,403.11	(1,887.18)	(641.09)	(2,528.27)	0.00	347,762.02
108	347,762.02	(1,883.71)	(644.56)	(2,528.27)	0.00	347,117.46	(7,509.58)	(22,829.66)
109	347,117.46	(1,880.22)	(648.05)	(2,528.27)	0.00	346,469.41
110	346,469.41	(1,876.71)	(651.56)	(2,528.27)	0.00	345,817.85
111	345,817.85	(1,873.18)	(655.09)	(2,528.27)	0.00	345,162.76
112	345,162.76	(1,869.63)	(658.64)	(2,528.27)	0.00	344,504.12
113	344,504.12	(1,866.06)	(662.21)	(2,528.27)	0.00	343,841.91
114	343,841.91	(1,862.48)	(665.79)	(2,528.27)	0.00	343,176.12
115	343,176.12	(1,858.87)	(669.40)	(2,528.27)	0.00	342,506.72
116	342,506.72	(1,855.24)	(673.03)	(2,528.27)	0.00	341,833.69
117	341,833.69	(1,851.60)	(676.67)	(2,528.27)	0.00	341,157.02
118	341,157.02	(1,847.93)	(680.34)	(2,528.27)	0.00	340,476.68
119	340,476.68	(1,844.25)	(684.02)	(2,528.27)	0.00	339,792.66
120	339,792.66	(1,840.54)	(687.73)	(2,528.27)	0.00	339,104.93	(8,012.53)	(22,326.71)
121	339,104.93	(1,836.82)	(691.45)	(2,528.27)	0.00	338,413.48
122	338,413.48	(1,833.07)	(695.20)	(2,528.27)	0.00	337,718.28
123	337,718.28	(1,829.31)	(698.96)	(2,528.27)	0.00	337,019.32
124	337,019.32	(1,825.52)	(702.75)	(2,528.27)	0.00	336,316.57
125	336,316.57	(1,821.71)	(706.56)	(2,528.27)	0.00	335,610.01
126	335,610.01	(1,817.89)	(710.38)	(2,528.27)	0.00	334,899.63
127	334,899.63	(1,814.04)	(714.23)	(2,528.27)	0.00	334,185.40
128	334,185.40	(1,810.17)	(718.10)	(2,528.27)	0.00	333,467.30
129	333,467.30	(1,806.28)	(721.99)	(2,528.27)	0.00	332,745.31
130	332,745.31	(1,802.37)	(725.90)	(2,528.27)	0.00	332,019.41
131	332,019.41	(1,798.44)	(729.83)	(2,528.27)	0.00	331,289.58
132	331,289.58	(1,794.49)	(733.78)	(2,528.27)	0.00	330,555.80	(8,549.13)	(21,790.11)
133	330,555.80	(1,790.51)	(737.76)	(2,528.27)	0.00	329,818.04
134	329,818.04	(1,786.51)	(741.76)	(2,528.27)	0.00	329,076.28
135	329,076.28	(1,782.50)	(745.77)	(2,528.27)	0.00	328,330.51
136	328,330.51	(1,778.46)	(749.81)	(2,528.27)	0.00	327,580.70
137	327,580.70	(1,774.40)	(753.87)	(2,528.27)	0.00	326,826.83
138	326,826.83	(1,770.31)	(757.96)	(2,528.27)	0.00	326,068.87
139	326,068.87	(1,766.21)	(762.06)	(2,528.27)	0.00	325,306.81
140	325,306.81	(1,762.08)	(766.19)	(2,528.27)	0.00	324,540.62
141	324,540.62	(1,757.93)	(770.34)	(2,528.27)	0.00	323,770.28
142	323,770.28	(1,753.76)	(774.51)	(2,528.27)	0.00	322,995.77
143	322,995.77	(1,749.56)	(778.71)	(2,528.27)	0.00	322,217.06
144	322,217.06	(1,745.34)	(782.93)	(2,528.27)	0.00	321,434.13	(9,121.67)	(21,217.57)
145	321,434.13	(1,741.10)	(787.17)	(2,528.27)	0.00	320,646.96
146	320,646.96	(1,736.84)	(791.43)	(2,528.27)	0.00	319,855.53
147	319,855.53	(1,732.55)	(795.72)	(2,528.27)	0.00	319,059.81
148	319,059.81	(1,728.24)	(800.03)	(2,528.27)	0.00	318,259.78
149	318,259.78	(1,723.91)	(804.36)	(2,528.27)	0.00	317,455.42
150	317,455.42	(1,719.55)	(808.72)	(2,528.27)	0.00	316,646.70
151	316,646.70	(1,715.17)	(813.10)	(2,528.27)	0.00	315,833.60
152	315,833.60	(1,710.77)	(817.50)	(2,528.27)	0.00	315,016.10
153	315,016.10	(1,706.34)	(821.93)	(2,528.27)	0.00	314,194.17
154	314,194.17	(1,701.89)	(826.38)	(2,528.27)	0.00	313,367.79
155	313,367.79	(1,697.41)	(830.86)	(2,528.27)	0.00	312,536.93
156	312,536.93	(1,692.91)	(835.36)	(2,528.27)	0.00	311,701.57	(9,732.56)	(20,606.68)
157	311,701.57	(1,688.38)	(839.89)	(2,528.27)	0.00	310,861.68
158	310,861.68	(1,683.83)	(844.44)	(2,528.27)	0.00	310,017.24
159	310,017.24	(1,679.26)	(849.01)	(2,528.27)	0.00	309,168.23
160	309,168.23	(1,674.66)	(853.61)	(2,528.27)	0.00	308,314.62
161	308,314.62	(1,670.04)	(858.23)	(2,528.27)	0.00	307,456.39
162	307,456.39	(1,665.39)	(862.88)	(2,528.27)	0.00	306,593.51
163	306,593.51	(1,660.71)	(867.56)	(2,528.27)	0.00	305,725.95
164	305,725.95	(1,656.02)	(872.25)	(2,528.27)	0.00	304,853.70
165	304,853.70	(1,651.29)	(876.98)	(2,528.27)	0.00	303,976.72
166	303,976.72	(1,646.54)	(881.73)	(2,528.27)	0.00	303,094.99
167	303,094.99	(1,641.76)	(886.51)	(2,528.27)	0.00	302,208.48
168	302,208.48	(1,636.96)	(891.31)	(2,528.27)	0.00	301,317.17	(10,384.40)	(19,954.84)
169	301,317.17	(1,632.13)	(896.14)	(2,528.27)	0.00	300,421.03
170	300,421.03	(1,627.28)	(900.99)	(2,528.27)	0.00	299,520.04
171	299,520.04	(1,622.40)	(905.87)	(2,528.27)	0.00	298,614.17
172	298,614.17	(1,617.49)	(910.78)	(2,528.27)	0.00	297,703.39
173	297,703.39	(1,612.56)	(915.71)	(2,528.27)	0.00	296,787.68
174	296,787.68	(1,607.60)	(920.67)	(2,528.27)	0.00	295,867.01
175	295,867.01	(1,602.61)	(925.66)	(2,528.27)	0.00	294,941.35
176	294,941.35	(1,597.60)	(930.67)	(2,528.27)	0.00	294,010.68
177	294,010.68	(1,592.56)	(935.71)	(2,528.27)	0.00	293,074.97
178	293,074.97	(1,587.49)	(940.78)	(2,528.27)	0.00	292,134.19
179	292,134.19	(1,582.39)	(945.88)	(2,528.27)	0.00	291,188.31
180	291,188.31	(1,577.27)	(951.00)	(2,528.27)	0.00	290,237.31	(11,079.86)	(19,259.38)
181	290,237.31	(1,572.12)	(956.15)	(2,528.27)	0.00	289,281.16
182	289,281.16	(1,566.94)	(961.33)	(2,528.27)	0.00	288,319.83
183	288,319.83	(1,561.73)	(966.54)	(2,528.27)	0.00	287,353.29
184	287,353.29	(1,556.50)	(971.77)	(2,528.27)	0.00	286,381.52
185	286,381.52	(1,551.23)	(977.04)	(2,528.27)	0.00	285,404.48
186	285,404.48	(1,545.94)	(982.33)	(2,528.27)	0.00	284,422.15
187	284,422.15	(1,540.62)	(987.65)	(2,528.27)	0.00	283,434.50
188	283,434.50	(1,535.27)	(993.00)	(2,528.27)	0.00	282,441.50
189	282,441.50	(1,529.89)	(998.38)	(2,528.27)	0.00	281,443.12
190	281,443.12	(1,524.48)	(1,003.79)	(2,528.27)	0.00	280,439.33
191	280,439.33	(1,519.05)	(1,009.22)	(2,528.27)	0.00	279,430.11
192	279,430.11	(1,513.58)	(1,014.69)	(2,528.27)	0.00	278,415.42	(11,821.89)	(18,517.35)
193	278,415.42	(1,508.08)	(1,020.19)	(2,528.27)	0.00	277,395.23
194	277,395.23	(1,502.56)	(1,025.71)	(2,528.27)	0.00	276,369.52
195	276,369.52	(1,497.00)	(1,031.27)	(2,528.27)	0.00	275,338.25
196	275,338.25	(1,491.42)	(1,036.85)	(2,528.27)	0.00	274,301.40
197	274,301.40	(1,485.80)	(1,042.47)	(2,528.27)	0.00	273,258.93
198	273,258.93	(1,480.15)	(1,048.12)	(2,528.27)	0.00	272,210.81
199	272,210.81	(1,474.48)	(1,053.79)	(2,528.27)	0.00	271,157.02
200	271,157.02	(1,468.77)	(1,059.50)	(2,528.27)	0.00	270,097.52
201	270,097.52	(1,463.03)	(1,065.24)	(2,528.27)	0.00	269,032.28
202	269,032.28	(1,457.26)	(1,071.01)	(2,528.27)	0.00	267,961.27
203	267,961.27	(1,451.46)	(1,076.81)	(2,528.27)	0.00	266,884.46
204	266,884.46	(1,445.62)	(1,082.65)	(2,528.27)	0.00	265,801.81	(12,613.61)	(17,725.63)
205	265,801.81	(1,439.76)	(1,088.51)	(2,528.27)	0.00	264,713.30
206	264,713.30	(1,433.86)	(1,094.41)	(2,528.27)	0.00	263,618.89
207	263,618.89	(1,427.94)	(1,100.33)	(2,528.27)	0.00	262,518.56
208	262,518.56	(1,421.98)	(1,106.29)	(2,528.27)	0.00	261,412.27
209	261,412.27	(1,415.98)	(1,112.29)	(2,528.27)	0.00	260,299.98
210	260,299.98	(1,409.96)	(1,118.31)	(2,528.27)	0.00	259,181.67
211	259,181.67	(1,403.90)	(1,124.37)	(2,528.27)	0.00	258,057.30
212	258,057.30	(1,397.81)	(1,130.46)	(2,528.27)	0.00	256,926.84
213	256,926.84	(1,391.69)	(1,136.58)	(2,528.27)	0.00	255,790.26
214	255,790.26	(1,385.53)	(1,142.74)	(2,528.27)	0.00	254,647.52
215	254,647.52	(1,379.34)	(1,148.93)	(2,528.27)	0.00	253,498.59
216	253,498.59	(1,373.12)	(1,155.15)	(2,528.27)	0.00	252,343.44	(13,458.37)	(16,880.87)
217	252,343.44	(1,366.86)	(1,161.41)	(2,528.27)	0.00	251,182.03
218	251,182.03	(1,360.57)	(1,167.70)	(2,528.27)	0.00	250,014.33
219	250,014.33	(1,354.24)	(1,174.03)	(2,528.27)	0.00	248,840.30
220	248,840.30	(1,347.88)	(1,180.39)	(2,528.27)	0.00	247,659.91
221	247,659.91	(1,341.49)	(1,186.78)	(2,528.27)	0.00	246,473.13
222	246,473.13	(1,335.06)	(1,193.21)	(2,528.27)	0.00	245,279.92
223	245,279.92	(1,328.60)	(1,199.67)	(2,528.27)	0.00	244,080.25
224	244,080.25	(1,322.10)	(1,206.17)	(2,528.27)	0.00	242,874.08
225	242,874.08	(1,315.57)	(1,212.70)	(2,528.27)	0.00	241,661.38
226	241,661.38	(1,309.00)	(1,219.27)	(2,528.27)	0.00	240,442.11
227	240,442.11	(1,302.39)	(1,225.88)	(2,528.27)	0.00	239,216.23
228	239,216.23	(1,295.75)	(1,232.52)	(2,528.27)	0.00	237,983.71	(14,359.73)	(15,979.51)
229	237,983.71	(1,289.08)	(1,239.19)	(2,528.27)	0.00	236,744.52
230	236,744.52	(1,282.37)	(1,245.90)	(2,528.27)	0.00	235,498.62
231	235,498.62	(1,275.62)	(1,252.65)	(2,528.27)	0.00	234,245.97
232	234,245.97	(1,268.83)	(1,259.44)	(2,528.27)	0.00	232,986.53
233	232,986.53	(1,262.01)	(1,266.26)	(2,528.27)	0.00	231,720.27
234	231,720.27	(1,255.15)	(1,273.12)	(2,528.27)	0.00	230,447.15
235	230,447.15	(1,248.26)	(1,280.01)	(2,528.27)	0.00	229,167.14
236	229,167.14	(1,241.32)	(1,286.95)	(2,528.27)	0.00	227,880.19
237	227,880.19	(1,234.35)	(1,293.92)	(2,528.27)	0.00	226,586.27
238	226,586.27	(1,227.34)	(1,300.93)	(2,528.27)	0.00	225,285.34
239	225,285.34	(1,220.30)	(1,307.97)	(2,528.27)	0.00	223,977.37
240	223,977.37	(1,213.21)	(1,315.06)	(2,528.27)	0.00	222,662.31	(15,321.40)	(15,017.84)
241	222,662.31	(1,206.09)	(1,322.18)	(2,528.27)	0.00	221,340.13
242	221,340.13	(1,198.93)	(1,329.34)	(2,528.27)	0.00	220,010.79
243	220,010.79	(1,191.73)	(1,336.54)	(2,528.27)	0.00	218,674.25
244	218,674.25	(1,184.49)	(1,343.78)	(2,528.27)	0.00	217,330.47
245	217,330.47	(1,177.21)	(1,351.06)	(2,528.27)	0.00	215,979.41
246	215,979.41	(1,169.89)	(1,358.38)	(2,528.27)	0.00	214,621.03
247	214,621.03	(1,162.53)	(1,365.74)	(2,528.27)	0.00	213,255.29
248	213,255.29	(1,155.13)	(1,373.14)	(2,528.27)	0.00	211,882.15
249	211,882.15	(1,147.69)	(1,380.58)	(2,528.27)	0.00	210,501.57
250	210,501.57	(1,140.22)	(1,388.05)	(2,528.27)	0.00	209,113.52
251	209,113.52	(1,132.70)	(1,395.57)	(2,528.27)	0.00	207,717.95
252	207,717.95	(1,125.14)	(1,403.13)	(2,528.27)	0.00	206,314.82	(16,347.49)	(13,991.75)
253	206,314.82	(1,117.54)	(1,410.73)	(2,528.27)	0.00	204,904.09
254	204,904.09	(1,109.90)	(1,418.37)	(2,528.27)	0.00	203,485.72
255	203,485.72	(1,102.21)	(1,426.06)	(2,528.27)	0.00	202,059.66
256	202,059.66	(1,094.49)	(1,433.78)	(2,528.27)	0.00	200,625.88
257	200,625.88	(1,086.72)	(1,441.55)	(2,528.27)	0.00	199,184.33
258	199,184.33	(1,078.92)	(1,449.35)	(2,528.27)	0.00	197,734.98
259	197,734.98	(1,071.06)	(1,457.21)	(2,528.27)	0.00	196,277.77
260	196,277.77	(1,063.17)	(1,465.10)	(2,528.27)	0.00	194,812.67
261	194,812.67	(1,055.24)	(1,473.03)	(2,528.27)	0.00	193,339.64
262	193,339.64	(1,047.26)	(1,481.01)	(2,528.27)	0.00	191,858.63
263	191,858.63	(1,039.23)	(1,489.04)	(2,528.27)	0.00	190,369.59
264	190,369.59	(1,031.17)	(1,497.10)	(2,528.27)	0.00	188,872.49	(17,442.33)	(12,896.91)
265	188,872.49	(1,023.06)	(1,505.21)	(2,528.27)	0.00	187,367.28
266	187,367.28	(1,014.91)	(1,513.36)	(2,528.27)	0.00	185,853.92
267	185,853.92	(1,006.71)	(1,521.56)	(2,528.27)	0.00	184,332.36
268	184,332.36	(998.47)	(1,529.80)	(2,528.27)	0.00	182,802.56
269	182,802.56	(990.18)	(1,538.09)	(2,528.27)	0.00	181,264.47
270	181,264.47	(981.85)	(1,546.42)	(2,528.27)	0.00	179,718.05
271	179,718.05	(973.47)	(1,554.80)	(2,528.27)	0.00	178,163.25
272	178,163.25	(965.05)	(1,563.22)	(2,528.27)	0.00	176,600.03
273	176,600.03	(956.58)	(1,571.69)	(2,528.27)	0.00	175,028.34
274	175,028.34	(948.07)	(1,580.20)	(2,528.27)	0.00	173,448.14
275	173,448.14	(939.51)	(1,588.76)	(2,528.27)	0.00	171,859.38
276	171,859.38	(930.90)	(1,597.37)	(2,528.27)	0.00	170,262.01	(18,610.48)	(11,728.76)
277	170,262.01	(922.25)	(1,606.02)	(2,528.27)	0.00	168,655.99
278	168,655.99	(913.55)	(1,614.72)	(2,528.27)	0.00	167,041.27
279	167,041.27	(904.81)	(1,623.46)	(2,528.27)	0.00	165,417.81
280	165,417.81	(896.01)	(1,632.26)	(2,528.27)	0.00	163,785.55
281	163,785.55	(887.17)	(1,641.10)	(2,528.27)	0.00	162,144.45
282	162,144.45	(878.28)	(1,649.99)	(2,528.27)	0.00	160,494.46
283	160,494.46	(869.34)	(1,658.93)	(2,528.27)	0.00	158,835.53
284	158,835.53	(860.36)	(1,667.91)	(2,528.27)	0.00	157,167.62
285	157,167.62	(851.32)	(1,676.95)	(2,528.27)	0.00	155,490.67
286	155,490.67	(842.24)	(1,686.03)	(2,528.27)	0.00	153,804.64
287	153,804.64	(833.11)	(1,695.16)	(2,528.27)	0.00	152,109.48
288	152,109.48	(823.93)	(1,704.34)	(2,528.27)	0.00	150,405.14	(19,856.87)	(10,482.37)
289	150,405.14	(814.69)	(1,713.58)	(2,528.27)	0.00	148,691.56
290	148,691.56	(805.41)	(1,722.86)	(2,528.27)	0.00	146,968.70
291	146,968.70	(796.08)	(1,732.19)	(2,528.27)	0.00	145,236.51
292	145,236.51	(786.70)	(1,741.57)	(2,528.27)	0.00	143,494.94
293	143,494.94	(777.26)	(1,751.01)	(2,528.27)	0.00	141,743.93
294	141,743.93	(767.78)	(1,760.49)	(2,528.27)	0.00	139,983.44
295	139,983.44	(758.24)	(1,770.03)	(2,528.27)	0.00	138,213.41
296	138,213.41	(748.66)	(1,779.61)	(2,528.27)	0.00	136,433.80
297	136,433.80	(739.02)	(1,789.25)	(2,528.27)	0.00	134,644.55
298	134,644.55	(729.32)	(1,798.95)	(2,528.27)	0.00	132,845.60
299	132,845.60	(719.58)	(1,808.69)	(2,528.27)	0.00	131,036.91
300	131,036.91	(709.78)	(1,818.49)	(2,528.27)	0.00	129,218.42	(21,186.72)	(9,152.52)
301	129,218.42	(699.93)	(1,828.34)	(2,528.27)	0.00	127,390.08
302	127,390.08	(690.03)	(1,838.24)	(2,528.27)	0.00	125,551.84
303	125,551.84	(680.07)	(1,848.20)	(2,528.27)	0.00	123,703.64
304	123,703.64	(670.06)	(1,858.21)	(2,528.27)	0.00	121,845.43
305	121,845.43	(660.00)	(1,868.27)	(2,528.27)	0.00	119,977.16
306	119,977.16	(649.88)	(1,878.39)	(2,528.27)	0.00	118,098.77
307	118,098.77	(639.70)	(1,888.57)	(2,528.27)	0.00	116,210.20
308	116,210.20	(629.47)	(1,898.80)	(2,528.27)	0.00	114,311.40
309	114,311.40	(619.19)	(1,909.08)	(2,528.27)	0.00	112,402.32
310	112,402.32	(608.85)	(1,919.42)	(2,528.27)	0.00	110,482.90
311	110,482.90	(598.45)	(1,929.82)	(2,528.27)	0.00	108,553.08
312	108,553.08	(588.00)	(1,940.27)	(2,528.27)	0.00	106,612.81	(22,605.61)	(7,733.63)
313	106,612.81	(577.49)	(1,950.78)	(2,528.27)	0.00	104,662.03
314	104,662.03	(566.92)	(1,961.35)	(2,528.27)	0.00	102,700.68
315	102,700.68	(556.30)	(1,971.97)	(2,528.27)	0.00	100,728.71
316	100,728.71	(545.61)	(1,982.66)	(2,528.27)	0.00	98,746.05
317	98,746.05	(534.87)	(1,993.40)	(2,528.27)	0.00	96,752.65
318	96,752.65	(524.08)	(2,004.19)	(2,528.27)	0.00	94,748.46
319	94,748.46	(513.22)	(2,015.05)	(2,528.27)	0.00	92,733.41
320	92,733.41	(502.31)	(2,025.96)	(2,528.27)	0.00	90,707.45
321	90,707.45	(491.33)	(2,036.94)	(2,528.27)	0.00	88,670.51
322	88,670.51	(480.30)	(2,047.97)	(2,528.27)	0.00	86,622.54
323	86,622.54	(469.21)	(2,059.06)	(2,528.27)	0.00	84,563.48
324	84,563.48	(458.05)	(2,070.22)	(2,528.27)	0.00	82,493.26	(24,119.55)	(6,219.69)
325	82,493.26	(446.84)	(2,081.43)	(2,528.27)	0.00	80,411.83
326	80,411.83	(435.56)	(2,092.71)	(2,528.27)	0.00	78,319.12
327	78,319.12	(424.23)	(2,104.04)	(2,528.27)	0.00	76,215.08
328	76,215.08	(412.83)	(2,115.44)	(2,528.27)	0.00	74,099.64
329	74,099.64	(401.37)	(2,126.90)	(2,528.27)	0.00	71,972.74
330	71,972.74	(389.85)	(2,138.42)	(2,528.27)	0.00	69,834.32
331	69,834.32	(378.27)	(2,150.00)	(2,528.27)	0.00	67,684.32
332	67,684.32	(366.62)	(2,161.65)	(2,528.27)	0.00	65,522.67
333	65,522.67	(354.91)	(2,173.36)	(2,528.27)	0.00	63,349.31
334	63,349.31	(343.14)	(2,185.13)	(2,528.27)	0.00	61,164.18
335	61,164.18	(331.31)	(2,196.96)	(2,528.27)	0.00	58,967.22
336	58,967.22	(319.41)	(2,208.86)	(2,528.27)	0.00	56,758.36	(25,734.90)	(4,604.34)
337	56,758.36	(307.44)	(2,220.83)	(2,528.27)	0.00	54,537.53
338	54,537.53	(295.41)	(2,232.86)	(2,528.27)	0.00	52,304.67
339	52,304.67	(283.32)	(2,244.95)	(2,528.27)	0.00	50,059.72
340	50,059.72	(271.16)	(2,257.11)	(2,528.27)	0.00	47,802.61
341	47,802.61	(258.93)	(2,269.34)	(2,528.27)	0.00	45,533.27
342	45,533.27	(246.64)	(2,281.63)	(2,528.27)	0.00	43,251.64
343	43,251.64	(234.28)	(2,293.99)	(2,528.27)	0.00	40,957.65
344	40,957.65	(221.85)	(2,306.42)	(2,528.27)	0.00	38,651.23
345	38,651.23	(209.36)	(2,318.91)	(2,528.27)	0.00	36,332.32
346	36,332.32	(196.80)	(2,331.47)	(2,528.27)	0.00	34,000.85
347	34,000.85	(184.17)	(2,344.10)	(2,528.27)	0.00	31,656.75
348	31,656.75	(171.47)	(2,356.80)	(2,528.27)	0.00	29,299.95	(27,458.41)	(2,880.83)
349	29,299.95	(158.71)	(2,369.56)	(2,528.27)	0.00	26,930.39
350	26,930.39	(145.87)	(2,382.40)	(2,528.27)	0.00	24,547.99
351	24,547.99	(132.97)	(2,395.30)	(2,528.27)	0.00	22,152.69
352	22,152.69	(119.99)	(2,408.28)	(2,528.27)	0.00	19,744.41
353	19,744.41	(106.95)	(2,421.32)	(2,528.27)	0.00	17,323.09
354	17,323.09	(93.83)	(2,434.44)	(2,528.27)	0.00	14,888.65
355	14,888.65	(80.65)	(2,447.62)	(2,528.27)	0.00	12,441.03
356	12,441.03	(67.39)	(2,460.88)	(2,528.27)	0.00	9,980.15
357	9,980.15	(54.06)	(2,474.21)	(2,528.27)	0.00	7,505.94
358	7,505.94	(40.66)	(2,487.61)	(2,528.27)	0.00	5,018.33
359	5,018.33	(27.18)	(2,501.09)	(2,528.27)	0.00	2,517.24
360	2,517.24	(13.64)	(2,517.24)	(2,528.27)	0.00	0.00	(29,299.95)	(1,041.90)
Totals		(510,179.81)	(400,000.00)	(910,177.20)	0.00		(400,000.00)	(510,179.81)

&C&14&USample Proforma Amortization Schedule

&LPage &P of &N&R&D