Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Property value (expressed in dollars): assume $250,000 Down payment (expressed in percent): assume 20% and include spin button to change the percentage in increments of
- Property value (expressed in dollars): assume $250,000
- Down payment (expressed in percent): assume 20% and include spin button to change the percentage in increments of 5 percentage points
- APR (expressed in percent): assume 6.8% and include spin button to change APR in increments of .1 percentage points.
- Number of years: Assume 30 years and include option button to accommodate for a 15 year, 20 year, and 30 years.
- Payments per year: assume 12 monthly payments
- Extra monthly payment (expressed in dollars): assume $0 but it has to work for any amount I choose when I grade your model
- Loan origination fee (expressed in percent): assume 0.07184% of loan amount
- Processing fee (expressed in percent): assume 0.19971% of loan amount
- Underwriting fee (expressed in percent): assume 0.25718% of loan amount
- Title service fee (expressed in percent): assume 1% of loan amount
- Survey fee (expressed in dollars): assume $350
- Appraisal fee (expressed in dollars): assume $200
- Government recordation fee and transfer taxes (expressed in dollars): assume $50
- Property insurance (expressed in dollars): Assume $50 per month for every $100,000 of home value.
- 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.
- Home owners association (HMO) (expressed in dollars): assume $600 per year
- 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 |
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started