{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

What is the price per unit that will make this

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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

{[ snackBarMessage ]}

Ask a homework question - tutors are online