Ag and Business Management - Financial Analysis I | ABM 121, Study notes of Agricultural engineering

Download Ag and Business Management - Financial Analysis I | ABM 121 and more Study notes Agricultural engineering in PDF only on Docsity! Morgan Community College – Ag and Business Management 08/14/04 File:Study Guide - Spreadsheets.doc Page 6 Some example Spreadsheets The table below shows the names of three of the spreadsheet files that the ABM department has developed. This list gives an indication of the variety of files available. This list is by no means complete. Your instructor should have more files if you are interested. Spreadsheet Name & Description View Snapshot Open Excel File Amortize This file is used to calculate an amortized loan where all of the necessary information is known. amortize.jpg View Snapshot amortize.xls Open with Excel Cow Calf Records This file is an example of how a spreadsheet can be used as a database. It could be used without modification for cow-calf production records. One advanced feature is the ability to filter the contents of the spreadsheet for a certain criterion (see the drop-down menu for the breed type). For heavy-duty databases the appropriate tool is to use Microsoft Access. Cow-Calf Records.jpg View Snapshot Cow-Calf Records.xls Open with Excel Invntory This file shows a manual method of tracking commodity inventory. Several students have modified this to track other items. Depending on your business situation, it may be better to track this in your accounting software. Invntory.jpg View Snapshot Inventory.xls Open with Excel