Posted to microsoft.public.excel.newusers

Tracy[_3_] Tracy[_3_] is offline

external usenet poster

Posts: 3

mortgage interest

Hi, What is the correct excel formula to calculate the monthly interest on
an interest only mortgage of £100,000 at a rate of 3.75% per year where the
interest is calculated daily?
At present I use

=((C22*C19)/12)

where C22 is £100,000 and C19 is 3.75% but the result is not the same as
what I am being charged each month.
Thanks, Tracy

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 to calculate my mortgage payments interest part?	Grd	New Users to Excel	6	March 12th 09 07:00 AM
Need HELP! Solve for mortgage interest rate with following variabl	Robalo	Excel Worksheet Functions	2	January 25th 08 10:11 PM
Interest PMNT per Year on Mortgage	ziak	Excel Discussion (Misc queries)	2	March 23rd 06 02:33 AM
Function to calculate the interest of a mortgage	Grd	Excel Worksheet Functions	7	January 6th 06 04:00 AM
Looking for an interest only mortgage template.	dfelzer	Excel Discussion (Misc queries)	1	February 23rd 05 11:30 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us