Hi
I am trying to do a cashflow projection which includes a substantial business loan.
Do I enter the loan as income or expenditure (as it immediately counts as debt) on my spreadsheet?
Thanks
Ian
Replies (3)
Please login or register to join the discussion.
Income
The loan would be income in the month that it will be received by the business. Any loan repayments would be expenditure in the months that the repayments are made.
Try Figurewizard
You can enter business loans into figurewizard forecasts. You enter the value of the loan, the date it is received and the date it is to be repaid plus the agreed rate of interest. Repayments, interest payments and an interest suspense account are then calculated and applied to all of the forecasts for profit and loss, cash flows, balance sheets and so on. If you already have a saved set of forecasts you can either retrieve that and simply add the loan or create a new set of forecasts, which in my experience can be done in about ten minutes.