Filetype Excel XLS | Posted on 16 Aug 2022 | 3 years ago
Authentication
digital resources
150x Filetype XLS File size 0.40 MB Source: www.ccim.com
Sheet 1: LICENSE
| NOSHOW | ||||||||||||||
| DCF Analysis Input Sheet -8/16/2022 | ||||||||||||||
| Property Assumptions | ||||||||||||||
| 1 | Name | |||||||||||||
| 2 | Location | |||||||||||||
| 3 | Type of Property | |||||||||||||
| 4 | Purpose of Analysis | |||||||||||||
| 5 | Prepared By | |||||||||||||
| 6 | Size (Square feet or Number of Units) | |||||||||||||
| 7 | Assessed/Appraised Value of Land | |||||||||||||
| 8 | Assessed/Appraised Value of Improvements | |||||||||||||
| 9 | Assessed/Appraised Value of Personal Property | |||||||||||||
| 10 | Useful Life of Improvements (Years) | |||||||||||||
| 11 | Useful Life of Personal Property (Years) | |||||||||||||
| 12 | Acquisition Price | |||||||||||||
| 13 | Acquisition Costs | |||||||||||||
| 14 | Potential Rental Income and Escalations | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Year 11 | ||
| 15 | Potential Rental Income | |||||||||||||
| 16 | Other Income (Collectable) | |||||||||||||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Year 11 | ||||
| 17 | Annual Vacancy Rates (Percent of Potential Rental Income) | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||
| 18 | Operating Expenses and Escalations | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Year 11 | |||
| 19 | Total Operating Expenses | |||||||||||||
| Financing Assumptions | 1st Mortgage | 2nd Mortgage | ||||||||||||
| 20 | Loan Amount | |||||||||||||
| 21 | Interest Rate | |||||||||||||
| 22 | Amortization Period (Years) | |||||||||||||
| 23 | Loan Term (Years) | |||||||||||||
| 24 | Payments Per Year | 0 | ||||||||||||
| 25 | Loan Costs | |||||||||||||
| Investor/Owner Assumptions | ||||||||||||||
| 26 | Ordinary Income Marginal Tax Rate | |||||||||||||
| 27 | Capital Gains Tax Rate | |||||||||||||
| 28 | Cost Recovery Recapture Tax Rate | |||||||||||||
| 29 | Anticipated Holding Period (1 - 10 Years) | |||||||||||||
| 30 | Disposition Price | |||||||||||||
| 31 | Disposition Cost of Sale | |||||||||||||
| Property Name | 0 | Acquisition Price | $0 | ||||||||||||||
| Location | 0 | Plus Acquisition Costs | $0 | ||||||||||||||
| Type of Property | 0 | Plus Loan Costs | $0 | ||||||||||||||
| Size of Property (sf/units) | 0 | Minus Mortgages | $0 | ||||||||||||||
| Purpose of Analysis | 0 | Equals Initial Investment | $0 | ||||||||||||||
| Prepared by | 0 | ||||||||||||||||
| Date Prepared | August 16, 2022 | ||||||||||||||||
| MORTGAGE DATA | COST RECOVERY DATA | BASIS DATA | |||||||||||||||
| 1st Mortgage | 2nd Mortgage | Improvements | Personal Property | ||||||||||||||
| Amount | $0 | $0 | Value | $0 | $0 | Acquisition Price | $0 | ||||||||||
| Interest Rate | 0.00% | 0.00% | C. R. Method | SL | SL | Acquisition Costs | $0 | ||||||||||
| Amortization Period | 0 | 0 | Useful Life | 0.0 | 0 | Total Acquisition Basis | $0 | ||||||||||
| Loan Term | 0 | 0 | In Service Date | 1-Jan | 1-Jan | ||||||||||||
| Payments/Year | 0 | 0 | Date of Sale | 31-Dec | 31-Dec | ||||||||||||
| Periodic Payment | $0.00 | $0.00 | 12 Months % age | 0.000% | 0.000% | ||||||||||||
| Annual Debt Service | $0 | $0 | 11.5 Months % age | 0.000% | 0.000% | ||||||||||||
| Loan Fees/Costs | $0 | $0 | |||||||||||||||
| TAXABLE INCOME | |||||||||||||||||
| End of Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | ||||||
| 1 | POTENTIAL RENTAL INCOME | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| 2 | -Vacancy & Credit Losses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| 3 | EFFECTIVE RENTAL INCOME | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| 4 | +Other Income (collectable) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| 5 | GROSS OPERATING INCOME | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| 6 | TOTAL OPERATING EXPENSES | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| 7 | NET OPERATING INCOME | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| 8 | -Interest-First Mortgage | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| 9 | -Interest-Second Mortgage | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| 10 | -Cost Recovery-Improvements | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| 11 | -Cost Recovery-Personal Property | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| 12 | -Loan Costs Amortization | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| 13 | - | ||||||||||||||||
| 14 | - | ||||||||||||||||
| 15 | REAL ESTATE TAXABLE INCOME | $0 | |||||||||||||||
| 16 | Tax Liability (Savings) at 0% | $0 | |||||||||||||||
| CASH FLOW | |||||||||||||||||
| 17 | NET OPERATING INCOME (Line 7) | $0 | |||||||||||||||
| 18 | -Annual Debt Service | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| 19 | - | ||||||||||||||||
| 20 | - | ||||||||||||||||
| 21 | - | ||||||||||||||||
| 22 | CASH FLOW BEFORE TAXES | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| 23 | -Tax Liability (Savings) (Line 16 ) | ||||||||||||||||
| 24 | CASH FLOW AFTER TAXES | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||
no reviews yet
Please Login to review.
