Select Page

# 100 years of canola returns

Put together a Microsoft Excel worksheet to analyze 100 years of canola returns using the random number expression =rand between(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 track gains or losses over the 100 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

Repeat 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 random number expression =rand between(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

## How it works – it’s easy

i

Submit your requirements through our small easy order form. Be sure to include and attach any relevant materials.

i

#### Writing process

We assign the assignment to the most qualified tutor. When the tutor completes the assignment, it is transferred to one of our professional editors to ensure that the assignment meets all of your requirements.

Once complete, we’ll send your assignment via the email provided on the order form.