Purchase Solution

Calculating present value and future value

Not what you're looking for?

Ask Custom Question

Find the future value one year from now of a $7,000 investment at a 3 percent annual compound interest rate. Also calculate the future value if the investment is made for two years.

FV one year
FV two years
Sum of FV's

Find the future value of $10,000 invested now after five years if the annual interest rate is 8 percent.

a. What would be the future value if the interest rate is a simple interest rate?

FV using simple interest

b. What would be the future value if the interest rate is a compound interest rate?

FV using compound interest

Find the present value of $7,000 to be received one year from now assuming a 3 percent annual discount interest rate. Also calculate the present value if the $7,000 is received after two years.

PV received one year from now
PV received two years from now

Determine the present value now of an investment of $3,000 made one year from now and an additional $3,000 made two years from now if the annual discount rate is 4 percent.

PV one year from now
PV two years from now

Use a financial calculator or computer software program to answer the following questions.

a. What is the present value of $359,000 that is to be received at the end of twenty-three years, the discount rate is 11 percent, and semiannual discounting occurs?

PV w/ semi-annual discounting

b. How would your answer for (a) change if monthly discounting were used?

PV w/ monthly discounting

Purchase this Solution

Solution Summary

This solution illustrates how to use Excel functions to find future and present values.

Purchase this Solution


Free BrainMass Quizzes
Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Motivation

This tests some key elements of major motivation theories.

Production and cost theory

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

Income Streams

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