Excel formulas must be used for credit

1. Estimate the design As Net Operating Cash Flows (NCF) using a given Excel worksheet. Complete the worksheet given along with this assignment. (Click the tab of Design A)

2. Estimate the design Bs Net Operating Cash Flows (NCF) using a given Excel worksheet. Complete the worksheet given along with this assignment. (Click the tab of Design B)

3. Calculate NPV of the two mutually exclusive designs. Which design should be chosen?

Note: Please answer the problems above by completing the worksheet named Applachian_Design A and Applachian_Design B

						4	5
					$0	$0	$0
					$0	$0	$0