Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Show the steps in an excel file The model should include an inputs box to allow the user to change the parameters of the loan.

  1. Show the steps in an excel file
    1. The model should include an inputs box to allow the user to change the parameters of the loan. The inputs are:
      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.

image text in transcribed

  1. Payments per year: assume 12 monthly payments
  2. Extra monthly payment (expressed in dollars): assume $0 but it has to work for any amount I choose when I grade your model
  3. Loan origination fee (expressed in percent): assume 0.07184% of loan amount
  4. Processing fee (expressed in percent): assume 0.19971% of loan amount
  5. Underwriting fee (expressed in percent): assume 0.25718% of loan amount
  6. Title service fee (expressed in percent): assume 1% of loan amount
  7. Survey fee (expressed in dollars): assume $350
  8. Appraisal fee (expressed in dollars): assume $200
  9. Government recordation fee and transfer taxes (expressed in dollars): assume $50
  10. Property insurance (expressed in dollars): Assume $50 per month for every $100,000 of home value.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Finance questions