Decreasing loan principle over a term

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Sort by date Sort by votes
Hi Perhaps:-
Code: 
[COLOR="RoyalBlue"][B]Row No [/B][/COLOR] [COLOR="RoyalBlue"][B]Column(A) [/B][/COLOR] [COLOR="RoyalBlue"][B]Column(B) [/B][/COLOR] [COLOR="RoyalBlue"][B]Column(C)          [/B][/COLOR]
1.      Principle  Rate 10%   7 Years as Mths    
2.      10000      0.1        84                 
3.      Rep/Mth    166.0118   =PMT(B2/12,C2,-A2)
Regards Mick
 
Upvote 0
You must log in or register to reply here.

Similar threads

trishcollins
  • Question Question
Looking for formula/VBA to determine where to best put extra funds
Replies
1
Views
225
trishcollins
trishcollins
M
  • Question Question
Amortization Schedule with SOFR
Replies
1
Views
869
KRice
K
J
  • Question Question
Actual loan rate with fees calculation
Replies
6
Views
485
Dave Patton
D
B
  • Solved
Back Solve for the Starting Loan Amount
Replies
2
Views
273
baileyisnotreal
B
spacecaptainsuperguy
  • Question Question
Advice for linked files on network drive
Replies
0
Views
712
spacecaptainsuperguy
spacecaptainsuperguy

Forum statistics

Threads
1,223,214
Messages
6,170,772
Members
452,353
Latest member
strainu

Share this page

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
Back
Top