2020 CASH SALES NUMBER OF Month End Credit Amount PP Fees Host Payout Revenue Revenue in USD BOOKINGS January February March April May June July August September October November December 124 P557,557.78 P0.00 9482,059.84 P75,497.94 $1,451.88 67 P286,517.44 $700.19 P5,706.14 P3,886.49 P249,333.07 P36,409.63 $1,856.42 ($9,311.13) $2,955.46 $1,336.71 162 P735,236.68 P634,816.54 P482,536.66 P435,757.97 P96,533.65 (P484,178.67) P153,683.69 248 P344.59 P1,986.60 330 P589,757.86 P335,389.32 P316.20 189 P1,227.60 P265,880.63 P383,932.42 P69,508.69 $1,994.98 $1,806.83 259 P486,520.19 P3,313.00 P101,743.77 209 P358,154.40 P698.00 P265,308.20 P92,148.20 P357,126.18 P320,296.65 $1,478.61 $1,615.52 $1,003.19 $1,832.41 160 P117.94 P281,599.30 P75,408.94 180 P194.40 P237,710.51 P82,391.74 P51,162.46 P93,452.67 127 P233,480.45 P0.00 P182,317.99 206 P563,803.01 P127.50 P470,222.84 TOTAL IN PHP 94,371,475.97 $8,721.04 P4,824,184.55 $94,591.85 P17,573.87 $344.59 P443,762.71 $8,701.23 TOTAL IN USD $85,715.22

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

1.How is the company's financial performance based on the data?
   2.What do you think are the factors affecting the number of bookings throughout the year?

3. What can you say about the company's revenue for 2020? Regardless if it's good or not, give strategic decisions that can help improve the revenue from its current status

4. What are your analysis and insights on the Financial statement.

 

1-2020-Direct-Cash-Sales-Report .XLSX
Share
File Edit View Insert Format Data Tools Help
100%
£
% .0 .00 123 -
Default (Ca.
12
в I S А
31
D21
fx |
A
D
E
J
K
2020 CASH SALES
NUMBER OF
Month End
Credit Amount
PP Fees
Host Payout
Revenue
Revenue in USD
2
ВОOKINGS
January
February
March
April
May
$1,451.88
$700.19
3
124
P557,557.78
P0.00
P482,059.84
P75,497.94
P249,333.07
P36,409.63
4
67
P286,517.44
P5,706.14
$1,856.42
($9,311.13)
$2,955.46
$1,336.71
$1,994.98
$1,806.83
$1,478.61
5
162
P735,236.68
P3,886.49
P634,816.54
P96,533.65
P344.59
(P484,178.67)
P153,683.69
6
248
P1,986.60
P316.20
P482,536.66
P589,757.86
P435,757.97
7
330
June
July
August
September
October
November
December
8
189
P335,389.32
P1,227.60
P265,880.63
P69,508.69
P486,520.19
9
259
P3,313.00
P383,932.42
P101,743.77
P698.00
P92,148.20
10
209
P358,154.40
P265,308.20
11
160
P357,126.18
P117.94
P281,599.30
P75,408.94
P194.40
P237,710.51
$1,615.52
12
180
P320,296.65
P82,391.74
P0.00
$1,003.19
$1,832.41
13
127
P233,480.45
P182,317.99
P51,162.46
P563,803.01
P127.50
14
206
P470,222.84
P93,452.67
16
TOTAL IN PHP
$8,721.04
P4,824,184.55
$94,591.85
P17,573.87
$344.59
P4,371,475.97
P443,762.71
$8,701.23
$85,715.22
17
TOTAL IN USD
18
Transcribed Image Text:1-2020-Direct-Cash-Sales-Report .XLSX Share File Edit View Insert Format Data Tools Help 100% £ % .0 .00 123 - Default (Ca. 12 в I S А 31 D21 fx | A D E J K 2020 CASH SALES NUMBER OF Month End Credit Amount PP Fees Host Payout Revenue Revenue in USD 2 ВОOKINGS January February March April May $1,451.88 $700.19 3 124 P557,557.78 P0.00 P482,059.84 P75,497.94 P249,333.07 P36,409.63 4 67 P286,517.44 P5,706.14 $1,856.42 ($9,311.13) $2,955.46 $1,336.71 $1,994.98 $1,806.83 $1,478.61 5 162 P735,236.68 P3,886.49 P634,816.54 P96,533.65 P344.59 (P484,178.67) P153,683.69 6 248 P1,986.60 P316.20 P482,536.66 P589,757.86 P435,757.97 7 330 June July August September October November December 8 189 P335,389.32 P1,227.60 P265,880.63 P69,508.69 P486,520.19 9 259 P3,313.00 P383,932.42 P101,743.77 P698.00 P92,148.20 10 209 P358,154.40 P265,308.20 11 160 P357,126.18 P117.94 P281,599.30 P75,408.94 P194.40 P237,710.51 $1,615.52 12 180 P320,296.65 P82,391.74 P0.00 $1,003.19 $1,832.41 13 127 P233,480.45 P182,317.99 P51,162.46 P563,803.01 P127.50 14 206 P470,222.84 P93,452.67 16 TOTAL IN PHP $8,721.04 P4,824,184.55 $94,591.85 P17,573.87 $344.59 P4,371,475.97 P443,762.71 $8,701.23 $85,715.22 17 TOTAL IN USD 18
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education