How to enter business loan into cashflow forecast

How to enter business loan into cashflow forecast

Didn't find your answer?

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.

avatar
By JKnight
14th Jan 2012 11:37

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.

Thanks (1)
avatar
By Pluribus
14th Jan 2012 11:52

Thanks!

 

You wouldn't believe how long I have been staring at excel trying to work that one out...

 

Regards

 

Ian

Thanks (0)
avatar
By KWest
06th Feb 2014 13:28

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.

 

http://www.figurewizard.com/

Thanks (0)