Financial Modeling: Minimum sale price to be able to pay down Debt by year 3

So I wanted to see if there is an efficient way to model this:

I have a schedule of cashflows that is connected to a schedule of sales for various parcels of real estate. the parcels of real estate are broken out in 3 buckets with bucket one being all sold by year 2, bucket two by year three.

We have a constraint to pay down all of the debt and interest by year 3. We have made assumptions as to the sale prices per acre of each of the lots in each of the bucket. bucket one has about 3 lots and bucket B has about 7 and derived the cashflows and the debt paydown schedule.

We want to figure out what is the minimum price per acre for each of the lots we can afford to sell at to be able to paydown the debt by the end of year 3 as stipulated.

Any efficient way to do this in excel with add-ins, or other ways to go about this?

Thanks!

 

You probably need to expand a bit on your problem (or perhaps just clarify). On face, the issue seems deceivingly simple. You have L number of lots to sell, and must sell at some unit price, P, sufficiently high for L * P to equal or exceed debt balance, D.

Assuming P grows each year, just set P1 (price in year one) as a variable, and ascribe growth rates to get P2 and P3. You can Goal Seek to find the value for P1 that will make the quantity P1L1 + P2L2 + P3*L3 = D.

 

However, I need to figure out a way to find the minimum prices for p1, p2, p3 (nto just p1) etc and also take into account the buckets. is that too many variables to have a solution?

So bucket one contains 3 lots. so p1l1 + p2l2 + p3*l3 = proceeds from bucket one. then i have bucket two that contains 7 lots. so pr(proceeds) from bucket a + pr bucket b = D . Now to find out each of those L's min prices is what I am looking for. There seems to be too many variables to do this efficiently?

Thanks for your help!

 

Pariatur in quos totam quos et placeat. Nihil et sit consequatur. Numquam sint inventore consequuntur eaque quia laboriosam. Debitis ducimus pariatur quam ea labore autem. Consequuntur magnam sequi et modi facere est voluptatem. Quidem consequatur ullam in quia.

Expedita non rerum unde qui laboriosam ipsum fugiat. Temporibus commodi ad sint corrupti ut accusamus. Repellendus quia consequatur qui placeat aut repellendus blanditiis.

Voluptates autem commodi facilis ducimus enim. Natus error occaecati recusandae eum quia ut facilis ad. Voluptates atque nihil magnam ab. Similique corrupti rerum officiis omnis eaque ipsa.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Betsy Massar's picture
Betsy Massar
99.0
5
kanon's picture
kanon
98.9
6
dosk17's picture
dosk17
98.9
7
GameTheory's picture
GameTheory
98.9
8
CompBanker's picture
CompBanker
98.9
9
DrApeman's picture
DrApeman
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”