Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calciation
i want to calk a loan in excel - and the
Variabels is :- rent, loan amount, year x, and total year payback I want to calk the rest loan after x year (input value from user) the user shall put in totalloan ,rent, years total to pay back. the sheet shall show : rents and payments - every year too year (X ) and rest amount in the end of year x not show the total period !! How can i calc this ? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calciation
Hi,
Take a look at the Financial function in Excel such as PMT, FV, IPMT, PPMT. -- If this helps, please click the Yes button Cheers, Shane Devenshire "AH" wrote: i want to calk a loan in excel - and the Variabels is :- rent, loan amount, year x, and total year payback I want to calk the rest loan after x year (input value from user) the user shall put in totalloan ,rent, years total to pay back. the sheet shall show : rents and payments - every year too year (X ) and rest amount in the end of year x not show the total period !! How can i calc this ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|