Question

In: Finance

In this paper you will be working with a dollar value of $1,000,000 to calculate present...

In this paper you will be working with a dollar value of $1,000,000 to calculate present value, present value of an annuity, future value and future value of an annuity. In each of the four parts of the assignment, you will provide a scenario in which you personally or a business would need to calculate these values. Personal examples are planning for retirement, planning for education or winning the lottery. Business examples are buying a new delivery truck, bond issues, purchasing a new building or opening a start-up business. The example you use is your choice and you may use the same example or different examples for each of the four calculations. For each of the four calculations, you will need to determine the timeline (how many years) and the interest rate. Research current interest rates to determine a reasonable percentage.

Solutions

Expert Solution

Present value of a single sum
Let us find the Present value of $ 1000000 that is to be received at end of year 8 as proceeds from a bond investment & the interest rate we use is the interest on one other investment owned, ie. 9%p.a.
we need to use the formula, to find the present value of a single sum in future
ie. PV= FV/(1+r)^ n
where, PV= the present value --to be found out-----??
FV= the future value, ie $ 1000000
r= the interest rate p.a., ie.9%
n= no.of years = 8
so, plugging -in all the values, in the formula,
PV=1000000/(1+0.09)^ 8
501866.28
So, the Present value of $ 1000000 that is to be received at end of year 8 at 9% p.a.= $ 501866
Present value of annuity---- a series of amounts
Now,instead of receiving at end yr. 8, we are going to receive $ 180675 at the end of each year for 8 years  
& using the same 9% interest as above,
we will find the present value of this annuity
using the formula,
PV of annuity=Pmt.(1-(1+r)^-n)/r
where PV=the present value to be found out--??
Pmt.= the annuity received at end of each yr. for 8 yrs.= $ 180675
r=rate of interest used= 9%
n=no.of compounding years, 8
so, plugging -in all the values, in the formula,
PV of annuity=180675*(1-(1+0.09)^-8)/0.09=
1000003
So, the present value of this annuity = $ 1000000
Future value of a single sum
Now, we are investing $1000000 in a security that will mature at end of year 8 , interest at 9% p.a. to be received along with the principal
we need to use the formula, to find the future value of this single sum, to know how much we will receive in total
ie. FV=PV*(1+r)^n
where, PV= the present value of the investment, ie. $ 1000000
FV= the compounded future value--- to be found out---??
r= the interest rate p.a., ie.9%
n= no.of years = 8
so, plugging -in all the values, in the formula,
ie. FV=1000000*(1+0.09)^8=
1992562.64
So, the Future value of $ 1000000 , or the amount accumulated , that is to be received at end of year 8 at 9% p.a.= $ 1992563
Future value of annuity------- a series of amounts
Now, we are going to recive $ 90675 at every year-end for 8 years
& using the same 9% interest as above,
we will find the future value of these series of receipts
using the formula,
FV of annuity=Pmt.((1+r)^n-1)/r
where FV=the future value to be found out--??
Pmt.= the annuity received at end of each yr. for 8 yrs.= $ 90675
r=rate of interest used= 9%
n=no.of compounding years, 8
so, plugging -in all the values, in the formula,
FV of annuity=90675/(1+0.09)^8-1)/0.09
1000007
So, the Future value of this series of receipts (annuity )= $ 1000007

Related Solutions

Present Value 6a. What is the present value of $1,000,000, due 25 years from now?   ...
Present Value 6a. What is the present value of $1,000,000, due 25 years from now?    b. What is the present value of a $40,000 ordinary annuity for 25 years? c. What is the present value of a $40,000 perpetuity, if the first payment is 1 year from now? d. What is the present value of a $40,000 perpetuity, if the first payment is now? Using formula or Excel function
What is the present value of $1,000,000 to be received in 15 years, if the opportunity...
What is the present value of $1,000,000 to be received in 15 years, if the opportunity cost is 3.50% annually?
4. What is the present value of $1,000,000 to be received in 35 years if the...
4. What is the present value of $1,000,000 to be received in 35 years if the average rate of interest over the 35 years is 2.5%? Interpret your result. Make sure to show your work.
Present value For the case shown in the following​ table, calculate the present value of the...
Present value For the case shown in the following​ table, calculate the present value of the cash​ flow, discounting at the rate given,and assuming that the cash flow is received at the end of the period noted. ​(Click on the icon here in order to copy the contents of the data table below into a​ spreadsheet.) Single cash flow- $148,000 discount rate- 13% end of period (years) - 7
How do you calculate Profit Present Value in excel?
How do you calculate Profit Present Value in excel?
When you calculate the present value of an asset, for example a bond, you are calculating...
When you calculate the present value of an asset, for example a bond, you are calculating _____. maximum price you would pay for the asset minimumm price you would pay for the asset future value of the asset insurance premiums
Net present value Using a cost of capital of 11​%, calculate the net present value for...
Net present value Using a cost of capital of 11​%, calculate the net present value for the project shown in the following table and indicate whether it is​ acceptable, Initial investment ​(CF 0CF0​) negative 1 comma 143 comma 000−1,143,000 Year ​(t​) Cash inflows ​(CF Subscript tCFt​) 1 $81,000 2 $138,000 3 $193,000 4 $258,000 5 $311,000 6 $377,000 7 $270,000 8 $98,000 9 $45,000 10 $29,000 The net present value​ (NPV) of the project is _____​$ ​(Round to the nearest​...
For each example, calculate the present value, or net present value, of the future amount(s) to...
For each example, calculate the present value, or net present value, of the future amount(s) to support your answer and show your work using either factors (pp. 219 & 221 in the text), an Excel spreadsheet with the Excel PV or NPV functions or the equations, such as PV = FV / (1+Interest Rate)Time. Suppose you have a project where you will invest $20,000 today and receive one payment $26,200 exactly 5 years in the future. If your opportunity cost...
In part 2 you will be creating multiple functions to calculate the present value. You may...
In part 2 you will be creating multiple functions to calculate the present value. You may be asking what a "present value" is. Suppose you want to deposit a certain amount of money into a savings account and then leave it alone to draw interest for some amount of time, say 12 years. At the end of the 12 years you want to have $15,000 in the account. The present value is the amount of money you would have to...
Prompt: Present value and Future value – In finance we often calculate present and future values....
Prompt: Present value and Future value – In finance we often calculate present and future values. Discuss their uses and the relationship between present and future value. Requirements: 250 words
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT