•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Making table to show home ownership % between 2 people
I'm trying to find a formula to calculate home ownership by monthly mortgage contribution but not sure how?
Like for example a house costs 200k, each person contributes about 1k a month (might pay more or less monthly) so that's 2k total. Mortgage minimum is 1.6k
Is there a way to calculate the percentage of who owns more of the house by their contributions? With the mortgage contributions from each person that can fluctuate?
I've tried doing $1,000/$200,000=50% for person 1 But for person 2 it's $1,400/$200,000=70%
And that doesn't add up to 100% I don't know what I'm missing here, if any clarification is needed I can provide it.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#AI formula generation techniques
#Excel compatibility
#financial modeling with spreadsheets
#formula generator
#Excel alternatives
#home ownership
#monthly mortgage contribution
#house cost
#mortgage minimum
#percentage ownership
#contributions
#fluctuate contributions
#ownership calculation
#mortgage payments
#shared ownership
#equity split