• Obscure amortization

    From Stumpy@21:1/5 to All on Fri Mar 8 14:04:22 2019
    I want to make a loan to a family member.

    $25,000 @3% to be paid in 25 monthly installments.
    First year @ $300/mo.
    Second year @ $1,000/mo.
    And then a final lump sum payment of the remainder including all
    interest accrued so far.

    I'm actually using LibreCalc but it can open Excel files.

    Would expect to need 5 columns:Period, Payment, Interest, Principal,
    Remaining balance.

    The templates I've found so far let me define the loan amount, interest
    rate, duration, but not variable payments.

    If I run it as 3 separate sheets I get numbers, but can't print out a
    single page summary. EG: $22,354.61 remaining after first year of $300 payments, $11,838.59 remaining after second year of $1,000 payments and
    then a final payment of $11,868.19 which includes $1,253.68 interest.

    Where can I find a template that looks better than my scribbling?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)