Question compute the future value of a 5 -year ordinary, Ask an Expert

Finance

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:

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M92797507

Have any Question?Write your Review or question?

Related Questions in Basic Finance

A firm has a profit margin of 39 percent a capital

A firm has a profit margin of 3.9 percent, a capital intensity ratio of 1.5, and a debt-equity ratio of .7. What is the firm's ROE? Can someone help me understand how to solve this?

What is the difference between promotion and

What is the difference between Promotion and Advertising?

Question 1 -a this is a two period certainty model

QUESTION 1 - a) This is a two period certainty model problem. Assume that Daisy Brown has a sole income from Fantasy Ltd in which she owns 15% of the ordinary share capital. Currently, she has no savings. In February, 20 ...

Average inventory is 415435 and cost of goods sold is

Average inventory is $415,435 and cost of goods sold is $1,410,000. On average, how long did a unit of inventory sit on the shelf before it was sold?

Arbitrage insures that equal cash flows of equal risk sell

Arbitrage insures that equal cash flows (of equal risk) sell at equal prices and unequal cash flows (of equal risk) sell at equal rates of return once arbitrage has worked to adjust the prices. True or False and why?

Question - the current zero-coupon yield curve for

Question - The current zero-coupon yield curve for risk-free bonds is as follows: Maturity(Years) 1 2 3 4 5 YTM 4.96% 5.48% 5.73% 5.97% 6.07% What is the risk-free interest rate for a five-year maturity?

You are berish on telecom and decide to shell short 100

You are berish on telecom and decide to shell short 100 shares at the current market price of $31 per share. a. How much in cash or securities must you put into your brokerage if the broker initial margin requirement is ...

John walters is comparing the cost of credit to the cash

John Walters is comparing the cost of credit to the cash price of an item. If John makes a down payment of $80 and pays $35 a month for 24 months, how much more will that amount be than the cash price of $685? Cost of cr ...

The inside door has total debt of 76662 total equity of

The Inside Door has total debt of $76662, total equity of $224477, and a return on equity of 12.7 percent. What is the return on assets? Input your answer as a decimal rounded to 4 places (i.e., 1% = 0.0100).

You have joined up with two partners george and joe to

You have joined up with two partners, George and Joe, to start a new computer equipment distributorship. Each partner invested $50,000, and you have been elected to actively manage the business. George is not active in t ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Basic Finance Expert