Microsoft Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2203489%22%20slang%3D%22en-US%22%3EMicrosoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2203489%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20Excel%20have%20the%20ability%20to%20calculate%20mortgage%20payments%20based%20on%20the%20principle%2C%20the%20interest%20rate%20and%20the%20length%20of%20the%20loan%20period%3F%20And%20if%20not%20is%20there%20any%20plans%20to%20add%20it%20in%20updates%3F%3C%2FP%3E%3CP%3EAl_H513%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2203489%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Does Excel have the ability to calculate mortgage payments based on the principle, the interest rate and the length of the loan period? And if not is there any plans to add it in updates?

Al_H513

1 Reply

@Al_H513 

You can use the PMT function for this. See Estimate mortgage payment 

Lower down in that article you'll find links to other financial functions in Excel.