Apartment Block Acquisition Model - 20 year Three Statement Analysis

Description
This Apartment Block Acquisition Model produces 20 years of Three Statement Analysis and Valuations, The model also provides for computation of Taxation and Capital Gain Tax to provide the user with an excellent overview of realistic returns. The Cash Flows produce month by month for 20 years so the model will provide a very good idea of how much cash is absorbed and every stage of the Investment, The Income Statements and Balance Sheets are annualised over the 20-year period. The model is extremely easy to use and easily adaptable for any circumstance. The most important features are to use the Loan amortization, vacancy rates, and annual escalations for both Income and Expenditure. You are able to zero out Capital Gains Tax provisions if that is suitable for the territory. The amount of gearing is crucial to any investment proposition, and the subsequent tax and valuations. We make use of IRR, MIRR and NPV for valuations and provide a month-by-month 20-year Cash flow statement so that the user will get a very good idea of how much cash is absorbed in the prospective Investment. The difference between the Purchase Price and the amount of gearing will go to the owner's loan account wherein the user will apply an appropriate (opportunity cost %) on this amount.