Calculate the future value of the annuity

Assignment Help Finance Basics

Reference no: EM131959850

Question: Compute the Future Value of a 5 -year ordinary annuity (where payments are received at the end of a time period), if the yearly annuity is $10,000 and the relevant interest rate is 6%. Complete the following table, showing the Future Value Factors and the Future Value of each Annuity Payment for years 2 through 5. In addition, calculate the Future Value of this ordinary annuity using the proper Excel function. Copy and the paste the Excel function showing the parameters used to calculate the Future Value of the Annuity. Also compute the Future Value of an Annuity Due using the same parameters.

Annual Interest Rate =		6%
Year	Ordinary Annuity	Future Value Factor	Future Value of Annuity Payment
1	$10,000	1.26247696	$12,624.77
2	$10,000
3	$10,000
4	$10,000
5	$10,000

Future Value of Ordinary Annuity = _____________________

Future Value of Annuity Due = _____________________

Excel Formula/Function:

Reference no: EM131959850

Questions Cloud

Calculate the present value of the bond : Jim Busby calls his broker to inquire about purchasing a bond of Disk Storage Systems. His broker quotes a price of $1,120.

Transnational and metanational structures : Why companies choose matrix, transnational and metanational structures and why? Why large multinational companies choose metanational structures?

Which are the current forces in the industry environments : Which are the current forces in the industry environments that affect Emirates' ongoing strategy?

What will be the new return on stockholders equity : Jerry Rice and Grain Stores has $4,430,000 in yearly sales. The firm earns 2 percent on each dollar of sales and turns over its assets 4.5 times per year.

Calculate the future value of the annuity : Compute the Future Value of a 5 -year ordinary annuity (where payments are received at the end of a time period), if the yearly annuity is $10,000.

How much will he have saved in eight years when he buys home : If his investment in a mutual fund will earn him 9.65 percent annually, how much will he have saved in eight years when he buys his house?

Song playing in the background : Which of the following compartments of the long-term memory is this information most likely to be stored in?

Bad decisions for a series of reasons : As discussed in the book (and as we will discuss in class on Monday, April 23rd), groupthink occurs when a team makes bad decisions for a series of reasons

Detremine the internal rate of return : Jericho Manufacturing developed a new wireless phone charger which also uses the excess heat generated during the process to keep your coffee warm.

User Account

All Pages