Need help building a simple worksheet, please

  • Thread starter Thread starter laurieslegends
  • Start date Start date
L

laurieslegends

Hi,

I am new here, I am no math wizard, for sure. But I want to build
simple worksheet in excel that will do the following:

Any help would be greatly appreciated.

I want say 3 columns (at least)

(person owed money) (total owed) (% of total debt)


then each following line would be different debtors

The idea being, for example, say I have 100 dollars extra to put o
past due bills. I want to divide it equally between all my past du
bills, but send it proportionately according to what there amount i
compared to the total amount. (column b compared to total of column b


I want to be able to come to this when I have extra to pay. Input a
amount in a cell and have it bring me the exact amount to go to eac
proportionately.

This is described in a book, by Jerrold Mundis, but I haven't been abl
to find any worksheets doing this online.

Thanks in advance to anyone who could help me with this. I coul
probably figure out how to do it by using excel for dummies an
spending hours, but I would rather spend hours trying to earn the mone
to pay of my past due bills. :o)

Laurie:confused
 
Hi

You can use 'amount owed by person' divided by 'total owed' to get a
percentage.
Bob 100 =100/175
Jim 60 =60/175
Bill 15 =15/175
Total 175

Format the results as percentages
 
In other words:

If you put the extra $ you have in cell A1, and then you put start
your columns in column B, you would format your spreadsheet like this

Extra Owed Amount % of Debt Amount to Pay Them
$100 Bob 100
Jim 60
Bill 15
Total

In order to calculate the total, use the formula =SUM(C2:C4). Type
the =SUM( and then use your mouse to highlight the cells containing
the amounts you owe.

In the "% of Debt" column, on Bob's row, use the formula =C2/C$5.
Copy that formula down for Jim, Bill, etc. Format the entire column as
a percent.

in the "Amount to Pay Them" column, on Bob's row, use the formula
=A$2*D2. Copy that formula down for Jim, Bill, etc.

By the way, this sounds like a good way to pay back debts, but not a
good way to pay back credit cards. Credit cards all have different
interest rates, and I would recommend paying minimum balance on all
credit cards. Then, take all extra money and send it to the one
credit card balance that is costing you the highest interest rate.
But then again, if I were you, I'd take input frmo me on Excel, but
not on finances.
 
Hi,

Heh thanks for the responses. I was waiting for emails to know I got
response, never got them. So I came back to check.

I drive an ice cream truck during the summer. I duplicated the invoic
the guy I work for uses (owner of the trucks and ice cream). I adde
extra columns for what it would cost me to buy if I owned my ow
vehicle and the difference I would be making each day. I am so proud o
myself for figuring it all out. It was my first attempt at putting
spreadsheet together. :o)

The formulas were simple multiplication addition and sum totals. Thi
percentage stuff had me stumped. I am ready to tackle it now.

Thanks again for you guys taking the time to help me. It is greatl
appreciated.

Kindest regards,

Lauri
 
Back
Top