Homework Question

Status
Not open for further replies.

dbk

Lifer
Apr 23, 2004
17,685
10
81
Do you really write out your name like that?
Isn't it just using the PMT function?
 

JM Aggie08

Diamond Member
Jan 3, 2006
8,419
1,009
136
Irate =VLOOKUP(C4,$A$17:$C$19,2)

Dpmt =VLOOKUP(C4,$A$17:$C$19,3)*B4

AMT Fin. = B4 - E4

Monthly PMT =PMT(D4/$C$4,$C$4*12,F4)
 

looker001

Banned
Jun 25, 2007
603
0
0
Why are you doing b4-c4 for amt finance? Should it not be b4-e4 being that is your down payment?

edit:looks like it's a typo when you posted.
 

JM Aggie08

Diamond Member
Jan 3, 2006
8,419
1,009
136
Originally posted by: looker001
Why are you doing b4-c4 for amt finance? Should it not be b4-e4 being that is your down payment?

edit:looks like it's a typo when you posted.

Ya, my bad.
 
Status
Not open for further replies.