where can I find a commercial amortization loan Calculator?
I.e..loan of $11,000,000 rate of 5.5% amortized for 25 years with fixed principal payments plus interest
Assuming you have Microsoft Excel on your computer then you can get free amortization tables that others have posted on the download section.
Go to Downloads and Trials on the tab list at the top, then click on Office Templates, and search for amortization. There are several and they will handle this for you and you can save the template and make use of it anytime.
If you dont have Excel or just dont want to do that for some reason, then advertising sites like bankrate.com have calculators including amortization tables on there sites you can use for free.
how to use a financial calculator to calculated commercial loans?
Try these free links. Watch out for the solicitations links.
Correctly calculating a Loan Amortization Schedule?
I am attempting to accurately calculate a commercial loan amortization. Principal was $200,000 at 6.5% on a 15 year paid monthly. The bank cites it is using a 360/360 Day count convention. They calculated a monthly payment (Exclusive of taxes and insurance) of $1,751.28 which I cannot seem to replicate. I come up with a monthly payment of $1,742.22. What I am trying to do is to develop an accurate Excel spreadsheet that will calculate on a daily basis. Any one have ideas on this? All of the standard loan calculators are not accurate enough.
Perhaps there were fees rolled into the loan? Or PMI (which is unlikely). I can’t seem to replicate it either. If the loan was based on $201,100 the payment comes out a little closer to their proposed amount due. Definitely worth checking on with them!
Powered by Yahoo! Answers