Bank Loan received – Paid back as lump sum with interest

Hello,

I hope you can help me, when I add a bank loan amount to the “Bank Loan 1” cell, under the “loans and hire purchase advances” – it shows up as a loan, but doesn’t make any changes to the cashflow Net balance amount.

The desired outcome that I would like is, I would like to see how the loan will impact my cashflow. If I add the amount to the “other income” cell, it gives me the desired outcome.

How best to approach this?

Some more points to note, the loan will be paid back in 12 months as one payment lump sum, and interest will be charged.

I think I’ve followed the steps correctly in the pdf document, but doesn’t seem to make sense to me,

Thanks,
Dean