| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Financial formulae
Hello!
I have: A1 Value of loan B1 annual interest C1 60 Months (Period) D1 Loan amortization (to intercalate) E1 (Formulae to calc montly income of interest) F1 (Formulae to calc montly income of loan) G1 =Sum(E1+F1) Whe 1st income = 100% interest and 0% amortization; Last income = 0% interest and 100% amortization. Is it possible with excel formulae, please? Thanks in advance. an |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
| cell format for financial functions | Excel Discussion (Misc queries) | |||
| vlookup change column index position - without changing formulae | Excel Worksheet Functions | |||
| How do I change the "Project Type" in "law Firm Financial Analys.. | Excel Discussion (Misc queries) | |||
| Where can I see VBA code for financial functions? | Excel Worksheet Functions | |||
Threaded Mode
