Payback 2

ROI Payback Calculator
12
1st year
2nd year
3rd year
4th year
5th year
Loan Amt
Monthly
Payback
$0.00
$20.00
$25.00
$40.00
$80.00
$1,000.00
12
Monthly
Payback
1st year
2nd year
3rd year
4th year
5th year
Loan Amt
$0.00
$200.00
$250.00
$400.00
$800.00
$10,000.00
12
Monthly
Payback
1st year
2nd year
3rd year
4th year
5th year
Loan Amt
$0.00
$500.00
$625.00
$1,000.00
$2,000.00
$25,000.00
12
Monthly
Payback
1st year
2nd year
3rd year
4th year
5th year
Loan Amt
$0.00
$1,000.00
$1,250.00
$2,000.00
$4,000.00
$50,000.00
Beginning
Balance
Increment
$5.00
$15.00
$40.00
Total Payout
$0.00
$240.00
$300.00
$480.00
$960.00
$1,980.00
ROI
Beginning
Balance
Increment
$50.00
$150.00
$400.00
Total Payout
$0.00
$2,400.00
$3,000.00
$4,800.00
$9,600.00
$19,800.00
ROI
Total Payout
$0.00
$6,000.00
$7,500.00
$12,000.00
$24,000.00
$49,500.00
ROI
Total Payout
$43,500.00
$36,000.00
$24,000.00
$0.00
$24,500.00
Beginning
Balance
Increment
$250.00
$750.00
$2,000.00
$17,400.00
$14,400.00
$9,600.00
$0.00
$9,800.00
Beginning
Balance
Increment
$125.00
$375.00
$1,000.00
$1,740.00
$1,440.00
$960.00
$0.00
$980.00
$0.00
$12,000.00
$15,000.00
$24,000.00
$48,000.00
$99,000.00
ROI
$87,000.00
$72,000.00
$48,000.00
$0.00
$49,000.00
Franchise Investment
$25,000
Store Open Cost
$12,000
Rent Average
Space Needed
Total rent per year
Monthly w/out cam
$17 sq ft
$1,000
$17,000
$1,417
Deposit
First months rent
cam charge average
$1,417
$1,417
$350
Marque
Door Lettering
$2,200
Current Investment
Chesapeake Value
Virginia Beach Value
Holder
Formula
512,000
Shares
Darryl
John
12500
12500
Total Shares
25000
Value
42000
92000
120000
ASSETS
Current Assets
Checking/Savings
Operating - 8720
Operating 2 - 4446
Operating 9247
Operating VA - 8623
Petty Cash
Total Checking/Savings
31-Dec-09
31-Dec-10
15-Sep-11
1,057.01
477.81
1,525.48
3,668.21
295.07
7,023.58
-609.74
1,195.19
1,512.73
882.09
519.21
3,499.48
1,661.26
1,168.99
1,512.73
259.64
7,574.02
12,176.64
Accounts Receivable
Accounts Receivable
Total Accounts Receivable
548.01
548.01
787.01
787.01
4,958.78
4,958.78
Other Current Assets

Inventory Asset
Undeposited Funds
Total Other Current Assets
4,317.35
653.95
4,971.30
19,882.93
368.5
20,251.43
9,707.52
37,305.73
47,013.25
12,542.89
24,537.92
64,148.67
12,542.89
24,537.92
64,148.67
13,693.03
13,693.03
1,938.22
1,938.22
1,240.93
1,240.93
2,123.55
2,123.55
3,020.54
516.16
35.55
3,572.25
3,020.54
516.16
35.55
3,572.25
12,072.95
4,292.82
3,167.03
10,000.00
11.05
29,543.85
45,360.43
45,360.43
-567.76
9,572.95
5,537.32
3,189.04
10,000.00
15.8
27,747.35
33,257.82
33,257.82
-567.76
7,611.95
5,349.32
3,076.70
10,000.00
15.8
25,486.01
30,299.19
30,299.19
-1,200.00
-1,200.00
173.99
-32,991.53
26,497.64
-1,200.00
-1,200.00
173.99
-6,493.89
42,569.38
Total Current Assets

TOTAL ASSETS
LIABILITIES & EQUITY
Liabilities
Current Liabilities
Accounts Payable
Accounts Payable
Total Accounts Payable
Credit Cards
BB & T 7273(old) 6669 (new)
Visa - 3770 - Navy Fed CC
Visa -3995 - Debit-DO NOT ENTER
Total Credit Cards
Other Current Liabilities
Child Support
Darryrl Loan
John Loan
Overdraft Line of Credit
Roger Loan
Sales Tax Payable
Total Other Current Liabilities
Total Current Liabilities
Total Liabilities
Equity
Darryl Draws
John Draws
Opening Balance Equity
Retained Earnings
Net Income
173.99
-32,991.53
Total Equity
TOTAL LIABILITIES & EQUITY
-32,817.54
-8,719.90
33,849.48
12,542.89
24,537.92
64,148.67
2009
Ordinary Income/Expense
Income
Hardware
Refund
Support and Maintenance
Total Income
Cost of Goods Sold
Cost of Goods Sold
Discounts
Freight and Shipping Costs
Merchant Account Fees
Parts
Software for Resale
Total COGS
Gross Profit
Expense
Accounting Services
Advertising and Promotion
Automobile Expense
Bank Service Charges
Business Licenses and Permits
Casual Labor
Charitable Contributions
Consignment
Corporat Fees
Credit Card Processing Fees
Dues and Subscriptions
Electric
Finance Fees
Fuel
Gift
Inspection
Insurance
Interest Expense
Internet
Late Fees
Leasehold Improvements
Meals and Entertainment
Misc
NFCU Credit Card
Office Supplies
Payroll Expenses
Postage and Delivery
Professional Fees
Reconciliation Discrepancies
Rent Expense
Sign
Small Tools and Equipment
2010
2011
6,089.17
-498.99
32,524.79
38,613.96
21,176.87
-498.99
68,847.27
89,525.15
20,722.18
-399
67,788.46
88,111.64
3,126.80
939.17
81.97
114.54
19,939.54
44.95
24,246.97
9,579.51
3,430.25
0
0
1,391.70
10,050.63
4,822.70
14,401.46
25,219.69
14,366.99
75,123.69
62,891.95
400
5,264.51
672.72
1,167.88
75
540
1,120.00
900
216.55
4,513.54
571.98
1,156.86
176.51
686.25
30
250
100
1,111.28
64.99
2,422.81
132.34
30.01
140
50
615.02
985.17
649.66
441.69
1,411.40
198.07
238.9
7.38
72.02
576.63
85
4,684.63
709.6
0
505
2,015.76
1,837.82
1.32
17,806.25
800
68.15
10,346.36
1,354.77
288.9
104.95
194.8
642.48
565.77
11.51
354
109.17
117
155.1
1,230.89
998.73
1,484.65
1,774.76
243.68
625
-176.2
29,908.06
150.19
1,743.32
51.78
12,478.22
Storage
Taxes - Property
Telephone Expense
Travel Expense
Utilities
Total Expense
Net Ordinary Income
Other Income/Expense
Other Income
Interest Income
Total Other Income
Net Other Income
Net Income
185
80
546.63
150.19
1,743.32
70.34
546.63
943.53
33.05
250
44,318.67
49,351.97
20,326.42
-29,951.68
25,771.72
42,565.53
0.03
0.03
0.03
21.54
21.54
21.54
3.85
3.85
3.85
-29,951.65
25,793.26
42,569.38
1,804.28
170
Total
48,852.17
-897.99
171,648.52
219,602.70
23,291.84
9,268.62
81.97
186.96
35,333.66
44.95
68,208.00
151,394.70
616.55
11,132.82
1,533.60
2,593.86
446.31
1,226.25
1,150.00
1,150.00
100
2,403.42
645.68
4,399.98
464.28
268.91
147.38
50
969.02
1,166.36
576.63
570.19
4,839.73
2,981.97
505
5,565.27
1,837.82
296.78
625
-176.2
60,192.53
800
68.15
355
150.19
4,712.13
103.39
876.63
115,344.63
36,050.07
25.42
25.42
25.42
36,075.49

Payback 2

Uploaded by

Copyright:

Available Formats

Payback 2

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Payback 2

Uploaded by

Copyright:

Available Formats

ROI Payback Calculator

Store Open Cost

Other Current Assets

Total Current Assets

You might also like