Using Excel Find the net cash flows:

Initial Assumptions - Revenue & Operating Costs per Acre Commodity Almonds Walnuts Establishment costs (operating) Year o ($6,453) Year 1 ($700) Year 2 ($650) Year 3 ($99) Year 4 $1,502 Year 5 Year 6 ($7,082) ($750) ($144) ($1,063) ($452) $663 $3,374 Net Cash Flows over the lifespan Year Almonds Walnuts 0 ($6,453.00) ($7,082.00) 1 ($700.00) ($750.00) 2 ($650.00) ($144.00) 3 ($99.00) ($1,063.00) 4 $1,502.00 ($452.00) 5 $663.00 6 $3,374.00 7 8 9 10 11 Full Productinon Potential Revenue Yield (lbs.) Price per Lb. Total Revenue 2,200 $2.50 $5,500 6,000 $1.20 $7,200 12 13 14 15 Operating Costs ($2,717) ($2,839) 16 17 Income above Operating costs $2,783 $4,361 18 19 20