2013 Archives by date, by thread · List index

# Re: [libreoffice-users] Calc - Amortization

```Hi :)
Going with the line-by-line approach but with a fast twist.

Each line has identical calculations with the result feeding into the next line and then having the
same calculation repeated doesn't it?  So it's something like
C1 = A1 * B1

A2 = C1
B2 = B1
C2 = A2 * B2

A3 = C2
B3 = B1
C3 = A3 * B3

I suspect a tad more complexity and there is probably a - in there somewhere (such as A2 = A1 -
C1), but again more complex but all kinda boiling down to something like that?

So write out the first row and the 2nd one but in row 2 write

A2 = C1
B2 = \$B\$1
C2 = A2 * B2

Now select all 3 cells in row 2 (or do them individually if there are extra columns in between).
See the tiny black square down in the bottom-right corner of the 3 selected cells?  When your mouse
hoovers over that it changes shape.  When it's the new shape drag all the way down the page until
somewhere past the last row you need (around 300 ish).  Then just delete the rows you don't need
and maybe make the last row bold.

Regards from
Tom :)

________________________________
From: John Jason Jordan <johnxj@comcast.net>
To: LibreOffice <users@global.libreoffice.org>
Sent: Tuesday, 8 October 2013, 17:46
Subject: [libreoffice-users] Calc - Amortization

I use Writer daily, but practically never use Calc, so I am pretty
helpless. Now I have a problem that calls for a spreadsheet;
actually, a script or plug-in or something to Calc.

The problem is that I need to calculate an amortization chart for a
loan of regular payments with an odd number of months, where the
interest is calculated monthly rather than on a daily basis. When the
loan was first made the term was supposed to be 300 months, but the
amount of the payment was miscalculated, so the borrower has been paying
slightly more. Using an HP-12C (yes, I still have one, and it still
works!) I find that it will amortize in slightly less than 299 months.
In order to find the true balance at any given time a custom chart must
be created.

I tried online services, but they cannot handle a mess like this. I
also tried Google Docs, but I can't find even basic help information,
like how to write <balance> x 045 / 12, or how to make the expression
do the calculation.

I could do this manually in Calc, one row at a time (ugh!), but I was
hoping that there existed a script or something that would set it up
for me and do all the calculations. I tried the LO extensions web page,
but couldn't find anything.

Any ideas or suggestions?

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
```