In: Finance
Total cost=working capital requirement+fixed asset investment=$100000+$1000000=$1100000
Again $100,000 working capital has to be added to Year5 cashflows due to its recovery in nature
All the formulas and how find the cashflows and NPV is given the below table
NPV can be calculated using NPV function in EXCEL
=NPV(rate, Year1 to Year5 cashflows)-Year0 cashflow
=NPV(10.75%,Year1 to Year5 cashflows)-$1100000
NPV=-$136,277