Input measures Investment project I Investment project II Initial investment outlay (Io) (€) 100,000 60,000 Production and sales volume (x) (units) 1,000 1,000 Sales price (p) (€ per unit) 100 100...


Please analyze. Build an Excel Model to compute the NPV of investment project I or II and make sure that the model works (allows for changes in the inputs ,updates the output-NPV-and gives the same result).


Could you send with a excel files?


Input measures<br>Investment project I<br>Investment project II<br>Initial investment outlay (Io) (€)<br>100,000<br>60,000<br>Production and sales volume (x) (units)<br>1,000<br>1,000<br>Sales price (p) (€ per unit)<br>100<br>100<br>Cash outflow per unit (dependent on<br>production volume) cof, (€ per unit)<br>50<br>60<br>Cash outflow per period (independent of<br>production volume) COFF (€)<br>16,000<br>17,500<br>Liquidation value (L) (€)<br>Economic life (T) (years)<br>5<br>5<br>Uniform discount rate (i) (%)<br>10<br>10<br>Net present value (€)<br>28,886.74<br>25,292.69<br>

Extracted text: Input measures Investment project I Investment project II Initial investment outlay (Io) (€) 100,000 60,000 Production and sales volume (x) (units) 1,000 1,000 Sales price (p) (€ per unit) 100 100 Cash outflow per unit (dependent on production volume) cof, (€ per unit) 50 60 Cash outflow per period (independent of production volume) COFF (€) 16,000 17,500 Liquidation value (L) (€) Economic life (T) (years) 5 5 Uniform discount rate (i) (%) 10 10 Net present value (€) 28,886.74 25,292.69

Jun 03, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here