Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using EXCEL, build a spreadsheet model for each of the following time-value-of-money problems. On your spreadsheet, you will calculate the solution to each problem in

Using EXCEL, build a spreadsheet model for each of the following time-value-of-money problems. On your spreadsheet, you will calculate the solution to each problem in two equivalent ways:

(1) Using the time-value-of-money mathematical formula

(2) Using the EXCEL time-value-of-money function

You must use cell referencing and formulas in your spreadsheet. All of your numbers must have no more than 2 decimal places. All of your work must be your own no sharing of spreadsheets.

For each problem, you will have three sections in your spreadsheet. The first section lists the name of each input and the corresponding numerical amount. The second section is the calculation using the mathematical formula, and the third section is the calculation using the EXCEL function.

Problems:

(1) What is the present value amount that is equivalent to $100 received at the end of 5 years, given a discount rate of 16% (compounded annually)?

(2) What is the present value amount that is equivalent to $100 received at the end of each year for 8 years, given a discount rate of 20%?

(3) Find the future value in 2 years of $100 that is deposited today in an account, which pays 12% compounded monthly.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Financial Crisis Implications For Research And Teaching

Authors: Ted Azarmi, Wolfgang Amann

1st Edition

3319205870, 978-3319205878

More Books

Students also viewed these Finance questions

Question

L A -r- P[N]

Answered: 1 week ago