Psalms One Business Owner - Appendix A – Three Year Financial Plan

Details: Written by Administrator; Created: 03 September 2010; Last Updated: 04 September 2010; Hits: 1616

Three-Year Financial Plan

Table 1 - Sales Quantity.

Quantity estimated to be sold for each product or service by month. Replace the title of each column with the short name of each product or service. If you have more than 9 products or services then copy the table and continue. These figures come from Assignment 9.7.

Month	Product 1	Product 2	Product 3	Product 4	Product 5	Product 6	Product 7	Product 8	Product 9
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
26
27
28
29
30
31
32
33
34
35
36

Table 2 - Cost Estimate

Cost estimated for each product or service by month. Replace the title of each column with the short name of each product or service. If you have more than 9 products or services then copy the table and continue. These figures are calculated from Assignment 9.1.

Month	Product 1	Product 2	Product 3	Product 4	Product 5	Product 6	Product 7	Product 8	Product 9
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
26
27
28
29
30
31
32
33
34
35
36

Table 3 - Estimated Product or Service Cost Extended

Extended Cost. Estimate for each product or service by month. Replace the title of each column with the short name of each product or service. If you have more than 9 products or services then copy the table and continue. Multiply the estimated quantity by the estimated cost per product or service, and enter that number in the appropriate cell in this table. These figures come by multiplying the figures in Table 1 by the figures in Table 2.

Month	Product 1	Product 2	Product 3	Product 4	Product 5	Product 6	Product 7	Product 8	Product 9	Total Cost
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
26
27
28
29
30
31
32
33
34
35
36

Table 4 - Selling price

Selling price estimated for each product or service by month. Replace the title of each column with the short name of each product or service. If you have more than 9 products or services then copy the table and continue. These figures are from Assignment 9.6.

Month	Product 1	Product 2	Product 3	Product 4	Product 5	Product 6	Product 7	Product 8	Product 9
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
26
27
28
29
30
31
32
33
34
35
36

Table 5 - Extended Selling Price.

Extended Selling price estimated for each product or service by month. Replace the title of each column with the short name of each product or service. If you have more than 9 products or services then copy the table and continue. These figures are from multiplying Table 1 by Table 4. Insert the totals of all product or service sales into the "Total Sales" column.

Month	Product 1	Product 2	Product 3	Product 4	Product 5	Product 6	Product 7	Product 8	Product 9	Total Sales
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
26
27
28
29
30
31
32
33
34
35
36

Table 6 Part 1 of 4

Projected Income statement

Total Sales (a) come from Table 5 "Total Sales." Total Cost of Goods Sold (b) come from Table 3 "Total Cost." Other rows are filled out according to Assignment 13.6.

Months

	1	2	3	4	5	6	7	8	9
a. Total Sales
b. Total Cost of Goods sold
c. Gross Profit c = a-b-c
Operating Expenses
d-1. Wages 1
d-2. Wages 2
d-3. Wages 3
e-1. Monthly 1
e-2. Monthly 2
e-3. Monthly 3
e-4. Monthly 4
f-1. Escrow 1
f-2. Escrow 2
f-3. Escrow 3
g-1. Escrow 4
g-2. Escrow 5
h. Total Op. Exp. h=d+e+f+g
i. Pre-Tax Income i = c-h
j. Profit Tax
k. Net Income k = i-j
l. Loan Payment
m. Monthly Support Fee
n. Cash Profit n = k-l-m
o. Loan Received
p. Start up Costs
q. Cash Flow (Accumulative) q = n-o-p+ last months q

Table 6 Part 2 of 4

Projected Income statement

Months

	10	11	12	13	14	15	16	17	18
a. Total Sales
b. Total Cost of Goods sold
c. Gross Profit a-b-c
Operating Expenses
d-1. Wages 1
d-2. Wages 2
d-3. Wages 3
e-1. Monthly 1
e-2. Monthly 2
e-3. Monthly 3
e-4. Monthly 4
f-1. Escrow 1
f-2. Escrow 2
f-3. Escrow 3
g-1. Escrow 4
g-2. Escrow 5
h. Total Op. Exp. h=d+e+f+g
i. Pre-Tax Income i = c-h
j. Profit Tax
k. Net Income k = i-j
l. Loan Payment
m. Monthly Support Fee
n. Cash Profit n = k-l-m
o. Loan Received
p. Start up Costs
q. Cash Flow (Accumulative) q = n-o-p+ last months q

Table 6 - Part 3 of 4

Projected Income statement

Months

	19	20	21	22	23	24	25	26	27
a. Total Sales
b. Total Cost of Goods sold
c. Gross Profit a-b-c
Operating Expenses
d-1. Wages 1
d-2. Wages 2
d-3. Wages 3
e-1. Monthly 1
e-2. Monthly 2
e-3. Monthly 3
e-4. Monthly 4
f-1. Escrow 1
f-2. Escrow 2
f-3. Escrow 3
g-1. Escrow 4
g-2. Escrow 5
h. Total Op. Exp. h=d+e+f+g
i. Pre-Tax Income i = c-h
j. Profit Tax
k. Net Income k = i-j
l. Loan Payment
m. Monthly Support Fee
n. Cash Profit n = k-l-m
o. Loan Received
p. Start up Costs
q. Cash Flow (Accumulative) q = n-o-p+ last months q

Table 6 - Part 4 of 4

Projected Income statement

Months

	28	29	30	31	32	33	34	35	36
a. Total Sales
b. Total Cost of Goods sold
c. Gross Profit a-b-c
Operating Expenses
d-1. Wages 1
d-2. Wages 2
d-3. Wages 3
e-1. Monthly 1
e-2. Monthly 2
e-3. Monthly 3
e-4. Monthly 4
f-1. Escrow 1
f-2. Escrow 2
f-3. Escrow 3
g-1. Escrow 4
g-2. Escrow 5
h. Total Op. Exp. h=d+e+f+g
i. Pre-Tax Income i = c-h
j. Profit Tax
k. Net Income k = i-j
l. Loan Payment
m. Monthly Support Fee
n. Cash Profit n = k-l-m
o. Loan Received
p. Start up Costs
q. Cash Flow (Accumulative) q = n-o-p+ last months q

Login Form

Example of Section Blog layout (FAQ section)

Psalms One Business Owner - Appendix A – Three Year Financial Plan