How is your Financial Analysis Website Created?This Financial Analysis Website (hosted for you by planEASe) can be created for each of your analyses by selecting the File / Publish To Web Menu Option at the Assumption Edit Screen in the planEASe Software. If you upload photos, the first one will show atop the Summary, otherwise a google map will be shown there, based on an address or coordinates that you enter. Your own summary description will display here. How do you Navigate within this Financial Analysis Website?Click any underlined word or phrase to drilldown into the financial analysis. On most tabs that you click on at the top, a (print view) option will be shown for the report. How to distribute your Financial Analysis Website?Once you have published an analysis, you can email a link (the URL) to the analysis to clients or colleagues so that they can view the analysis later, or simultaneously with you. Optionally, analyses can be password protected at two levels. What can you Publish?- Investment Analysis (Apartments, Offices, Retail, etc.)
- Development Analysis (Apartments, Offices, Retail, etc.)
- Unit Sales Analysis (if you have the Monthly Extension)
- Tenant Representation Analysis
- Owner Representation Analysis
- Partnership / LLC Analysis (if you have the Partnership / LLC Models)
- Portfolio Analysis (if you have the Portfolio Extension)
What is Customizable?- All the colors
- The fonts
- Three logo images can be uploaded
- The choice of including a map
- Adding a summary description
- Adding Extensive Description (shows as its own tab)
- Before Tax or After Tax
- Which Ratios are Shown
- Expenses Total or Detail
- Revenues Total or Detail
- Loans Total or Detail
- Capital Spending Items Total or Detail
- Reimbursements Total or Detail
- Additional photos related to the analysis
- Additional documents related to the analysis
| | Pine Lake HomeSites (120 units) | | |
| Unit Sales Summary | View Project Details | | Total Unit Sales Planned | $3,140,000 | | Less: Sale Commissions | 188,400 | | Net Sales Planned | $2,951,600 | | Less: Total Cost Planned | $2,170,310 | | Profit before Debt Costs | $781,290 | | Less: Draw Loan Interest & Fees | $127,619 | | Project Profit | $653,671 |
| Before Debt (IRR) | 38.9% | | Before Tax (IRR) | 87.7% | | After Tax (IRR) | 53.8% | | Net Present Value Before Debt @10% | 509,562 | | Net Present Value Before Tax @10% | 504,477 | | Net Present Value After Tax @10% | 280,058 |
| Cost Item | $/Unit | Total % | Total $ |
|---|
| Land | 8,750.00 | 48.38% | 1,050,000 | | Total | $8,750.00 | 48.38% | $1,050,000 | | | | | | Site Development | | | | | Clearing & Grading | 495.24 | 2.74% | 59,429 | | Paving | 997.19 | 5.51% | 119,663 | | Curb & Gutter | 559.16 | 3.09% | 67,100 | | Sanitary Sewer | 1,337.95 | 7.40% | 160,554 | | Storm Sewer | 516.25 | 2.85% | 61,950 | | Water | 541.72 | 3.00% | 65,006 | | Entrance | 316.83 | 1.75% | 38,020 | | Power & Street Lighting | 78.35 | 0.43% | 9,402 | | Amenity | 2,376.25 | 13.14% | 285,150 | | Contingency | 291.67 | 1.61% | 35,000 | | Total Site Development | $7,510.61 | 41.53% | $901,274 | | | | | | Engineering | | | | | Design | 312.50 | 1.73% | 37,500 | | Layout | 212.93 | 1.18% | 25,552 | | Total Engineering | $525.43 | 2.91% | $63,052 | | | | | | Other Costs | | | | | Taxes & Insurance | 100.00 | 0.55% | 12,000 | | Legal & Closing | 108.33 | 0.60% | 13,000 | | Appraisal | 41.67 | 0.23% | 5,000 | | Marketing & Advertising | 533.20 | 2.95% | 63,984 | | County Fees | 16.67 | 0.09% | 2,000 | | Development Fees | 500.00 | 2.76% | 60,000 | | Total Other Costs | $1,299.87 | 7.19% | $155,984 | | | | | | Total Project Cost | $18,085.92 | 100.00% | $2,170,310 | | | | | |
'>
'>
The IRR is the discount rate that makes the NPV zero hence, if the IRR is exactly the same as the discount rate, the NPV would be zero (rounding means it is usually very close to zero). The IRR and the NPV use the same cash flows and the same process. The IRR simply runs lots of NPV's seaching for the discount rate that returns a NPV that is close to zero.
The IRR can be compared to the redemption yield of a bond, or the APY on a bank account.
After Tax Cash Flows for IRR and NPV
| MM/DD/YY | Cash Flow |
|---|
| 01/15/2012 | $0 |
| 02/15/2012 | ($525,000) |
| 03/15/2012 | $0 |
| 04/15/2012 | $0 |
| 05/15/2012 | $0 |
| 06/15/2012 | $0 |
| 07/15/2012 | $95,425 |
| 08/15/2012 | $11,530 |
| 09/15/2012 | $11,530 |
| 10/15/2012 | $72,170 |
| 11/15/2012 | $61,295 |
| 12/15/2012 | ($15,877) |
| 01/15/2013 | $60,637 |
| 02/15/2013 | ($33,356) |
| 03/15/2013 | $40,583 |
| 04/15/2013 | ($17,574) |
| 05/15/2013 | $39,633 |
| 06/15/2013 | ($18,532) |
| 07/15/2013 | $38,667 |
| 08/15/2013 | $45,445 |
| 09/15/2013 | $173,396 |
| 10/15/2013 | $54,067 |
| 11/15/2013 | $82,236 |
| 12/15/2013 | $54,067 |
| 01/15/2014 | $82,236 |
| 02/15/2014 | $54,067 |
| 03/15/2014 | $28,169 |
| 04/15/2014 | $0 |
| 05/15/2014 | $0 |
| 06/15/2014 | $0 |
| 07/15/2014 | $0 |
| 08/15/2014 | $0 |
| 09/15/2014 | $0 |
| 10/15/2014 | $0 |
| 11/15/2014 | $0 |
| 12/15/2014 | $0 |
All the IRR's and NPV's are computed on a monthly basis using the XIRR and XNPV process which is designed to handle irregular cash flows. To verify the IRR or NPV a spreadsheet program like Excel, Google Spreadsheets, Matlab, etc. will need to be used, because most financial calculators are not able to compute irregular dates and cash flows like the table shown.
Here are links to other descriptions of XIRR and XNPV:
Directions for XIRR/XNPV Excel Verification - Open Excel and try to insert function/financial/XIRR or XNPV
- If the XIRR or XNPV is not there, select Tools/Add-ins, and add the analysis toolpak.
- Copy and paste the cash flows shown into excel. If the paste does not go into separate columns try a paste special as text.
- Insert the function/financial/XIRR or XNPV and highlight the dates, and cash flows as directed by the function.
How is a monthly IRR or NPV different from a Yearly IRR or NPV? A Yearly IRR assumes that there is one total Cash Flow amount each year. If you are using an End-of-Period Convention, that Cash Flow is assumed to occur at the end of the year. Using this method, for example, a 30 year 12% mortgage evaluates to a 12% IRR for the lender. Most bankers know this is false, and they will consider the fact that the payments are received each month rather than at the end of the year, and correctly calculate that their IRR (Lender's Yield) on the mortgage is 12.68%. It is easy to correct for this calculation deficiency (since the monthly payment is always the same) by using a "Mid-Year Convention" which assumes that the annual cash flow occurs at the mid-point of the year involved. Using this convention, the computed Yearly IRR for the 12% mortgage returns to the (correct) 12.68%. For the Mid-Year Convention to be accurate in computing IRR and NPV, however, the monthly cash flows must all be equal. This is almost always false with real estate investments, and in some cases it is grossly false. Consider development or other capital spending items such as rehabilitation. Think of the cash flow effect of re-financing or monthly draws on a development loan. Consider that leases end --- and their renewals (or new tenants) may involve Vacant Periods, Free Rent, Tenant Improvements and Commissions, all of which do not occur in convenient annual time frames. These and other events combine to assure that the monthly cash flows for real estate investments are and will be unequal. In turn, Yearly IRR and NPV calculations are almost always inaccurate, and sometimes grossly inaccurate. For these reasons, competent real estate analysis software must compute monthly cash flows and compute the IRR and NPV measures on a monthly basis if those measures are to be accurate. Since these measures are continuously used in practice to compare and decide between real estate (and other) investments, accuracy is mandatory if proper decisions are to be made. In recognition of this, Excel (for example) corrected it's previous (until 1996) Yearly IRR and NPV routines with new XIRR and NPV routines that expressly consider the date of a cash flow rather than assuming they occur a year apart. Other spreadsheet programs such as Google and MATLAB also now offer this capability.
The IRR is the discount rate that makes the NPV zero hence, if the IRR is exactly the same as the discount rate, the NPV would be zero (rounding means it is usually very close to zero). The IRR and the NPV use the same cash flows and the same process. The IRR simply runs lots of NPV's seaching for the discount rate that returns a NPV that is close to zero.
The IRR can be compared to the redemption yield of a bond, or the APY on a bank account.
Before Tax Cash Flows for IRR and NPV
| MM/DD/YY | Cash Flow |
|---|
| 01/15/2012 | $0 |
| 02/15/2012 | $0 |
| 03/15/2012 | ($525,000) |
| 04/15/2012 | $0 |
| 05/15/2012 | $0 |
| 06/15/2012 | $0 |
| 07/15/2012 | $0 |
| 08/15/2012 | $98,700 |
| 09/15/2012 | $14,805 |
| 10/15/2012 | $14,805 |
| 11/15/2012 | $80,605 |
| 12/15/2012 | $59,455 |
| 01/15/2013 | ($261,518) |
| 02/15/2013 | $79,195 |
| 03/15/2013 | ($21,667) |
| 04/15/2013 | $59,455 |
| 05/15/2013 | ($4,888) |
| 06/15/2013 | $59,455 |
| 07/15/2013 | ($4,888) |
| 08/15/2013 | $59,455 |
| 09/15/2013 | $60,718 |
| 10/15/2013 | $195,014 |
| 11/15/2013 | $65,800 |
| 12/15/2013 | $100,580 |
| 01/15/2014 | $714,029 |
| 02/15/2014 | $100,580 |
| 03/15/2014 | $65,800 |
| 04/15/2014 | $34,780 |
| 05/15/2014 | $0 |
| 06/15/2014 | $0 |
| 07/15/2014 | $0 |
| 08/15/2014 | $0 |
| 09/15/2014 | $0 |
| 10/15/2014 | $0 |
| 11/15/2014 | $0 |
| 12/15/2014 | $0 |
All the IRR's and NPV's are computed on a monthly basis using the XIRR and XNPV process which is designed to handle irregular cash flows. To verify the IRR or NPV a spreadsheet program like Excel, Google Spreadsheets, Matlab, etc. will need to be used, because most financial calculators are not able to compute irregular dates and cash flows like the table shown.
Here are links to other descriptions of XIRR and XNPV:
Directions for XIRR/XNPV Excel Verification - Open Excel and try to insert function/financial/XIRR or XNPV
- If the XIRR or XNPV is not there, select Tools/Add-ins, and add the analysis toolpak.
- Copy and paste the cash flows shown into excel. If the paste does not go into separate columns try a paste special as text.
- Insert the function/financial/XIRR or XNPV and highlight the dates, and cash flows as directed by the function.
How is a monthly IRR or NPV different from a Yearly IRR or NPV? A Yearly IRR assumes that there is one total Cash Flow amount each year. If you are using an End-of-Period Convention, that Cash Flow is assumed to occur at the end of the year. Using this method, for example, a 30 year 12% mortgage evaluates to a 12% IRR for the lender. Most bankers know this is false, and they will consider the fact that the payments are received each month rather than at the end of the year, and correctly calculate that their IRR (Lender's Yield) on the mortgage is 12.68%. It is easy to correct for this calculation deficiency (since the monthly payment is always the same) by using a "Mid-Year Convention" which assumes that the annual cash flow occurs at the mid-point of the year involved. Using this convention, the computed Yearly IRR for the 12% mortgage returns to the (correct) 12.68%. For the Mid-Year Convention to be accurate in computing IRR and NPV, however, the monthly cash flows must all be equal. This is almost always false with real estate investments, and in some cases it is grossly false. Consider development or other capital spending items such as rehabilitation. Think of the cash flow effect of re-financing or monthly draws on a development loan. Consider that leases end --- and their renewals (or new tenants) may involve Vacant Periods, Free Rent, Tenant Improvements and Commissions, all of which do not occur in convenient annual time frames. These and other events combine to assure that the monthly cash flows for real estate investments are and will be unequal. In turn, Yearly IRR and NPV calculations are almost always inaccurate, and sometimes grossly inaccurate. For these reasons, competent real estate analysis software must compute monthly cash flows and compute the IRR and NPV measures on a monthly basis if those measures are to be accurate. Since these measures are continuously used in practice to compare and decide between real estate (and other) investments, accuracy is mandatory if proper decisions are to be made. In recognition of this, Excel (for example) corrected it's previous (until 1996) Yearly IRR and NPV routines with new XIRR and NPV routines that expressly consider the date of a cash flow rather than assuming they occur a year apart. Other spreadsheet programs such as Google and MATLAB also now offer this capability.
The IRR is the discount rate that makes the NPV zero hence, if the IRR is exactly the same as the discount rate, the NPV would be zero (rounding means it is usually very close to zero). The IRR and the NPV use the same cash flows and the same process. The IRR simply runs lots of NPV's seaching for the discount rate that returns a NPV that is close to zero.
The IRR can be compared to the redemption yield of a bond, or the APY on a bank account.
After Tax Cash Flows for IRR and NPV
| MM/DD/YY | Cash Flow |
|---|
| 01/15/2012 | $0 |
| 02/15/2012 | ($525,000) |
| 03/15/2012 | $0 |
| 04/15/2012 | $0 |
| 05/15/2012 | $0 |
| 06/15/2012 | $0 |
| 07/15/2012 | $95,425 |
| 08/15/2012 | $11,530 |
| 09/15/2012 | $11,530 |
| 10/15/2012 | $72,170 |
| 11/15/2012 | $61,295 |
| 12/15/2012 | ($15,877) |
| 01/15/2013 | $60,637 |
| 02/15/2013 | ($33,356) |
| 03/15/2013 | $40,583 |
| 04/15/2013 | ($17,574) |
| 05/15/2013 | $39,633 |
| 06/15/2013 | ($18,532) |
| 07/15/2013 | $38,667 |
| 08/15/2013 | $45,445 |
| 09/15/2013 | $173,396 |
| 10/15/2013 | $54,067 |
| 11/15/2013 | $82,236 |
| 12/15/2013 | $54,067 |
| 01/15/2014 | $82,236 |
| 02/15/2014 | $54,067 |
| 03/15/2014 | $28,169 |
| 04/15/2014 | $0 |
| 05/15/2014 | $0 |
| 06/15/2014 | $0 |
| 07/15/2014 | $0 |
| 08/15/2014 | $0 |
| 09/15/2014 | $0 |
| 10/15/2014 | $0 |
| 11/15/2014 | $0 |
| 12/15/2014 | $0 |
All the IRR's and NPV's are computed on a monthly basis using the XIRR and XNPV process which is designed to handle irregular cash flows. To verify the IRR or NPV a spreadsheet program like Excel, Google Spreadsheets, Matlab, etc. will need to be used, because most financial calculators are not able to compute irregular dates and cash flows like the table shown.
Here are links to other descriptions of XIRR and XNPV:
Directions for XIRR/XNPV Excel Verification - Open Excel and try to insert function/financial/XIRR or XNPV
- If the XIRR or XNPV is not there, select Tools/Add-ins, and add the analysis toolpak.
- Copy and paste the cash flows shown into excel. If the paste does not go into separate columns try a paste special as text.
- Insert the function/financial/XIRR or XNPV and highlight the dates, and cash flows as directed by the function.
How is a monthly IRR or NPV different from a Yearly IRR or NPV? A Yearly IRR assumes that there is one total Cash Flow amount each year. If you are using an End-of-Period Convention, that Cash Flow is assumed to occur at the end of the year. Using this method, for example, a 30 year 12% mortgage evaluates to a 12% IRR for the lender. Most bankers know this is false, and they will consider the fact that the payments are received each month rather than at the end of the year, and correctly calculate that their IRR (Lender's Yield) on the mortgage is 12.68%. It is easy to correct for this calculation deficiency (since the monthly payment is always the same) by using a "Mid-Year Convention" which assumes that the annual cash flow occurs at the mid-point of the year involved. Using this convention, the computed Yearly IRR for the 12% mortgage returns to the (correct) 12.68%. For the Mid-Year Convention to be accurate in computing IRR and NPV, however, the monthly cash flows must all be equal. This is almost always false with real estate investments, and in some cases it is grossly false. Consider development or other capital spending items such as rehabilitation. Think of the cash flow effect of re-financing or monthly draws on a development loan. Consider that leases end --- and their renewals (or new tenants) may involve Vacant Periods, Free Rent, Tenant Improvements and Commissions, all of which do not occur in convenient annual time frames. These and other events combine to assure that the monthly cash flows for real estate investments are and will be unequal. In turn, Yearly IRR and NPV calculations are almost always inaccurate, and sometimes grossly inaccurate. For these reasons, competent real estate analysis software must compute monthly cash flows and compute the IRR and NPV measures on a monthly basis if those measures are to be accurate. Since these measures are continuously used in practice to compare and decide between real estate (and other) investments, accuracy is mandatory if proper decisions are to be made. In recognition of this, Excel (for example) corrected it's previous (until 1996) Yearly IRR and NPV routines with new XIRR and NPV routines that expressly consider the date of a cash flow rather than assuming they occur a year apart. Other spreadsheet programs such as Google and MATLAB also now offer this capability.
|