Present Value 150000
Interest Rate 0.06
Base Value 1
Number of Periods 18
Future Value 428,150.87 €
Annuity Deposits needed
Annnual payments 150000 Future Value 150000
Interest Rate 0.06 Interest Rate 0.06
Base Value 1 Base Value 1
Number of Periods 18 Number of Periods 18
Future Value 4,635,847.88 € Annual Payments 4,853.48 €
Annuity Due
Annnual payments
Interest Rate
Base Value 1
Number of Periods
Future Value #DIV/0!
Mixed Stream
Year Cash Flow
1 -11500
2 -14000
3 -12900
4 -16000
5 -18000
Rate of interest 8%
NPV -56,902.30 €
Number of Years 5
Future Value 83,608.15 €
,Future Value 428150
Interest Rate 0.06
Base Value 1
Number of Periods 18
Present Value 149,999.69 €
Annuity
Annnual payments 150000
Interest Rate 0.06
Base Value 1
Number of Periods 18
Present Value 1,624,140.52 €
Annuity Due
Annnual payments
Interest Rate
Base Value 1
Number of Periods
Present Value #DIV/0!
Mixed Stream
Year Cash Flow
1 400
2 800
3 500
4 400
5 300
Rate of interest 9%
Present Value 1,904.76 €
, Project A Project B
Year Annual Cash Flow Cummulative Cash Flow Annual Cash Flow
0 - 1,500,000.00 € - 1,500,000.00 € - 1,500,000.00 €
1 400,000.00 € - 1,100,000.00 € 400,000.00 €
2 800,000.00 € - 300,000.00 € 800,000.00 €
3 800,000.00 € 500,000.00 € 800,000.00 €
4 50,000.00 € 550,000.00 € 50,000.00 €
5 20,000.00 € 570,000.00 € 20,000.00 €
6 15,000.00 € 585,000.00 € 15,000.00 €
7 10,000.00 € 595,000.00 € - €
Project Cash Flow 2,095,000.00 € 2,085,000.00 €
Payback Period 1.625 1.625
0.38 €