Parc Komo is a freehold condo
Laying Out the Model
We should also think about how we want to lay it out so we keep our workspace clean. In Excel, one of the best ways to organize financial models is to separate certain sections of the model on different worksheets.
We can give each tab a name that describes the information contained in it. This way, other users of the model can better understand where data is calculated in the model and how it flows.
In our investment property model, let's use four tabs: property, financing, expenses and financials. Property, financing and expenses will be the tabs on which we input assumption and make projections for our model. The financials tab will be our results page where we will display the output of our model in a way that's easily understood.
Forecasting Revenues
Let's start with the property tab by renaming the tab "Property" and adding this title in cell A1 of the worksheet. By taking care of some of these formatting issuing on the front end, we'll have an easier time keeping the model clean.
Next, let's set up our assumptions box. A few rows below the title, type "Assumptions" and make a vertical list of the following inputs:
Purchase Price
Initial Monthly Rent
Occupancy Rate
Annual Appreciation
Annual Rent Increase
Broker Fee
Investment Period
In the cells to the right of each input label, we'll set up an input field by adding a realistic placeholder for each value. We will format each of these values to be blue in color. This is a common modeling convention to indicate that these are input values. This formatting will make it easier for us and others to understand how the model flows. Here are some corresponding values to start with:
$250,000.00
$1,550.00
95.00%
3.50%
1.00%
6.00%
4 years
Article Source: http://condolaunch.org/pasir-ris-central-residences/
We should also think about how we want to lay it out so we keep our workspace clean. In Excel, one of the best ways to organize financial models is to separate certain sections of the model on different worksheets.
We can give each tab a name that describes the information contained in it. This way, other users of the model can better understand where data is calculated in the model and how it flows.
In our investment property model, let's use four tabs: property, financing, expenses and financials. Property, financing and expenses will be the tabs on which we input assumption and make projections for our model. The financials tab will be our results page where we will display the output of our model in a way that's easily understood.
Forecasting Revenues
Let's start with the property tab by renaming the tab "Property" and adding this title in cell A1 of the worksheet. By taking care of some of these formatting issuing on the front end, we'll have an easier time keeping the model clean.
Next, let's set up our assumptions box. A few rows below the title, type "Assumptions" and make a vertical list of the following inputs:
Purchase Price
Initial Monthly Rent
Occupancy Rate
Annual Appreciation
Annual Rent Increase
Broker Fee
Investment Period
In the cells to the right of each input label, we'll set up an input field by adding a realistic placeholder for each value. We will format each of these values to be blue in color. This is a common modeling convention to indicate that these are input values. This formatting will make it easier for us and others to understand how the model flows. Here are some corresponding values to start with:
$250,000.00
$1,550.00
95.00%
3.50%
1.00%
6.00%
4 years
Article Source: http://condolaunch.org/pasir-ris-central-residences/