Stuck on Percentage Calculation

[Vintage79]

Hello all!

I am trying to make a simple calculation to work out a property value. If a bank is willing to loan 360k with the understanding that you must put down a 10% deposit on a house, then you can buy a house up to 400k in value. I want to be able to enter the loan amount, and the deposit percentage, and find out the maximum property value.

I think the equation looks like this, where PV is property value: PV-(0.1*PV)=360. I then searched around, and found that it might be solved using a quadratic equation, like this: PV-(0.1)*PV-(360)=0. But I don't think this is taking me down a road that will help me find an Excel formula!

Can anyone help with this?

Thank you!

 

[AhoyNC]

Try:

Excel Workbook
	A	B
1	Loan	360,000
2	Down Payment	10%
3
4	Property Value	400,000
Sheet

 

[Vintage79]

Wow, that looks so simple now! Thanks so much for this, I struggled for ages trying to figure this out, before I eventually posted it here. It goes to show how easy it is to over-complicate stuff!

Thanks again!

 

[AhoyNC]

You're welcome. Thanks for the feedback.