Question: 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
Need years 1 throuhh 20 all formulas shown so that any number
in table 1 can be changed to adjust for table 2 1.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!