Time value of money mathematical formula

Assignment Help Financial Management

Reference no: EM131836727

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.

Reference no: EM131836727

Questions Cloud

What is the difference between dsdna and ssdna : What is the difference between dsDNA and ssDNA? Distinguish between + and - sense RNA.

What do you think is the most important similarity : What do you think is the most important similarity, and which is the most important difference? Use specifics to support your answer.

Approximate molecular mass : You need to calculate ligation for your insert. You know that you have 3 ng/µL in your sample, how many picomols/µL do you have if it is a 1000 bp insert?

Discuss the mechanisms that pseudomonas aeruginosa : Please discuss the mechanisms that Pseudomonas aeruginosa, Staphylococcus aureus,Propionibacterium acnes and Streptococcus pyogenes

Time value of money mathematical formula : 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)?

Problem on staffing current events topic to research : Your research assignment for this class will be to choose a staffing current events topic to research. There are three parts to the assignment.

States with large areas of forestation such as colorado : The lyme disease infection is primarily limited to states with large areas of forestation such as Colorado, Montana, Idaho, etc. would lyme diseas

How have various people written about the history of taiwan : How do we understand the historiography-the history of history writing-of Taiwan? How have various people written about the history of Taiwan in the past?

Describe the structure of a simple lipid : Describe the structure of a simple lipid. How are saturated and unsaturated fatty acids different? Give an example of a saturated

User Account

All Pages