Please help, I really need help on this!!

Suppose you are consultant for a farmer who owns 100 acres of usable land. She wants to plant some combination of corn and wheat on the land. She wants you to build a spreadsheet that will calculate NPV and IRR based on her estimates for costs and revenues related to this project.

Create an NVP analysis that the farmer can use to make the optimal investment decision

"Assumptions" Tab

* Insert placeholder data of your choosing into yellow input cells

* Create dynamic calculations for all non-input cells

"Worksheet" tab

* Create dynamic calculations using data from assumptions tab

"ROI" Tab

* Create dynamic cash flow calculations for each year using data from the other tabs

* Use excel formulas to calculate NPV and IRR based on the net cash flow data

* Use conditional formatting to indicate when the NPV and IRR indicate a good investment

"Scenarios" Tab

* Answer the questions relating to each scenario using your completed spreadsheet as the calculator

1Enter values in yellow-highlighted cells only 100 Land Available (Acres) 3 4 Inputs Acres Cost of corn-growing equipment Actual Capital Investment Year 1 Expense/Acre Expense annual Increase (%) Year 1 Revenue/Acre Revenue Annual Increase (%) Acres Cost of wheat-growing equipment Actual Capital Investment Year 1 Expense/Acre Expense annual increase (%) Year 1 Revenue/Acre Revenue Annual Increase (%) Corn 10 12 13 14 15 16 17 18 19 20 21 Wheat 23 24 25 26 27 28 29 30 31 32 34 35 36 ROI Asumptions Worksheet Scenarios 1Enter values in yellow-highlighted cells only 100 Land Available (Acres) 3 4 Inputs Acres Cost of corn-growing equipment Actual Capital Investment Year 1 Expense/Acre Expense annual Increase (%) Year 1 Revenue/Acre Revenue Annual Increase (%) Acres Cost of wheat-growing equipment Actual Capital Investment Year 1 Expense/Acre Expense annual increase (%) Year 1 Revenue/Acre Revenue Annual Increase (%) Corn 10 12 13 14 15 16 17 18 19 20 21 Wheat 23 24 25 26 27 28 29 30 31 32 34 35 36 ROI Asumptions Worksheet Scenarios