excel training class

excel training class - PMT

Resolved · Low Priority · Version Standard

PMT

Neil has attended:
Excel Advanced course

by - delegate Neil [2 posts] (2008 Jan 24 Thu, 14:04) Reply

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?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu	Bayswater	2	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	2	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
2007	2008 Dec 16 Tue	Bayswater	6	book now	£207	£215
Full Schedule: See all 109 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: PMT

by - trainer Mark gold contributer [275 posts] (2008 Feb 1 Fri, 11:56) Reply

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

· Training Budgets In A Bad Economy
· Excel and Inventory Management
· Microsoft Excel Training - Numerical excellence for all
· Reasons Why VBA for Excel Training Fails
· Features of Microsoft Excel that assist in Analysis of Financial Data

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips

Rate this page: