AutoTrends AutoSports

12 Month Cashflow Projection Example

 

Start Up

Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Month 10

Month 11

Month 12

Total

Cash In

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Opening Cash Balance

$0

 

 

 

 

 

 

 

 

 

 

 

 

 

Cash Receipts

 

$19,600

$23,521

$27,441

$27,441

$31,361

$31,361

$31,361

$35,281

$39,201

$39,201

$43,121

$43,121

$392,011

Cash Equity

$27,795

 

-

-

-

-

-

-

-

-

-

-

-

$27,795

ADPC Bridge Loan

$74,121

-

-

-

-

-

-

-

-

-

-

-

-

$74,121

ADPC

-

-

-

$6,000

-

$74,121

-

$2,250

-

-

-

-

-

$82,371

Commercial Financing

$83,387

-

-

-

-

-

-

-

-

-

-

-

-

$83,387

Total Cash In

$185,303

$19,600

$23,521

$33,441

$27,741

$105,482

$31,361

$33,611

$35,281

$39,281

$39,201

$43,121

$43,121

$659,685

Cost of Sales

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Labour, Materials - Auto Accessories Services

 

$11,502

$11,502

$11,502

$11,502

$11,502

$11,502

$11,502

$11,502

$11,502

$11,502

$11,502

$11,502

$138,024

Total Cost of Goods Sold

 

$11,502

$11,502

$11,502

$11,502

$11,502

$11,502

$11,502

$11,502

$11,502

$11,502

$11,502

$11,502

$138,024

Gross Profit

$185,303

$8,098

$12,019

$21,939

$15,939

$93,980

$19,859

$22,109

$23,779

$27,699

$27,699

$31,619

$31,619

$521,661

Cash Out

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Capitalization Activities

$105,000

-

-

-

-

-

-

-

-

-

-

-

-

$48,000

Marketing and Promotions

$3,000

$2,555

$545

$545

$545

$545

$545

$545

$545

$545

$85

$0

$0

$10,000

Communications

 

 $205

  $205

  $205

 $205

 $205 

 $205 

  $205

 $205

  $205

 $205 

 $205 

 $205 

$2,460

Repairs and Maintenance

 

$200

$200

$200

$200

$200

$200

$200

$200

$200

$200

$200

$200

$2,400

Insurance

 

$1,125

$1,125

$1,125

$1,125

$1,125

$1,125

$1,125

$1,125

$1,125

$1,125

$1,125

$1,125

$13,500

Office Supplies

 

$200

$200

$200

$200

$200

$200

$200

$200

$200

$200

$200

$200

$2,400

Vehicle Expense & Travel

 

$1,200

$1,200

$1,200

$1,200

$1,200

$1,200

$1,200

$1,200

$1,200

$1,200

$1,200

$1,200

$14,400

Employee Benefits

 

$500

$500

$500

$500

$500

$500

$500

$500

$500

$500

$500

$500

$6,000

Rent

 

$6,278

$6,278

$6,278

$6,278

$6,278

$6,278

$6,278

$6,278

$6,278

$6,278

$6,278

$6,278

$75,336

Freight

 

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$12,000

Utilities

 

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$2000

$2000

$2000

$2000

$20,000

Office Expenses & Postage

 

$150

$150

$150

$150

$150

$150

$150

$150

$150

$150

$150

$150

$1,800

Bank Charges and Interest

 

$100

$100

$100

$100

$100

$100

$100

$100

$100

$100

$100

$100

$1,200

Franchise Fees

$50,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$62,000

Bridge Loan Repayment

 

-

-

-

-

-

$74,121

- - - - - -

$74,121

Loan Interest

 

$695

$683

$671

$659

$647

$635

$622

$610

$597

$585

$572

$559

$7,536

Principle Repayment   $1,420 $1,432 $1,444 $1,456 $1,468 $1,480 $1,493 $1,505 $1,517 $1,530 $1,543 $1,556 $17,843

Professional Fees

$1,800

$100

$100

$100

$100

$100

$100

$100

$100

$100

$100

$100

$100

$3,000

Owner's or Partner's Draws   $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $30,000

Total Cash Out

$159,800

$20,728

$18,718

$18,718

$18,718

$92,839

$18,718

$18,718

$18,718

$19,218

$18,758

$18,673

$18,673

$460,996

Net Cash Flow

$25,503

($12,630)

($6,699)

$3,221

($2,779)

$1,141

$1,141

$3,391

5,061

$8,481

$8,941

$12,946

$12,946

$60,665

Cumulative Cash Flow

$25,503

$12,873

$6,174

$9,385

$6,616

$7,757

$8,899

$12,290

$17,351

$25,832

$34,773

$47,719

$60,665

 


Click here to return to AutoTrend AutoSports Financial Plan