Please critique my CapEx Allowance formula
These assumptions are based on a particular sqr footage. But how do you think the basic methodology works?
thanks!
| Item | Cost | Life years | Months | Cost Per Month |
| Roof | $ 6,000.00 | 25 | 300 | $ 20.00 |
| HVAC | $ 4,500.00 | 15 | 180 | $ 25.00 |
| Hot H2O | $ 550.00 | 8 | 96 | $ 5.73 |
| Flooring Carpet | $ 1,800.00 | 5 | 60 | $ 30.00 |
| Flooring Laminate Wood | $ 1,800.00 | 10 | 120 | $ 15.00 |
| Interior Paint | $ 2,500.00 | 6 | 72 | $ 34.72 |
| Exterior Paint | $ 3,000.00 | 8 | 96 | $ 31.25 |
| Revamp Plumbing | $ 1,500.00 | 20 | 240 | $ 6.25 |
| Revamp Electrical | $ 3,500.00 | 30 | 360 | $ 9.72 |
| Misc | $ 200.00 | 1 | 12 | $ 16.67 |
| Monthly CapEx Allowance | _ | _ | _ | $ 179.34 |