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 status4. What are your analysis and insights on the Financial statement. 1-2020-Direct-Cash-Sales-Report .XLSXShareFile Edit View Insert Format Data Tools Help100%£% .0 .00 123 -Default (Ca.12в I S А31D21fx |ADEJK2020 CASH SALESNUMBER OFMonth EndCredit AmountPP FeesHost PayoutRevenueRevenue in USD2ВОOKINGSJanuaryFebruaryMarchAprilMay$1,451.88$700.193124P557,557.78P0.00P482,059.84P75,497.94P249,333.07P36,409.63467P286,517.44P5,706.14$1,856.42($9,311.13)$2,955.46$1,336.71$1,994.98$1,806.83$1,478.615162P735,236.68P3,886.49P634,816.54P96,533.65P344.59(P484,178.67)P153,683.696248P1,986.60P316.20P482,536.66P589,757.86P435,757.977330JuneJulyAugustSeptemberOctoberNovemberDecember8189P335,389.32P1,227.60P265,880.63P69,508.69P486,520.199259P3,313.00P383,932.42P101,743.77P698.00P92,148.2010209P358,154.40P265,308.2011160P357,126.18P117.94P281,599.30P75,408.94P194.40P237,710.51$1,615.5212180P320,296.65P82,391.74P0.00$1,003.19$1,832.4113127P233,480.45P182,317.99P51,162.46P563,803.01P127.5014206P470,222.84P93,452.6716TOTAL IN PHP$8,721.04P4,824,184.55$94,591.85P17,573.87$344.59P4,371,475.97P443,762.71$8,701.23$85,715.2217TOTAL IN USD18

Company's financial performance based on the data: Net Profit Margin = Revenue / Credit Sales *…

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

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

Quickbooks Online Accounting

3rd Edition

ISBN:9780357391693

Author:Owen

Publisher:Owen

Chapter10: Financial Statements And Reports

Section: Chapter Questions

Problem 3.5C

See similar textbooks

Similar questions

OkyOTcw/a/MjUwNDEyNDM20TEx/details Particulars Credit (RM) 48,400 Debit (RM) Capital Drawings Trade receivables Trade payables Sales Purchases Sales returns Purchases retums Wages and salaries Discounts allowed Discounts received Provision for doubtful debts Insurance Inventory as at 1 September 2018 Utilities 3,500 9,000 12,500 40,400 31,000 300 250 5,600 120 200 300 700 2,400 950 350 10,000 3,000 20,000 Rates Premises Fixtures and fittings Motor van Cash in hand Cash at bank TOTAL 330 14,800 102.050 102.050 Additional information as at 31 August 2019: i. Inventory as at 31 August 2019 amounted RM3,300 ii. An entity from whom there is accounts receivables of RM200 was unable to settle his debt and this amount is to be written off as bad debts. iii. The provision for doubtful debts is 1% of the outstanding trade receivables. iv. The owner took RM100 worth of goods from the business for his own use Required: a) Statement of Profit or Loss and Others Comprehensive Income for the year…
Calculate ROE for PotBelly Corp 2015. Use highlighted excel info
Find the ROE for Potbelly Corp for the year 2015. Use the highlighted excel information. Please explain steps used, thanks!
(To record cash purchase of premiums) Cash Sales Revenue (To record cash sales) Cash Premium Expense Inventory of Premiums (To record redemption of codes) (To adjust unearned revenue) Save for Later 3840000 000 0 Attempts: 1 of 3 used Submit Answer E
ssignment/takeAssignmentMain.do?invoker%=&takeAssignmentSessionLocator38inprogress3Dfalse CardPointe ONew Tab UTA Is The Leader I.... Commercial Captur... UPS-Shipping ups Search for Corporat... |国 Determine the amount to be paid by the buyer for full settlement of each invoice, assuming that credit for returns and allowances was received prior to payment and that all invoices were paid within the discount period. Merchandise Transportation Paid by Seller Transportation Terms Returns and Allowances (a) $7,600 $202 FOB Shipping Point, 1/10, net 30 $800 (b) $7,500 $62 FOB Destination, 2/10, net 45 $1,700 a. b. Previous Next Email Instruct + %24 %24
VVIICH UI the TVWO TmetiTIOUS UC you pTeter affa wiry: P8-4 (LO3) EXCEL (Compute FIFO, LIFO, and Average-Cost) Hull Company's record of transactions concerning part X for the month of April was as follows. Purchases Sales April 1 (balance on hand) 100 @ $5.00 April 5 300 400 @ 5.10 12 200 11 300 @ 5.30 27 800 18 200 @ 5.35 28 150 26 600 @ 5.60 30 200 @ 5.80 Instructions (a) Compute the inventory at April 30 on each of the following bases. Assume that perpetual inventory records are kept in units only. Carry unit costs to the nearest cent. (1) First-in, first-out (FIFO). (2) Last-in, first-out (LIFO). (3) Average-cost.
Please help with 5.2
What is the value on 1/1/16 of the following cash flows? Use a 10% discount rate, and round your answer to the nearest $1.00. Date Cash Received 1/1/18 1/1/19 1/1/20 1/1/21 1/1/22 OA. $1,065 OB. $1,500 OC. $880 OD. $968 Amount of Cash $100 $200 $300 $400 $500
Please help question 5. This question ends at Taxation is 28%
Find ROA and Financial Leverage for Potbelly Corp 2015. Use highlighted excel company information. Please list steps taken, thanks!
laun OPI=https%253A%252F%252Fblackboard.waketech.edu%252Fwebapps%252Fportal%252Fframeset.jsp%253Ftab_tab dexternal_browser%3U From the following, prepare a classified balance sheet for Bach Crawlers as of December 31, 2020. Ending merchandise inventory was $5,300 for the year. Cash Prepaid rent Prepaid insurance Office equipment (net) $ 7,300 2,250 5,300 6,300 Accounts payable Salaries payable Note payable (long term) P. Bach, capital* $ 2,450 2,250 9,300 12,450 *What the owner supplies to the business. Replaces common stock and retained earnings section. BACH CRAWLERS Balance Sheet December 31, 2020 Assets Liabilities Current assets: Current liabilities: Total current assets Total current liabilities Long-term liabilities: Total liabilities Plant and equipment: Owner's Equity 回可可 acer
C. P177.60 d. P29.60 P74.40 P300 P620 30% e. 4. Find the (a) cash discount and (b) net amount due if the following invoices are paid within the discoun period. Net invoice price P3,265 Net amount due Terms of payment 3 п Cash discount 10'30 P 1,342 15'60 2 n P985 5'15 5. Find the (a) deadline for discount period, (b) deadline for credit period, (c) cash discount and (d) amount due for the following cases. Deadline of discount Net Deadline of credit Invoice Terms of Cash Invoice date amount due amount payment discount period period 1 n P 1,675 Jan. 15 15'45 P645 Feb. 25 10'30 1n P 895 March 12 10'45 3 2 P785 April 22 . 15'20'90 6. The net invoice price of a wall clock is P287.00. If the discount granted was 18%, find: a. Net invoice price rate b. List price C. Discount 7. The net invoice price of a dining table is P6,187.50, representing 75% of the list price. Find: a. List price b. Discount