Sam

Posts: n/a

Amortization

HomeLoan computation:

By given loan amt(PV), % rate(rate), tenure(nper), we may compute the
instalment by using '=PMT' function.

If the tenure = 20 years and we wish to find the outstanding principal after
10 years, we may get it by using amortisation.

Question: is amortisation available in Excel 2003?

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
amortization schedule	peggy metro	Excel Discussion (Misc queries)	1	February 15th 05 10:43 PM
does anyone have a great Interest only amortization schedule wher.	Kelsey	Excel Discussion (Misc queries)	2	January 29th 05 10:44 PM
Loan amortization schedule with bi-monthly payments	McCarthy_MF	Excel Worksheet Functions	0	December 9th 04 09:45 PM
Amortization Schedule	Steven M. Britton	Excel Worksheet Functions	0	December 8th 04 04:23 AM
Unknown IF function parameter on amortization schedule	Michael from Austin	Excel Worksheet Functions	1	November 9th 04 06:32 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us