Warning

 

Close
Confirm Action

Are you sure you wish to do this?

Cancel Confirm
AR15.COM
2/15/2010 2:50:45 PM EDT
Terry Martinez is considering taking out a loan to purchase a desk. The furniture store manager rarely finances purchases, but will for Terry "as a special favor".  The rate will be 10% per year, and because the desk cost $600, the interest will come to $60 for a one year loan. Thus, the total price is $660 and Terry can pay it off in 12 installments of $55 each.

Use the interest rate of 10% per year to calculate the net present value of the loan. (Remember to convert to a monthly interest rate) Based on this interest rate, should Terry accept the terms of the loan?

TI 84
npv (10, 660, {55},{12}= $1034.75.............if he is only paying $660 total...... where under these conditions.....should'nt he be paying $1034.75.  

http://www.youtube.com/watch?v=qJ95zEqWid8
2/15/2010 2:51:52 PM EDT
[#1]
Tax
2/15/2010 3:00:53 PM EDT
[#2]
It's a simple interest arrangement, not a compound interest setup.
2/15/2010 3:08:35 PM EDT
[#3]
and failure at linking

http://www.youtube.com/watch?v=qJ95zEqWid8
2/15/2010 3:18:45 PM EDT
[#4]
If only there was a banker around here who wrote story prolems for a living.
2/15/2010 3:59:34 PM EDT
[#5]
Quoted:
Based on this interest rate, should Terry accept the terms of the loan?


No, he should not.  No one needs a desk that bad.  A $60 folding leg table or an old door will do until Terry can get his lazy ass to save $600 and buy it without paying interest for something that will *never* go up in value over time.  Sure, maybe he can deduct the interest or depreciate the desk, but $600 isn't that much to save or earn.

You're welcome.  
2/15/2010 4:38:22 PM EDT
[#6]
I know......I was taking a chance of getting flamed....Ive been working on homework for about five hours.....Im frucking pssssdddd oofffff.  Useless information.
2/15/2010 5:14:06 PM EDT
[#7]
I've been doing math homework for the last three days.  The thing about that problem, the way it's worded, makes no sense in what they want for an answer.  There is no other information to be able to decide for "Terry" if he should do it or not.
2/15/2010 5:41:54 PM EDT
[#8]
No...........can........help................math make Vini head hurt................................
2/15/2010 5:43:25 PM EDT
[#9]
Quoted:

No, he should not.  No one needs a desk that bad.  A $60 folding leg table or an old door will do until Terry can get his lazy ass to save $600 and buy it without paying interest for something that will *never* go up in value over time.    


Staying out of debt is an underutilized principle.
2/15/2010 5:52:57 PM EDT
[#10]
Quoted:
Terry Martinez is considering taking out a loan to purchase a desk. The furniture store manager rarely finances purchases, but will for Terry "as a special favor".  The rate will be 10% per year, and because the desk cost $600, the interest will come to $60 for a one year loan. Thus, the total price is $660 and Terry can pay it off in 12 installments of $55 each.
Use the interest rate of 10% per year to calculate the net present value of the loan. (Remember to convert to a monthly interest rate) Based on this interest rate, should Terry accept the terms of the loan?

TI 84
npv (10, 660, {55},{12}= $1034.75.............if he is only paying $660 total...... where under these conditions.....should'nt he be paying $1034.75.  

http://www.youtube.com/watch?v=qJ95zEqWid8


If the contract says "total price is $660....12 payments of $55 each", that is that. No sense in doing fancy schmancy 10%/12months = blah blah times $660 etc.

12 payments of $55, only Terry can decide if he will/shall accept the terms.

Would I accept them? Don't need a desk right now, so no thanks.

2/15/2010 5:58:06 PM EDT
[#11]



Quoted:


Terry Martinez is considering taking out a loan to purchase a desk. The furniture store manager rarely finances purchases, but will for Terry "as a special favor".  The rate will be 10% per year, and because the desk cost $600, the interest will come to $60 for a one year loan. Thus, the total price is $660 and Terry can pay it off in 12 installments of $55 each.



Use the interest rate of 10% per year to calculate the net present value of the loan. (Remember to convert to a monthly interest rate) Based on this interest rate, should Terry accept the terms of the loan?







Terry is a dumbass.



CL has a whole page of free desks, 11 listed just today
 
2/15/2010 6:49:24 PM EDT
[#12]
Is the desk made in the USA, or is it from IKEA?
2/15/2010 7:10:32 PM EDT
[#13]
Quoted:
Quoted:
Terry Martinez is considering taking out a loan to purchase a desk. The furniture store manager rarely finances purchases, but will for Terry "as a special favor".  The rate will be 10% per year, and because the desk cost $600, the interest will come to $60 for a one year loan. Thus, the total price is $660 and Terry can pay it off in 12 installments of $55 each.
Use the interest rate of 10% per year to calculate the net present value of the loan. (Remember to convert to a monthly interest rate) Based on this interest rate, should Terry accept the terms of the loan?

TI 84
npv (10, 660, {55},{12}= $1034.75.............if he is only paying $660 total...... where under these conditions.....should'nt he be paying $1034.75.  

http://www.youtube.com/watch?v=qJ95zEqWid8


If the contract says "total price is $660....12 payments of $55 each", that is that. No sense in doing fancy schmancy 10%/12months = blah blah times $660 etc.

12 payments of $55, only Terry can decide if he will/shall accept the terms.

Would I accept them? Don't need a desk right now, so no thanks.



Interest problems are easy to do if you have Excel or another spreadsheet program.  You don't need interest formulas at all.

a1 "Starting Balance"
b1 "Payment"
c1 "Balance"
d1 "Balance + Interest"

a2  600
b2   55
c2  =a2-b2
d2  =C3*(1+0.1/12)

a3  =d2  
b3  55
c3  =A3-B3
d3  =C3*(1+0.1/12)

Then copy cells a3 to d3 down through row 13.

I believe he overpays by about $34.04 (compared to if monthly compoounding was used)  because his balance has decreased each month.  But the problem gives no reason to compare to monthly compounding.  Why not compare to instantaneous compounding.  It's a poorly explained problem.


2/15/2010 7:37:30 PM EDT
[#14]
Barbie says, "Math class is HARD!"
2/15/2010 7:50:33 PM EDT
[#15]
Terry, Casey, Kim, Pat, Stacey, Lynn, Drew,  where did we establish this was a dude? you guys are forgetting something...



2/15/2010 8:18:56 PM EDT
[#16]
Scope Scare...thank you...Ive tried using Excel and have since switched to the TI 84 just because it seems easier.  Ill go back to excel and give it a shot....Math scares me....Im not sure why but it causes me issues.  Thanks.
2/15/2010 9:35:18 PM EDT
[#17]
Quoted:
No...........can........help................math make Vini head hurt................................


+a bottle of Tylenol
2/15/2010 9:54:39 PM EDT
[#18]
"What am I NOT getting?"



Laid.


2/15/2010 9:57:15 PM EDT
[#19]
Quoted:
"What am I NOT getting?"

Laid.


2/16/2010 11:41:12 AM EDT
[#20]
Want a real answer?  He's paying the interest for the full amount for the full year:  10% x $600.  Since's he's paying it off monthly, though, he shouldn't HAVE to pay interest on the full amount for the entire year.  He should not take the loan.  If he has to "pre pay" the entire interest amount, then he shouldn't have to make any monthly payments, but just pay the full lump sum at the end of the year.

Rob
2/16/2010 12:12:52 PM EDT
[#21]
Alternately, ask if the buyer is okay with paying ~18% interest on the desk, which is roughly what $55/month for 12 months - $600 principal+$60 interest works out to be.


~Icarus
2/16/2010 12:49:37 PM EDT
[#22]


I know what you aren't.  You aren't GettingThat.  He lives on the dry side.
HA!





I kill me