i need some major help here please. i need to create a mortgage calculator in excel when the user inputs the value of the mortgage, annual rate, loan duration, balloon payment, and number of pay periods a year. then i need to calculate the total payment of the mortgage. any ideas here?????? be specific please.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
mortgage calculator
- Thread starter futbwal15
- Start date
SkipVought
Programmer
Hi,
Check out the PMT and PPMT functions.
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
[red][/red]![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]- Status