Even when your overall property budget is large enough, a gap can still appear on a specific payment date. For example, the bank has not yet disbursed the loan, but the buyer already needs to top up the self-funded portion; or renovation costs, furniture and the first loan installment all happen to fall in the same month.
A cash-flow table exists to answer three questions: when a payment is due, where the money for it will come from, and how much is left once it is paid.
First, Decide What the Table Records
For a first draft, it helps to build the table from the “buyer’s own funds” perspective, recording only the cash you can actually access yourself and the payments you need to make personally.
Loan amounts paid by the bank directly to the seller or developer can be noted separately, in a financing memo, rather than treated as income sitting freely in your own account.
The deposit, down payment and subsequent top-up payments toward the property price also need to be cross-checked against each other. If the deposit has already been credited against the purchase price, it should not be counted again when calculating the remaining self-funded amount.
The Table Needs at Least These Columns
| Estimated Date / Stage | Item | Cash In | Cash Out | Amount Status and Basis |
|---|---|---|---|---|
| Around signing | Deposit or down payment under the contract | — | To be filled in | Confirmed by contract; note whether it is credited against the price |
| Financing and completion stage | Remaining self-funded portion of the price | — | To be filled in | Cross-checked against loan approval and the payment schedule |
| Documentation stage | Stamp duty, legal fees and other costs | — | To be filled in | Written quotes; note whether tax is included |
| Before construction or handover | Applicable installments, interest or loan payments | — | To be filled in | Bank and developer payment notices |
| Around handover | Deposits, advance management fees, renovation and furniture | — | To be filled in | Quotes or scenario estimates |
| Monthly during the holding period | Loan installment, management fees and running costs | — | To be filled in | Bank repayment schedule and bills |
| Annual or specific months | Land tax, assessment tax, insurance, etc. | — | To be filled in | Fill in against actual due dates |
| After renting out | Expected rental income received | To be filled in | — | Lease agreement or a conservative estimate |
| Every month / stage | Other funds available for the property plan | To be filled in | — | Amount available after deducting living expenses |
The dates in the table are only illustrative categories; the actual payment sequence should be adjusted according to the sale and purchase agreement (SPA), loan documents and bills.
Add one more line each month:
Closing cash = Opening cash + Cash in this period − Cash out this period
Do not just check whether the year as a whole shows a surplus — also identify the single month in which the balance is lowest.
Beyond the Down Payment: Six Funding Items Easily Missed
1. The Gap Between Loan Approval and Your Original Assumption
An initial estimate can use an assumed loan amount, but once you are close to a firm decision to buy, switch to the amount actually confirmed by the bank.
If the loan amount actually available to pay toward the property is lower than originally expected, the self-funded portion increases accordingly. Where the loan includes a premium or other fees, it is also worth working out exactly how much of it genuinely goes toward the purchase price.
2. Financing Costs Before Handover
Buying an uncompleted property does not mean bank-related payments only start once you get the keys. Depending on the loan structure, interest or installments may already be payable during a staged disbursement period.
If you are still paying rent at the same time, the cash-flow table should include your existing rent as well, to avoid missing the months where rent and mortgage payments overlap.
3. Renovation Payment Schedule and Refundable Deposits
Don’t just enter renovation as a single total. It can be allocated across the actual payment months by deposit, materials, progress payments and the final balance.
Move-in, renovation or utility deposits also tie up cash. Even if they are refundable later, they should still be recorded as an outflow when paid; the refund should be listed separately as an inflow in the month it is reasonably expected, noted as not yet confirmed.
4. Bills That Still Apply During a Vacancy
When a rental property sits vacant, rental income can be zero, but the loan, management fees and some other costs remain. You can set up two scenarios: “let quickly” and “delayed letting.” In the delayed scenario, simply set the rent for the relevant months to zero and keep the costs that still apply — don’t also separately deduct the same amount again as an expected rental loss.
A tenant’s deposit should also be recorded separately, and should not be treated as freely usable rental income.
5. Exchange Rate, Remittance and When Funds Actually Arrive
If a foreign buyer is paying in a currency other than the local one, the table can record the local-currency amount due, an estimated exchange rate, and the required amount in the original currency, with remittance fees listed separately.
Before a large payment, also confirm when the funds will actually be available. Funds still tied up in an asset you plan to sell, a fixed deposit you need to break, or a remittance still in progress should not be treated as cash you can already use today.
6. A Reserve for Repairs and Everyday Emergencies
Beyond the renovation budget, you may also run into equipment failure, additional construction work, or an interruption to your income.
You can set a minimum cash balance you need to maintain. This is money kept in reserve, not an expense already spent that month; if it has already been deducted from the funds available for the property plan, do not deduct it again as a separate expense.
What Can Be Estimated, and What Needs Written Confirmation?
| Item | A Better Way to Fill It In |
|---|---|
| Self-funded portion of the price | Use an assumed loan amount initially; switch to the confirmed amount once approved |
| Taxes and legal fees | Calculate based on your status, the transaction type and the documentation, then update with a written quote |
| Loan installments | Use the bank’s repayment schedule; build a separate adjustment scenario for a floating rate |
| Management fees, land tax and insurance | Refer to the property’s bills, management-office information and the policy |
| Renovation and furniture | Fill in by stage, based on the work schedule and quotes |
| Rent and vacancy | Refer to comparable rental data, and set different scenarios for letting time and rent |
“There is no universal ratio” does not mean it cannot be estimated at all. What matters is recording where each assumption came from, and updating it as new information comes in.
A Simple Example of a Cash Shortfall
Suppose in a given month:
- Opening cash available: RM80,000
- New funds that can be contributed: RM10,000
- Property payment, fees, renovation and loan installment combined: RM65,000
The closing cash balance is:
RM80,000 + RM10,000 − RM65,000 = RM25,000
If your minimum reserve target is RM30,000, the account has not run to zero, but it is still RM5,000 below your own reserve target. At this point, you could review whether any renovation or furniture spending can be delayed, or increase your available funds; a payment due under a contract, however, cannot simply be postponed on your own.
The figures above are only used to demonstrate how the table is calculated — they are not a recommended property budget.
Frequently Asked Questions
Can I just divide annual costs by twelve and spread them evenly across each month?
You can use that to estimate how much to set aside each month, but the actual cash-flow table should still show the payment in the month it is actually due. If you record a monthly reserve as well, make sure you don’t count the internal reserve and the actual payment as two separate expenses.
Should the loan principal also be included in the cash flow?
Yes. Both the principal and the interest portion of a monthly installment reduce your cash that month. The distinction between the two only matters when you are calculating investment returns — the principal should not be left out just because it isn’t an interest cost.
The renovation quote isn’t ready yet — can I leave it blank for now?
You can mark it as “to be confirmed,” but it should not default to zero in the total. Get an initial range based on the scope of work first, then check whether your funds are sufficient under a higher-cost scenario.
Disclaimer
This article provides a budgeting method, not an official prescribed form or a standard ratio for funds. Actual payment dates, taxes and fees, and financing arrangements should be updated based on the contract, bank documents and formal quotes.
Have a question about this guide? Leave a comment below, or ask Zagdim directly.
Your first stop for international property and global living.
Research and insights. Know what’s changing. Understand what matters.
