Posted to microsoft.public.excel.newusers

Kimmer

external usenet poster

Posts: 25

Loan Amortization Schedule Formula

Does anyone know how I can set up a loan amortization for $15,000 at 5% for
10 years with monthly payments? I have tried a couple different things and
keep getting NAME? in columns for to interest and to principal. I have a
template but I would really like to know how to do the formula for this.
Formulas are my worst problem with excel.
Thanks.
--
Too old to be in college

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
loan amortization schedule	nldilch	Excel Worksheet Functions	4	December 8th 10 08:52 AM
loan amortization schedule	Fran	Excel Discussion (Misc queries)	6	January 23rd 08 06:28 AM
Loan Amortization Schedule	oscramx1l3sc4	Excel Worksheet Functions	1	July 18th 07 05:20 PM
loan amortization schedule	red wagon	Excel Discussion (Misc queries)	0	June 7th 05 09:20 PM
Loan amortization schedule	AMS228	New Users to Excel	0	April 30th 05 02:56 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us