0% found this document useful (0 votes)
33 views21 pages

Transaction Amount Rate Q1 Q2 Q3 Q4

This document summarizes financial transactions and rates across multiple accounts for each month. It includes purchases, repairs, rent payments, fees, expenses and earnings. The document is organized by month and provides details on transaction amounts, rates, quarterly payments and amounts payable or withheld each period.

Uploaded by

Arnold Bernas
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
33 views21 pages

Transaction Amount Rate Q1 Q2 Q3 Q4

This document summarizes financial transactions and rates across multiple accounts for each month. It includes purchases, repairs, rent payments, fees, expenses and earnings. The document is organized by month and provides details on transaction amounts, rates, quarterly payments and amounts payable or withheld each period.

Uploaded by

Arnold Bernas
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 21

Transaction Amount Rate Q1 Q2 Q3 Q4

Purchases 5000 2% 100


Repair 4000 2% 80
Advance Rent 5000 5% 250
April 1000 5% 50
May 1000 5% 50
June 1000 5% 50
July 1000 5% 50
August 1000 5% 50
September 1000 5% 50
October 1000 5% 50
Agency Fee-security 60 1% 0.6 0.6 0.6 0.6
Agency Fee 15 1% 0.15 0.15 0.15 0.15
Total 180.750 350.750 200.750 50.750
Witheld 100.25 300.25 100.25 50.25
0.25 0.25 50.25 0.25
Payable 80.250 50.250 50.250 0.250

1st 1/1-3/30
2nd 4/1-6/30
3rd 7/1-9/30
4th 10/1-12/31

Jan Feb Mar Apr May Jun


100 80 250
0.2 0.2 0.2 50 50
0.2 0.2 0.2

0.05 0.05 0.05 0.05 0.05 0.05


100.25 0.25 80.25 300.25 0.25 50.25
Monthly 10-Feb 10-Mar 10-Apr 10-May 10-Jun 10-Jul
Quarterly 30-Apr 31-Jul
Timing
20-Jan
1-Mar
1-Apr
15-Apr
10-Jun
15-Jul
25-Jul
30-Aug
20-Sep
15-Oct
Every end of the month
Every end of the month

Jul Aug Sep Oct Nov Dec

50
50
0.2 50 50 50
0.2 0.2 0.2 0.2 0.2
0.05 0.05 0.05 0.05 0.05 0.05
100.25 50.25 50.25 50.25 0.25 0.25
10-Aug 10-Sep 10-Oct 10-Nov 10-Dec 15-Jan
30-Oct 30-Jan
Jan Feb Mar Apr May Jun Jul
Rent Inc 25 5 5
RPT 1.5
Billboard 90
PPE
Total 26.5 0 0 0 90 5 5
5% 5% 5% 5% 5% 5% 5%
1.325 0 0 0 4.5 0.25 0.25
27.825 0 0 0 94.5 5.25 5.25
0 0
Aug Sep Oct Nov Dec
5 5 5 5

90
4 4 4 4
95 9 9 9 4
5% 5% 5% 5% 5%
4.75 0.45 0.45 0.45 0.2
99.75 9.45 9.45 9.45 4.2
Aug Sep Oct Nov Dec
Jan Feb Mar Apr May Jun
BF 50
CPF 20
T/D 40
WR 35
Duties and Taxes 125
Total 85 270
5% 5%
4.25 13.5
0
Jul Aug Sep Oct Nov Dec
Jan Feb Mar Apr May Jun Jul
Security 35 35 35 35 35 35 35
Rate 1% 1% 1% 1% 1% 1% 1%
Total 0.35 0.35 0.35 0.35 0.35 0.35 0.35
Broadcast 5000
Rate 2%
Total 100
0.35 0.35 0.35 0.35 0.35 100.35 0.35
Aug Sep Oct Nov Dec
35 35 32 32 32
1% 1% 1% 1% 1%
0.35 0.35 0.32 0.32 0.32

0.35 0.35 0.32 0.32 0.32


Jan Feb Mar Apr May Jun Jul
A 1000 1000 1000 1000 1000
B 2000
C
D
E
TOTAL 0 0 1000 1000 1000 1000 3000
Aug Sep Oct Nov Dec
1000 1000 1000 1000 1000
1250 1250 1250 1250 1250
2500 1500 1500 1500
5000 200

2250 4750 3750 8750 3950


Jan Feb Mar Apr May Jun Jul Aug
A 120
5%
6
b

d 10 10
5% 5%
0.5 0.5
e 85 85 85 85 85 85 85 85
10% 10% 10% 10% 10% 10% 10% 10%
8.5 8.5 8.5 8.5 8.5 8.5 8.5 8.5
8.5 8.5 8.5 8.5 8.5 8.5 15 9
Sep Oct Nov Dec

225 225
10% 10%
22.5 22.5
350 350
10% 10%
35 35

10 10 10 10
5% 5% 5% 5%
0.5 0.5 0.5 0.5
85 85 85 85
10% 10% 10% 10%
8.5 8.5 8.5 8.5
66.5 9 9 66.5
Jan Feb Mar Apr May
Docotor Fees
60% 1500
40% 1000
Rate 5%
10%
75
100
175

3500
1%
35
Jun Jul Aug Sep Oct Nov Dec

1200 1800 2100


800 1200 1400
5% 5% 5%
10% 10% 10%
60 90 105
80 120 140
140 210 245

0 0 0

2750 3800 5250


1% 1% 1%
27.5 38 52.5
100M*6% 500M*9%
6,000,000 45,000,000
1-Jan 1-Jul

Jan Feb Mar Apr


a 416666.6666667 416666.6666667 416666.6666667 416666.6666667
b 3,750,000 3,750,000 3,750,000 3,750,000
Total 4,166,667 4,166,667 4,166,667 4,166,667
2% 2% 2% 2%
83,333.33 83,333.33 83,333.33 83,333.33
c 250000
1%
2500
d 120000 120000 120000 120000
5% 5% 5% 5%
a/b 6000 6000 6000 6000

c 89,333.33 89,333.33 91,833.33 89,333.33


May Jun Jul Aug Sep
416666.6666667 416666.6666667 416666.6666667 416666.6666667 416666.6666667
3,750,000 3,750,000 3,750,000 3,750,000 3,750,000
4,166,667 4,166,667 4,166,667 4,166,667 4,166,667
2% 2% 2% 2% 2%
83,333.33 83,333.33 83,333.33 83,333.33 83,333.33
320000 380000
1% 1%
3200 3800
120000 120000 120000 120000 120000
5% 5% 5% 5% 5%
6000 6000 6000 6000 6000

89,333.33 92,533.33 89,333.33 89,333.33 93,133.33


Oct Nov Dec
416666.6666667 416666.6666667 416666.6666667
3,750,000 3,750,000 3,750,000
4,166,667 4,166,667 4,166,667
2% 2% 2%
83,333.33 83,333.33 83,333.33
275000
1%
2750
120000 120000 120000
5% 5% 5%
6000 6000 6000

89,333.33 89,333.33 92,083.33


Jan Feb Mar Apr May Jun
a
b

Sales 60M
COGS 12M
OPEX 8M
NIST 40M
Passive Inc 100K
Total 40,100,000
20,050,000
Jul Aug Sep Oct Nov Dec
6020000
15%
903000
40,100,000
15%
6015000
6918000
350000 10% 35000
Exempt
Exempt
Exempt
Exempt
Exempt
Exempt

350000 10% 35000


280000 2% 5600
1200000 2% 24000
64600

You might also like