Unformatted text preview: t per unit is $ 19.0 1. Based on the information above, create a table in excel and calculate annual costs and profits year by year and determine net profits (or losses) covering 32 years. (Please show your excel table) 2. Sum all the 32 year net total profits including capital costs in year zero. Use excel and report the total Sum. (Please show your excel table) 3. What is the price per unit that will make this project breakeven (zero profit)? Also solve this in excel. 4. Based on the cash flow from 32 years life, use the discount formula in every year to calculate the total net present value of your...
View
Full Document
 Spring '14

Click to edit the document details