Get documents about "balsht
Shared by: lanyuehua
-
Stats
- views:
- 0
- posted:
- 4/9/2012
- language:
- pages:
- 8
Document Sample
36f648aa-bdf9-4e13-afe6-f0b4c665d5d8.xls Data 4/9/2012
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS AT AU AV AW AX AY AZ BA BB BC BD BE BF BG BH BI BJ BK BL BM BN BO BP BQ BR BS BT BU BV BW BX BY BZ CA CB CC CD CE CF CG CH CI CJ CK CL CM CN CO CP CQ
1 Caribbean Internet Café Analysis
Annual
depreciation Annual
Page in Asset : 8 year depreciation: Total annual
2 Description Amount or v alue Period or units case? Paragraph? Life assets 3 year assets depreciation
3 Equipment
4
5 Total equipment
6 Hardware
7
8 Total hardware
9 Software
10
11
12 Total software
13 Furniture
14
15
16 Total furniture
17 Other
18
19 Total other
20 Total investment in assets
21 Start-up costs
22
23 Total startup costs
24 Monthly costs
25
36f648aa-bdf9-4e13-afe6-f0b4c665d5d8.xls Data 4/9/2012
CR CS CT CU CV CW CX CY CZ DA DB DC DD
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
36f648aa-bdf9-4e13-afe6-f0b4c665d5d8.xls Mtge 4/9/2012
A B C D E F
1 Caribbean Internet Café Loan Amortization
2 Amt borrowed
3 Interest rate (per month)
4 Years months
5 Periodic payment
6 Annual payment
7 Total interest
8 Amortization schedule
9 Year Month Payment Interest Principle Balance due
10 1 1
11 1 2
12 1 3
13 1 4
14 1 5
15 1 6
16 1 7
17 1 8
18 1 9
19 1 10
20 1 11
21 1 12
22 2 1
23 2 2
24 2 3
25 2 4
26 2 5
27 2 6
28 2 7
29 2 8
30 2 9
31 2 10
32 2 11
33 2 12
34 3 1
35 3 2
36 3 3
37 3 4
38 3 5
39 3 6
40 3 7
41 3 8
42 3 9
43 3 10
44 3 11
45 3 12
46 4 1
47 4 2
48 4 3
49 4 4
50 4 5
36f648aa-bdf9-4e13-afe6-f0b4c665d5d8.xls Mtge 4/9/2012
A B C D E F
51 4 6
52 4 7
53 4 8
54 4 9
55 4 10
56 4 11
57 4 12
58 5 1
59 5 2
60 5 3
61 5 4
62 5 5
63 5 6
64 5 7
65 5 8
66 5 9
67 5 10
68 5 11
69 5 12
70
71 Calculation of total annual interest and principle, year 1
72 Year Month Payment Interest Principle Total Payment
73
74
75
76
77 Calculation of total annual interest and principle, year 2
78 Year Month Payment Interest Principle Total Payment
79
80
81
82 -
balsht
A B C D E F G H I
1 End of day balance sheet, June 28th:
2 Assets Liabilities and owner's equity
3 Account Balance Account Balance
4 Cash Equity
5 Total Total
6
7 End of day balance sheet, June 29th Derivation of June 29th cash:
8 Assets Liabilities and owner's equity Grant's capital
9 Account Balance Account Balance JTL's capital
10 Cash Long term debt Loan from JTL
11 Equity: Grant Total
12 Equity: JTL
13 Total Total
14
15 End of day balance sheet, June 30th Derivation of June 30th cash
16 Assets Liabilities and owner's equity Beginning balance
17 Account Balance Account Balance Less:
18 Cash Long term debt Purchase cost of fixed assets
19 Fixed assets Equity: Grant Startup costs
20 Intangible assets Equity: JTL Ending cash
21 Total Total
22
23 Balance sheet, End of year 1: Optimistic
24 Assets Liabilities and owner's equity Derivation of cash, end of year 1
25 Account Balance Account Balance Optimistic Realistic Pessimistic
26 Cash Long term debt Beginning balance
27 Fixed assets Equity: Grant Add revenues from sales
28 Less accum depr Equity: JTL Total cash available
29 Intangible assets Retained earnings Less:
30 Less amortization Purchase cost of fixed assets
Net fixed and Check on balance?
31 intangible assets Total equity & R/E [sh/be zero] Payment for startup items
Fixed operating costs [less
32 Total Total depreciation and amortization]
33 Cost of goods sold
34 Balance sheet, End of year 1: Realistic Payment on principle
35 Assets Liabilities and owner's equity Total cash expenditures
36 Account Balance Account Balance Ending cash
37 Cash Long term debt
38 Fixed assets Equity: Grant Total fixed costs [for reference]
39 Less accum depr
40 Intangible assets Equity: JTL
41 Less amortization Retained earnings
Net fixed and Check on balance?
42 intangible assets Total equity + R E [sh/be zero]
43 Total Total
44
45 Balance sheet, End of year 1: Pessimistic
46 Assets Liabilities and owner's equity
47 Account Balance Account Balance
48 Cash Long term debt
49 Fixed assets Equity: Grant
50 Less accum depr
51 Intangible assets Equity: JTL
52 Less amortization Retained earnings
Net fixed and Check on balance?
53 intangible assets Total equity + R E [sh/be zero]
54 Total Total
A B C D E F
Assumption: Percent of
1 customers accessing Internet
2 Contribution margin calculation
Line item [all are per Contribution
3 customer] Revenues Variable costs Margin
4 Internet service provider rate
5 Internet/customer (weighted)
6 Beverage revenues
7 Food revenues
Total revenues [Internet +
8 Beverage + Food]
9 Contribution margin ratio
10 Revenues/customer ($US)
11 Breakeven analysis Jamaican Currency In US $
12 Year 1 Year 2 Year 1 Year 2
13 Fixed costs per month
14 Cash items
15 Depreciation
16 Amortization
17 Total fixed costs
18 Contribution margin ratio
19 Breakeven revenues
20 Customers/year
21 Customers/month
22 Customers/day
23 Days/year that he is open
Total variable Total fixed Total
24 Volume [customers per day] Revenue costs costs/day costs Profit
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
mkt
A B C D E F G
1 Market analysis and income statements
2 Market analysis Year 1 Year 2
3 Population size
4 Estimate Optimistic Realistic Pessimistic Optimistic Realistic Pessimistic
5 Percentage of market
6 Visits annually
7 Weighted visits
8 Revenue
9 Variable costs
10 Contribution margin
11 Less fixed costs
12 Profit (loss)
13
14 Market analysis in US$
Value of the
15 Jamaican dollar US $
16 Exchange rate
17 Revenue
18 Variable costs
19 Contribution margin
20 Less fixed costs
21 Profit (loss)
perf
Performance measures
Year 1
Optimistic Realistic Pessimistic
RONA
ROE
ROS
Debt to total assets
Debt to equity
