jagomart
digital resources
picture1_Roi Calculator L


 178x       Filetype XLSX       File size 0.11 MB       Source: www.prinsco.com


File: Roi Calculator L
v201 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 ...

icon picture XLSX Filetype Excel XLSX | Posted on 16 Aug 2022 | 3 years ago
Partial file snippet.
                                                                                                                                                                 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
The words contained in this file might help you see if this file matches what you are looking for:

...V this document is intended for an estimate of roi on drain tile systems only it not tax or accounting purposes advice related concerns please contact your financial professional project information return investment acres average yield buacre break even year expected increase corn soybean truck crop wheat cost bracket increased operating expense cells shaded in green must be filled estimated price per bu economic analysis bushel additional gross income costs operation depreciation pretax savings net cash flow current cumulative irr reference data gds lists yearterms cropselection crops...

no reviews yet
Please Login to review.