ProForma Tool

Financial projections created in advance to describe future scenarios.
Edit any variable number during the session, watch formulas update across tabs, and save the active page as a PDF.
-Bob Hiner

Stage 1 · Operating

Editable cells reset to the original workbook defaults whenever the page is opened.

Operating Model Pro Forma
**ENTER DATA IN GREEN CELLS TO AFFECT NET PROFIT**
TOTAL SALES
Budget Revenue$4,400,000
Revenue Goal Increase %100%
Target RevenueTarget$8,800,000100%
Cost of Goods Sold
Material Cost Windows45%$2,464,00028%
Doors > > >$352,0004%
Siding< < <$176,0002%
Other42%$352,0004%
Labor15%$1,144,00013%
Commissions6%$792,0009%
Total Cost of Goods Sold63-66%$5,280,00060%
Gross Profit 34-37%$3,520,00040%
Operating Expense
Advertising/Marketing9%$1,144,00013%
Overhead13-18%$1,012,00012%
Total Operating Expense22-27%$2,156,00024%
COGS & Operating Expense$7,436,000
Operating Net Profit7-15%$1,364,00016%

Stage 2 · Marketing

Editable cells reset to the original workbook defaults whenever the page is opened.

Marketing Pro Forma
**ENTER DATA IN GREEN CELLS TO AFFECT MARKETING COST**
Sales Target$8,800,000
Average Contract$9,500
Jobs Required to Meet Sales Target926
Closing %45%
Leads Required to Meet Target2,058
Avg Lead Cost/CPLI$470
(Cost Per Lead Issued)
Marketing Cost$967,48511%

Stage 3 · Margin & Closing

Editable cells reset to the original workbook defaults whenever the page is opened.

Margin & Closing % Pro Forma
CONTRACT AMOUNTGROSS PROFIT %CLOSING %CPLI LEAD COST $WEIGHTED MARKETING COST $MKT % INCOME $INCOME %OVERHEADNET PROFIT $NET PROFIT %NSLI
$5,13140%$47012%
$5,131$2,05270%$470$67113%$1,380.9727%$590$790.9115%$3,592
$5,131$2,05260%$470$78315%$1,269.0725%$590$679.0013%$3,079
$5,131$2,05250%$470$94018%$1,112.4022%$590$522.3410%$2,566
$5,131$2,05245%$470$1,04420%$1,007.9620%$590$417.898%$2,309
$5,131$2,05240%$470$1,17523%$877.4017%$590$287.346%$2,052
$5,131$2,05235%$470$1,34326%$709.5414%$590$119.482%$1,796
$5,131$2,05225%$470$1,88037%$172.403%$590-$417.66-8%$1,283

Stage 4 · DC

Editable cells reset to the original workbook defaults whenever the page is opened.

DC Pro Forma
**ENTER DATA IN GREEN CELLS**
Sales Target$1,450,000
Average Contract$9,226
Jobs Required to Meet Sales Target157
Closing %60%
Leads Required to Meet Target262
Avg Commission Per Sale7%$646
Avg Commission Per Lead$387
Desired Annual Earnings$101,500