Question

In: Accounting

. Ledger Properties has the following financial information: Current Year Prior Year Revenues $ 48,915 $...

. Ledger Properties has the following financial information:

Current Year

Prior Year

Revenues

$

48,915

$

43,610

Administrative expenses

12,106

11,602

Interest expense

816

468

Cost of goods sold

29,715

26,309

Depreciation

1,408

1,387

Net fixed assets

32,711

31,984

Current liabilities

14,652

14,625

Common stock

15,000

14,000

Current assets

16,506

14,687

Long-term debt

12,200

?

Retained earnings

7,365

4,246

Dividends paid

290

275

What is the cash flow of the firm for the current year if the tax rate is 22 percent?

A) $1,885

B) $1,042

C) $2,297

D) $2,096

E) $2,517

Solutions

Expert Solution

Cash flow of the firm means the operating cash flows. Operating Cash Flow is cash generated from normal operations i.e. day to day operations of the firm.

Operating Cash flow = Operating Income ( Gross Income - operating expenses, which include selling, general and administrative expense (S G & A), depreciation and amortization) + Depreciation - Taxes (+/-) Change in Working Capital

Particulars Current Year ($) Prior Year ($)
Current Assets 16506 14687
(Less) Current Liabilities (14652) (14625)
Net Working Capital 1854 62

Change in Working Capital = Working Capital of Previous Year - Working Capital of Current Year

= $ 62 - $ 1854

= ($1792) i.e. Negative Working Capital

Now, Operating Income / Taxable Income = Revenues - Cost of Goods Sold - Administrative Expenses - Depreciation - Interest Expenses

= $ 48915 - $ 29715 - $ 12106 - $ 1408 - $ 816

= $ 4870

Taxes @ 22% = Taxable Income * Tax Rate = $ 4870 * 22%

= $ 1071.40

= $ 1071 (Approx.)

Net Income = Taxable Income - Tax = $ 4870 - $ 1071 = $ 3799

Now, To calculate the Operating cash flow (OCF), we want to calculate Revenues minus costs, but we don't want to include depreciation because it's not a cash outflow, and we don't want to include interest because it's a financing expense. We do want to include taxes because taxes are (unfortunately) paid in cash which will decrease our cash.

Operating Cash Flows = Net Income + Depreciation + Interest - Change In working (Since Negative)

= $ 3799 + $ 1408 + $ 816 - $ 1792

= $ 4231


Related Solutions

5) Ledger Properties has the following financial information:    Current Year Prior Year Revenues $ 48,915...
5) Ledger Properties has the following financial information:    Current Year Prior Year Revenues $ 48,915 $ 43,610 Administrative expenses 12,106    11,602 Interest expense    816 468 Cost of goods sold    29,715 26,309 Depreciation 1,408    1,387 Net fixed assets    32,711 31,984 Current liabilities    14,652    14,625 Common stock    15,000 14,000 Current assets 16,506    14,687 Long-term debt 12,200 ? Retained earnings 7,365 4,246 Dividends paid    290    275 What is the cash flow...
YYZ has the following financial information: Current Year Prior Year # Units in Beginning Inventory ?...
YYZ has the following financial information: Current Year Prior Year # Units in Beginning Inventory ?                    0   # Units Sold        570,000         580,000 # Units Manufactured (Actual)        610,000         590,000 # Units Manufactured (Budget)        640,000         600,000 Selling Price (per unit)            10.00               9.90 Variable Manufacturing Costs (per unit)              5.00               4.80 Variable Sales+Admin Costs (per unit)              1.00               1.00 Fixed Manufacturing Costs (Budget and Actual) (total)     1,600,000      1,560,000 Fixed sales+admin...
XYZhas the following financial information: Current Year Prior Year # Units in Beginning Inventory ?            ...
XYZhas the following financial information: Current Year Prior Year # Units in Beginning Inventory ?                    0   # Units Sold        570,000         580,000 # Units Manufactured (Actual)        610,000         590,000 # Units Manufactured (Budget)        640,000         600,000 Selling Price (per unit)            10.00               9.90 Variable Manufacturing Costs (per unit)              5.00               4.80 Variable Sales+Admin Costs (per unit)              1.00               1.00 Fixed Manufacturing Costs (Budget and Actual) (total)     1,600,000      1,560,000 Fixed sales+admin costs...
Given the following information: Prior Year (Budget) Prior Year (Actual) Current Year (Budget) Current Year (Actual)...
Given the following information: Prior Year (Budget) Prior Year (Actual) Current Year (Budget) Current Year (Actual) Beginning Inventory (Units) 0 0 ? ? Sales (Units) 600,000 580,000 575,000 570,000 Manufactured (Units) 600,000 590,000 640,000 610,000 Selling Price ($/unit) 9.99 9.90 9.95 10.00 Variable Manufacturing Cost ($/unit) 4.92 4.90 5.00 4.95 Total Fixed Manufacturing Costs ($) 1,584,000 1,561,000 1,625,000 1,599,531 Variable Selling Cost ($/unit) 1.00 1.01 0.99 1.00 Total Fixed SG&A Costs ($) 350,000 353,000 352,850 348,000 Other information: The manufacturer...
I need to create a balance sheet with the following information Account Current Year Prior Year...
I need to create a balance sheet with the following information Account Current Year Prior Year Cash 3,422,928 3,773,862 Balance sheet Accrued compensation and related liabilities 4,248,791 2,656,831 Balance sheet Accounts and notes receivable 52,966,361 48,883,616 Balance sheet Prepaid expenses and other current assets 13,956 33,094 Balance sheet Inventory 1,461,138 1,397,898 Balance sheet Accounts payable 2,080,892 2,657,082 Balance sheet Payable to third­party payors 400,083 321,196 Balance sheet Notes and loans payable 5,142,900 Balance sheet Other deferred credits 40,598 Balance sheet...
Given the following information: Prior Year (Budget and Actual) Current Year (Budget and Actual) Beginning Inventory...
Given the following information: Prior Year (Budget and Actual) Current Year (Budget and Actual) Beginning Inventory (Units) 0 ? Sales (Units) 600,000 575,000 Manufactured (Units) 600,000 640,000 Selling Price ($/unit) 9.90 10.00 Variable Manufacturing Cost ($/unit) 4.80 5.00 Total Fixed Manufacturing Costs ($) 1,560,000 1,600,000 Variable Selling Cost ($/unit) 1.00 1.00 Total Fixed SG&A Costs ($) 351,000 358,000 Other information: The manufacturer uses FIFO. All Variable costs are direct costs Required: Prepare an income statement for the Current Year based...
Given the following information: Prior Year (Budget and Actual) Current Year (Budget and Actual) Beginning Inventory...
Given the following information: Prior Year (Budget and Actual) Current Year (Budget and Actual) Beginning Inventory (Units) 0 ? Sales (Units) 600,000 575,000 Manufactured (Units) 600,000 640,000 Selling Price ($/unit) 9.90 10.00 Variable Manufacturing Cost ($/unit) 4.80 5.00 Total Fixed Manufacturing Costs ($) 1,560,000 1,600,000 Variable Selling Cost ($/unit) 1.00 1.00 Total Fixed SG&A Costs ($) 351,000 358,000 Other information: The manufacturer uses FIFO. All Variable costs are direct costs Required: Prepare an income statement for the Current Year based...
Mustang Motors. has the following assets, liabilities, revenues and expenses for the current year. The accounts...
Mustang Motors. has the following assets, liabilities, revenues and expenses for the current year. The accounts are listed below in alphabetical order. The company has a December 31st year end. Accounts receivable $27,000 Office equipment $59,500 Accounts payable 38,500 Office supplies 5,000 Building 45,000 Service revenue 102,000 Cash 60,000 Supplies expense 8,000 Commission expense 24,500 Utilities expense 18,500 Common stock 42,500 Wage expense 65,500 Interest payable 10,800 Deferred revenue 8,200 Land 40,000 Beginning retained earnings was $154,000 and dividends were...
Starbucks Corporation reported the following geographical segment revenues for a recent and a prior fiscal year:...
Starbucks Corporation reported the following geographical segment revenues for a recent and a prior fiscal year: Recent Year (in millions, rounded) Prior Year (in millions, rounded) Americas $9,904 $7,974 China/Asia Pacific 2,396 1,130 Channel Development* 1,731 1,546 EMEA** 1,217 1,295 Other 2,100 1,675 Total $17,348 $13,620 *Sells packaged coffee and teas globally **Europe, Middle East, and Africa a. Prepare a horizontal analysis of the segment data using the prior year as the base year. Round all percents to one decimal...
The current year and prior-year balance sheet of NCA show the following account balance: current year...
The current year and prior-year balance sheet of NCA show the following account balance: current year prior year Supplies $4000 $6500 Unearned Revenue $8400 $8000 During the current year, NCA $13300 of supplies expense and received $8700 of cash for services to be performed later. Required: Using the ledger accounts, determine NCA's supplies expense and service revenue for the current year.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT