Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee

Human-written only.

24/7 Support

Anytime, anywhere.

Plagiarism Free

100% Original.

Expert Tutors

Masters & PhDs.

100% Confidential

Your privacy matters.

On-Time Delivery

Never miss a deadline.

Repaying a Loan  While Mary Corens was a student at the University of Tennessee, she borrowed $9,000 in student loans at an annual interest rate of 8%

Finance Jan 21, 2021

Repaying a Loan 
While Mary Corens was a student at the University of Tennessee, she borrowed $9,000 in student loans at an annual interest rate of 8%. If Mary repays $1,700 per year, then how long (to the nearest year) will it take her to repay the loan? Do not round intermediate calculations. Round your answer to the nearest whole number. 
year(s) 

 


Problem 4-14 (Uneven Cash Flow Stream) 
e oo 
Uneven Cash Flow Stream 
a. Find the present values of the following cash flow streams. The appropriate interest rate is 12%. (Hint: It is fairly easy to work this problem dealing with the individual cash flows. However, if you have a financial calculator, read the section of the manual that describes how to enter cash flows such as the ones in this problem. This will take a little time, but the investment will pay huge dividends throughout the course. Note that, when working with the calculator's cash flow register, you must enter CF0 = 0. Note also that it is quite easy to work the problem with Excel, using procedures described in the Ch04 Tool Kit.xlsx.) Do not round intermediate calculations. Round your answers to the nearest cent. 
Year Cash Stream A Cash Stream B 1 $100 $200 2 400 400 3 400 400 4 400 400 5 200 100 Stream A: $ 
Stream B: $ b. What is the value of each cash flow stream at a 0% interest rate? Round your answers to the nearest dollar. Stream A $ Stream B $ 
 

Expert Solution

Repaying a Loan:

Computation of Number of Years for Repayment of Loan using NPER Function in Excel:

=nper(rate,pmt,-pv,fv)

Here,

Nper = Number of Years = ?

Rate = 8%

PMT = $1,700

PV = $9,000

FV = 0

Substituting the values in formula:

=nper(8%,1700,-9000,0)

NPER or Number of Years = 7.16 years or 7 years.

 

Present Value of Cash Flows:

PFA

Archived Solution
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment