Small Business Financial Planner

Product Information

Selling Price ($)

Mold Cost ($)

Unit Cost Price (First Run) ($)

Unit Cost Price (Second Run) ($)

Unit Cost Price (Third Run) ($)

Production Information

First Production Volume

First Prod Run Range (Months)

Second Production Volume

Second Prod Run Range (Months)

Third Production Volume

Third Prod Run Range (Months)

Lead Times (No Sales Period)

Define how many months pass before each run actually starts selling. This prevents showing revenue in months where product is not yet available.

Lead Time (Months) Before Run #1 Sales

Lead Time (Months) Before Run #2 Sales

Lead Time (Months) Before Run #3 Sales

Cost Adjustments

Adjust the percentages or dollar amounts to modify cost components.

Manufacturing Cost (per-unit) (based on Run #1 for slider, % applies to all runs)

% $

Overseas Shipping (per-unit) (based on Run #1 for slider, % applies to all runs)

% $

Packaging Cost (per-unit) (based on Run #1 for slider, % applies to all runs)

% $

Inventory Storage (per-unit) (based on Run #1 for slider, % applies to all runs)

% $

Shipping to Customer (per-unit) (based on Selling Price for slider, % applies to all runs)

% $

US Taxes (per-unit) (based on Selling Price for slider, % applies to all runs)

% $

Payment Processing Fees (per-unit) (based on Selling Price for slider, % applies to all runs)

% $

Advertising Costs (Monthly $)

Return/Refund Costs (Monthly $)

Platform Fees (Monthly $)

Miscellaneous Overheads (Monthly $)

Loan Information

Loan Amount ($)

Small Business Financial Planner

Product Information

Production Information

Lead Times (No Sales Period)

Cost Adjustments

Loan Information

Financial Analysis

Monthly Net Cash Flow

Monthly Profit (P&L Perspective)

Cost Breakdown (First Run)

Selling Price Composition