INCOME STATEMENT OF DEL CAMPO FOR 2019 AND 2018 | ||||
Accrual Basis | Cash Basis | |||
2019 | 2018 | 2019 | 2018 | |
Income | ||||
Revenue | 250,000.00 | 185,000.00 | 80,000.00 | 97,000.00 |
250,000.00 | 185,000.00 | 80,000.00 | 97,000.00 | |
Operating Expenses | ||||
Salary | 12,000.00 | 16,500.00 | - | - |
Purchases | 5,500.00 | 3,500.00 | 4,000.00 | 2,500.00 |
[4000+1500] | [2500+1000] | |||
Depreciation | 2,000.00 | 2,000.00 | - | - |
Rent | 7,000.00 | 3,000.00 | 7,000.00 | 3,000.00 |
Insurance | - | - | 5,500.00 | - |
26,500.00 | 25,000.00 | 16,500.00 | 5,500.00 | |
Operating Income | 223,500.00 | 160,000.00 | 63,500.00 | 91,500.00 |
Operating Cash Flow for 2019 and 2018 | ||||
2019 | 2018 | |||
Cash Collected from clients | 80,000.00 | 97,000.00 | ||
(-) Cash paid towards purchases | (4,000.00) | (2,500.00) | ||
(-) Cash paid towards Rent | (7,000.00) | (3,000.00) | ||
(-) Cash paid towards Insurance | (5,500.00) | |||
Net Cash flow from operations | 63,500.00 | 91,500.00 | ||
Financial Reporting Theory Cash vs. Accrual You are provided the following information for the Del Campo...
1. Prepare an income statement for Del Campo for 2019 and 2018 under both the cash and the accrual basis of accounting. (Always use cell references and formulas, including $0 balances, where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.) Accrual Basis 2019 2018 Cash Basis 2019 2018 Operating expenses: Operating income 2. Compute operating cash flow for both years under cash and accrual bases. (Always use cell references and formulas...
erform: Instructions Prepare the company's income statement for the year ended December 31, 2018, complete with an appropriate heading. a. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values to be subtracted. b. Check your spelling carefully and do not abbreviate. (Always use cell references and formulas where appropriate to receive full credit If you copy/paste from the Instructions tab you will be marked wrong.) Total Points 1 The Financial Statements 2...
i Cost-Volume-Profit Analysis CVP exercises The Dell-Sub Shop owns and operates six stores in and around Minneapolis. You are given the following corporate budget data for next year: Revenues Fixed costs Variable costs $11,000,000 $3,000,000 $7,500,000 10 Variable costs change based on the number of subs sold. 12 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. Cell references and formulas should be based on the...
erform: Instructions Prepare Jackson Corporation's balance sheet at December 31, 2018, complete with its proper heading. a. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values to be subtracted. b. Check your spelling carefully and do not abbreviate. c. Enter amounts in millions, as provided to you in the data. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be...
Instructions Using the straight-line method of depreciation, calculate the depreciation expense, accumulated depreciation balance, and book value for each of the four years of the van's useful life. a. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values to be subtracted. (Always use cell references and formulas where appropriate to receive full credit. If you copy paste from the Instruction tab you will be marked wrong.) Total Points Total Points A B...
Instructions Complete the financial statements. a. Enter all amounts in millions. For example, an amount of $1.2 million should be entered as 1.2, not 1,200,000. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.) 1 The Financial Statements 2. Construct an income statement, statement of retained earnings, and balance sheet The partially completed financial statements (income statement, statement of retained earnings, and 4 balance sheet)...
Excel with formulas and links. Thank you very very very much. 1 Cost-Volume-Profit Analysis 2 Contribution margin, gross margin, and margin of safety. Juicy Beauty manufactures and sells a face cream to small specialty stores in the greater Los Angeles area. It presents the monthly operating income statement shown here to George Lopez, a potential investor in the business. Help Mr. Lopez understand Juicy Beauty's cost structure. The monthly operating income statement can be found on the 4Ц "INCOM ESTATE...
The Master Budget Sales and cash collections budgets Augustine Reeds, a manufacturer of saxophone, oboe, and clarinet reeds, has projected sales to be: October November December January $904,000 $964,000 $1,045,000 $936,000 Augustine's sales are: 20% cash 80% credit The company's collection history indicates that credit sales are collected as follows: 30% in the month of the sale 60% in the month after the sale 8% two months after the sale 2% are never collected Use the blue shaded areas on...
1 The Statement of Cash Flows 2 Using Excel to prepare the statement of cash flows, indirect method 4 5 The James Island Clothing Company began operations on July 1, 2018. The adjusted trial balance as of December 31, 2018, appears below, along with transaction data for 2018. JAMES ISLAND CLOTHING COMPANY Adjusted Trial Balance 12/31/18 Account Title Cash Accounts Receivable Inventory Office Equipment Truck Accumulated Depreciation-Plant Assets Accounts Payable Note Payable-Short Term Note Payable-Long Term Common Stock Retained Earnings...
Instructions For 2017 and 2018, calculate current ratio, quick (acid-test) ratio, inventory turnover and days' inventory outstanding (DIO), accounts receivable turnover, days' sales in average receivables or days' sales outstanding (DSO), accounts payable turnover, days' payable outstanding (DPO), and cash conversion cycle (in days). a. Use the cost of goods sold in the formula for accounts payable turnover. b. Use a 365-day year for calculations as needed. c. Use cell references from prior calculations, if applicable. (Always use cell references...