Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need years 1 throuhh 20 all formulas shown so that any number in table 1 can be changed to adjust for table 2 1. Recreate
Need years 1 throuhh 20 all formulas shown so that any number in table 1 can be changed to adjust for table 2
1. Recreate the series of tables shown below to conduct a capital budgeting comparison of the two commodities. Note: All of the tables must be linked to investigate the effect of changing any of the values in the initial assumptions table. Table 1: Initial Assumptions - Revenue & Operating Costs per Acre (5 pts.) Commodity Almonds Walnuts Establishment costs (operating) Year 0 ($ 6,453) ($ 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 potential Revenue Yield (lbs.) Price per lb. Total revenue 2,200 $ 2.50 $ 5,500 6,000 $ 1.20 $ 7,200 Operating costs ($ 2,717) ($ 2,839) Income above operating costs $ 2,783 $ 4,361 Table 2: Net Cash Flows over the Lifespan (5 pts.) Year Almonds Walnuts 0 1 2 3 4 5 1 20 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