Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Authentication
digital resources
187x Filetype XLSX File size 0.28 MB Source: www.agmanager.info
Sheet 1: Introduction
| KSU-Integrated Financial Statements | ||||||||||||
| An Excel spreadsheet to build a balance sheet, income statement, and cash flow from farm records | ||||||||||||
| Version- 8.8.2018 | ||||||||||||
| INSTRUCTIONS FOR THE USER: | ||||||||||||
| Blue values are inputs that need to be entered for your operation. Black values are automatically calculated. | ||||||||||||
| Hover or click on each item with a red triangle to get more detailed information on what to enter. | ||||||||||||
| FOR MORE INFORMATION: | ||||||||||||
| See Farm Management Guides: | ||||||||||||
| Balance Sheet-A Financial Management Tool | ||||||||||||
| Income Statement-A Financial Management Tool | ||||||||||||
| Cash Flow Projection for Operating Loan Determination | ||||||||||||
| Financial Ratios Used in Financial Management | ||||||||||||
| Computation of Deferred Tax Liability | ||||||||||||
| With Questions contact: | ||||||||||||
| Robin Reid | Kevin Herbel | Dr. Rich Llewelyn | ||||||||||
| Extension Associate | KFMA Executive Director | Extension Assistant | ||||||||||
| Kansas State University | Kansas State University | Kansas State University | ||||||||||
| robinreid@ksu.edu | kherbel@ksu.edu | rvl@ksu.edu | ||||||||||
| 785-532-0964 | 785-532-8706 | 785-532-1504 | ||||||||||
| Copyright 2017 AgManager.info, K-State Department of Agricultural Economics | ||||||||||||
| BALANCE SHEET for | Name | Date | FARM FINANCIAL RATIOS | |||||||||
| ASSETS: | Jan. 1 | Dec. 31 | Average | |||||||||
| January 1 | December 31 | Average | Notes | Current Ratio | (Line 8/Line 22) | |||||||
| 1) Cash | #DIV/0! | Working Capital | $0 | $0 | $0 | (Line 8-Line 22) | ||||||
| 2) Accounts Receivable | #DIV/0! | Debt/Asset Ratio | (Line 27/Line 15) | |||||||||
| 3) Fertilizer and Supplies | #DIV/0! | Equity/Asset Ratio | (Line 28/Line 15) | |||||||||
| 4) Investment in Growing Crops | #DIV/0! | Debt/Equity Ratio | (Line 27/Line 28) | |||||||||
| 5) Crops Held for Sale and Feed | #DIV/0! | |||||||||||
| 6) Market Livestock | #DIV/0! | |||||||||||
| 7) Other Current Assets | #DIV/0! | COMBINED PERSONAL & FARM FINANCIAL RATIOS | ||||||||||
| 8) TOTAL CURRENT ASSETS | $0 | $0 | $0 | (adds lines 1-7) | Jan. 1 | Dec. 31 | Average | |||||
| Debt/Asset Ratio | (Line 33/Line 31) | |||||||||||
| 9) Breeding Livestock | #DIV/0! | Equity/Asset Ratio | (Line 35/Line 31) | |||||||||
| 10) Machinery and Equipment | #DIV/0! | Debt/Equity Ratio | (Line 33/Line 35) | |||||||||
| 11) Buildings | #DIV/0! | |||||||||||
| 12) Investments in Cooperatives | #DIV/0! | |||||||||||
| 13) Land | #DIV/0! | |||||||||||
| 14) TOTAL NONCURRENT ASSETS | $0 | $0 | $0 | (adds lines 9-13) | ||||||||
| 15) TOTAL FARM ASSETS | $0 | $0 | $0 | (adds lines 8 & 14) | ||||||||
| LIABILITIES AND NET WORTH: | ||||||||||||
| January 1 | December 31 | Average | Notes | |||||||||
| 16) Accounts Payable/Accrued Expenses | #DIV/0! | |||||||||||
| 17) Income & Social Security Taxes Payable | #DIV/0! | |||||||||||
| 18) Current Portion: Deferred Taxes | #DIV/0! | |||||||||||
| 19) Current Loans Due Within One Year | #DIV/0! | |||||||||||
| 20) Current Portion of Term Debt | #DIV/0! | |||||||||||
| 21) Accrued Interest | #DIV/0! | |||||||||||
| 22)TOTAL CURRENT LIABILITIES | $0 | $0 | $0 | (adds lines 16-21) | ||||||||
| 23) Noncurrent Portion: Deferred Taxes | #DIV/0! | |||||||||||
| 24) Noncurrent Portion: Intermediate Loans | #DIV/0! | |||||||||||
| 25) Noncurrent Portion: Long-term Loans | #DIV/0! | |||||||||||
| 26) TOTAL NONCURRENT LIABILITIES | $0 | $0 | $0 | (adds lines 23-25) | ||||||||
| 27) TOTAL FARM LIABILITIES | $0 | $0 | $0 | (adds lines 22 & 26) | ||||||||
| 28) FARM NET WORTH | $0 | $0 | $0 | (subtracts line 27 from 15) | ||||||||
| 29) TOTAL LIABILITIES AND NET WORTH | $0 | $0 | $0 | (adds line 27 & 28) | ||||||||
| January 1 | December 31 | Average | Notes | |||||||||
| 30) Total Personal Assets | $0 | $0 | $0 | |||||||||
| 31) TOTAL FARM AND PERSONAL ASSETS | $0 | $0 | $0 | (adds lines 15 & 30) | ||||||||
| 32) Total Personal Liabilities | $0 | $0 | $0 | |||||||||
| 33) TOTAL FARM AND PERSONAL LIABILITIES | $0 | $0 | $0 | (adds lines 27 & 32) | ||||||||
| 34) PERSONAL NET WORTH | $0 | $0 | $0 | (subtracts line 32 from 30) | ||||||||
| 35) TOTAL FARM AND PERSONAL NET WORTH | $0 | $0 | $0 | (subtracts line 33 from 31) | ||||||||
| INCOME STATEMENT for | Name | Date | FINANCIAL RATIOS | |||||||
| Farm Business Receipts: | Jan. 1 | Dec. 31 | Average | |||||||
| 1A) Crop Cash Sales ……………………………………………………………. | Current Ratio | (Balance Sheet Line 8/Balance Sheet Line 22) | ||||||||
| 1B) Ending Crop Inventory …………………………………………………. | $0 | Working Capital | $0 | $0 | $0 | (Balance Sheet Line 8-Balance Sheet Line 22) | ||||
| 1C) Beginning Crop Inventory ……………………………………………. | $0 | Working Capital Ratio | #DIV/0! | #DIV/0! | #DIV/0! | (Working Capital value/Line 6) | ||||
| 1D) Crop Insurance Proceeds ………………………………………………… | Debt/Asset Ratio | (Balance Sheet Line 27/Balance Sheet Line 15) | ||||||||
| 1) Accrual Gross Revenue from Crops ………………………………… | $0 | Equity/Asset Ratio | (Balance Sheet Line 28/Balance Sheet Line 15) | |||||||
| Debt/Equity Ratio | (Balance Sheet Line 27/Balance Sheet Line 28) | |||||||||
| 2A) Livestock and Milk Cash Sales ……………………………………… | ||||||||||
| 2B) Ending Livestock Inventory …………………………………………. | $0 | Rate of Return on Farm Assets | #DIV/0! | (Line 30+Line 27-Line 31)/Balance Sheet Line 15 Average | ||||||
| 2C) Beginning Livestock Inventory ……………………………………. | $0 | Rate of Return on Farm Equity | #DIV/0! | (Line 30-Line 31)/Balance Sheet Line 28 Average | ||||||
| 2D) Livestock Purchases………………………………………….……………. | Operating Profit Margin | #DIV/0! | (Line 30+Line 27-Line 31)/Line 8 | |||||||
| 2) Accrual Gross Revenue from Livestock and Milk…………… | $0 | Asset Turnover Ratio | #DIV/0! | (Line 8/Balance Sheet Line 15 Average) | ||||||
| Operating Expense Ratio | #DIV/0! | (Line 26/Line 6) | ||||||||
| 3) Agricultural Program Payments ……………………………………… | Depreciation Expense Ratio | #DIV/0! | (Line 28/Line 6) | |||||||
| 4) Accounts Receivable Adjustment………………………………….. | $0 | Interest Expense Ratio | #DIV/0! | (Line 27/Line 6) | ||||||
| 5) Other Farm Income ………………………………………………………. | Total Expense Ratio | #DIV/0! | (Line 29/Line 6) | |||||||
| Net Farm Income Ratio | #DIV/0! | (Line 30/Line 6) | ||||||||
| 6) ACCRUAL GROSS FARM REVENUE…..………………………..…….. | $0 | |||||||||
| Farm Business Expenses: | ||||||||||
| 7) Purchased Feed……………………………………………………………… | ||||||||||
| 8) VALUE OF FARM PRODUCTION………………………………………. | $0 | |||||||||
| 9) Labor Hired …………………………………………………………………. | ||||||||||
| 10) Repairs ……………………………………………………………………….. | ||||||||||
| 11) Seed …………………………………………………………………………. | ||||||||||
| 12) Fertilizer …………………………………………………………………….. | ||||||||||
| 13) Herbicide and Insecticide……………………………………………… | ||||||||||
| 14) Veterinarian Expense…………………………………………………… | ||||||||||
| 15) Storage & Marketing ….……………………………………………… | ||||||||||
| 16) Machinery Hire and Lease………………………………………….. | ||||||||||
| 17) Fuel and Oil……..………………………………………………………… | ||||||||||
| 18) Utilities………………………………………………………………………. | ||||||||||
| 19) Property Tax ……………………………………………………………….. | ||||||||||
| 20) Real Estate Tax……………………………………………………………. | ||||||||||
| 21) General Farm Insurance ……………………………………………… | ||||||||||
| 22) Crop Insurance Premiums …………………………………………. | ||||||||||
| 23) Cash Rent…………………………………………………………………….. | ||||||||||
| 24) Miscellaneous …………………………………………………………….. | ||||||||||
| 25) Expense Inventory Adjustment …………………………………. | $0 | |||||||||
| 26) ACCRUED OPERATING EXPENSES | $0 | |||||||||
| 27A) Cash Interest Paid……………………………………………………….. | ||||||||||
| 27B) Accrued Interest Adjustment……………………………………… | $0 | |||||||||
| 27) Total Interest Expenses………………………………………………… | $0 | |||||||||
| 28) Depreciation ……………………………………………………………….. | ||||||||||
| 29) TOTAL FARM BUSINESS EXPENSES…………………...…………… | $0 | |||||||||
| 30) NET FARM INCOME……………………………...………………………… | $0 | |||||||||
| 31) Value of Unpaid Labor and Management…………………….. | ||||||||||
no reviews yet
Please Login to review.
