Entering a loan with a custom payment schedule Follow

The standard loan entry in LivePlan calculates equal monthly payments. But let's say you want to set up a loan with quarterly payments, or a balloon payment at the end. You can always use the flexible Add Other option to enter a loan with custom repayment terms. 

LivePlan will still calculate the interest automatically if you need, but you'll be able to enter the loan's timing and payments flexibly.

 

  1. Click on the Forecast tab, and then click Financing:
    forecast-menubar-new-financing.png
  2. Click the Add Other button:

    addother.png#asset:993

  3. Enter a name for the financing:
    nameother.png#asset:1124

  4. Click Next.

  5. Indicate the annual interest rate, if any:
    interestrateother.png#asset:1105
  6. Indicate whether you'll pay this financing back within 12 months:
    payback-other.png#asset:1695
  7. Click Next.
  8. 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:
    receive per month other.png#asset:1145
  9. Click Next.
  10. Enter the amount you plan to pay back each month or year against the balance:
    payback other.png#asset:1133

    Note: the default setting in LivePlan is for one year of monthly detail. If you need more years of monthly detail in order to enter future payments more accurately, you can easily change that setting.

  11. Click Save & Close. This loan and its payments will be displayed in the Financing table.

 

Adding special types of loans

Custom loans can take many different forms. The links below offer detailed instructions for some common types of specialty loans:

 

Where does this entry appear in the financial statements?

(For more details, read How LivePlan handles loans and other financing.)

 

When you enter a custom loan, only the interest portion will appear in your Profit and Loss table. This is because the interest is the only true cost your business incurs in the loan:

financing-loan-pandl.png

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. For more on this, read What is the difference between short-term debt and long-term debt?

financing-loan-balancesheet.png

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

financing-loan-cashflow.png

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.