Financial statements, cash flow, and taxes: spreadsheet problems


all of your answers are numeric. you must use simply cell references or formulas for answers.

Financial Statements, Cash Flow, and Taxes: Spreadsheet Problems

(2-14) Build a Model: Free Currency Flows, EVA, and MVA
Begin after a while the peculiar standard in the polish Ch02 P14 Build a Model.xls on the textbook's Web condition.

Financial Statements, Currency Flow, and Taxes: Spreadsheet Problems

a. Cumberland Industries's 2010 sales were $455,000,000; easy costs (notwithstanding diminution) were similar to 85% of sales; net agricultural possessions were $67,000,000; diminution amounted to 10% of net agricultural possessions; attention charges were $8,550,000; the state-plus-federal municipal tax rebuke was 40%; and Cumberland paid 25% of its net allowance out in dividends. Given this counsel, compose Cumberland's 2010 allowance assertion. To-boot rate entirety dividends and the conjunction to retained rights. ( Hint: Start after a while the peculiar standard in the polish and narration all dollar figures in thousands to weaken clutter.)

b. Cumberland Industries's peculiar counterpoise sheets are shown beneath. Cumberland issued $10,000,000 of new niggardly fund in 2010. Using this counsel and the results from dissect a, rise in the missing values for niggardly fund, retained rights, entirety niggardly equity, and entirety liabilities and equity.

Cumberland Industries: Counterpoise Sheets as of December 31 (Thousands of Dollars)
2010 2009

Assets
Cash $ 91,450 $ 74,625
Short-term investments 11,400 15,100
Accounts receivable 108,470 85,527
Inventories 38,450 34,982
Total present possessions $249,770 $210,234
Net agricultural possessions 67,000 42,436
Total possessions $316,770 $252,670
Liabilities and Equity
Accounts payable $ 30,761 $ 23,109
Accruals 30,405 22,656
Notes payable 12,717 14,217
Total present liabilities $ 73,883 $ 59,982
Long-term debit 80,263 63,914
Total liabilities $154,146 $123,896
Common fund ? $ 90,000
Retained rights ? 38,774
Total niggardly equity ? $128,774
Total liabilities and equity ? $252,670

Cumberland Industries: Counterpoise Sheets as of December 31 (Thousands of Dollars) View PDF

Back to Top P. 81

Cumberland Industries: Counterpoise Sheets as of December 31 (Thousands of Dollars) (continued) View PDF

c. Compose the assertion of currency flows for 2010.

Analysis of Financial Statements: Spreadsheet Problem

(3–15) Build a Model: Ratio Analysis
Start after a while the peculiar standard in the polish Ch03 P15 Build a Model.xls from the textbook's Web condition. Joshua & White (J&W) Technologies's financial assertions are to-boot shown beneath. Answer the subjoined questions. (Note: Industry medium ratios are supposing in Ch03 P15 Build a Model.xls.)

Analysis of Financial Statements: Spreadsheet Problem

a. Has J&W's liquidity position improved or worsened? Explain.

b. Has J&W's power to husband its possessions improved or worsened? Explain.

c. How has J&W's profitpower modifiable during the terminal year? d. Perform an strong Du Pont resolution for J&W for 2009 and 2010. What do these results betray you?

e. Perform a niggardly largeness resolution. What has happened to the combination (that is, percentage in each predicament) of possessions and liabilities?

f. Perform a percentage substitute resolution. What does this betray you about the substitute in profitpower and asset utilization?

Joshua & White Technologies: December 31 Counterpoise Sheets (Thousands of Dollars)
Assets 2010 2009 Liabilities &Equity 2010 2009

Cash and currency equivalents $ 21,000 $ 20,000 Accounts payable $ 33,600 $ 32,000
Short-term investments 3,759 3,240 Accruals 12,600 12,000
Accounts receivable 52,500 48,000 Notes payable 19,929 6,480

Inventories 84,000 56,000 Entirety present liabilities $ 66,129 $ 50,480

Total present possessions $161,259 $127,240 Long-term debit 67,662 58,320

Net agricultural possessions 218,400 200,000 Entirety liabilities $133,791 $108,800

Total possessions $379,659 $327,240 Niggardly fund 183,793 178,440

Retained rights 62,075 40,000

Total niggardly equity $245,868 $218,440

Total liabilities & equity $379,659 $327,240

Joshua & White Technologies: December 31 Counterpoise Sheets (Thousands of Dollars) View PDF

Joshua & White Technologies December 31 Allowance Statements (Thousands of Dollars)
2010 2009

Sales $420,000 $400,000
Expenses notwithstanding depr. & amort. 327,600 320,000

EBITDA $ 92,400 $ 80,000
Depreciation and amortization 19,660 18,000

EBIT $ 72,740 $ 62,000
Interest charge 5,740 4,460
EBT $ 67,000 $ 57,540
Taxes (40%) 26,800 23,016
Net allowance $ 40,200 $ 34,524
Common dividends $ 18,125 $ 17,262

Joshua & White Technologies December 31 Allowance Statements (Thousands of Dollars) View PDF

Back to Top P. 116