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

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter11: The Statement Of Cash Flows

Section: Chapter Questions

Problem 23CE: Cash Receipts from Customers Singleton Inc. had accounts receivable of $22,150 at January 1, 2019,...

See similar textbooks

Similar questions

Lucky House Ltd Trial Balance As at 30 September 2020 Account Debit(£) Credit(£)Cash at Bank 5,850Capital Account 15,000Machine 8,100Raw Materials 2,655Stationery 250Accounts Payable 6,545Rent 950Business Insurance 38Prepayments 1,362Sales Income 17,550Cost of Goods Sold 11,345Accounts Receivable 4,500Drawings 4,000Telephone 45Depreciation 135Accumulated Depreciation 135 Total 39,230 39,230 Prepare a statement of cash flow ?
Lucky House Ltd Trial Balance As at 30 September 2020 Account Debit(£) Credit(£)Cash at Bank 5,850Capital Account 15,000Machine 8,100Raw Materials 2,655Stationery 250Accounts Payable 6,545Rent 950Business Insurance 38Prepayments 1,362Sales Income 17,550Cost of Goods Sold 11,345Accounts Receivable 4,500Drawings 4,000Telephone 45Depreciation 135Accumulated Depreciation 135 Total 39,230 39,230 Prepare a Statement of Profit & Loss and Statement of…
the sales ledger and purchase ledger junta ltd as at 31 may 2020. purchase ledger balances as 1 june 2020 $19,420sales ledger balance as 1 june 2020 $28,227purchase journal $210,416sales journal $305,824returns outwards $1,452returns inwards $3,618cheques paid to suppliers $205,751cash paid to supplier $62cheques ans cash received from customers $287,317discount allowed $4,102discount received $1,721contras against purchase ledger $640 1) Sales ledger control2)Puchase ledger control
Metal tech Cash Account 31.12.2020 RS RS Balance B/D50Payment to suppliers2000 Equity share300Purchase of fixed asset200 Receipts from customer2800Overhead expenses200 Sale of fixed asset100Wages & Salaries100 Tax250 Dividend50 Repayment of loan300 Balance C/D150 3250 3250 Prepare a cash flow account for metal tech ending on 31.12.2020.
1. Compute the current assets.Cash Php 25,867.00Barney’s drawing 50,485.00Accounts Payable 78,584.00Notes Receivable 45,051.00Building 1,500,125.00Inventory 33,669.002. Compute the Net Income.Service Income Php 356,867.00Prepaid Rent 16,800.00Interest Expense 1,523.00Barney’s drawing 21,786.00Taxes 4,544.00Utilities Expense 3,651.003. The liabilities of Bb Barn are equal to 1/3 of thetotal assets. The owner's equity is P 6,300,500. Whatis the amount of the liabilities?4. Prepare journal entries to the following transactionsfor the year 2020.Sept. 1 V Barney invested Php 150,000 in Barney repair ShopSept 3 Purchased equipment worth Php 80,000 on account.Sept. 12 Paid Php 25, 000 for the equipmentpurchased dated Sept. 3, 2020.Sept. 15 Rendered service amounting toPhp 45,000.Sept. 17 Paid salaries to employees, Php16,000
Income tac was $300,409 for the year. Income tac payable was $28,102 and $42,997 at the beginning and end of the year,reapectively. Cash payants for income tac reportés on the statement pc cash flots usine the direct method la a. $ 285,514 b. 315,304 c. 300,409 d. 371,508
Life-Positive’s Account Balances 2021 ($) 2022 ($) accounts payable 24,600.00 21,250.00Accounts receivable 15,700.00 12,340.00Cash 23,450.00 28,600.00Cost of goods sold 19,700.00 23,000.00Depreciation 3,090.00 4,590.00Dividends 5,800.00 10,800.00Interest 2,340.00 2,890.00Inventory 7,050.00 8,640.00Long-term debt 28,000.00 30,000.00Net fixed assets 41,500.00 48,000.00Other expenses 2,400.00 2,800.00Sales 58,000.00 62,500.00Short-term Notes Payable 2,890.00 2,340.00Shares outstanding 85,000.00 90,000.00 tax rate is 32% 4. Calculate the cash flow from assets, cash flow to creditors,and cash flow to stockholders…
Revenue R100 000, Debtors (opening R50 000, closing R110 000), Calculate Cash Receipts from Customers. Select one: a. R60 000 b. R40 000 c. R110 000 d. R100 000
Company A's net credit sales in 2020 and 2021 are 21115 and 35118 respectively. Cost of sales in 2020 is 15432, and in 2021 is 17088. Company A'a account receivable in 2020 and 2021 are 500 and 1000 respectively and its inventory in 2020 and 2021 are 2839 and 3489 respectively. Company A's cash collections from customers in 2021 are:
h. Assume that accounts receivable at December 31, 2020, totaled $310 million. Calculate the number of days' sales in receivables at that date. (Use 365 days a year. Do not round intermediate calculations. Round your answer to 1 decimal place.) WIPER INC. Condensed Balance Sheets December 31, 2020, 2019, 2018 (in millions) 2020 2019 2018 Current assets $ 650 $ 900 $ 700 Other assets 2,750 2,050 1,750 Total assets $ 3,400 $ 2,950 $ 2,450 Current liabilities $ 500 $ 800 $ 700 Long-term liabilities 1,500 1,000 800 Stockholders' equity 1,400 1,150 950 Total liabilities and stockholders' equity $ 3,400 $ 2,950 $ 2,450 WIPER INC. Selected Income Statement and Other Data For the year Ended December 31, 2020 and 2019 (in millions) 2020 2019 Income statement data: Sales $ 3,300 $ 2,900 Operating income 380 300 Interest expense 80 70 Net income…
Balance on April 1, 2020Debtors control Dr. $65, 145Debtors control Cr. 600Creditors control Dr. 950Creditors control Cr. 75, 500Totals for the month of April 2020Cash purchases 35, 600Credit purchases 62, 600Cash Sales 47, 000Credit Sales 75, 000Contra entry: Set off 1, 800Refund to cash customers 2, 800Bad debt written off 3, 300Discount Allowed 3, 750Total payments to suppliers 87, 000Total receipt from customers 98, 800Discount received 5, 500Dishonoured cheques: customers 2, 900Increase in the allowance for bad debts 2, 100Return Inwards 2, 400Return Outwards 15, 200Balances at 30 April 2020Debtors control: Dr. ? Cr: $8 300Creditors control: Dr. $7 500 Cr: ?Required: Prepare the Sales ledger control account Prepare the Purchases control account
Maple Group LtdComparative Balance SheetDecember 31, 2020 and 20192020 2019 Increase/(Decrease)Assets Cash and cash equivalent ? 31,500 (10,000)Accounts Receivable ? 87,500 ? Inventories 97,100 ? ? Fixed Assets, net 142,300 ? 32,000 Total Assets 302,900 323,000 (20,100)Liabilities Accounts payable 25,600 26,600 ? Accrued liabilities 24,000 ? 1,200 Long-term notes payable 58,200 ? (20,000)Stockholders' Equity: Common Stock ? 131,400 ? Retained earnings 54,800 64,000 (9,200)Total liabilities and stockholders' equity 302,900 323,000 (20,100)- - - Maple Group Ltd Income Statement Year Ended December 31,2020 Revenues and gains: Sales revenue 370,000 Interest revenue 11,800 Total revenues and gains 381,800 Expenses Cost of goods sold 205,500 Depreciation expense 15,500 Other operating expense 126,000 Interest expense 24,300 Total expenses 371,300 Income before income taxes 10,500 Income tax expense 16,300 Net Loss (5,800) Notes Acquisition of fixed asset during 2020 47,500 Sale proceed…