Excel Formula for calculating Finance Charge

[kumar1803]

Hello
I need help with a formula to calculate finance charge with the following variables..I need a value for finance charge ( buy rate) and finance Charge( sell rate) Please help:

[TABLE="width: 607"]
<colgroup><col span="3"><col><col><col></colgroup><tbody>[TR]
[TD="align: left"]Buy Rate[/TD]
[TD="align: left"]Sell Rate[/TD]
[TD="align: left"]Amount Financed[/TD]
[TD="align: left"]Term [/TD]
[TD="align: left"]Finance Charge ( Buy rate)[/TD]
[TD="align: left"]Finance Charge ( Sell Rate)[/TD]
[/TR]
[TR]
[TD]7.99%[/TD]
[TD]9.99%[/TD]
[TD]25000[/TD]
[TD]60 months[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[BadgerRoad]

The finance charge is the Pmt x Term - Amount Financed
Assuming monthly payments: =PMT(Rate/12, 60, -Amount Financed) x Term - Amount Financed