amz-cash-flow-forecaster-dd7

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Cash Flow Forecaster (DD+7)

DD+7现金流预测工具

Amazon's DD+7 policy holds funds until 7 days after the estimated delivery date. For sellers used to weekly biweekly payouts, this is a working-capital shock that can leave a healthy business out of cash. This skill models the gap and sizes the buffer.
亚马逊的DD+7政策会将资金冻结至预计交付日期后的7天。对于习惯每周或每两周收款的卖家来说,这会对营运资金造成冲击,甚至可能让运营状况良好的企业陷入现金流短缺。本技能可模拟资金缺口并计算所需的缓冲额度。

When to use this

使用场景

  • DD+7 just kicked in for the seller's account.
  • Planning Q4 and worried about cash held through the peak.
  • Sales are growing fast and the seller does not know if cash can keep up.
  • Considering FBM or 3PL to shorten the payout cycle.
  • 卖家账户刚启用DD+7政策。
  • 规划第四季度,担心旺季期间资金被冻结。
  • 销售额快速增长,卖家不确定现金流能否跟上。
  • 考虑使用FBM或第三方物流(3PL)来缩短付款周期。

The framework. The DD+7 Cash Cycle

框架:DD+7现金流周期

Cash held by Amazon at any moment = sales of the trailing window held through estimated delivery + 7 days. Three factors determine how much:
  1. Daily sales rate. Higher sales = more cash in the pipeline at once.
  2. Transit time. Faster delivery (Prime, regional FBA) clears cash sooner. Slow delivery (FBM, oversize, international) extends the hold.
  3. Refund and return rate. Refunds reduce the released amount and stretch the effective cycle.
The buffer formula: working capital buffer roughly equals daily sales rate x average days in the cash cycle. For an FBA seller with average 4-day transit and a trailing 30-day window of attention, that is around 11 days of sales held at any time. Plus seasonality. peak weeks pile up cash that releases slowly into a slower period.
亚马逊在任意时刻冻结的资金 = 处于预计交付+7天冻结窗口内的过往销售额。有三个因素决定冻结金额:
  1. 日均销售额:销售额越高,同时处于资金流转环节的现金就越多。
  2. 运输时间:配送速度越快(如Prime、本地FBA),资金到账就越快。配送速度慢(如FBM、大件商品、国际配送)会延长冻结时间。
  3. 退款与退货率:退款会减少可释放的资金金额,并延长实际现金流周期。
缓冲额度公式:营运资金缓冲额度大致等于日均销售额 × 平均现金流周期天数。对于平均运输时间为4天、需关注过往30天窗口的FBA卖家来说,任意时刻冻结的资金约为11天的销售额。再加上季节性因素,旺季积累的资金会缓慢释放到销售淡季。

Step by step

操作步骤

  1. Collect inputs. Average daily sales (USD), fulfillment mix (FBA % vs FBM %), average transit time per channel, refund rate, and any known seasonal pattern.
  2. Compute the steady-state hold. Daily sales x (transit days + 7) for each channel, weighted by mix.
  3. Model the peak. Multiply daily rate by the seasonal multiplier for the peak weeks, recompute the hold. This is the maximum cash held mid-peak.
  4. Stress-test. Add a refund spike scenario (+50 percent of normal rate for a week). Add a slow-shipping scenario (+3 transit days). Both happen in Q4.
  5. Size the buffer. Recommend a working-capital buffer equal to the maximum stress-tested hold, with a small margin. This is the minimum cash on hand to survive the policy without short-term debt.
  6. Recommend mitigations. Faster fulfillment, Seller-Fulfilled Prime, 3PL with own merchant of record, or financing facilities matched to the cycle.
  7. Run the quality check, then deliver.
  1. 收集输入数据:日均销售额(美元)、履约方式占比(FBA占比 vs FBM占比)、各渠道平均运输时间、退款率,以及已知的季节性模式。
  2. 计算稳态冻结金额:按各渠道分别计算日均销售额 ×(运输天数 +7),再根据履约占比加权求和。
  3. 模拟旺季场景:将日均销售额乘以旺季的季节性乘数,重新计算冻结金额。这是旺季中期的最大冻结资金额。
  4. 压力测试:添加退款激增场景(一周内退款率较正常水平提升50%)。添加发货延迟场景(运输时间增加3天)。两种场景均设定在第四季度。
  5. 确定缓冲额度:建议营运资金缓冲额度等于压力测试中的最大冻结金额,并预留少量余量。这是无需短期贷款即可应对该政策所需的最低留存现金。
  6. 推荐缓解措施:更快的履约方式、卖家自配送Prime(SFP)、拥有自有商户资质的第三方物流(3PL),或匹配现金流周期的融资方案。
  7. 进行质量检查,然后输出结果

Output format

输出格式

undefined
undefined

DD+7 Cash Flow Forecast. [account]

DD+7现金流预测报告. [账户名称]

Inputs: daily sales [$], FBA [%]/FBM [%], avg transit [d], refund rate [%]
输入数据:日均销售额 [$],FBA [%]/FBM [%],平均运输时间 [天],退款率 [%]

Steady-state hold

稳态冻结金额

[$ held in the pipeline at any moment]
[$ 任意时刻处于流转环节的冻结资金]

Peak scenario

旺季场景

Seasonal multiplier: [Nx] Peak hold: [$]
季节性乘数:[N倍] 旺季冻结金额:[$]

Stress-tests

压力测试结果

Refund spike: [$ hold] Slow shipping: [$ hold]
退款激增场景:[$ 冻结金额] 发货延迟场景:[$ 冻结金额]

Recommended buffer

推荐缓冲额度

Working capital buffer: [$] Why: [the binding scenario]
营运资金缓冲额度:[$] 原因:[约束性场景]

Mitigations

缓解措施

[faster fulfillment, SFP, 3PL, financing options]
undefined
[更快履约、SFP、3PL、融资选项]
undefined

Worked example

示例计算

A seller at 8,000 USD daily sales, all FBA, average 4-day transit, refund rate 8%.
Steady state: 8,000 x 11 = 88,000 USD held at any moment. Peak (Q4 at 3x): 264,000 held. Stress test with a refund spike and slow shipping: roughly 310,000. The recommended buffer is roughly 320,000 USD of working capital, or a credit facility matched to that ceiling. The seller had been operating on 80k of cash and was about to be squeezed through Q4 without knowing it.
某卖家日均销售额8000美元,全部使用FBA,平均运输时间4天,退款率8%。
稳态冻结金额:8000 × 11 = 88000美元(任意时刻冻结)。旺季(第四季度为3倍销售):冻结264000美元。同时进行退款激增和发货延迟的压力测试:冻结金额约为310000美元。建议的营运资金缓冲额度约为320000美元,或匹配该上限的信贷额度。该卖家此前仅留存80000美元现金,若未提前规划,第四季度将面临现金流紧张。

Quality check

质量检查要点

  • Hold is computed per fulfillment channel, weighted by mix.
  • The peak scenario uses a real seasonal multiplier, not a flat assumption.
  • Both refund-spike and slow-shipping stress tests are run.
  • The recommended buffer is the worst-case stress-tested hold, not the steady state.
  • Mitigations are practical, not just "get a loan".
  • 按履约渠道分别计算冻结金额,并根据占比加权。
  • 旺季场景使用真实的季节性乘数,而非统一假设。
  • 同时进行退款激增和发货延迟的压力测试。
  • 推荐的缓冲额度为压力测试中的最坏情况冻结金额,而非稳态金额。
  • 缓解措施切实可行,而非仅“申请贷款”。

Common mistakes

常见误区

  • Confusing payout speed with cash speed. Payouts may arrive on schedule and the business still runs out of cash, because the trailing window keeps growing.
  • Modeling steady state only. Peak and stress are when the policy bites hardest.
  • Ignoring refunds. A refund spike during peak compounds with the hold.
  • No mitigation plan. Telling a seller to "have more cash" is not a plan.

  • 混淆付款速度与现金流速度:付款可能按时到账,但企业仍可能现金流短缺,因为冻结的过往销售额窗口持续扩大。
  • 仅模拟稳态场景:旺季和压力场景才是该政策影响最严重的时刻。
  • 忽略退款因素:旺季期间的退款激增会加剧资金冻结的影响。
  • 未制定缓解计划:仅告诉卖家“留存更多现金”并非可行方案。

Built by Jay GPT Pro

由Jay GPT Pro开发

Part of Amazon Pro Skills. Production-grade skills for serious Amazon sellers. Free and open. Built by Jay Margaliot.
I share a new AI play for Amazon sellers every week, free, in my WhatsApp group. Join here: https://chat.whatsapp.com/ILX65p1yWcaIG3c9WGHpTY
属于Amazon Pro Skills系列。为专业亚马逊卖家打造的生产级技能。免费开源。由Jay Margaliot开发。
我每周会在WhatsApp群组中免费分享一个面向亚马逊卖家的AI应用技巧。点击链接加入:https://chat.whatsapp.com/ILX65p1yWcaIG3c9WGHpTY