Finding an Unknown Future Payment Amount
Not what you're looking for?
Alex has just won the lottery. Specifically, Alex has won the lump sum amount of $1100 but he must wait until the end of 5 years to receive the money. He is in need of cash and would rather receive a different pattern of payments: $325 today and then receive some unknown lump sum amount that will be received in 5 years. Using an interest rate of 5.50%, determine the unknown lump sum amount that would make the present value of both prizes equivalent.
Purchase this Solution
Solution Summary
This solution illustrates how to use Excel's time value of money functions to find the amount of an unknown future payment that equates to a known future payment if a portion of the former payment is received today.
Solution Preview
Please see the attached Excel 97-2003 spreadsheet.
Alex has just won the lottery. Specifically, Alex has won the lump sum amount of $1100 but he must wait until the end of 5 years to receive the money. He is in need of cash and would rather receive a different pattern of payments: $325 today and then
receive some unknown lump sum amount that will be received in 5 years. Using an interest rate of 5.50%, determine the ...
Purchase this Solution
Free BrainMass Quizzes
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
Introduction to Finance
This quiz test introductory finance topics.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.