excel training class - pmt

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Train Strikes - 7th, 12th Nov 2024
Hide
Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training class - PMT

excel training class - PMT

resolvedResolved · Low Priority · Version Standard

Neil has attended:
Excel Advanced course

PMT

Is there a formula I can use to be able to show month on month how much a loan reduces and factor in any changes in interst rate, e.g. mortgage repayments?

RE: PMT

Hiya Neil hope you are well sorry we have not got back to sooner.

With regards to the PMT formula you can find one by using the function wizard from the insert menu and clicking function under the financial category.

But in saying that i can go one better than that because a template that you can simply enter in all the stats you will need eg: loan term, payments per year etc...

then the template does it for you and if anything changes you go back in and update the info and the template updates the rest

to find this template go to the your file menu and click new, from the window you see choose the spreadsheet solutions tab and then double click the Loan Amortization

When finished do a file save as

Hope this helps

Mark East


 

Excel articles

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.08 secs.