ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Loan calculator (https://www.excelbanter.com/excel-discussion-misc-queries/187865-loan-calculator.html)

alli

Loan calculator
 
Hi,
I have a loan amount with a fixed interest rate. I have been making
payments fortnightly that are variable amounts. I would like to track what I
owe in excel but am not sure how to do this. I am new to using excel in this
manner.....

I would greatly appreciate someone helping me out!! I have looked at various
functions but just dont know which one to use!!

thank you
Alli
--
"Only a scientist"

Gary''s Student

Loan calculator
 
You may be able to adapt this to your needs:

http://office.microsoft.com/en-us/te...CT101444811033
--
Gary''s Student - gsnu200786


"Alli" wrote:

Hi,
I have a loan amount with a fixed interest rate. I have been making
payments fortnightly that are variable amounts. I would like to track what I
owe in excel but am not sure how to do this. I am new to using excel in this
manner.....

I would greatly appreciate someone helping me out!! I have looked at various
functions but just dont know which one to use!!

thank you
Alli
--
"Only a scientist"


alli

Loan calculator
 
Thanks... I'll give it a go... I think I should be able to work it out from
that ..
Cheers
Alli
--
"Still Only a scientist"


"Gary''s Student" wrote:

You may be able to adapt this to your needs:

http://office.microsoft.com/en-us/te...CT101444811033
--
Gary''s Student - gsnu200786


"Alli" wrote:

Hi,
I have a loan amount with a fixed interest rate. I have been making
payments fortnightly that are variable amounts. I would like to track what I
owe in excel but am not sure how to do this. I am new to using excel in this
manner.....

I would greatly appreciate someone helping me out!! I have looked at various
functions but just dont know which one to use!!

thank you
Alli
--
"Only a scientist"



All times are GMT +1. The time now is 11:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com