Sales Forecast

Unit Sales

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Bibleos Video Sets

5,000

5,100

5,202

5,306

5,412

5,520

5,631

5,743

5,858

5,975

6,095

6,217

Bibleos Video

5,000

5,100

5,202

5,306

5,412

5,520

5,631

5,743

5,858

5,975

6,095

6,217

Bibleos CD-ROM

5,000

5,100

5,202

5,306

5,412

5,520

5,631

5,743

5,858

5,975

6,095

6,217

Total Unit Sales

15,000

15,300

15,606

15,918

16,236

16,560

16,893

17,229

17,574

17,925

18,285

18,651

Unit Prices

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Bibleos Video Sets

$24.95

$24.95

$24.95

$24.95

$24.95

$24.95

$24.95

$24.95

$24.95

$24.95

$24.95

$24.95

Bibleos Video

$15.00

$15.00

$15.00

$15.00

$15.00

$15.00

$15.00

$15.00

$15.00

$15.00

$15.00

$15.00

Bibleos CD-ROM

$19.95

$18.95

$18.95

$19.95

$19.95

$19.95

$19.95

$19.95

$19.95

$19.95

$19.95

$19.95

Sales

Bibleos Video Sets

$124,750

$127,245

$129,790

$132,385

$135,029

$137,724

$140,493

$143,288

$146,157

$149,076

$152,070

$155,114

Bibleos Video

$75,000

$76,500

$78,030

$79,590

$81,180

$82,800

$84,465

$86,145

$87,870

$89,625

$91,425

$93,255

Bibleos CD-ROM

$99,750

$96,645

$98,578

$105,855

$107,969

$110,124

$112,338

$114,573

$116,867

$119,201

$121,595

$124,029

Total Sales

$299,500

$300,390

$306,398

$317,829

$324,179

$330,648

$337,297

$344,006

$350,894

$357,903

$365,091

$372,398

Direct Unit Costs

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Bibleos Video Sets

$11.25

$11.25

$11.25

$11.25

$11.25

$11.25

$11.25

$11.25

$11.25

$11.25

$11.25

$11.25

Bibleos Video

$2.85

$2.85

$2.85

$2.85

$2.85

$2.85

$2.85

$2.85

$2.85

$2.85

$2.85

$2.85

Bibleos CD-ROM

$1.50

$1.50

$1.50

$1.50

$1.50

$1.50

$1.50

$1.50

$1.50

$1.50

$1.50

$1.50

Direct Cost of Sales

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Bibleos Video Sets

$56,250

$57,375

$58,523

$59,693

$60,885

$62,100

$63,349

$64,609

$65,903

$67,219

$68,569

$69,941

Bibleos Video

$14,250

$14,535

$14,826

$15,122

$15,424

$15,732

$16,048

$16,368

$16,695

$17,029

$17,371

$17,718

Bibleos CD-ROM

$7,500

$7,650

$7,803

$7,959

$8,118

$8,280

$8,447

$8,615

$8,787

$8,963

$9,143

$9,326

Subtotal Direct Cost of Sales

$78,000

$79,560

$81,151

$82,774

$84,427

$86,112

$87,844

$89,591

$91,385

$93,210

$95,082

$96,985

Profit and Loss (Income Statement)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sales

$299,500

$300,390

$306,398

$317,829

$324,179

$330,648

$337,297

$344,006

$350,894

$357,903

$365,091

$372,398

Direct Cost of Sales

$78,000

$79,560

$81,151

$82,774

$84,427

$86,112

$87,844

$89,591

$91,385

$93,210

$95,082

$96,985

Other

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

------------

------------

------------

------------

------------

------------

------------

------------

------------

------------

------------

------------

Total Cost of Sales

$78,000

$79,560

$81,151

$82,774

$84,427

$86,112

$87,844

$89,591

$91,385

$93,210

$95,082

$96,985

Gross Margin

$221,500

$220,830

$225,247

$235,056

$239,752

$244,536

$249,453

$254,415

$259,509

$264,693

$270,009

$275,413

Gross Margin %

73.96%

73.51%

73.51%

73.96%

73.96%

73.96%

73.96%

73.96%

73.96%

73.96%

73.96%

73.96%

Operating expenses:

Advertising/Promotion

$25,000

$25,000

$25,000

$25,000

$25,000

$25,000

$25,000

$25,000

$25,000

$25,000

$25,000

$25,000

Travel

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

Miscellaneous

$2,500

$2,500

$2,500

$2,500

$0

$0

$0

$0

$0

$2,500

$2,500

$2,500

Payroll Expense

$13,333

$13,333

$13,333

$13,333

$13,333

$13,333

$13,333

$13,333

$13,333

$13,333

$13,333

$13,333

Payroll Burden

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

Depreciation

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Insurance

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

Rent

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Contract/Consultants

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

------------

------------

------------

------------

------------

------------

------------

------------

------------

------------

------------

------------

Total Operating Expenses

$47,833

$47,833

$47,833

$47,833

$45,333

$45,333

$45,333

$45,333

$45,333

$47,833

$47,833

$47,833

Profit Before Interest and Taxes

$173,667

$172,997

$177,413

$187,222

$194,418

$199,203

$204,120

$209,082

$214,176

$216,859

$222,175

$227,580

Interest Expense Short-term

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Interest Expense Long-term

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Taxes Incurred

$43,417

$43,249

$44,353

$46,806

$48,605

$49,801

$51,030

$52,270

$53,544

$54,215

$55,544

$56,895

Extraordinary Items

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Net Profit

$130,250

$129,748

$133,060

$140,417

$145,814

$149,402

$153,090

$156,811

$160,632

$162,644

$166,631

$170,685

Net Profit/Sales

43.49%

43.19%

43.43%

44.18%

44.98%

45.18%

45.39%

45.58%

45.78%

45.44%

45.64%

45.83%

Pro-Forma Cash Flow

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Net Profit

$130,250

$129,748

$133,060

$140,417

$145,814

$149,402

$153,090

$156,811

$160,632

$162,644

$166,631

$170,685

Plus:

Depreciation

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Change in Accounts Payable

$133,908

$1,211

$2,345

$3,545

$829

$2,506

$2,576

$2,599

$2,669

$4,346

$2,785

$2,831

Current Borrowing (repayment)

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Increase (decrease) Other Liabilities

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Long-term Borrowing (repayment)

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Capital Input

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Subtotal

$264,158

$130,959

$135,405

$143,962

$146,642

$151,908

$155,666

$159,410

$163,301

$166,991

$169,416

$173,516

Less:

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Change in Other Short-term Assets

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Capital Expenditure

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Dividends

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Subtotal

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Net Cash Flow

$264,158

$130,959

$135,405

$143,962

$146,642

$151,908

$155,666

$159,410

$163,301

$166,991

$169,416

$173,516

Cash Balance

$956,658

$1,087,617

$1,223,021

$1,366,983

$1,513,626

$1,665,534

$1,821,200

$1,980,610

$2,143,911

$2,310,902

$2,480,319

$2,653,835

Pro-forma Balance Sheet

Assets

Short-term Assets

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Cash

$956,658

$1,087,617

$1,223,021

$1,366,983

$1,513,626

$1,665,534

$1,821,200

$1,980,610

$2,143,911

$2,310,902

$2,480,319

$2,653,835

Other Short-term Assets

$10,500

$10,500

$10,500

$10,500

$10,500

$10,500

$10,500

$10,500

$10,500

$10,500

$10,500

$10,500

Total Short-term Assets

$967,158

$1,098,117

$1,233,521

$1,377,483

$1,524,126

$1,676,034

$1,831,700

$1,991,110

$2,154,411

$2,321,402

$2,490,819

$2,664,335

Long-term Assets

Capital Assets

$9,500

$9,500

$9,500

$9,500

$9,500

$9,500

$9,500

$9,500

$9,500

$9,500

$9,500

$9,500

Accumulated Depreciation

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Total Long-term Assets

$9,500

$9,500

$9,500

$9,500

$9,500

$9,500

$9,500

$9,500

$9,500

$9,500

$9,500

$9,500

Total Assets

$976,658

$1,107,617

$1,243,021

$1,386,983

$1,533,626

$1,685,534

$1,841,200

$2,000,610

$2,163,911

$2,330,902

$2,500,319

$2,673,835

Liabilities and Capital

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Accounts Payable

$133,908

$135,119

$137,464

$141,009

$141,838

$144,344

$146,920

$149,519

$152,188

$156,535

$159,319

$162,151

Short-term Notes

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Other Short-term Liabilities

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Subtotal Short-term Liabilities

$133,908

$135,119

$137,464

$141,009

$141,838

$144,344

$146,920

$149,519

$152,188

$156,535

$159,319

$162,151

Long-term Liabilities

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Total Liabilities

$133,908

$135,119

$137,464

$141,009

$141,838

$144,344

$146,920

$149,519

$152,188

$156,535

$159,319

$162,151

Paid in Capital

$750,000

$750,000

$750,000

$750,000

$750,000

$750,000

$750,000

$750,000

$750,000

$750,000

$750,000

$750,000

Retained Earnings

($37,500)

($37,500)

($37,500)

($37,500)

($37,500)

($37,500)

($37,500)

($37,500)

($37,500)

($37,500)

($37,500)

($37,500)

Earnings

$130,250

$259,998

$393,057

$533,474

$679,288

$828,690

$981,780

$1,138,591

$1,299,223

$1,461,868

$1,628,499

$1,799,184

Total Capital

$842,750

$972,498

$1,105,557

$1,245,974

$1,391,788

$1,541,190

$1,694,280

$1,851,091

$2,011,723

$2,174,368

$2,340,999

$2,511,684

Total Liabilities and Capital

$976,658

$1,107,617

$1,243,021

$1,386,983

$1,533,626

$1,685,534

$1,841,200

$2,000,610

$2,163,911

$2,330,902

$2,500,319

$2,673,835

Net Worth

$842,750

$972,498

$1,105,557

$1,245,974

$1,391,788

$1,541,190

$1,694,280

$1,851,091

$2,011,723

$2,174,368

$2,340,999

$2,511,684