Put together a Microsoft Excel worksheet to analyze 100 years of canola returns

Put together a Microsoft Excel worksheet to analyze 100 years of canola returnsusing the random number expression =randbetween(X,Y). Yield is 28 – 40 bu/ac.Price is $6 – $10/bu. Cost is $250 – $270/ac. Start with equity of $500/ac and trackgains or losses over the 100 years. Graph cumulative profit and equity. Recalculatescenarios by hitting the key. Set up a table as follows:# Yield Price Sales Costs Profit Cum Profit EquityRepeat 1 with costs $270 – $290.Repeat 1 with costs $240 – $260.2. Put together a Microsoft Excel worksheet to analyze 100 years of wheat returns.Start with $500/acre equity. Put ranges around total operating costs per acre (+/-10%), total fixed costs per acre(+/- 2%), labour costs per acre (+/- 10%), price(+/- 20%) per bushel and yield in bushels per acre (+/- 20%). Using the randomnumber expression =randbetween(X,Y), calculate and track gains or losses over the100 years. Graph cumulative profit and equity. Recalculate scenarios by hitting the key. Set up a table as follows:# Yield Price Sales Costs Profit Cum Profit Equity

The post Put together a Microsoft Excel worksheet to analyze 100 years of canola returns appeared first on graduate paper help.

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now
 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"