[Bug 72499] Re: payment schedule

2007-05-03 Thread lymz
After examining it, I noted 2 formula "enhancements"; please feel free
to add or elaborate on them.  Also, "Principle" should be "Principal" as
noted and fixed in bug #67991.

1. "Total Payments Paid" formula changed from:
"Interest" sum + "Loan Amount" + "Extra Principal" sum
to:
"Interest" sum + "Principal" sum + "Extra Principal" sum

2. "Extra Principal" formula (E13:E371) changed from:
IF("Balance" = 0); then $0; else "Extra Principal Payment"
to:
IF("Balance"=0); then $0; else IF ("Balance" + "Interest" - "Principal" >= 
"Extra Principal Payment"); then "Extra Principal Payment"; else "Balance" + 
"Interest" - "Principal"

I think both of these are more than just enhancements, these are bug
fixes.  If you enter a large amount for "Extra Principal Payment"(i.e.
$50,000) both of these bugs are pretty evident; your "Total Payments
Paid" would be incorrect and you would overpay in "Extra Principal".

There is still a bug in the spreadsheet; currently it is possible to
overpay the loan in one period (i.e. enter an "Extra Principal Payment"
larger than "Loan Amount" and  you will get a negative balance).  To fix
this, just extend the formulas from E13:F13 to E12:F12.

I attached a spreadsheet with this minor fix and the correct spelling.
I like the references from the "Print" worksheet instead of
recalculating.  Very good work!

** Attachment added: "new-payment-schedule.ods"
   http://librarian.launchpad.net/7548966/new-payment-schedule.ods

-- 
payment schedule
https://bugs.launchpad.net/bugs/72499
You received this bug notification because you are a member of Ubuntu
Bugs, which is the bug contact for Ubuntu.

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 72499] Re: payment schedule

2007-05-02 Thread lymz
Shawn,

Can we get a list of these enhancements?

-- 
payment schedule
https://bugs.launchpad.net/bugs/72499
You received this bug notification because you are a member of Ubuntu
Bugs, which is the bug contact for Ubuntu.

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs