help with EXCEL
Thread Starter
The Oracle of Acurazine!
Joined: Nov 2003
Posts: 28,706
Likes: 44
From: Fresno, CA
help with EXCEL
Cost of equipment $8,750
Down Payment 0
Amount of loan $8,750
Annual Interest rate 7%
Years to pay 3
cellB16: Monthly payment ($270)
Total cost of the loan ($9,726)
use the "goal seek" to get the payment down to $200 by adjusting your down payment.
how do i do that on excel?
Down Payment 0
Amount of loan $8,750
Annual Interest rate 7%
Years to pay 3
cellB16: Monthly payment ($270)
Total cost of the loan ($9,726)
use the "goal seek" to get the payment down to $200 by adjusting your down payment.
how do i do that on excel?
Photography Nerd
Joined: Sep 2003
Posts: 21,489
Likes: 11
From: Toronto
Don't reinvent the wheel. There are a million loan calculators on the web: http://www.google.com/search?sourcei...oan+calculator
Don't listen to me.
Joined: Sep 2003
Posts: 4,053
Likes: 1
From: Visalia CA
Re: help with EXCEL
Originally posted by AcuraTLjaTT559
Cost of equipment $8,750
Down Payment 0
Amount of loan $8,750
Annual Interest rate 7%
Years to pay 3
cellB16: Monthly payment ($270)
Total cost of the loan ($9,726)
use the "goal seek" to get the payment down to $200 by adjusting your down payment.
how do i do that on excel?
Cost of equipment $8,750
Down Payment 0
Amount of loan $8,750
Annual Interest rate 7%
Years to pay 3
cellB16: Monthly payment ($270)
Total cost of the loan ($9,726)
use the "goal seek" to get the payment down to $200 by adjusting your down payment.
how do i do that on excel?
Note: change only the amt and/or down payment
Don't listen to me.
Joined: Sep 2003
Posts: 4,053
Likes: 1
From: Visalia CA
Originally posted by Dan Martin
Don't reinvent the wheel. There are a million loan calculators on the web: http://www.google.com/search?sourcei...oan+calculator
Don't reinvent the wheel. There are a million loan calculators on the web: http://www.google.com/search?sourcei...oan+calculator
Thread Starter
The Oracle of Acurazine!
Joined: Nov 2003
Posts: 28,706
Likes: 44
From: Fresno, CA
thanx guys.... i was doing a test on EXCEL yesterday, i had trouble doing it but.. then i figured it out... and ortiz... dont delete that yet... i'll save it today later on...
thanx again
thanx again
Trending Topics
Thread
Thread Starter
Forum
Replies
Last Post
08_UA7_Gr33k
Member Cars for Sale
13
Feb 11, 2016 02:17 PM
InFaMouSLink
Car Parts for Sale
6
Oct 27, 2015 06:52 PM
08_UA7_Gr33k
Member Cars for Sale
1
Sep 27, 2015 01:56 PM