OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Really Need Help Putting Discounts in a Loan Spreadsheet

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Skint
Newbie
Newbie


Joined: 15 Mar 2010
Posts: 1

PostPosted: Mon Mar 15, 2010 4:26 pm    Post subject: Really Need Help Putting Discounts in a Loan Spreadsheet Reply with quote

Alright so I've created a spreadsheet which has a data sheet containing a list of loans owed to a loan company, and a stats sheet containing various statistics which are generated by information on (and affect calculations made by) the data sheet.

On the data sheet, the loan amount, loan length, annual interest rate, and discounts are inputs. The total without discount and the Monthly Payment are outputs which I calculated.
On the stats page, the possible discounts are both inputs, as are the two dollar
values under “Loans over”. Everything else is an output, which I calculated.

(here's a screenshot of what I have so far)

http://img.photobucket.com/albums/v465/Skint/Untitled-2.jpg?t=1268699157

Outputs I calculated were:
Total w/o discount is the total which would be repaid on the loan, assuming no discounts.

Monthly Payment is the amount that will be paid per month on the loan, assuming the same payment every month. (which applied discounts)

Total Owed is the total owed to the loan company,

Expected per month is the amount of payment expected per month. It is the sum of the “Monthly Payment”column.

The Loans over section calculates the number of loans which are worth more than specified values ($500 and $5,000 in the example). This is calculated based on the loan amount, not the total that will be repaid.


Alright, if you're following me, I'm having trouble figuring out what I'm trying to do next, I need to implement a generic support for discounts. That is, enabling new discounts to be added simply by adding another line in the “possible discounts” section.


If this makes any sense to anyone, please help me, if this is unclear and you need more info, please let me know.

Thank you in advance.[img][/img][img][/img][url][/url]
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group