Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 ... 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_2

Step: 3

blur-text-image_3

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

Entrepreneurship & Small Business Management

Authors: Steve Mariotti, Caroline Glackin

2nd edition

133801160, 133767183, 9780133801163, 978-0133767186

More Books

Students also viewed these Finance questions

Question

What is the MFD? UFD? How are they related?

Answered: 1 week ago

Question

Is this really true, or am I just taking it for granted?

Answered: 1 week ago

Question

Increase in the reporting of sustainability perf

Answered: 1 week ago

Question

How do you plan to incorporate philanthropy in your marketing mix?

Answered: 1 week ago