Finance Calculator

C

Colleen

Does anyone know how to create a finance calculator?
I have all the math in an excel spreadsheet I have
attached. I just need to put it in a format that the
potential customer can go to my website and enter the
numbers they want and calculate a payment.

$10,000.00 Principal
8.00% APR
24 Term in Months
$5,000.00 Balloon
12 #Months / Year
0.66667% Monthly Interest Rate


Finance Payment Computation Balloon Discount Computation
1.0066667 1.01
1.17289 1.18
0.852596376 0.18
0.147403624 27.11
22.11054361 26.11
191.53
$452.27 Finance Payment ($191.53)
Balloon Discount


LEASE PAYMENT $260.75
 
S

Stefan B Rusynko

Try creating it in JavaScript using samples from
http://javascript.internet.com/calculators/

Or if you user also have Excel see
http://support.microsoft.com/default.aspx?scid=kb;en-us;229808




| Does anyone know how to create a finance calculator?
| I have all the math in an excel spreadsheet I have
| attached. I just need to put it in a format that the
| potential customer can go to my website and enter the
| numbers they want and calculate a payment.
|
| $10,000.00 Principal
| 8.00% APR
| 24 Term in Months
| $5,000.00 Balloon
| 12 #Months / Year
| 0.66667% Monthly Interest Rate
|
|
| Finance Payment Computation Balloon Discount Computation
| 1.0066667 1.01
| 1.17289 1.18
| 0.852596376 0.18
| 0.147403624 27.11
| 22.11054361 26.11
| 191.53
| $452.27 Finance Payment ($191.53)
| Balloon Discount
|
|
| LEASE PAYMENT $260.75
|
|
 
Top