Remember Me?

#1
December 15th 03, 03:21 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Dec 2003 Posts: 3
calculating balance w/interest

Can anyone help me with the formula that will allow me to figure out the balance on a loan or credit card after each payment, without creating a loop? i.e. BALANCE=1000.00 PAYMENT=-100.00 INTEREST=+10.00 NEW BALANCE=910.00(The problem is the "NEW BALANCE" needs to go to the "BALANCE" now. and each "PAYMENT" is an accumulated total.(In January "PAYMENT"=100.00, in February "PAYMENT" equals 200.00, etc.) At the end of the year the result will display the current balance, total of monthly payments, total interest paid.

#2
December 15th 03, 10:03 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Jul 2003 Posts: 162
calculating balance w/interest

Hi Slaw!

A1: Payment
B1: Interest
C1: Balance
C2: 1000 (Opening Balance)
A3: -100 (Payment)
B3: 10 (Interest)
C3: =C2+A3+B3 (Running Balance)

Often the column A and (especially) B items will be calculations
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"slaw" wrote in message
...
Can anyone help me with the formula that will allow me to figure out

the balance on a loan or credit card after each payment, without
creating a loop? i.e. BALANCE=1000.00 PAYMENT=-100.00 INTEREST=+10.00
NEW BALANCE=910.00(The problem is the "NEW BALANCE" needs to go to the
"BALANCE" now. and each "PAYMENT" is an accumulated total.(In January
"PAYMENT"=100.00, in February "PAYMENT" equals 200.00, etc.) At the
end of the year the result will display the current balance, total of
monthly payments, total interest paid.

#3
December 15th 03, 10:47 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Oct 2003 Posts: 34
calculating balance w/interest

I have a spreadsheet that is a mortgage calculator that
does this. The formula's can be looked at in the
schedual sheets. The VBA just makes those sheets, the
formulas do the work. It is at www.kjtfs.com in the
Hope it helps.

Keith
www.kjtfs.com
-----Original Message-----
Can anyone help me with the formula that will allow me

to figure out the balance on a loan or credit card after
each payment, without creating a loop? i.e.
BALANCE=1000.00 PAYMENT=-100.00 INTEREST=+10.00 NEW
BALANCE=910.00(The problem is the "NEW BALANCE" needs to
go to the "BALANCE" now. and each "PAYMENT" is an
accumulated total.(In January "PAYMENT"=100.00, in
February "PAYMENT" equals 200.00, etc.) At the end of the
year the result will display the current balance, total
of monthly payments, total interest paid.
.

#4
December 15th 03, 11:56 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Dec 2003 Posts: 3
calculating balance w/interest

thank you very much Norman, and Keith.
#5
December 16th 03, 12:14 AM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Jul 2003 Posts: 162
calculating balance w/interest

Hi Slaw!

If you need examples of credit card schedules and amortization tables
I'll send on request off group.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"slaw" wrote in message
...
thank you very much Norman, and Keith.

#6
December 16th 03, 12:36 AM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Dec 2003 Posts: 3
calculating balance w/interest

That may help. Im new to this , and still having problems. . thank you
#7
December 16th 03, 01:13 AM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Jul 2003 Posts: 162
calculating balance w/interest

Hi Chris!

Sent a quick and dirty credit card calculator with inputs of:

Loan
Effective Rate per Month
Min % repayment
Min \$ repayment
Rounding amount

John Walkenbach's Excel Formulas 2003 covers a lot of the basics of
these calculations.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"SLAW" wrote in message
...
That may help. Im new to this , and still having problems.

. thank you

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post dowwcoww Setting up and Configuration of Excel 1 May 30th 09 08:48 PM Matt Excel Discussion (Misc queries) 0 February 24th 09 04:40 PM JimS Excel Discussion (Misc queries) 0 May 10th 06 07:45 AM NinasNumber Excel Worksheet Functions 1 January 9th 06 08:31 PM LPMastro Excel Discussion (Misc queries) 0 February 16th 05 09:13 PM

All times are GMT +1. The time now is 09:16 PM.