FishBiz Spreadsheets
This Excel workbook contains an income statement, cash flow statement, balance sheet and asset and liability details you can complete for your own fishing operation. Click to enable macros when opening.
Use the series of videos produced by Greg Fisk and the University of Minnesota to learn how to work with financial spreadsheets.
This Excel workbook contains an income statement, cash flow statement, balance sheet and asset and liability details you can complete for your own fishing operation. Use the series of videos produced by Greg Fisk and the University of Minnesota to learn how to work with financial spreadsheets.
The goals of this Excel spreadsheet are to track and summarize species poundage recorded on fish tickets, add company/tender information and fish temperatures, note crew changes, and track tender fuel and supplies purchases. Fishermen have shared with us other ideas for spreadsheet uses: setting up formulas that automatically account for post-season price adjustments, taxes and crew percentages, tracking setnet operations with multiple permits and direct market sales.
Download this template and customize it to your needs. Maybe you want to use a spreadsheet just to check delivery poundage against processor year-end statements or maybe summarizing income and crewshare information for your tax preparer is your priority. If you can utilize a spreadsheet while fishing, try adding columns and formulas for other items such as weather and tides, crew changes and direct market sales.
You will need Microsoft Excel to use this spreadsheet.
Use this Excel workbook to analyze various “what-if” scenarios in your fishing business. Enter predicted fuel, bait, gear, moorage, crew, and insurance costs and see how each changes your bottom line. You can look at the impact of different loan interest rates, or targeting different salmon species, or adjusting your days at sea.
The workbook consists of 8 linked worksheets. The one titled “Main Sheet” is your final product. The other 7 sheets, automatically linked to the main sheet, are where you enter information in the input fields outlined in green. Click to enable macros when opening.
Use the series of videos produced by Greg Fisk and the University of Minnesota to learn how to work with financial spreadsheets.
This Excel calculator analyzes costs whether you fish the quota on your own boat or on someone else’s. It also includes a converter to translate quota shares into poundage. Click to enable macros when opening.
Use the series of videos produced by Greg Fisk and the University of Minnesota to learn how to work with financial spreadsheets.
Use this Excel calculator to help you determine how much the money you invest today will be worth in 20 years, given varying inflation rates, interest rates, beginning principal, etc. Use it in conjunction with the “Investing for Retirement” podcast on this website (minutes 10:45-16:15).