Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 principal

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Dynamics Of International Finance

Authors: Ruchi Mehrotra Joshi

1st Edition

1685078389, 978-1685078386

More Books

Students also viewed these Finance questions