Blogger
Share this content
0
3
2608

How to enter business loan into cashflow forecast

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

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.

Thanks (1)

Thanks!

 

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

 

Regards

 

Ian

Thanks (0)

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)