Posted to microsoft.public.excel.programming

Luqman

external usenet poster

Posts: 8

Lease Amortization Calculation ?

Say, I want to give an amount of $100,000 as a Loan on 15% IRR for 36
Months, if last 6 instalments/cash flows are mentioned in Amortization
Schedule say $100/=, how can I calculate the 1st 30 instalments/cash flows.

Some one told me that I have to use quadratic equation in Excel, but I don't
know how to use it, any idea please ?

Best Regards,

Luqman

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
Auto Lease	Zulu[_2_]	Excel Discussion (Misc queries)	1	April 10th 10 04:58 PM
sale or lease?	possmm1	New Users to Excel	7	February 9th 07 03:38 PM
CAR LEASE CALCULATION WITH RESIDUAL	FIN	Excel Worksheet Functions	1	January 19th 07 12:31 AM
IRR&NPV Financial lease	littleps	Excel Discussion (Misc queries)	5	March 29th 06 09:13 AM
Amortization Calculation in Excel worksheet	Tiff	Excel Worksheet Functions	4	January 29th 05 04:18 AM

All times are GMT +1. The time now is 07:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us