ReePrime
Blog DMC
Learn Excel 2010 – “Variable Rate Loan Pmt”: #1438

Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.

Learn Excel 2010 – “Variable Rate Loan Pmt”: #1438

B
Bill Jelen

590 Views • Oct 03, 2011

Description

“I was in Milwaukee this week at the IIA Regional Conference when Heidi asked me about calculating a loan payment for a loan, with variable interest rates.” In Episode #1438, Bill shows us how to use Goal Seek to back into this answer.

Keywords & Tags

#2010 accounting Bill Jelen business Calculate a loan payment Payment Excel Functions Goal Seek MrExcel PMT spreadsheets technology tutorial Worksheet

More from User

02:34

MrExcel's Learn Excel #976 - Default Comment

Bill Jelen

03:19

Learn Excel 2010 - "Date Next to a Yes" #1474

Bill Jelen

07:51

Dueling Excel - "Rank Ties by Weight" #1473

Bill Jelen

03:39

Learn Excel 2010 – “Wrap Cells and Resize" #1472

Bill Jelen

02:08

Learn Excel 2010 - "Random with No Repeats" #1471

Bill Jelen

06:30

Learn Excel - "Copy Total to Weeks Macro": #1470

Bill Jelen

Related Videos

07:27

Excel For Beginners | Functions (spreadsheets) HD

Junior Lexus

05:04

How to Link Cells in Different Excel Spreadsheets

Alexia Angelina

02:11

Tip a Day - How To Keep A Constant In Excel And Other Spreadsheets - GeekBeat Tips & Reviews

Geek Beat TV

03:53

Calculating PV (Present Value) & PMT (Payment) Time Value of Money Problems using Excel

Gunnar Guthrie

03:48

Learn Excel 2010– “MrExcel Mailbag”: Podcast #1448

Bill Jelen

00:05

[PDF Download] Pivot Table Data Crunching: Microsoft Excel 2010 (MrExcel Library) [PDF] Full

Jgtr