1 / 18

Agricultural Microeconomics Lesson 7 : Intro to Spreadsheet Modeling

Agricultural Microeconomics Lesson 7 : Intro to Spreadsheet Modeling.

cianna
Download Presentation

Agricultural Microeconomics Lesson 7 : Intro to Spreadsheet Modeling

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Agricultural MicroeconomicsLesson 7: Intro to Spreadsheet Modeling This course developed by The Environmental Finance Center at UNC Chapel Hill for The North Carolina School of Science and Math and NCDPI is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License

  2. Using Spreadsheets • Net Earnings Statement • Cost-Benefit Analysis • Cash Flow Analysis • Pro-forma (future) statements • Scenario Analysis • Graphing

  3. Meet the Spreadsheet Get to Know Excel 2010: Meet the Spreadsheet

  4. Adding Column Titles Get to Know Excel 2010: Create Column Titles

  5. Adding Column Titles • Item Description • Months • January • February • March • etc. • 12-Month Total

  6. Adding Row Titles • Revenue from Bulk Beef Sales • Revenue from Packaged Beef Sales • Total Revenue • Pasture Costs • Supplemental Feed • Mineral Supplement • Vaccinations • Processing Charge • Packaging Charge • Labor • Machinery and Equipment • Marketing • Certification Fees • Property, Taxes and Insurance • Debt Repayment • Total Operating Costs • Net Earnings

  7. Adding Rows and Columns Get to Know Excel 2010: Get More (or Less) Columns, Rows and Spreadsheets

  8. Entering Data • Use data from Piedmont Farm Case Study (or make up your own). • Think about seasonality of revenue and expenses: • Does all revenue come in equally during the year or is it different in some months? • Do some expenses only occur during certain times of the year? • Don’t worry about adding up the numbers (for now).

  9. Do Basic Math Get to Know Excel 2010: Do Basic Math in Excel

  10. Formatting Currency Formatting Underline Formatting

  11. Next Class: Advanced Spreadsheet Modeling This course developed by The Environmental Finance Center at UNC Chapel Hill for The North Carolina School of Science and Math and NCDPI is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License

More Related