Business plan

profileHussein jing
Financial_Model.xlsx
Home>Business & Finance homework help>Business plan

Sources_Uses

Sources and Uses of Funds
Uses of Funds
Operating Equipment $ 45,000.00
Refurbishment $ 20,000.00
initial inventory $ 3,000.00
payroll 6 months $ 15,000.00
initial marketing $ 7,000.00
miscellaneous $ 10,000.00
Total $ 100,000.00
Sources of Funds
Own Funds $ 20,000.00
Investors $ - 0
Bank Loan $ 80,000.00
Total $ 100,000.00

Balance_Sheet

Balance Sheet
Opening Balance Month 1 Month 2 Month 3
Assets
Current Assets
Cash $ 100,000.00 $ 38,724.30 $ 22,048.60 $ 27,466.93
Inventory $ - 0 $ 1,000.00 $ 1,000.00 $ 2,000.00
Accounts Receivable $ - 0 $ - 0
non-current Assets
Rent Deposit $ - 0 $ - 0 $ - 0
Equipment $ 52,000.00 $ 52,000.00 $ 52,000.00
less: accumulated depreciation $ 841.27 $ 1,682.54 $ 2,523.81
Total Equipment $ 51,158.73 $ 50,317.46 $ 49,476.19
total Assets $ 100,000.00 $ 90,883.03 $ 73,366.06 $ 78,943.12
Liabilities
Current Liabilities $ - 0 $ - 0 $ - 0
Accounts Payable
Salaries Payable
Current Portion of Long-Term Debt $ 38,095.24 $ 38,399.01 $ 38,705.21
Non-Current Liabilities
non-Current Portion of Long-Term Debt $ 38,866.99 $ 35,501.23 $ 32,108.62
total liabilties $ 80,000.00 $ 76,962.23 $ 73,900.24 $ 70,813.83
Owner's Equity
common stock $ 20,000.00 $ 20,000.00 $ 20,000.00 $ 20,000.00
retained earnings $ -6,079.20 $ -20,534.18 $ -11,870.71
total Owner's Equity $ 20,000.00 $ 13,920.80 $ -534.18 $ 8,129.29
Liabilities + O.E. $ 100,000.00 $ 90,883.03 $ 73,366.06 $ 78,943.12
check $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Income_Statement

Income Statement
Month 1 Month 2 Month 3
Revenues
Food Revenues $ - 0 $ - 0 $ 15,000.00
Beverage Revenues $ - 0 $ - 0 $ 6,000.00
Total Revenues $ - 0 $ - 0 $ 21,000.00
Expenses
C.O.F.S. $ - 0 $ - 0 $ 3,750.00
C.O.B.S. $ - 0 $ - 0 $ 1,200.00
Payroll & Related $ 2,500.00 $ 2,500.00 $ 3,500.00
Depreciation $ 841.27 $ 841.27 $ 841.27
Petrol $ 100.00 $ 500.00 $ 1,000.00
Interest $ 637.93 $ 613.71 $ 589.29
Miscellaneous $ 2,000.00 $ 10,000.00 $ 1,000.00
Total Expenses $ 6,079.20 $ 14,454.98 $ 11,880.56
pre-tax Income $ -6,079.20 $ -14,454.98 $ 9,119.44
Income Tax $ - 0 $ - 0 $ 455.97
Net Income $ -6,079.20 $ -14,454.98 $ 8,663.47
Retained Earnings
Opening Balance $ - 0 $ -6,079.20 $ -20,534.18
+ Net Profit $ -6,079.20 $ -14,454.98 $ 8,663.47
- Dividends $ - 0 $ - 0 $ - 0
Closing Balance $ -6,079.20 $ -20,534.18 $ -11,870.71

Equipment

Equipment
item cost useful life (years) useful life (months) depreciation per month
Truck $ 40,000.00 5 60 $ 666.67
Computer $ 2,000.00 3 36 $ 55.56
Equipment $ 10,000.00 7 84 $ 119.05
total $ 52,000.00 $ 841.27

Statement of Cash Flows

Statement of Cash Flows
Month 1 Month 2 Month 3
C.f. from Operating Activities
Net Income $ -6,079.20 $ -14,454.98 $ 8,663.47
Adjustments to reconcile
+ depreciation $ 841.27 $ 841.27 $ 841.27
Current Assets $ -1,000.00 $ - 0 $ -1,000.00
Current Liabilities $ - 0 $ - 0
C.f. from Operating Activities $ -6,237.93 $ -13,613.71 $ 8,504.74
C.f.from Financing Activities $ -3,037.77 $ -3,061.99 $ -3,086.41
Cash Flow from Investing Activities
Purchasing of Equipment $ -52,000.00 $ - 0 $ - 0
Cash Flow from Investing Activities $ -52,000.00 $ - 0 $ - 0
Cash Flow $ -61,275.70 $ -16,675.70 $ 5,418.33
Opening Cash Balance $ 100,000.00 $ 38,724.30 $ 22,048.60
Cash Flow $ -61,275.70 $ -16,675.70 $ 5,418.33
Closing Cash Balance $ 38,724.30 $ 22,048.60 $ 27,466.93

Assumptions

Assumptions Sheet
Food Cost% 25%
BevCost% 20%
Income Tax rate 5%

loan

Loan payment
Annual interest rate 10.0%
Monthly rate 0.80%
Loan amount $80,000
Durantion (months) 24 320
Payment ($3,675.70)
Month Principal balance Principal payment Interest Payment
1 $80,000 ($3,038) ($638) ($3,676)
2 $76,962 ($3,062) ($614) ($3,676)
3 $73,900 ($3,086) ($589) ($3,676)
4 $70,814 ($3,111) ($565) ($3,676)
5 $67,703 ($3,136) ($540) ($3,676)
6 $64,567 ($3,161) ($515) ($3,676)
7 $61,406 ($3,186) ($490) ($3,676)
8 $58,220 ($3,211) ($464) ($3,676)
9 $55,009 ($3,237) ($439) ($3,676)
10 $51,772 ($3,263) ($413) ($3,676)
11 $48,509 ($3,289) ($387) ($3,676)
12 $45,220 ($3,315) ($361) ($3,676)
13 $41,905 ($3,342) ($334) ($3,676)
14 $38,563 ($3,368) ($308) ($3,676)
15 $35,195 ($3,395) ($281) ($3,676)
16 $31,800 ($3,422) ($254) ($3,676)
17 $28,378 ($3,449) ($226) ($3,676)
18 $24,928 ($3,477) ($199) ($3,676)
19 $21,452 ($3,505) ($171) ($3,676)
20 $17,947 ($3,533) ($143) ($3,676)
21 $14,414 ($3,561) ($115) ($3,676)
22 $10,854 ($3,589) ($87) ($3,676)
23 $7,264 ($3,618) ($58) ($3,676)
24 $3,647 ($3,647) ($29) ($3,676)
25 ($0) ($0) $0 $0
26 ($0) ($0) $0 $0
27 ($0) ($0) $0 $0
28 ($0) ($0) $0 $0
29 ($0) ($0) $0 $0
30 ($0) ($0) $0 $0
31 ($0) ($0) $0 $0
32 ($0) ($0) $0 $0
33 ($0) ($0) $0 $0
34 ($0) ($0) $0 $0
35 ($0) ($0) $0 $0
36 ($0) ($0) $0 $0
37 ($0) ($0) $0 $0
38 ($0) ($0) $0 $0
39 ($0) ($0) $0 $0
40 ($0) ($0) $0 $0
41 ($0) ($0) $0 $0
42 ($0) ($0) $0 $0
43 ($0) ($0) $0 $0
44 ($0) ($0) $0 $0
45 ($0) ($0) $0 $0
46 ($0) ($0) $0 $0
47 ($0) ($0) $0 $0
48 ($0) ($0) $0 $0
49 ($0) ($0) $0 $0
50 ($0) ($0) $0 $0
51 ($0) ($0) $0 $0
52 ($0) ($0) $0 $0
53 ($0) ($0) $0 $0
54 ($0) ($0) $0 $0
55 ($0) ($0) $0 $0
56 ($0) ($0) $0 $0
57 ($0) ($0) $0 $0
58 ($0) ($0) $0 $0
59 ($0) ($0) $0 $0
60 ($0) ($0) $0 $0
61 ($0) ($0) $0 $0
62 ($0) ($0) $0 $0
63 ($0) ($0) $0 $0
64 ($0) ($0) $0 $0
65 ($0) ($0) $0 $0
66 ($0) ($0) $0 $0
67 ($0) ($0) $0 $0
68 ($0) ($0) $0 $0
69 ($0) ($0) $0 $0
70 ($0) ($0) $0 $0
71 ($0) ($0) $0 $0
72 ($0) ($0) $0 $0
73 ($0) ($0) $0 $0
74 ($0) ($0) $0 $0
75 ($0) ($0) $0 $0
76 ($0) ($0) $0 $0
77 ($0) ($0) $0 $0
78 ($0) ($0) $0 $0
79 ($0) ($0) $0 $0
80 ($0) ($0) $0 $0
81 ($0) ($0) $0 $0
82 ($0) ($0) $0 $0
83 ($0) ($0) $0 $0
84 ($0) ($0) $0 $0
85 ($0) ($0) $0 $0
86 ($0) ($0) $0 $0
87 ($0) ($0) $0 $0
88 ($0) ($0) $0 $0
89 ($0) ($0) $0 $0
90 ($0) ($0) $0 $0
91 ($0) ($0) $0 $0
92 ($0) ($0) $0 $0
93 ($0) ($0) $0 $0
94 ($0) ($0) $0 $0
95 ($0) ($0) $0 $0
96 ($0) ($0) $0 $0
97 ($0) ($0) $0 $0
98 ($0) ($0) $0 $0
99 ($0) ($0) $0 $0
100 ($0) ($0) $0 $0
101 ($0) ($0) $0 $0
102 ($0) ($0) $0 $0
103 ($0) ($0) $0 $0
104 ($0) ($0) $0 $0
105 ($0) ($0) $0 $0
106 ($0) ($0) $0 $0
107 ($0) ($0) $0 $0
108 ($0) ($0) $0 $0
109 ($0) ($0) $0 $0
110 ($0) ($0) $0 $0
111 ($0) ($0) $0 $0
112 ($0) ($0) $0 $0
113 ($0) ($0) $0 $0
114 ($0) ($0) $0 $0
115 ($0) ($0) $0 $0
116 ($0) ($0) $0 $0
117 ($0) ($0) $0 $0
118 ($0) ($0) $0 $0
119 ($0) ($0) $0 $0
120 ($0) ($0) $0 $0