amz-cash-flow-forecaster-dd7
Compare original and translation side by side
🇺🇸
Original
English🇨🇳
Translation
ChineseCash 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:
- Daily sales rate. Higher sales = more cash in the pipeline at once.
- Transit time. Faster delivery (Prime, regional FBA) clears cash sooner. Slow delivery (FBM, oversize, international) extends the hold.
- 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天冻结窗口内的过往销售额。有三个因素决定冻结金额:
- 日均销售额:销售额越高,同时处于资金流转环节的现金就越多。
- 运输时间:配送速度越快(如Prime、本地FBA),资金到账就越快。配送速度慢(如FBM、大件商品、国际配送)会延长冻结时间。
- 退款与退货率:退款会减少可释放的资金金额,并延长实际现金流周期。
缓冲额度公式:营运资金缓冲额度大致等于日均销售额 × 平均现金流周期天数。对于平均运输时间为4天、需关注过往30天窗口的FBA卖家来说,任意时刻冻结的资金约为11天的销售额。再加上季节性因素,旺季积累的资金会缓慢释放到销售淡季。
Step by step
操作步骤
-
Collect inputs. Average daily sales (USD), fulfillment mix (FBA % vs FBM %), average transit time per channel, refund rate, and any known seasonal pattern.
-
Compute the steady-state hold. Daily sales x (transit days + 7) for each channel, weighted by mix.
-
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.
-
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.
-
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.
-
Recommend mitigations. Faster fulfillment, Seller-Fulfilled Prime, 3PL with own merchant of record, or financing facilities matched to the cycle.
-
Run the quality check, then deliver.
-
收集输入数据:日均销售额(美元)、履约方式占比(FBA占比 vs FBM占比)、各渠道平均运输时间、退款率,以及已知的季节性模式。
-
计算稳态冻结金额:按各渠道分别计算日均销售额 ×(运输天数 +7),再根据履约占比加权求和。
-
模拟旺季场景:将日均销售额乘以旺季的季节性乘数,重新计算冻结金额。这是旺季中期的最大冻结资金额。
-
压力测试:添加退款激增场景(一周内退款率较正常水平提升50%)。添加发货延迟场景(运输时间增加3天)。两种场景均设定在第四季度。
-
确定缓冲额度:建议营运资金缓冲额度等于压力测试中的最大冻结金额,并预留少量余量。这是无需短期贷款即可应对该政策所需的最低留存现金。
-
推荐缓解措施:更快的履约方式、卖家自配送Prime(SFP)、拥有自有商户资质的第三方物流(3PL),或匹配现金流周期的融资方案。
-
进行质量检查,然后输出结果。
Output format
输出格式
undefinedundefinedDD+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、融资选项]
undefinedWorked 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