asg-blue-600w

FishBiz Project

Financial and business tools for Alaska commercial seafood harvesters brought to you by the Alaska Sea Grant Marine Advisory Program

Costs and Your Bottom Line

Dungeness Crabbing. Photo credit Alaska Sea Grant.

Once you have your fishing business off the ground, determining how your costs are measuring up against your income becomes a top priority. Alaska Sea Grant has developed an Excel spreadsheet tool specifically for Alaska fishermen to help do this.  (Note: you need Microsoft Excel to use this tool.) 

This kind of proforma anaylsis is just a first step to making better business decisions. Remember, neither your annual tax return nor a rough estimate of cash-in/cash-out (such as this tool), are substitutes for actual long-term business planning. For more detailed financial tools that are the basis of a complete business plan, see "Financial Statements"

The "Fishing Vessel Operational Analysis" workbook below can help get a more detailed look at your fishing business costs and the required cashflow.

Files:
Proforma HOT

This Excel-based spreadsheet allows you 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 eight linked worksheets. The one titled "Main Sheet" is your final product. The other seven sheets, automatically linked to the main sheet, are where you enter information in the input fields outlined in green. You will need to "enable macros" to use these sheets.

Author Greg Fisk File Size 118.5 KB Download

The workbook consists of eight linked worksheets, with the one titled "Main Sheet" as your final product or summary page. The other seven sheets are where you enter information in the input fields outlined in green.  For more detailed instructions on how to use these sheets, see below.

Proforma instructions HOT

This pdf contains instructions for using the Fishermen's Proforma spreadsheet.

File Size 123.37 KB Download