Question
Build a short-term loan model, allowing terms out to 5 years. Take the term, annual interest rate, and principal balance as inputs. Either calculate the
Build a short-term loan model, allowing terms out to 5 years. Take the term, annual interest rate, and principal balance as inputs. Either calculate the required payment or use a payment input cell. Use your model to answer the following questions:
- with a term of 5 years and a rate of 5%, what should payments be for a $10,000 loan
- how many months will it take to pay off the loan if payments are $1,000
- if all payments but the last payment are $1,000, how much should be paid off in the last month to leave $0 due?
Add a discount factor to your model. Use another input for the appropriate opportunity cost of capital.
- what is the PV of the payments if the discount rate is 5%
- what is the loan's NPV to the customer if the discount rate is 4%? 6%?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Answer i Loan amount 10000 Interest rate 5 Number of years 5 Equal monthly installament EMI EMI P X ...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 StartedRecommended Textbook for
Entrepreneurship & Small Business Management
Authors: Steve Mariotti, Caroline Glackin
2nd edition
133801160, 133767183, 9780133801163, 978-0133767186
Students also viewed these Finance questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App