178x Filetype XLSX File size 0.11 MB Source: www.prinsco.com
V.2.0.1 *This document is intended for an estimate of ROI on drain tile systems only. It is not intended for tax or accounting purposes. For advice on tax related concerns, please contact your financial professional. Project Information Return on Investment 20.1% Project Acres 200 Average Yield (bu/acre) 160 Break Even Year 5 Expected Yield Increase (bu/acre) Expected Increase (%) Corn 30 18.75% Soybean 10 6.25% Truck Crop 10 6.25% Wheat 10 6.25% Project Cost $ 50,000 Tax Bracket (%) 20% Increased Operating Expense 10 *Cells shaded in green must be filled in. Estimated Crop Price (per Bu.) Year 1 2 3 4 5 6 7 8 9 10 Crop Corn Soybean Corn Soybean Corn Soybean Corn Soybean Corn Soybean Price $ 3.00 $ 4.00 $ 3.00 $ 4.00 $ 3.00 $ 4.00 $ 3.00 $ 4.00 $ 3.00 $ 4.00 Economic Analysis Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Crop Corn Soybean Corn Soybean Corn Soybean Corn Soybean Corn Soybean Price (per Bushel) $ 3.00 $ 4.00 $ 3.00 $ 4.00 $ 3.00 $ 4.00 $ 3.00 $ 4.00 $ 3.00 $ 4.00 Additional Yield (Bu) 6,000 2,000 6,000 2,000 6,000 2,000 6,000 2,000 6,000 2,000 Estimated Gross Income: Additional Yield Income $ 18,000 $ 8,000 $ 18,000 $ 8,000 $ 18,000 $ 8,000 $ 18,000 $ 8,000 $ 18,000 $ 8,000 Estimated costs: Operation Costs $ 10 $ 10 $ 10 $ 10 $ 10 $ 10 $ 10 $ 10 $ 10 $ 10 Estimated Depreciation $ 5,355 $ 9,565 $ 7,515 $ 6,125 $ 6,125 $ 6,125 $ 6,125 $ 3,065 $ - $ - Gross Income (pretax) $ 12,635 $ (1,575) $ 10,475 $ 1,865 $ 11,865 $ 1,865 $ 11,865 $ 4,925 $ 17,990 $ 7,990 Estimated Income Tax (cost)/savings $ (2,527) $ 315 $ (2,095) $ (373) $ (2,373) $ (373) $ (2,373) $ (985) $ (3,598) $ (1,598) Estimated Net Income $ 10,108 $ (1,260) $ 8,380 $ 1,492 $ 9,492 $ 1,492 $ 9,492 $ 3,940 $ 14,392 $ 6,392 Cash flow: Estimated Net Income $ 10,108 $ (1,260) $ 8,380 $ 1,492 $ 9,492 $ 1,492 $ 9,492 $ 3,940 $ 14,392 $ 6,392 Estimated Depreciation $ 5,355 $ 9,565 $ 7,515 $ 6,125 $ 6,125 $ 6,125 $ 6,125 $ 3,065 $ - $ - Current cash flow $ 15,463 $ 8,305 $ 15,895 $ 7,617 $ 15,617 $ 7,617 $ 15,617 $ 7,005 $ 14,392 $ 6,392 Cumulative Cash Flow $ 15,463 $ 23,768 $ 39,663 $ 47,280 $ 62,897 $ 70,514 $ 86,131 $ 93,136 $ 107,528 $ 113,920 Break Even 0.00 1.00 2.00 3.00 4.00 5.00 6.00 7.00 8.00 9.00 0.00 0.00 0.00 0.00 5.00 6.00 7.00 8.00 9.00 10.00 0.00 0.00 0.00 0.00 5.00 0.00 0.00 0.00 0.00 0.00 IRR Cash flow - 50,000 15,463 8,305 15,895 7,617 15,617 7,617 15,617 7,005 14,392 6,392 20.1% Reference Tax Data 2014 7-Year GDS Reference Lists 10.71 Lists 19.13 YearTerms CropSelection 15.03 5 Corn 12.25 10 Soybean 12.25 15 Truck Crops 12.25 Wheat 12.25 6.13
no reviews yet
Please Login to review.