We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
EXCEL Interest Rate Formulae
Grumpy_Old_Duffer
Posts: 689 Forumite
in Techie Stuff
Can someone give me the EXCEL formulae for calculating the monthly interest for :-
A Mortgage Account (say at 5.95% - Re. One Account)
and
High Interest Savings Account (say at 5.35% - Re. Alliance Leicester Online Saver)
... so that the resulting %'ages can be used to calculate the monthly Interest/payment.
A Mortgage Account (say at 5.95% - Re. One Account)
and
High Interest Savings Account (say at 5.35% - Re. Alliance Leicester Online Saver)
... so that the resulting %'ages can be used to calculate the monthly Interest/payment.
It has taken about 4,500,000,000 (4.5 billion) years for the Earth to form as it is now .........
and it'll only take about another 100 years for mankind to really **** it up!!!!
and it'll only take about another 100 years for mankind to really **** it up!!!!
0
Comments
-
Hi GOD,
Capital * Interest Rate / 1200 is 'sort of' what you want, although most morgages and savings accounts attract interest daily. To be really accurate, you'd also need to take into account when it was opened and (for the mortgage) when the payments were made.0 -
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 351.8K Banking & Borrowing
- 253.4K Reduce Debt & Boost Income
- 454K Spending & Discounts
- 244.7K Work, Benefits & Business
- 600.2K Mortgages, Homes & Bills
- 177.3K Life & Family
- 258.4K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.6K Read-Only Boards