Purchase Solution

Calculations with Interest Rates

Not what you're looking for?

Ask Custom Question

a. What amount of money should you pay each month to retire a $12000 debt in five years if the interest rate on money is 10% nominal annual interest rate compounded monthly?

b. What amount of money today is equivalent to $100 per month compounded quarterly for ten years at 5%?

c. If you buy a piece of land for $10,000 and spend $1000 per year on taxes, what is your rate of return if you sell the land for $20,000 in 6 years?

d. If the equivalent annual interest rate is 15%, what is the monthly rate that would be compounded to achieve this?

Purchase this Solution

Solution Summary

This solution explains calculations in Excel for questions regarding interest rates.

Solution Preview

Please see the attached file for full problem description.

a. What amount of money should you pay each month to retire a $12000 debt in five years if the interest rate on money is 10% nominal annual interest rate compounded monthly?

Monthly interest rate [10%/12], RATE: 0.0083333333
Number of months [5 years * 12], NPER: 60
Present value, PV if any: 0
Future value, FV: $12,000
Amount to be paid each month, PMT = $154.96 [Using =PMT(rate,nper,pv,fv) function]

b. What amount of money today is equivalent to $100 per month compounded quarterly for ten years at ...

Solution provided by:
Education
  • MPhil, Madurai Kamaraj University
  • MCom, Annamalai University
  • IATA, International Air Transport Association
Recent Feedback
  • "Great explanations on how the answers were obtained."
  • "Love the way she explains everything step by step."
  • "Solutions were thoroughly explained."
  • "Excellent explanations of how problems are solved"
  • "Thanks"
Purchase this Solution


Free BrainMass Quizzes
Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.