Interest only loans w/ minimum payment

condoman

New Member
Joined
Jan 23, 2005
Messages
5
I am trying to create a spreadsheet for different loan structures. I am having difficulty with this last one.

I want to calculate the payment on a interest only loan where the mortgagor can pay a minimum fee. (This is very similar to a credit card payment structure).

The loan amount is 496,500.
The rate on the loan is 4.762%
The minimum monthly payment is .95%
The period is 30 years.

Any ideas???

:eek:
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
Condoman: If you will only state all the rules that govern what you are talking about, you will get your answer. Without knowing the rules, anything we can come up with is stricktly a guess!

For instance, are the monthly payments to be equal? Obviously not, since a 0.95% payment of the original loan amount would pay up the debt in ess than 30 years. However, paying only 0.95% of the remaining balance every month cannot pay up the loan in 30 years. So, what is the rule to follow for the monthly payments? Do tell us.
 

Forum statistics

Threads
1,147,665
Messages
5,742,500
Members
423,733
Latest member
hamann666

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top