Calculate Max borrowing based on funds available cell and LVR of 88%

**Totalegazy** · 04-08-2024, 01:58 AM

Hi Guys,

I am hoping someone can help me out. Really stumped with this one.

I want to calculate the potential purchase price based off the amount of funds avaialble in Cell E51 and continued all the way up to cell W51 if each year and a max loan to value ratio of 88%, like the example provided above.

If you are not sure what Loan to Value ratio is it is calcuated as the % of the loan balance against the value of the property

This potential price has nothing to do with the property details at the top. This is based on the available equity in the property, how much they could spend on the next property.

I understand this might be a difficult calculation and that is why I require help.

Thanks in advance

**AliGW** · 04-08-2024, 02:06 AM

Where have you mocked up expected results? I can see your notes, but it's a busy worksheet and you really need to make it easier to find all of the relevant cells and ranges.

Remember this is YOUR data, so you understand it implicitly. Others will need some more specific signposting.

**Totalegazy** · 04-08-2024, 02:16 AM

I have highlighted the first of the cells that require this formula.

I have no idea where to start with this formula. I have provided a screenshot of my source that I want to replicate on the right side of the table.

I want to be able to use the funds available in the surplus to reinvest row starting with cell E51 and a total LVR (Loan to value ratio) of 88% to determine the next property purchase price after each year. This will be in found in cell E53 - W53.

These are the two inputs in the source screenshot, to work out the potential property value.

I hope that makes sense.

Thanks

**AliGW** · 04-08-2024, 02:21 AM

I can see E53 highlighted. I can help you with a formula if you tell me the manual calculation needed to reach that figure. What I can't do is work out the maths - that's not what the forum is about (as I am sure you realise).

So what's the manual calculation and where (which cells) are the relevant values coming from?

**Totalegazy** · 04-08-2024, 02:32 AM

I have highlighted the first of the cells that require this formula.

I have no idea where to start with this formula. I have provided a screenshot of my source that I want to replicate on the right side of the table.

I want to be able to use the funds available in the surplus to reinvest row starting with cell E51 and a total LVR (Loan to value ratio) of 88% to determine the next property purchase price after each year. This will be in found in cell E53 - W53.

These are the two inputs in the source screenshot, to work out the potential property value.

I hope that makes sense.

ThanksInvestment-property-spreadsheet - Example.xlsx

**AliGW** · 04-08-2024, 02:38 AM

OK - so from what you are saying, you don't know what the calculation required is.

Be aware that this is a forum about Excel rather than a maths forum. You may get lucky - someone here may happen to know how this sort of thing is calculated, but as I said, that's not ultimately what the forum is about: the forum is about facilitating calculations that you know how to make but cannot replicate yourself with the software.

I'll have one more look, but I suspect that I shan't be able to help.

EDIT: I looked again and am none the wiser, sorry.

**6StringJazzer** · 04-08-2024, 07:03 AM

This looks like the same question and same file as this thread which you marked SOLVED

https://www.excelforum.com/excel-gen...e-and-lvr.html

Please explain how this is different or I am going to close this as a duplicate.

**6StringJazzer** · 04-08-2024, 07:15 AM

The calculation of loan-to-value based on available funds is straightforward

Max loan = Funds*LTV/(1-LTV)

The thing that is really unclear about your question is where we get the amount of funds available. Do we sum up all of the numbers in row 51? Or is it cumulative? Are you trying to get results per year, or a total? Where does 88% come from? There is no cell in your sheet that has 88% as a parameter. These are the same questions that were unclear in your previous thread, and yet you marked it SOLVED.

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #2 about thread duplication.

**AliGW** · 04-08-2024, 08:48 AM

Is this thread now meant to be closed?

**6StringJazzer** · 04-08-2024, 09:28 AM

I'm giving the OP a chance to tell me why it should not be closed. I can't tell if the question has changed, or if it is only an attempt to restate the exact same question.

Calculate Max borrowing based on funds available cell and LVR of 88%

LinkBack

Thread Tools

Rate This Thread

Display

Calculate Max borrowing based on funds available cell and LVR of 88%

Re: Calculate Max borrowing based on funds available cell and LVR of 88%

Re: Calculate Max borrowing based on funds available cell and LVR of 88%

Re: Calculate Max borrowing based on funds available cell and LVR of 88%

Re: Calculate Max borrowing based on funds available cell and LVR of 88%

Re: Calculate Max borrowing based on funds available cell and LVR of 88%

Re: Calculate Max borrowing based on funds available cell and LVR of 88%

Re: Calculate Max borrowing based on funds available cell and LVR of 88%

Re: Calculate Max borrowing based on funds available cell and LVR of 88%

Re: Calculate Max borrowing based on funds available cell and LVR of 88%

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Calculate Max Loan amount based on funds available and LVR

Calculate total funds used, from a list of start & end times for individual trades.

[SOLVED] A formula to directly calculate the minimum sum without borrowing auxiliary columns

Calculate the date out of funds given a known expenditure plan each month

interactive scenarios based on available funds

[SOLVED] Calculate proportionately across all funds

[SOLVED] if statement to calculate distribution of funds

Bookmarks

Bookmarks

Posting Permissions