Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Joint Loan Calculator

0

I need to know if there is a spreadsheet loan calculator for a home equity loan that is being paid for by two separate people. The original amounts borrowed are different, and I want to equally show the balance owed by each person. Thank you....

Answer
Discuss

Answers

0

There are functions in Excel which calculate loan repayments, including monthly or annual instalments due and remaining balance, based on the amount borrowed and the applicable rate of interest. A single loan taken out by two people would be handled like two loands with identical schedules and maturities. Please look at the examples and tutorials listed to the left of this post for inspiration. Then design your own worksheet to provide the exact information you want and, if necessary, come back here to get help with the deployment of some of the formulas you will need. You ought to be able to get exactly what you have in mind.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login