Principles of Finance I Spreadsheet Problem 2-14 Grantham University – savvyessaywriters.net | Savvy Essay Writers
Principles of Finance I Spreadsheet Problem 2-14 Grantham University – savvyessaywriters.net | Savvy Essay Writers
Savvy Essay Writers Business & Finance Assignment Help
Spreadsheet Problem(2-14) Begin with the partial model in the file Ch02 P14 Build a Model.xls on the textbook’s Web site.a. Cumberland Industries’s 2010 sales were $455,000,000; operating costs (excluding depreciation) were equal to 85% of sales; net fixed assets were $67,000,000; depreciation amounted to 10% of net fixed assets; interest expenses were $8,550,000; the state-plus-federal corporate tax rate was 40%; and Cumberland paid 25% of its net income out in dividends. Given this information, construct Cumberland’s 2010 income statement. Also calculate total dividends and the addition to retained earnings. (Hint: Start with the partial model in the file and report all dollar figures in thousands to reduce clutter.)b. Cumberland Industries’s partial balance sheets are shown below. Cumberland issued $10,000,000 of new common stock in 2010. Using this information and the results from a part a, fill in the missing values for common stock, retained earnings, total common equity, and total liabilities and equality.Cumberland Industries: Balance Sheets as of December 31 (Thousands of Dollars)2010 2009AssetsCash $91,450 $74,625Short-term investments 11,400 15,100Accounts receivable 108,470 85,527Inventories 38,450 34,982Total current assets $249,770 $210,234Net fixed assets 67,000 42,436Total assets $316,770 $252,6702010 2009Liabilities and EquityAccounts payable $30,761 $23,109Accruals 30,405 22,656Notes payable 12,717 14,217Total current liabilities $73,883 $59,982Long-term debt 80,263 63,914Total liabilities $154,146 $123,896Common stock ? $90,000Retained earnings _____? 38,774Total common equity ? $128,774Total liabilities and equity _____? $252,670c. Construct the statement of cash flows for 2010.
Team of Professional Essay Writers
Savvyessaywriters.net is a trusted essay service that connects learners seeking assistance with top-ranked experts. Every essay writer on our team has a unique rating based on the percentage of successful orders and customer reviews. Check out our pros’ profiles to hire the most suitable one.
