Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need to find the net cash flows for the rest of the years using table 1 also need excel formulas used to fiugure out solutions
Need to find the net cash flows for the rest of the years using table 1 also need excel formulas used to fiugure out solutions Table 1: Initial Assumptions- Revenue & Operating cost per Acre Commodity Almonds Walnuts stablishment Costs (operating) Year o ($6,463) ($7,082) Year 1 ($700) ($750) Year 2 ($650) ($1,044) Year 3 ($99) ($1,063) Year 4 $1,502 ($452) Year 5 $663 Year 6 $3,374 Full Production Potenital Revenue Yeild (lbs.) Price per lb. Total Revenue 2,200 $2.50 $5,500.00 6,000 $1.20 $7,200.00 Operating costs ($2,717) ($2,839) Income Above Operating costs $2,783.00 $4,361.00 Year N Table 2: Net Cash Flows over the Lifespan Almonds Walnuts 0 ($6,463) ($7,082) 1 ($700) ($750) ($650) ($1,044) ($99) ($1,063) 4 $1,502 V$452) 5 $663 6 $3,374 7 3 Vous 09 8 9 10 11 12 13 14 15 16 17 18 19 20 o lo Table 1: Initial Assumptions- Revenue & Operating cost per Acre Commodity Almonds Walnuts stablishment Costs (operating) Year o ($6,463) ($7,082) Year 1 ($700) ($750) Year 2 ($650) ($1,044) Year 3 ($99) ($1,063) Year 4 $1,502 ($452) Year 5 $663 Year 6 $3,374 Full Production Potenital Revenue Yeild (lbs.) Price per lb. Total Revenue 2,200 $2.50 $5,500.00 6,000 $1.20 $7,200.00 Operating costs ($2,717) ($2,839) Income Above Operating costs $2,783.00 $4,361.00 Year N Table 2: Net Cash Flows over the Lifespan Almonds Walnuts 0 ($6,463) ($7,082) 1 ($700) ($750) ($650) ($1,044) ($99) ($1,063) 4 $1,502 V$452) 5 $663 6 $3,374 7 3 Vous 09 8 9 10 11 12 13 14 15 16 17 18 19 20 o lo
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started