Question

In: Finance

What is the firm's total change in cash from the prior year to the current year?...

What is the firm's total change in cash from the prior year to the current year?
Accounts payable 3,194.00 5,965.00
Accounts receivable 6,995.00 9,057.00
Accruals 5,777.00 6,028.00
Additional paid in capital 19,562.00 13,579.00
Cash ??? ???
Common Stock 2,850 2,850
COGS 22,838.00 18,682.00
Current portion long-term debt 500 500
Depreciation expense 952.00 1,006.00
Interest expense 1,287.00 1,145.00
Inventories 3,096.00 6,734.00
Long-term debt 16,588.00 22,141.00
Net fixed assets 75,663.00 74,153.00
Notes payable 4,057.00 6,584.00
Operating expenses (excl. depr.) 19,950 20,000
Retained earnings 35,246.00 34,445.00
Sales 46,360 45,871.00
Taxes 350 920

Solutions

Expert Solution

Cash = Total assets - Net fixed assets - Accounts Receivable - Inventories

Where Total assets = Total liabilities + Total equity = Accounts payable + Accruals + Current portion of long-term debt + Notes payable + Long-term debt + Common stock + retained earning + additional paid in capital

So for current years,

=> Total assets = 5965 + 6028 + 500 + 6584 + 22141 + 2850 + 34445 + 13579 = 92092

=> Cash = 92092 - 74153 - 9057 - 6734 = 2148

For prior year,

Total assets = 3194 + 5777 + 500 + 4057 + 16588 + 2850 + 35246 + 19562 = 87774

=> Cash = 87774 - 75663 - 6995 - 3096 = 2020

total change in cash the prior year to current year = 2148 - 2020 = 128


Related Solutions

What is the firm's total change in cash from the prior year to the current year?
CategoryPrior YearCurrent YearAccounts payable3,136.005,912.00Accounts receivable6,865.008,909.00Accruals5,736.006,053.00Additional paid in capital20,381.0013,763.00Cash??????Common Stock2,8502,850COGS22,644.0018,617.00Current portion long-term debt500500Depreciation expense964.001,040.00Interest expense1,294.001,127.00Inventories3,079.006,686.00Long-term debt16,952.0022,082.00Net fixed assets75,263.0074,206.00Notes payable4,068.006,510.00Operating expenses (excl. depr.)19,95020,000Retained earnings35,375.0034,409.00Sales46,36045,043.00Taxes350920What is the firm's total change in cash from the prior year to the current year?Answer format: Number: Round to: 0 decimal places
What is the firm's current year gross profit margin?
Category Prior Year Current YearAccounts payable ??? ???Accounts receivable 320,715 397,400Accruals 40,500 33,750Additional paid in capital 500,000 541,650Cash 17,500 47,500Common Stock 94,000 105,000COGS 328,500 428,048.00Current portion long-term debt 33,750 35,000Depreciation expense 54,000 54,731.00Interest expense 40,500 41,017.00Inventories 279,000 288,000Long-term debt 339,670.00 401,877.00Net fixed assets 946,535 999,000Notes payable 148,500 162,000Operating expenses (excl. depr.) 126,000 161,905.00Retained earnings 306,000 342,000Sales 639,000 850,323.00Taxes 24,750 48,686.00What is the firm's current year gross profit margin?
What is the firm's current year net profit margin?
Category Prior Year Current YearAccounts payable ??? ???Accounts receivable 320,715 397,400Accruals 40,500 33,750Additional paid in capital 500,000 541,650Cash 17,500 47,500Common Stock 94,000 105,000COGS 328,500 428,048.00Current portion long-term debt 33,750 35,000Depreciation expense 54,000 54,731.00Interest expense 40,500 41,017.00Inventories 279,000 288,000Long-term debt 339,670.00 401,877.00Net fixed assets 946,535 999,000Notes payable 148,500 162,000Operating expenses (excl. depr.) 126,000 161,905.00Retained earnings 306,000 342,000Sales 639,000 850,323.00Taxes 24,750 48,686.00What is the firm's current year net profit margin?
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...
Determine the total cash inflows, the total cash outflows, and the expected change in cash for...
Determine the total cash inflows, the total cash outflows, and the expected change in cash for each month from January to July, 2019. Show your work in excel using excel functions. Based the findings, explain in your own words whether the company should borrow/invest and how much and in which months. The management estimates total sales for the period January, 2019 through June 2019 based on actual sales from the immediate past six months. The following assumptions are made: The...
What is a firm's total asset turnover
What is a firm's total asset turnover, If its fixed assets are 120,000 current assets are 30,000 current liabilities are 44,000 sales were 200,000 and net income was 75,000.
FORTEN COMPANY Comparative Balance Sheets December 31 Current Year Prior Year Assets Cash $ 78,400 $...
FORTEN COMPANY Comparative Balance Sheets December 31 Current Year Prior Year Assets Cash $ 78,400 $ 92,500 Accounts receivable 94,460 69,625 Inventory 304,156 270,800 Prepaid expenses 1,400 2,275 Total current assets 478,416 435,200 Equipment 138,500 127,000 Accum. depreciation—Equipment (46,125 ) (55,500 ) Total assets $ 570,791 $ 506,700 Liabilities and Equity Accounts payable $ 72,141 $ 143,175 Short-term notes payable 15,700 9,800 Total current liabilities 87,841 152,975 Long-term notes payable 55,500 67,750 Total liabilities 143,341 220,725 Equity Common stock, $5...
1)      Analytical review of current financials against prior year 2016 2015 % Change $’000 $’000 INCOME...
1)      Analytical review of current financials against prior year 2016 2015 % Change $’000 $’000 INCOME / (EXPENSES) Premiums 5,771,000 5,858,000 ? Operating Expenses (2,323,000) (2,397,000) ? Claims Expenses (3,710,000) (3,843,000) ? Payroll Costs (880,000) (680,000) ? Investment Income 856,000 851,000 ? Net Income 2,088,000 940,000 ? ASSETS/ (LIABILITIES) Fixed Assets 941,000 1,064,000 ? Investments 11,383.000 10,577,000 ? Outstanding Claim Settlement (8,483,000) (8,795,000) ? Shareholders’ Equity (6,088,000) (4,993,000) ? RATIOS Net Margin ? ? ? Return on Investment ? ?...
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.
Below is information extracted from General Electric’s 10k current year prior year Raw materials and work...
Below is information extracted from General Electric’s 10k current year prior year Raw materials and work in process 5603 5515 finished goods 2863    2546 Unbilled shipments 246 280 ---------------------------------- 8712 8341 Less LIFO reserves    (2,226) (2,076) --------------------------------- LIFO value of inventories 6486 6265    requirements: Compute the increase or decrease in the pretax operating profit (loss) that would have been reported for the current year had GE employed FIFO accounting for both years. Indicate whether it was an...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT