Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 15th 03, 02:21 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2003
Posts: 3
Default 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   Report Post  
Old December 15th 03, 09:03 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2003
Posts: 162
Default 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   Report Post  
Old December 15th 03, 09:47 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2003
Posts: 34
Default 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
downloads section, it is called mortgage calculator.
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   Report Post  
Old December 15th 03, 10:56 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2003
Posts: 3
Default calculating balance w/interest

thank you very much Norman, and Keith.
  #5   Report Post  
Old December 15th 03, 11:14 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2003
Posts: 162
Default calculating balance w/interest

Hi Slaw!

Always pleased to help.

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   Report Post  
Old December 15th 03, 11:36 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2003
Posts: 3
Default calculating balance w/interest

That may help. Im new to this , and still having problems. . thank you
  #7   Report Post  
Old December 16th 03, 12:13 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2003
Posts: 162
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a spreadsheet to accrue interest on a balance 30+d dowwcoww Setting up and Configuration of Excel 1 May 30th 09 08:48 PM
Auto Calculating Daily interest on a moving balance? Matt Excel Discussion (Misc queries) 0 February 24th 09 03:40 PM
How to automate daily interest in a balance sheet? JimS Excel Discussion (Misc queries) 0 May 10th 06 07:45 AM
Simple interest, multiple payments, loan balance NinasNumber Excel Worksheet Functions 1 January 9th 06 07:31 PM
calculate interest on an increasing balance with variable rate LPMastro Excel Discussion (Misc queries) 0 February 16th 05 08:13 PM


All times are GMT +1. The time now is 03:48 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017