Struggling a little with finance - specifically where i find the information/how do I calculate the value & weight of each type of capital) and how to set up the CAPM, Dividend Growth & Premium Over Bond models -- I don't need anyone to run the models -- just show me how to answer #1 find the information for the company Ruger (10-K attached) and set up the models for #2.

So I need #1 answered and explained where the information is found (in a text box on the excel would be fine) and the models set up for #2.

***I attached an excel already --

--------------------------------

Here are the questions:

(1.) Use the most recent financial statements and current market data to figure out the company's capital structure. Calculate value and weight of each type of capital (Wd, Wp, Ws).

(- Market data is available in various financial sites such as Bloomberg or Yahoo Finance! Morningstar is a good resource to pull market data for corporate bonds. You can access to Morningstar via Penrose library. If you cannot find the market information or the security is not publicly traded, use book value to calculate weights.)

(2.) Use the appropriate model to estimate the cost of each capital (rd, rp, rs). - To estimate the cost of equity, use all THREE methods (CAPM, Dividend growth and Premium over bond), take the average of three. Assume that market risk premium is 6% and the premium over bond is 5%.

(3.) Estimate the company?s cost of capital (WACC).

--------------------------------

The Ruger 10-K is here and I input the balance sheet/income statement information already into the spreadsheet:http://www.ruger.com/corporate/PDF/10K-2014.pdf

And here is the Yahoo Finance info for Ruger:http://finance.yahoo.com/q?s=RGR

1) Calculate value & weight of each type of capital = weight of debt _ _= weight of preferred stocks _ = weight of common stocks wd+wp+ ws= 1 2) Use appropriate model to estimate cost of each capital ---- to estimate cost of equity, use all three methods (CAPM, Dividend Growth & Premium over Bond) _= cost of _ debt cost of preferred stocks _= _ _= cost of common stocks _ 3) Estimate the company's cost of capital (WACC) WACC = wdrd(1 - T) + wprp + wsrs market risk premium = 6% premium over bond = 5% Ruger Income Statement For the Years Ended December 31, (In thousands, except par share data) 2014 Net firearms sales Net castings sales Total net sales Cost of products sold Gross profit Operating Expenses: Selling General and administrative Defined benefit pension plans settlement charge Other operating (expenses), net Total operating expenses Operating income Other income: Royalty income Interest income Interest expense Total other income, net Income before income taxes Income taxes Net income Other comprehensive income (loss), net of tax: Defined benefit pension plans Comprehensive income Basic Earnings Per Share Fully Diluted Earnings Per Share Cash Dividends Per Share 2013 2012 $ 542,267 2,207 544,474 375,300 169,174 $ 678,552 9,724 688,276 429,671 258,605 $ 484,933 6,891 491,824 312,871 178,953 44,550 28,899 40,999 -1,612 ) 112,836 56,338 38,363 29,231 293 67,887 111,066 468 2 (152 ) 902 57,240 18,612 38,628 $ $ $ $ 48,706 35,394 (401 ) 83,699 174,906 658 4 (135 ) 326 175,232 63,960 111,272 824 34 (95 ) 1,043 112,109 41,480 70,629 38,628 1.99 1.95 1.62 10,240 121,512 5.76 5.58 2.12 (2,077 ) 68,552 3.69 3.6 5.8 $ $ $ $ $ $ $ $ Ruger Income Statement For the Years Ended April 30, (In thousands, except par share data) 2013 Net firearms sales Net castings sales Total net sales Cost of products sold Gross profit Operating Expenses: Selling General and administrative Other operating (income) expenses, net Total operating expenses Operating income Other income: Royalty income Interest income Interest expense Other (expense) income, net Total other income, net Income before income taxes Income taxes Net income Other comprehensive income (loss), net of tax: Defined benefit pension plans Comprehensive income Basic Earnings Per Share Fully Diluted Earnings Per Share Cash Dividends Per Share 2012 2011 $ 678,552 9,724 688,276 429,671 258,605 $ 484,933 6,891 491,824 312,871 178,953 $ 324,200 4,616 328,816 217,058 111,758 48,706 35,394 (401 ) 83,699 174,906 28,691 20,970 (319 ) 49,342 62,416 658 4 (135 ) (201 ) 326 175,232 63,960 111,272 $ $ $ $ 38,363 29,231 293 67,887 111,066 824 34 (95 ) 280 1,043 112,109 41,480 70,629 873 29 (110 ) 308 1,100 63,516 23,501 40,015 10,240 121,512 5.76 5.58 2.12 (2,077 ) 68,552 3.69 3.6 5.8 (7,895 ) 32,120 2.12 2.09 0.43 $ $ $ $ $ $ $ $ Ruger Balance Sheet As of December 31, 2014 2013 (In thousands, except par value and share data) ASSETS Current Assets Cash and cash equivalents Trade receivables, net Gross inventories Less LIFO reserve Less excess and obsolescence reserve Net inventories Deferred income taxes Prepaid expenses and other current assets Total Current Assets Property, Plant, and Equipment Less allowances for depreciation Net property, plant and equipment Other assets Total Assets $ 8,901 49,735 89,017 (40,578 ) (3,750 ) 44,689 7,246 7,603 118,174 288,236 (177,575 ) 110,661 25,547 $ 254,382 $ 55,064 67,384 64,199 (38,516 ) (2,422 ) 23,261 7,637 4,280 157,626 250,127 (149,099 ) 101,028 18,464 $ 277,118 LIABILITIES & STOCKHOLDERS' EQUITY Current Liabilities Trade accounts payable and accrued expenses Product liability Employee compensation and benefits Workers' compensation Income taxes payable Total Current Liabilities Product liability Deferred income taxes Contingent liabilities (Note 16) Stockholders' Equity Common stock, non-voting, par value $1: Authorized shares - 50,000; none issued Common stock, par value $1: Authorized shares - 40,000,000 2014 - 23,717,321 issued, 18,737,074 outstanding 2013 - 23,647,350 issued, 19,347,916 outstanding Additional paid-in capital Retained earnings Less: Treasury stock - at cost 2014 - 5,054,747 shares 2013 - 4,299,434 shares Accumulated other comprehensive loss Total Stockholders' Equity Total Liabilities and Stockholders' Equity $ 36,150 641 18,302 5,133 156 60,382 204 8,334 $ 46,991 971 34,626 5,339 239 88,166 265 9,601 23,717 25,472 198,159 20,614 192,088 (61,886 ) $ 23,647 (37,884 ) 185,462 254,382 (19,379 ) 179,086 277,118 $ Ruger Balance Sheet As of December 31, 2013 2012 (In thousands, except par value and share data) ASSETS Current Assets Cash and cash equivalents Trade receivables, net Gross inventories Less LIFO reserve Less excess and obsolescence reserve Net inventories Deferred income taxes Prepaid expenses and other current assets Total Current Assets Property, Plant, and Equipment Less allowances for depreciation Net property, plant and equipment Deferred income taxes Other assets Total Assets $ 55,064 67,384 64,199 (38,516 ) (2,422 ) 23,261 7,637 4,280 157,626 250,127 (149,099 ) 101,028 18,464 $ 277,118 $ 30,978 43,018 55,827 (38,089 ) (1,729 ) 16,009 5,284 1,632 96,921 195,713 (129,720 ) 65,993 2,004 9,568 $ 174,486 LIABILITIES & STOCKHOLDERS' EQUITY Current Liabilities Trade accounts payable and accrued expenses Product liability Employee compensation and benefits Workers' compensation Income taxes payable Total Current Liabilities Accrued pension liability Product liability Deferred income taxes Contingent liabilities (Note 16) Stockholders' Equity Common stock, non-voting, par value $1: Authorized shares - 50,000; none issued Common stock, par value $1: Authorized shares - 40,000,000 2013 - 23,647,350 issued, 19,347,916 outstanding 2012 - 23,562,422 issued, 19,262,988 outstanding Additional paid-in capital Retained earnings Less: Treasury stock - at cost 2013 and 2012 - 4,299,434 shares Accumulated other comprehensive loss Total Stockholders' Equity Total Liabilities and Stockholders' Equity $ 46,991 971 34,626 5,339 239 88,166 265 9,601 - $ 38,500 720 15,182 4,600 489 59,491 19,626 337 - 23,647 20,614 192,088 (37,884 ) $ 23,563 15,531 123,442 (37,884 ) (19,379 ) 179,086 277,118 (29,620 ) 95,032 174,486 $