321x 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.