Norway-Florida Fund IRR Verification Report

Posted by Joe Manausa on Sunday, March 7th, 2010 at 12:59am.

Norway-Florida Fund IRR Verification Report

These cash flows and dates are those on which the Net Present Value After Tax in our analysis of the Norway-Florida Fund are based. Our analysis plans operating cash flows monthly, and assumes that cash flows occurring during the month all occur at the middle of the month.Calculators and Spreadsheets typically schedule these cash flows at the end of the year (year-end convention).Since cash flows do actually occur unevenly during the year, the mid-month convention is more accurate. The Internal Rate of Return (IRR) is defined as the Present Value Discount Rate which makes the Net Present Value of the Cash Flows involved equal to zero. The Net Present Value of $0.00 shown below demonstrates that the Net Present Value of these Cash Flows is very close to zero when discounted at 16.1811% and, in turn, the IRR of the Cash Flows is very close to 16.1811%.

Date Years Cash Flow Present Value Discount Factor Present Value at 16.1811%
1 Jun 2010 0.00 ($475,800.00) 1.0000000 ($475,800.00)
15 Jun 2010 0.04 (2,669.00) 0.9942638 (2,653.69)
15 Jul 2010 0.12 (2,669.00) 0.9820826 (2,621.18)
15 Aug 2010 0.21 (2,669.00) 0.9696522 (2,588.00)
15 Sep 2010 0.29 1,118.00 0.9573790 1,070.35
15 Oct 2010 0.37 1,118.00 0.9456497 1,057.24
15 Nov 2010 0.46 1,118.00 0.9336804 1,043.85
15 Dec 2010 0.54 1,118.00 0.9222414 1,031.07
15 Jan 2011 0.62 1,118.00 0.9105684 1,018.02
15 Feb 2011 0.71 1,118.00 0.8990431 1,005.13
15 Mar 2011 0.79 1,118.00 0.8887586 993.63
15 Apr 2011 0.87 1,118.00 0.8775093 981.06
15 May 2011 0.95 1,118.00 0.8667585 969.04
15 Jun 2011 1.04 1,118.00 0.8557877 956.77
15 Jul 2011 1.12 1,118.00 0.8453031 945.05
15 Aug 2011 1.21 1,118.00 0.8346038 933.09
15 Sep 2011 1.29 1,156.00 0.8240401 952.59
15 Oct 2011 1.37 1,156.00 0.8139443 940.92
15 Nov 2011 1.46 1,156.00 0.8036420 929.01
15 Dec 2011 1.54 1,156.00 0.7937962 917.63
15 Jan 2012 1.62 1,156.00 0.7837489 906.01
15 Feb 2012 1.71 1,156.00 0.7738288 894.55
15 Mar 2012 1.79 1,156.00 0.7646624 883.95
15 Apr 2012 1.87 1,156.00 0.7549839 872.76
15 May 2012 1.96 1,156.00 0.7457342 862.07
15 Jun 2012 2.04 1,156.00 0.7362953 851.16
15 Jul 2012 2.12 1,156.00 0.7272746 840.73
15 Aug 2012 2.21 1,156.00 0.7180693 830.09
15 Sep 2012 2.29 1,194.00 0.7089805 846.52
15 Oct 2012 2.38 1,194.00 0.7002944 836.15
15 Nov 2012 2.46 1,194.00 0.6914306 825.57
15 Dec 2012 2.54 1,194.00 0.6829596 815.45
15 Jan 2013 2.63 1,194.00 0.6743152 805.13
15 Feb 2013 2.71 1,194.00 0.6657802 794.94
15 Mar 2013 2.79 1,194.00 0.6581641 785.85
15 Apr 2013 2.87 1,194.00 0.6498335 775.90
15 May 2013 2.96 1,194.00 0.6418721 766.40
15 Jun 2013 3.04 1,194.00 0.6337477 756.69
15 Jul 2013 3.12 1,194.00 0.6259834 747.42
15 Aug 2013 3.21 1,194.00 0.6180602 737.96
15 Sep 2013 3.29 1,233.00 0.6102372 752.42
15 Oct 2013 3.38 1,233.00 0.6027609 743.20
15 Nov 2013 3.46 1,233.00 0.5951316 733.80
15 Dec 2013 3.54 1,233.00 0.5878404 724.81
15 Jan 2014 3.63 1,233.00 0.5803999 715.63
15 Feb 2014 3.71 1,233.00 0.5730536 706.58
15 Mar 2014 3.79 1,233.00 0.5664982 698.49
15 Apr 2014 3.87 1,233.00 0.5593279 689.65
15 May 2014 3.96 1,233.00 0.5524753 681.20
15 Jun 2014 4.04 1,233.00 0.5454825 672.58
15 Jul 2014 4.12 1,233.00 0.5387995 664.34
15 Aug 2014 4.21 1,233.00 0.5319798 655.93
15 Sep 2014 4.29 1,272.00 0.5252464 668.11
15 Oct 2014 4.38 1,272.00 0.5188114 659.93
15 Nov 2014 4.46 1,272.00 0.5122446 651.58
15 Dec 2014 4.54 1,272.00 0.5059689 643.59
15 Jan 2015 4.63 1,272.00 0.4995647 635.45
15 Feb 2015 4.71 1,272.00 0.4932416 627.40
15 Mar 2015 4.79 1,272.00 0.4875992 620.23
15 Apr 2015 4.87 1,272.00 0.4814275 612.38
15 May 2015 4.96 1,272.00 0.4755293 604.87
15 Jun 2015 5.04 1,272.00 0.4695104 597.22
15 Jul 2015 5.12 1,272.00 0.4637582 589.90
15 Aug 2015 5.21 1,272.00 0.4578883 582.43
15 Sep 2015 5.29 1,311.00 0.4520927 592.69
15 Oct 2015 5.38 1,311.00 0.4465539 585.43
15 Nov 2015 5.46 1,311.00 0.4409018 578.02
15 Dec 2015 5.54 1,311.00 0.4355001 570.94
15 Jan 2016 5.63 1,311.00 0.4299878 563.71
15 Feb 2016 5.71 1,311.00 0.4245454 556.58
15 Mar 2016 5.79 1,311.00 0.4195164 549.99
15 Apr 2016 5.88 1,311.00 0.4142065 543.02
15 May 2016 5.96 1,311.00 0.4091318 536.37
15 Jun 2016 6.04 1,311.00 0.4039533 529.58
15 Jul 2016 6.13 1,311.00 0.3990043 523.09
15 Aug 2016 6.21 1,311.00 0.3939540 516.47
15 Sep 2016 6.30 1,351.00 0.3889676 525.50
15 Oct 2016 6.38 1,351.00 0.3842022 519.06
15 Nov 2016 6.46 1,351.00 0.3793393 512.49
15 Dec 2016 6.55 1,351.00 0.3746918 506.21
15 Jan 2017 6.63 1,351.00 0.3699492 499.80
15 Feb 2017 6.72 1,351.00 0.3652667 493.48
15 Mar 2017 6.79 1,351.00 0.3610882 487.83
15 Apr 2017 6.88 1,351.00 0.3565179 481.66
15 May 2017 6.96 1,351.00 0.3521500 475.75
1 Jun 2017 7.01 1,213,627.00 0.3496987 424,403.72
TOTALS   $829,387.00   $0.00
     

The following reports are available for review:

Joe Manausa, MBA is a 26 year veteran of real estate brokerage in Tallahassee, Florida and has owned and managed his own company since 1992. He is a daily blogger with content that focuses on real estate analytics and providing his clients with a tactical advantage in today's challenging market.

Leave a Comment