Can someone help me with a calculation/amortization

[Seymour]

suppose I paid $200 per month for the last 26 years and it was running at 5% - how much would the payee owe me to pay back everything with the interest - thanks

 

[PatsFan1283]

It would take 128,383 for you not to break their legs.

 

[Hamilbet]

Loan Amount	35,000
	Annual Interest Rate	<input value="5.00%" name="p1E8" id="p1E8" type="text" tabindex="2" class="ee130" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; font-family: Tahoma, sans-serif; font-size: 11pt; text-align: right; vertical-align: bottom; width: 136px;">
	Term of Loan in Years	26
	First Payment Date	7/1/1990
	Frequency of Payment	<select name="p1E11" id="p1E11" size="1" tabindex="5" class="ee130" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; color: windowtext; font-family: Tahoma, sans-serif; font-size: 11pt; text-align: right; vertical-align: bottom; width: 136px;"> <option value="Annually">Annually</option> <option value="Semi-Annually">Semi-Annually</option> <option value="Quarterly">Quarterly</option> <option value="Bi-Monthly">Bi-Monthly</option> <option value="Monthly" selected="selected">Monthly</option> <option value="Bi-Weekly">Bi-Weekly</option> </select>
	Rate (per period)	0.417%
	Payment (per period)	200.67
	Number of Payments	312
	Total Payments	$62,609.12
	Total Interest	$27,609.12

<tbody>
</tbody>

 

[festeringZit]

Am I missing something, why would you not just need back the money you paid out?

I.e. 26 * 12 * $200 = $62,400

 

[festeringZit]

Are you saying you want 5% of the money you paid out, over time?

 

[PatsFan1283]

Yeah, 62,400 is the answer if it was a loan at 5% and the payment was 200 a month

The way I answered it he loaned out $200 at 5% over 26yrs and it compounded and now it is due.

 

[Willie99]

I have some of the best and most versatile amortization software at my office Seymour, I'll post calculation in the morning

 

[PatsFan1283]

You need a calculator? Pfft

I do it in my head rainman style

j/k

 

[Willie99]

Invest $ 200 per month for 26 years
Earn 5% return on your money

FMV in 26 years = $ 128,182.86

 

[RunMaker]

Willie is a machine!

 

[Seymour]

Thanks