Using Excel Answer the following:

Net Cash Flows over the lifespan Year Almonds Walnuts 0 1 2 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 3 4 ($7,082) ($750) ($144) ($1,063) ($452) $663 $3,374 5 6 7 NPV by Discount Rate, along with IRR & MIRR Discount rate (%) Almonds Walnuts 0.25% 0.50% 1.00% 3.00% 6.00% 9.00% 12.00% 15.00% 18.00% 21.00% 24.00% 27.00% 30.00% 33.00% 36.00% 39.00% IRR 8 9 10 11 Full Productinon Potential Revenue Yield (lbs.) Price per Lb. Total Revenue 12 2,200 $2.50 $5,500 6,000 $1.20 $7,200 13 14 15 Operating Costs ($2,717) ($2,839) 16 17 MIRR Income above Operating Costs $2,783 $4,361 18 19 20 Break-even Value Parameter Per unit price of almonds Per unit price of walnuts Yield of almonds Yield of walnuts Net Cash Flows over the lifespan Year Almonds Walnuts 0 1 2 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 3 4 ($7,082) ($750) ($144) ($1,063) ($452) $663 $3,374 5 6 7 NPV by Discount Rate, along with IRR & MIRR Discount rate (%) Almonds Walnuts 0.25% 0.50% 1.00% 3.00% 6.00% 9.00% 12.00% 15.00% 18.00% 21.00% 24.00% 27.00% 30.00% 33.00% 36.00% 39.00% IRR 8 9 10 11 Full Productinon Potential Revenue Yield (lbs.) Price per Lb. Total Revenue 12 2,200 $2.50 $5,500 6,000 $1.20 $7,200 13 14 15 Operating Costs ($2,717) ($2,839) 16 17 MIRR Income above Operating Costs $2,783 $4,361 18 19 20 Break-even Value Parameter Per unit price of almonds Per unit price of walnuts Yield of almonds Yield of walnuts