Jump to content

Talk:Amortization calculator

Page contents not supported in other languages.
From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by 68.165.11.243 (talk) at 21:40, 28 March 2010 (→‎Needs useful non commercial Website with a working amortization calculator). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

How do we calculate based on a 365-day year? I believe that should be included in this article. —Preceding unsigned comment added by 216.114.198.130 (talk) 16:12, 15 December 2008 (UTC)[reply]

The first equation in the article shows an equivalent form. I tried it with that form and it doesn't work. I suspect the equivalent form has an error. Tried it for yourself. —Preceding unsigned comment added by 70.90.46.81 (talk) 17:13, 12 October 2008 (UTC)[reply]

WikiProject iconBusiness Start‑class Low‑importance
WikiProject iconThis article is within the scope of WikiProject Business, a collaborative effort to improve the coverage of business articles on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.
StartThis article has been rated as Start-class on Wikipedia's content assessment scale.
LowThis article has been rated as Low-importance on the project's importance scale.

I do not have the confidence to edit this page but I suggest that the maths behind derivation of this formula be illustrated if possible. Also since there is a repeated term ,in the formula at the time of writing, can the author divide 'top and bottom' by this factor and simplify the equation so it only has to be used once ? Many thanks for the input from all of the contributers.

J_B. Is there an excel or openoffice (calc) tutorial where how to do mortgage calculations are explained ?


Is it possible to post excel spreadsheets on wikipedia? I wouldn't mind adding a sample amortization schedule.

I think this article should make the distinction clear between dealing with installment debt and revolving loans. Additionally, it should make explicit reference to concepts of APR and Truth-in-Lending regulations. I will begin to make these contributions. -- Mhervitz 14:59, 21 July 2006 (UTC)[reply]

Mhervitz, please do, as it seems strange to me that one would suggest it can also be used to analyze revolving loans (e.g. credit cards). It is a fine estimate but it is not completely accurate and doesn't show how total interest paid changes with payment. E.g., by my calculations one can save just over $7.50 in interest (big deal, I guess, but accurate) on a $9000 balance over 12 months at 1.99% APR if one pays 826.31 over the amortization calculator's suggestion of 758.11 (final payment will be about $0.03 for the $826 payment... just one penny more and it would be an 11 month payoff--of course, this depends on when the payoff starts). (Erislover 19:16, 14 June 2007 (UTC))[reply]

Propose merge with time value of money

This is not a very standard term, and it also is a little confusing as written here. Merging would seem to be easier than fixing this page.--Gregalton 02:30, 11 February 2007 (UTC)[reply]

please, help me to stop this vandal.

This link: calculator-loan.info has been in the encyclopedia for 2 months since 7 of May 2007. The vandal 138.88.117.182 (138.88.169.147) came on 4 July 2007 and sneaky changed the link for his own. After I undid his change he keeps deleting the original link. Please, somebody help to stop him. Ivanups 06:17, 7 July 2007 (UTC)[reply]

Please provide a useful non commercial Website. Your site calculator-loan.info was littered with Google Ads and offered no value to the Wikipedia Community. I also noticed that you removed the ads after you posted this message. We consider that spamming here.

For 2 months it has not been spammy, but now you decide so. Why did you remove this link, the next one also has Google Ads? And speak only for yourself not for the whole community. That site (calculator-loan.info) has got average 5 pages per viewer, so people find that site useful since they use that calculator and it is not up to you to decide about of usefulness of this link. If you consider that you link has some value for this article, go ahead and add your link and let to the community decide is it valuable or not. And do not do like before when you just removed other link, please. Ivanups 18:20, 7 July 2007 (UTC)[reply]

I'll leave it up to the community then. I just think it's shady to remove all the ads on your site before calling me a vandal for removing your site and crying foul. Being listed there for two months isn't really a sound argument for being allowed to be there. Again, the community will decide so if you decide to spam again in the future I'm sure your site will receive the proper treatment. You can take it up then with the next so called "vandal."

I have again removed a number of links to websites that do not seem to meet Wikipedia guidelines for external links. It would be more helpful to discuss the value and notability of each individual link to the article rather than just trying to readd them enmass. Flowanda | Talk 01:11, 8 May 2008 (UTC)[reply]

HELP on How to Amortise Transaction Cost & Upfront Fee??

Hi,

This is my first post here and hope I didnt make any posting errors.

Can anyone guide me on the following: (A) I have a 15 year bank loan with 155 monthly principal repayment commencing from the 25th month and 1 lump sum final principal repayment at end of loan (B) When we draw down the loan, we paid transaction cost & upfront fee.

Can I know how to amortise the transaction cost & upfront fee to the respective loan period?

Many thanks Anson Tonykhkwan (talk) 02:55, 19 November 2008 (UTC)[reply]

Needs useful non commercial Website with a working amortization calculator

Might WolframAlpha's be OK? http://www.wolframalpha.com/input/?i=principal+and+interest

Might someone point to one or build one on Wiki commons?

Ideally, the calculations would be done on the host machine, so that it was not necessary to allow javascript or java access to the user's computer.