Question: Develop a break-even analysis equation using the data below examining purchasing Farm A vs. Farm B for the purpose of stall rental opportunities during the

Develop a break-even analysis equation using the data below examining purchasing Farm A vs. Farm B for the purpose of stall rental opportunities during the 5-month winter high season (December-April).

Plot a break-even analysis model in excel (or by hand) for both Farm A vs. Farm B.

Farm A:

20 stalls on property

Stall rental: $20,000/stall for the season

Expenses:

Maintenance

$150,000

Property tax

$182,900

Association fees

$10,404

Property tax

$42,969

Insurance

$ 69,756

Total Expenses = $456,029

Farm B:

20 stalls on property

Stall rental: $12,000/stall for the season

Expenses

Maintenance

$200,000

Property tax

$152,220

Association fees

$5,400

Property tax

$105,709

Insurance

$ 58,056

Total Expenses = $521,385

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!