1. Property value (expressed in dollars): assume $250,000
2. Down payment (expressed in percent): assume 20% and include spin button to change the percentage in increments of 5 percentage points
3. APR (expressed in percent): assume 6.8% and include spin button to change APR in increments of .1 percentage points.
4. Number of years: Assume 30 years and include option button to accommodate for a 15 year, 20 year, and 30 years.

5. Payments per year: assume 12 monthly payments
6. Extra monthly payment (expressed in dollars): assume $0 but it has to work for any amount I choose when I grade your model
7. Loan origination fee (expressed in percent): assume 0.07184% of loan amount
8. Processing fee (expressed in percent): assume 0.19971% of loan amount
9. Underwriting fee (expressed in percent): assume 0.25718% of loan amount
10. Title service fee (expressed in percent): assume 1% of loan amount
11. Survey fee (expressed in dollars): assume $350
12. Appraisal fee (expressed in dollars): assume $200
13. Government recordation fee and transfer taxes (expressed in dollars): assume $50
14. Property insurance (expressed in dollars): Assume $50 per month for every $100,000 of home value.
15. Private mortgage insurance (PMI) (expressed in percent): assume 0.625% per year. The PMI is paid when the down payment is less than 20% or when the principal payment reaches 20% of the value of the loan. Assume the PMI is charged regardless of the down payment or repayment of principal.
16. Home owners association (HMO) (expressed in dollars): assume $600 per year
17. Property taxes (expressed in dollars per $100 value): The property can be located in the City of McAllen, City of Edinburg, or City of Brownsville. For example, for the City of McAllen and Brownsville you need to include the following property taxes:

Description	Tax rate
Hidalgo County
McAllen ISD
South Texas School
South Texas College
Drainage District #1
City of McAllen
Total

Description	Tax rate
Cameron County
Brownsville ISD
Brownsville Navigation District
South Texas ISD
Texas Southmost College District
City of Brownsville
Total