Thoughtful templates. Instant downloads.
RizqtekStudio.
Launch gift: 4 of 5 free template claims remainUse STUDIOFIRST5 →

Q4 E-Commerce BFCM Discount & ROAS Calculator

EXCEL + GOOGLE SHEETS · BUSINESS

Q4 E-Commerce BFCM Discount & ROAS Calculator — Excel & Google Sheets Template

Model SKU promo margins, landed COGS, breakeven ROAS and true net profit across paid channels.

High-revenue Black Friday weekends often lose money once deep discounts, pick-pack shipping, payment fees, and inflated Q4 ad CPMs collide. This founder & marketer workbench calculates unit margin and breakeven ROAS per SKU and reconciles true net contribution across Meta, Google, TikTok, Email, and SMS.

$17.99 USD · ONE-TIME PURCHASE

Digital download · No physical item

Refunds & download support · Template licence

Software requirementsWorks in Microsoft Excel (Windows & Mac, 2019/2021/365) and Google Sheets. Verified in Desktop Excel 16.0 build 20527.0 with 100% macro-free universal formulas (SUMIFS, COUNTIFS, INDEX/MATCH) and includes a dedicated Google_Sheets_Edition.xlsx for one-click Google Drive import. Minor font or print-page scaling differences may appear in browser sheets.

Try the free budget starter · Read practical guides

  • 200-SKU promo pricing waterfall with COGS, fulfillment, fees & breakeven ROAS
  • 300-campaign Q4 marketing tracker across Meta, Google, TikTok, Email & SMS
  • Live blended MER (Marketing Efficiency Ratio) and net contribution profit KPIs

From the people who use it.

No published customer reviews yet.

Purchased this product? Sign in to review it. Link guest orders from your private receipt first.

Consider the details.

What’s inside

6 worksheets, thoughtfully organized.

  • 200-SKU promo pricing waterfall with COGS, fulfillment, fees & breakeven ROAS
  • 300-campaign Q4 marketing tracker across Meta, Google, TikTok, Email & SMS
  • Live blended MER (Marketing Efficiency Ratio) and net contribution profit KPIs
  • Offer & ROAS Simulator stress-testing 15% to 35% discount tiers before launch
  • Includes Excel master, Google Sheets edition, sample copy & PDF guide

Template.xlsx (Excel master), Google_Sheets_Edition.xlsx (Google Drive/Sheets ready), Example.xlsx (populated sample), Quick_Start.txt, User_Guide.txt, and illustrated User_Guide.pdf.

Software & capacity

Works in Microsoft Excel (Windows & Mac, 2019/2021/365) and Google Sheets. Verified in Desktop Excel 16.0 build 20527.0 with 100% macro-free universal formulas (SUMIFS, COUNTIFS, INDEX/MATCH) and includes a dedicated Google_Sheets_Edition.xlsx for one-click Google Drive import. Minor font or print-page scaling differences may appear in browser sheets.

  • Management unit-economics calculator; excludes returns/refunds unless built into blended COGS/fee assumptions.
  • Campaign log attributes orders to a hero SKU per row; use blended SKU rows for multi-item bundles.
Download & getting started
After captured payment is verified, the order page provides your download links. Save your private order access link. Extract the ZIP, read Quick_Start.txt, and save a working copy of the clean workbook. Read the download guide
Licence & product support
One purchaser may use this digital workbook internally within one household or one business (up to five internal team members). Personal working copies and cloud backups in your own Microsoft or Google account are permitted. Resale, redistribution, public sharing, or client-template delivery of the spreadsheet file itself is prohibited. Completed reports, quotes, and PDFs may be shared freely. Copyright 2026 RizqtekStudio. All rights reserved. Read the licence

Questions about this template

What is included with Q4 E-Commerce BFCM Discount & ROAS Calculator?

Template.xlsx (Excel master), Google_Sheets_Edition.xlsx (Google Drive/Sheets ready), Example.xlsx (populated sample), Quick_Start.txt, User_Guide.txt, and illustrated User_Guide.pdf.

What software is required to use Q4 E-Commerce BFCM Discount & ROAS Calculator?

Works in Microsoft Excel (Windows & Mac, 2019/2021/365) and Google Sheets. Verified in Desktop Excel 16.0 build 20527.0 with 100% macro-free universal formulas (SUMIFS, COUNTIFS, INDEX/MATCH) and includes a dedicated Google_Sheets_Edition.xlsx for one-click Google Drive import. Minor font or print-page scaling differences may appear in browser sheets.

How do I receive Q4 E-Commerce BFCM Discount & ROAS Calculator after purchasing?

After captured payment is verified, your private order page provides download links and a receipt is emailed. A valid complimentary claim also provides access without payment.

What licence applies to this template?

One purchaser may use this digital workbook internally within one household or one business (up to five internal team members). Personal working copies and cloud backups in your own Microsoft or Google account are permitted. Resale, redistribution, public sharing, or client-template delivery of the spreadsheet file itself is prohibited. Completed reports, quotes, and PDFs may be shared freely. Copyright 2026 RizqtekStudio. All rights reserved.

A little more possibility.

All templates