Entering a Loan with a Custom Payment Schedule

Adding a New Loan:

Use this method for loans you'll place anytime after the start date of your forecast/plan.

1

Under the working capital tab of financial forecasting tool, Click on the Funding tab, and then click Add Funding Button:

2

Enter a name for the loan(borrowed on interest), and select funding type as Other Financing(Borrowed) and then click on Next:

3

Click on Next.

4

Enter the annual interest rate, if any, and also indicate whether you'll pay this financing back within 12 months:

5

Click on Save.

6

Amount Received: Enter the amount of money you'll receive and when you'll receive it. You can enter a single amount in a single month or amounts in multiple months, depending on how your loan is structured, Upmetrics will automatically calculate interest on the loan and other parameters using the standard loan formula:

7

Amount Repaid: Enter the amount you plan to pay back each month or year against the balance:

8

Updates you make in the excel sheet are in autosave mode. Close the overlay. This loan and its payments will be displayed in the Financing table.

Where does this entry appear in the financial statements?

When you enter a Loan or an Other entry, only the interest portion will appear in your Profit and Loss statement. This is because the interest is the only true cost your business incurs in the loan:

Loans will appear on one or two lines of the Balance Sheet, depending on their length. A loan that will be paid back within 12 months appears as Short-Term Debt. A loan of longer than 12 months will be divided into Short-Term Debt and Long-Term Debt.

In the Cash Flow, similarly, loans (or portions of loans) may be considered Short-Term Debt or Long-Term Debt: