I can add more detail later.
Here is a spreadsheet I put together.
Ignores growth
Assumes 2% price increases.
Starts in Yr 1 with leasing 1000 buses.
Assumes about 12,000 buses.
1000 new ones each year.
1000 buses are 12 years old each year and are retired/sold for almost nothing.
6 years of leasing 1000 buses/yr. ($8.5M)
6 year of financing and 6 yr amortization of lease buyout each year ($4M/yr)
$70k buses.
Every year after year 12 looks virtually identical. This shows the progression.
I think we are in year 4 or 6 approx.
Cost to purchase buses as a % of sales.
Thoughts? I am sure I am missing lots. just trying to get a sense of how the finances will develop over time
(hopefully it formats ok)
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| $550,000,000.00 | $561,000,000.00 | $572,220,000.00 | $583,664,400.00 | $595,337,688.00 | $607,244,441.76 | $619,389,330.60 | $631,777,117.21 | $644,412,659.55 | $657,300,912.74 | $670,446,931.00 | $683,855,869.62 |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $4,000,000.00 | $4,000,000.00 | $4,000,000.00 | $4,000,000.00 | $4,000,000.00 | $4,000,000.00 |
| | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $4,000,000.00 | $4,000,000.00 | $4,000,000.00 | $4,000,000.00 | $4,000,000.00 |
| | | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $4,000,000.00 | $4,000,000.00 | $4,000,000.00 | $4,000,000.00 |
| | | | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $4,000,000.00 | $4,000,000.00 | $4,000,000.00 |
| | | | | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $4,000,000.00 | $4,000,000.00 |
| | | | | | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $4,000,000.00 |
| | | | | | | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 |
| | | | | | | | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 |
| | | | | | | | | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 |
| | | | | | | | | | $8,500,000.00 | $8,500,000.00 | $8,500,000.00 |
| | | | | | | | | | | $8,500,000.00 | $8,500,000.00 |
| | | | | | | | | | | | $8,500,000.00 |
| | | | | | | | | | | | |
| $8,500,000.00 | $17,000,000.00 | $25,500,000.00 | $34,000,000.00 | $42,500,000.00 | $51,000,000.00 | $55,000,000.00 | $59,000,000.00 | $63,000,000.00 | $67,000,000.00 | $71,000,000.00 | $75,000,000.00 |
| | | | | | | | | | | | |
| 1.55% | 3.03% | 4.46% | 5.83% | 7.14% | 8.40% | 8.88% | 9.34% | 9.78% | 10.19% | 10.59% | 10.97% |