it would be great to get some kind of DCF / NPV calculation (as another XLS model) on the level of an individual robot. The interest rate should be an input parameter, maybe we assume 10% for now.

VariablesCostOccurances Over PeriodAmortization periodAmortized Cost $/OccuranceOccurancesMonths$Monthly revenue$6,5002424$6,500 Robot Cost$190,000160$3,167Service Visit Cost$3,000824$1,000Depot inspection$600424$100Tech Support$1882424$188Training (classroom + OJT)$7,350124$306Training T&E$2,000124$83Mobilization$3,000424$500Materials (Replacement Parts)$4,000224$333 Q4 2023Q1 2024Q3 2024Q1 2025Revenue$6,500$10,000$11,000$13,500 Robot Depreciation$2,750$3,667$3,167$2,833Field Support - Personnel Cost$250$200$150$125Field Support - Travel$750$550$350$125Depot Repair$100$100$100$100Technical Support$188$141$106$79Training$306$230$172$129Training T&E$83$83$83$83Mobilization$500$500$250$125Materials (Replacement Parts)$333$333$333$333Total Direct Costs$5,261$5,804$4,711$3,934Gross Profit$1,239$4,196$6,289$9,566Gross Margins19.06%41.96%57.17%70.86% Total Direct Costs wo/ Depreciation$2,511$2,137$1,545$1,100Contribution Margin$3,989$7,863$9,455$12,400Robot BOM Cost$165,000$220,000$190,000$170,000Payback Period3.42.31.7