Posted to microsoft.public.excel.worksheet.functions

joeu2004

external usenet poster

Posts: 2,059

Amortization Schedule

Errata ....

On Jan 9, 1:23*pm, joeu2004 wrote:
E6: *=$B$1
[....]
D7: *=E6*(B7-B6)*$B$2/365

I forgot to mention:

D6: 12/15/2008

D6 is the loan origination date. The OP did not mention it. I assume
it is one month before the first payment date.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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	Richard	Excel Discussion (Misc queries)	1	November 2nd 07 08:53 PM
amortization schedule	Billy Hatcher	Charts and Charting in Excel	1	July 8th 07 10:14 AM
Amortization Schedule	BG	Excel Worksheet Functions	2	February 24th 07 02:05 PM
amortization schedule	peggy metro	Excel Discussion (Misc queries)	1	February 15th 05 10:43 PM
Amortization Schedule	Steven M. Britton	Excel Worksheet Functions	0	December 8th 04 04:23 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us