Answered step by step
Verified Expert Solution
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.
- 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. The inputs are:
- 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.
- The model should include an inputs box to allow the user to change the parameters of the loan. The inputs are:
- 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.
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