ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAO
1
YEAR 1YEAR 2YEAR 3
2
MarchAprilMay JuneJuly AugustSeptemberOctoberNovemberDecemberJanuaryFebruaryMarchAprilMay JuneJulyAugustSeptemberAugustSeptemberOctoberNovemberDecember January February MarchAprilMay JuneJuly AugustSeptemberOctoberNovemberDecemberJanuaryFebruary
3
Beginning Cash Balance ₱ - ₱ 36,150.00 ₱ 817,000.00 ₱ 571,150.00 ₱ 1,038,150.00 ₱ 792,300.00 ₱ 1,141,800.00 ₱ 895,950.00 ₱ 1,245,450.00 ₱ 999,600.00 ₱ 1,114,100.00 ₱ 868,250.00 ₱ 982,750.00 ₱ 622,400.00 ₱ 1,381,650.00 ₱ 1,021,300.00 ₱ 1,780,550.00 ₱ 1,420,200.00 ₱ 2,060,950.00 ₱ 1,700,600.00 ₱ 2,341,350.00 ₱ 1,981,000.00 ₱ 2,621,750.00 ₱ 2,261,400.00 ₱ 2,464,650.00 ₱ 2,104,300.00 ₱ 2,276,050.00 ₱ 1,202,350.00 ₱ 2,253,850.00 ₱ 1,780,150.00 ₱ 2,831,650.00 ₱ 2,357,950.00 ₱ 3,291,950.00 ₱ 2,818,250.00 ₱ 3,752,250.00 ₱ 3,278,550.00 ₱ 3,507,550.00 ₱ 3,033,850.00
4
Add: Receipts
5
Capital ₱ 350,000.00 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
6
Collections from customers ₱ - ₱ 500,000.00 ₱ - ₱ 500,000.00 ₱ - ₱ 375,000.00 ₱ - ₱ 375,000.00 ₱ - ₱ 125,000.00 ₱ - ₱ 125,000.00 ₱ - ₱ 812,500.00 ₱ - ₱ 812,500.00 ₱ - ₱ 687,500.00 ₱ - ₱ 687,500.00 ₱ - ₱ 687,500.00 ₱ - ₱ 187,500.00 ₱ - ₱ 187,500.00 ₱ - ₱ 1,125,000.00 ₱ - ₱ 1,125,000.00 ₱ - ₱ 1,000,000.00 ₱ - ₱ 1,000,000.00 ₱ - ₱ 250,000.00 ₱ - ₱ 250,000.00
7
Total Receipts ₱ 350,000.00 ₱ 536,150.00 ₱ - ₱ 500,000.00 ₱ - ₱ 375,000.00 ₱ - ₱ 375,000.00 ₱ - ₱ 125,000.00 ₱ - ₱ 125,000.00 ₱ - ₱ 812,500.00 ₱ - ₱ 812,500.00 ₱ - ₱ 687,500.00 ₱ - ₱ 687,500.00 ₱ - ₱ 687,500.00 ₱ - ₱ 187,500.00 ₱ - ₱ 187,500.00 ₱ - ₱ 1,125,000.00 ₱ - ₱ 1,125,000.00 ₱ - ₱ 1,000,000.00 ₱ - ₱ 1,000,000.00 ₱ - ₱ 250,000.00 ₱ - ₱ 250,000.00
8
Total Available Cash ₱ 350,000.00 ₱ 536,150.00 ₱ 817,000.00 ₱ 1,071,150.00 ₱ 1,038,150.00 ₱ 1,167,300.00 ₱ 1,141,800.00 ₱ 1,270,950.00 ₱ 1,245,450.00 ₱ 1,124,600.00 ₱ 1,114,100.00 ₱ 993,250.00 ₱ 982,750.00 ₱ 1,434,900.00 ₱ 1,381,650.00 ₱ 1,833,800.00 ₱ 1,780,550.00 ₱ 2,107,700.00 ₱ 2,060,950.00 ₱ 2,388,100.00 ₱ 2,341,350.00 ₱ 2,668,500.00 ₱ 2,621,750.00 ₱ 2,448,900.00 ₱ 2,464,650.00 ₱ 2,291,800.00 ₱ 2,276,050.00 ₱ 2,327,350.00 ₱ 2,253,850.00 ₱ 2,905,150.00 ₱ 2,831,650.00 ₱ 3,357,950.00 ₱ 3,291,950.00 ₱ 3,818,250.00 ₱ 3,752,250.00 ₱ 3,528,550.00 ₱ 3,507,550.00 ₱ 3,283,850.00
9
Less: Disbursements
10
Direct Materials ₱ 256,950.00 - ₱ 225,450.00 - ₱ 225,450.00 - ₱ 225,450.00 - ₱ 225,450.00 - ₱ 225,450.00 - ₱ 328,250.00 - ₱ 328,250.00 - ₱ 328,250.00 - ₱ 328,250.00 - ₱ 328,250.00 - ₱ 328,250.00 - ₱ 328,250.00 - ₱ 1,050,900.00 - ₱ 450,900.00 ₱ - ₱ 450,900.00 ₱ - ₱ 450,900.00 ₱ - ₱ 450,900.00 ₱ - ₱ 450,900.00 ₱ -
11
Direct Labor ₱ 3,000.00 ₱ 3,000.00 ₱ 3,000.00 ₱ 3,000.00 ₱ 3,000.00 ₱ 3,000.00 ₱ 3,000.00 ₱ 3,000.00 ₱ 3,000.00 ₱ 3,000.00 ₱ 3,000.00 ₱ 3,000.00 ₱ 4,500.00 ₱ 4,500.00 ₱ 4,500.00 ₱ 4,500.00 ₱ 4,500.00 ₱ 4,500.00 ₱ 4,500.00 ₱ 4,500.00 ₱ 4,500.00 ₱ 4,500.00 ₱ 4,500.00 ₱ 4,500.00 ₱ 4,500.00 ₱ 4,500.00 ₱ 6,000.00 ₱ 6,000.00 ₱ 6,000.00 ₱ 6,000.00 ₱ 6,000.00 ₱ 6,000.00 ₱ 6,000.00 ₱ 6,000.00 ₱ 6,000.00 ₱ 6,000.00 ₱ 6,000.00 ₱ 6,000.00
12
Overhead ₱ 8,400.00 - ₱ 8,400.00 - ₱ 8,400.00 - ₱ 8,400.00 - ₱ 8,400.00 - ₱ 8,400.00 - ₱ 12,600.00 - ₱ 12,600.00 - ₱ 12,600.00 - ₱ 12,600.00 - ₱ 12,600.00 - ₱ 12,600.00 - ₱ 12,600.00 - ₱ 16,800.00 - ₱ 16,800.00 ₱ - ₱ 16,800.00 ₱ - ₱ 16,800.00 ₱ - ₱ 16,800.00 ₱ - ₱ 16,800.00 ₱ -
13
SG&A ₱ 9,000.00 - ₱ 9,000.00 - ₱ 9,000.00 - ₱ 9,000.00 - ₱ 9,000.00 - ₱ 9,000.00 - ₱ 15,000.00 - ₱ 15,000.00 - ₱ 15,000.00 - ₱ 15,000.00 - ₱ 15,000.00 - ₱ 15,000.00 - ₱ 15,000.00 - ₱ - - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
14
Commission ₱ - ₱ 30,000.00 ₱ - ₱ 30,000.00 ₱ - ₱ 22,500.00 ₱ - ₱ 22,500.00 ₱ - ₱ 7,500.00 ₱ - ₱ 7,500.00 ₱ - ₱ 48,750.00 ₱ - ₱ 48,750.00 ₱ - ₱ 42,250.00 ₱ - ₱ 42,250.00 ₱ - ₱ 42,250.00 ₱ - ₱ 11,250.00 ₱ - ₱ 11,250.00 ₱ - ₱ 67,500.00 ₱ - ₱ 67,500.00 ₱ - ₱ 60,000.00 ₱ - ₱ 60,000.00 ₱ - ₱ 15,000.00 ₱ - ₱ 15,000.00
15
Org Budget ₱ 36,500.00 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
16
Total Disbursements ₱ 313,850.00 ₱ 33,000.00 ₱ 245,850.00 ₱ 33,000.00 ₱ 245,850.00 ₱ 25,500.00 ₱ 245,850.00 ₱ 25,500.00 ₱ 245,850.00 ₱ 10,500.00 ₱ 245,850.00 ₱ 10,500.00 ₱ 360,350.00 ₱ 53,250.00 ₱ 360,350.00 ₱ 53,250.00 ₱ 360,350.00 ₱ 46,750.00 ₱ 360,350.00 ₱ 46,750.00 ₱ 360,350.00 ₱ 46,750.00 ₱ 360,350.00 ₱ 15,750.00 ₱ 360,350.00 ₱ 15,750.00 ₱ 1,073,700.00 ₱ 73,500.00 ₱ 473,700.00 ₱ 73,500.00 ₱ 473,700.00 ₱ 66,000.00 ₱ 473,700.00 ₱ 66,000.00 ₱ 473,700.00 ₱ 21,000.00 ₱ 473,700.00 ₱ 21,000.00
17
Excess of Available Cash Over Cash Disbursements ₱ 36,150.00 ₱ 503,150.00 ₱ 571,150.00 ₱ 1,038,150.00 ₱ 792,300.00 ₱ 1,141,800.00 ₱ 895,950.00 ₱ 1,245,450.00 ₱ 999,600.00 ₱ 1,114,100.00 ₱ 868,250.00 ₱ 982,750.00 ₱ 622,400.00 ₱ 1,381,650.00 ₱ 1,021,300.00 ₱ 1,780,550.00 ₱ 1,420,200.00 ₱ 2,060,950.00 ₱ 1,700,600.00 ₱ 2,341,350.00 ₱ 1,981,000.00 ₱ 2,621,750.00 ₱ 2,261,400.00 ₱ 2,464,650.00 ₱ 2,104,300.00 ₱ 2,276,050.00 ₱ 1,202,350.00 ₱ 2,253,850.00 ₱ 1,780,150.00 ₱ 2,831,650.00 ₱ 2,357,950.00 ₱ 3,291,950.00 ₱ 2,818,250.00 ₱ 3,752,250.00 ₱ 3,278,550.00 ₱ 3,507,550.00 ₱ 3,033,850.00 ₱ 3,262,850.00
18
Financing
19
Borrowings ₱ 313,850.00 ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
20
Repayments ₱ - ₱ 467,000.00 ₱ 221,150.00 ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
21
Repayment-12% Interest ₱ - ₱ 6,277.00 ₱ 1,607.00 ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
22
Ending Cash Balance ₱ 36,150.00 ₱ 817,000.00 ₱ 571,150.00 ₱ 1,038,150.00 ₱ 792,300.00 ₱ 1,141,800.00 ₱ 895,950.00 ₱ 1,245,450.00 ₱ 999,600.00 ₱ 1,114,100.00 ₱ 868,250.00 ₱ 982,750.00 ₱ 622,400.00 ₱ 1,381,650.00 ₱ 1,021,300.00 ₱ 1,780,550.00 ₱ 1,420,200.00 ₱ 2,060,950.00 ₱ 1,700,600.00 ₱ 2,341,350.00 ₱ 1,981,000.00 ₱ 2,621,750.00 ₱ 2,261,400.00 ₱ 2,464,650.00 ₱ 2,104,300.00 ₱ 2,276,050.00 ₱ 1,202,350.00 ₱ 2,253,850.00 ₱ 1,780,150.00 ₱ 2,831,650.00 ₱ 2,357,950.00 ₱ 3,291,950.00 ₱ 2,818,250.00 ₱ 3,752,250.00 ₱ 3,278,550.00 ₱ 3,507,550.00 ₱ 3,033,850.00 ₱ 3,262,850.00
23
24
Desired Ending Balance ₱ 350,000.00
25
26
Loan Calculator
27
Do I need to borrow? Yes No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No
28
How much do I borrow? ₱ 313,850.00 ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
29
Can I repay my loan, If any? Yes Yes No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan No Loan
30
How much can I repay? ₱ - ₱ 467,000.00 ₱ 221,150.00 ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
31
How much do I actually pay? ₱ 467,000.00 ₱ 221,150.00 ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
32
33
Loan Balance ₱ 313,850.00 ₱ 627,700.00 ₱ 160,700.00 ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
34
Add: New Loan ₱ 313,850.00 ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
35
Less: Loan Payments ₱ - ₱ 467,000.00 ₱ 221,150.00 ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
36
Ending Loan Balance ₱ 627,700.00 ₱ 160,700.00 ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
37
Interest Rate of loan 12% ₱ 6,277.00 ₱ 1,607.00 ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100