Location: Spring, TX
The attached spreadsheet model is for Reliable Emergency Vehicles, Inc. and the company is listed for $1,925,000. REV Inc. has been making and selling new and used ambulances since 1992 and is located in Spring, Texas. Included in the spreadsheet is a pro forma income statement and balance sheet, a tab indicating a high low forecast with an option to expand, and a tab showing a forecast leading to bankruptcy and the costs of bankruptcy. The spreadsheet allows for computations to be changed.
With the input values chosen, the model has a weighted average cost of capital of 7% with a 51% debt proportion.