how do I calculate a monthly payment based on a variable rate?

Posted to microsoft.public.excel.worksheet.functions

Chick N Egg

Posts: n/a

how do I calculate a monthly payment based on a variable rate?

I have to calculate a monthly payment based on avariable interest rate. What
is the formula I use, ex. variable rate in is A6, loan term B6, and payment
C6?

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
Calculate total interest earned on a loan and monthly payment	Matt Stanley	Excel Worksheet Functions	4	May 4th 23 03:42 AM
Calculate Interest Rate when payment changes!	huntermcg	Excel Worksheet Functions	2	October 25th 05 08:32 AM
calculate payment with first payment due date variable?	Jody Solbach	Excel Worksheet Functions	1	September 8th 05 05:46 PM
calculate interest on an increasing balance with variable rate	LPMastro	Excel Discussion (Misc queries)	0	February 16th 05 08:13 PM
How do you calculate rate of return on monthly cash flows	Philly Fan	Excel Worksheet Functions	1	February 16th 05 04:24 AM

All times are GMT +1. The time now is 03:01 AM.

Menu

About Us