Ventures International is considering one of four projects to fund. Please calculate the: a) Present Worth b) Future Worth or c) Annual Worth of each project which last for five years and the risk-free interest rate is 10%. Show calculations in the form of excel or other spreadsheet means.
Alternative
Present Worth
Future Worth
Annual Worth
1
Invest $14000 today and receive $25000 in five years.
$answer & excel formula
$answer & excel formula
$answer & excel formula
2
Invest $10000 today receive annual payments of $3000.
$answer & excel formula
$answer & excel formula
$answer & excel formula
3
Invest $15000 today receive annual payments of $4000 and also receive a final payment of $2000.
$answer & excel formula
$answer & excel formula
$answer & excel formula
4
Invest $9000 today receive annual payments of $1000 $2000 $3000 $4000 and $5000
$answer & excel formula
$answer & excel formula
$answer & excel formula
or to restate the question in different terms there are 4 alternatives below:
Alternative 1 Invest $14000 today and receive $25000 in five years.
Alternative 2 Invest $10000 today receive annual payments of $3000.
Alternative 3 Invest $15000 today receive annual payments of $4000 and also receive a final payment of $2000.
Alternative 4: Invest $9000 today receive annual payments of $1000 $2000 $3000 $4000 and $5000
Requested answer:
Please calculate the present worth future worth and annual worth for alternatives 1-4.
Attachments: