Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loan Amortization in a cell
I'm a Home Loan Officer in Los Angeles and I'm creating a Finance sheet for
some realtors I work with for there open houses and I'm looking to give examples of payments. So what I need is the formula of the Loan Amortization of a 30 year fixed loan. Is there documentation on it that breaks it down sot that know how to apply it with my sheet? Larry Hughes Progressive Loan Funding (323) 228-2736 cell |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loan Amortization in a cell
Try here
http://office.microsoft.com/en-us/te...on&av=TPL000-- Jock "Larry Hughes" wrote: I'm a Home Loan Officer in Los Angeles and I'm creating a Finance sheet for some realtors I work with for there open houses and I'm looking to give examples of payments. So what I need is the formula of the Loan Amortization of a 30 year fixed loan. Is there documentation on it that breaks it down sot that know how to apply it with my sheet? Larry Hughes Progressive Loan Funding (323) 228-2736 cell |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loan Amortization in a cell
Look at the PMT (Payment) function in Excel help.
there are a series of related functions associated with PMT. In the help click on the See also Link. The PV (present Value) formula help actually has the "master" formula for these functions and provides greater detail. -- Regards, Tom Ogilvy "Larry Hughes" wrote: I'm a Home Loan Officer in Los Angeles and I'm creating a Finance sheet for some realtors I work with for there open houses and I'm looking to give examples of payments. So what I need is the formula of the Loan Amortization of a 30 year fixed loan. Is there documentation on it that breaks it down sot that know how to apply it with my sheet? Larry Hughes Progressive Loan Funding (323) 228-2736 cell |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loan Amortization in a cell
Tom, I used the PMT and it seemed to work for me but...
The number is a negative number by default because it is a payment. I need to know how to change the sign or change it to a positive number. On my HP financial calculater there is "CHS" key for change sign. I need to do this because I have other cells dependant on this cell and when it is a negative number it through the rest of the work sheet off. I have uploaded the excell sheet for your viewing to the following; http://www.larryhughesjr.com/NewScenario.xls The row I'm referring to is Mortgage Payment Row, Columns B,C, and D Any help you can give would be appreciated! Larry Hughes 323 228-2736 cell "Tom Ogilvy" wrote: Look at the PMT (Payment) function in Excel help. there are a series of related functions associated with PMT. In the help click on the See also Link. The PV (present Value) formula help actually has the "master" formula for these functions and provides greater detail. -- Regards, Tom Ogilvy "Larry Hughes" wrote: I'm a Home Loan Officer in Los Angeles and I'm creating a Finance sheet for some realtors I work with for there open houses and I'm looking to give examples of payments. So what I need is the formula of the Loan Amortization of a 30 year fixed loan. Is there documentation on it that breaks it down sot that know how to apply it with my sheet? Larry Hughes Progressive Loan Funding (323) 228-2736 cell |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loan Amortization in a cell
I figured it out... since the PMT function puts out a negative number I just
changed the PV in the equation to a negative number. Two negatives equal a positive. Thanks again! Larry Hughes 323.228.2736 cell "Tom Ogilvy" wrote: Look at the PMT (Payment) function in Excel help. there are a series of related functions associated with PMT. In the help click on the See also Link. The PV (present Value) formula help actually has the "master" formula for these functions and provides greater detail. -- Regards, Tom Ogilvy "Larry Hughes" wrote: I'm a Home Loan Officer in Los Angeles and I'm creating a Finance sheet for some realtors I work with for there open houses and I'm looking to give examples of payments. So what I need is the formula of the Loan Amortization of a 30 year fixed loan. Is there documentation on it that breaks it down sot that know how to apply it with my sheet? Larry Hughes Progressive Loan Funding (323) 228-2736 cell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
loan amortization loan in months | Excel Worksheet Functions | |||
Loan Amortization | Excel Worksheet Functions | |||
loan amortization template with loan start date AND first payment | Excel Discussion (Misc queries) | |||
loan amortization | New Users to Excel | |||
Loan amortization | Excel Worksheet Functions |