05:03Monthly Cash Flow Projection Introduction

00:35Introduction by Pauline Van Nurden 02:45General Information 01:32Length of Plan 02:32Crop Plan 04:54Livestock Plan - Dairy Example 04:01Livestock Plan - Hog Example 03:03Livestock Plan - Steer Example 00:45Blank Livestock 06:19Crop Sales & Purchases 02:25Generic Hay 03:22Expenses 01:03Pattern - Quickly Enter a Distribution 02:52Toggle Between Distributions and Dollars 02:09Show Historic FINAN / Sch. F Data 02:10Other Cash Flows 01:51Capital Purchases 02:42Capital Sales 03:14New Borrowings 01:34Loan Payments 03:53Using the Loan Calculator 02:24Annual Operating Loan 03:33Ending Balance Sheet 02:40Depreciation

00:38Introduction by Katie Wilts Johnson 02:03Start the Case Farm Download Case Write-up and Results 02:49Review Crop and Livestock Data Entry 02:27Review Crop Sales and Purchases 02:43Review Expense and Other Cash Flows Data Entry 02:54Review New Borrowings, Loans, Depreciation and Balance Sheet Data Entry

00:07Introduction by Curtis Mahnken 00:59Go to 00:55Deleting Rows in Data Entry 01:29Multiple Harvest Months 00:47Repeat Last Number 00:43Crop Sales and Purchases Detail 01:35Expense Detail 01:34Paying Down Accounts Payable 01:02Family Living Detail 01:40Gain / Loss on Capital Sale 02:18Government Crop Loan Liquidation 01:45New Government Crop Loans 00:44Loans – Interest Rate Detail 01:03Loans – Loan Payment Detail 02:30Loans – Capital Sale to Pay Off a Loan 03:15Loans – Refinancing a Loan 00:51Handling Debt Forgiveness 00:51Estimated Principal Due Next Year 01:56Prepaid Expense Detail 01:33Value of Labor and Management 02:40Multiple Years 01:51Monitoring Worksheet 00:56AUMs

00:37Introduction by Pauline Van Nurden and Curtis Mahnken 02:22Cash Flow Summary 06:46Monthly Cash Flow 02:54Production & Inventory Summary 04:06Business Performance 02:44Term Debt Coverage & Financial Standards 00:58Balance Sheet 03:01Final Evaluation

Monthly Cash Flow Projections Quiz