Purchase Solution

Time Value of Money

Not what you're looking for?

Ask Custom Question

Pierre borrowed $100,000 from his grandfather for college expenses. The interest rate is to be 5% annually (and compounded annually). The plan is that he will graduate in four years and start making payments at the end of the fifth year.
a. How much will Pierre owe just before he makes his first payment?
b. If he wants to pay off the loan in 10 years, what would his annual payment be?
c. How long would it take to pay off the loan after he graduates if he pays his grandfather $15,000 annually.

Attachments
Purchase this Solution
Solution Summary

Solution determines the desired parameters by using the functions in MS Excel.

Solution Preview

Please refer attached file for better understanding of formulas.

a How much will Pierre owe just before he makes his first payment?
Loan amount=PV=$100,000
Annual Payment made=PMT=0
Interest Rate=RATE=5%
Number of periods=NPER=5
Type of payment=0 Year End Payments
Amount at the end of 5th Year=FV=?

We can use FV function in MS Excel to get ...

Solution provided by:
Lokesh Jain, MSc
Education
  • BEng (Hons) , Birla Institute of Technology and Science, India
  • MSc (Hons) , Birla Institute of Technology and Science, India
Recent Feedback
  • "Thank you"
  • "Really great step by step solution"
  • "I had tried another service before Brain Mass and they pale in comparison. This was perfect."
  • "Thanks Again! This is totally a great service!"
  • "Thank you so much for your help!"
Purchase this Solution
Free BrainMass Quizzes
Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

View More Free Quizzes
Related BrainMass Solutions

  • This posting addresses the time value of money.

    463184 Finance: The Time Value of Money Why does money have a time value? Can you provide at least one real-life scenario in which you can apply the concept of "time value of money?"

  • Time Value of Money - Finance

    504530 Time Value of Money - Finance During periods of low interest rates, why is considering the time value of money (i.e., present value, future value, etc.) less relevant?

  • What is the time value of money?

    501182 What is the time value of money? What is the time value of money? How do net present value (NPV) and future value (FV) impact the concept of time value of money?

  • Why is the time value of money so important in capital budgeting decisions?

    160523 Time Value of Money Why is the time value of money so important in capital budgeting decisions? Why is the time value of money so important in capital budgeting decisions?

  • Time Value of Money Concept: Individuals & Businesses

    301198 What is "time value of money" mean? Why is the concept important to both businesses and individuals? This posting addresses the following questions: What does the concept "time value of money" mean? Why is the concept important?

  • Time Value of Money

    TIME VALUE OF MONEY Time preference for money is an individual's preference for possession of a given amount of money now, rather than the same amount at some future time.

  • Time value of money associated with commerical bank

    87318 Time value of money associated with commerical bank How does Time value of money associated with commerical bank? Time value of Money This concept is used by commercial banks to judge the financial position of its clients.

  • Time value of money in decision making

    The time value of money is important in economic decisions because the value of money received today is more than the value of same money going to be received after one year.

  • Time value of money and capital budgeting

    57169 Time value of money and capital budgeting How do time value of money concepts assist a company in making capital budgeting decisions?

  • Managerial Finance - Time Value and Money

    Why would someone in Argentina want to have debt and why does money have a time value? Present worth of rupee received after some time will be less than the rupee received today. This is because of the time value of money.

View More Related Solutions