Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you do this in a box in excel v. Payments per year: assume 12 monthly payments vi. Extra monthly payment (expressed in dollars): assume
Can you do this in a box in excel
v. Payments per year: assume 12 monthly payments vi. Extra monthly payment (expressed in dollars): assume $0 but it has to work for any amount I choose when I grade your model vil. Loan origination fee (expressed in percent): assume 0.07184% of loan amount vill. Processing fee (expressed in percent): assume 0.19971% of loan amount ix. Underwriting fee (expressed in percent): assume 0.25718% of loan amount X Title service fee (expressed in percent): assume 1% of loan amount xl Survey fee (expressed in dollars): assume $350 xii. Appraisal fee (expressed in dollars): assume $200 xiii. Government recordation fee and transfer taxes (expressed in dollars): assume $50 xiv. Property insurance (expressed in dollars): Assume $50 per month for every $100,000 of home value. xv. 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 v. Payments per year: assume 12 monthly payments vi. Extra monthly payment (expressed in dollars): assume $0 but it has to work for any amount I choose when I grade your model vil. Loan origination fee (expressed in percent): assume 0.07184% of loan amount vill. Processing fee (expressed in percent): assume 0.19971% of loan amount ix. Underwriting fee (expressed in percent): assume 0.25718% of loan amount X Title service fee (expressed in percent): assume 1% of loan amount xl Survey fee (expressed in dollars): assume $350 xii. Appraisal fee (expressed in dollars): assume $200 xiii. Government recordation fee and transfer taxes (expressed in dollars): assume $50 xiv. Property insurance (expressed in dollars): Assume $50 per month for every $100,000 of home value. xv. 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 principalStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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