Interested in a PLAGIARISM-FREE paper based on these particular instructions?...with 100% confidentiality?

Order Now

Hi there! Hope all is well. Can you check my work please. You can skip #1 and assume that it is correct along with the yield to maturity rate you will see. If I need to separate this question let me know. Period Ending: 02/02/2014 03/02/2013 29/01/2012 30/01/2011 Total Revenue $78,812,000 $74,754,000 $70,395,000 $67,997,000 Cost of Revenue $51,422,000 $48,912,000 $46,133,000 $44,693,000 Gross Profit $27,390,000 $25,842,000 $24,262,000 $23,304,000 Operating Expenses Research and Development $0 $0 $0 $0 Sales, General and Admin. $16,597,000 $16,508,000 $16,028,000 $15,849,000 Non-Recurring Items $0 $0 $0 $0 Other Operating Items $1,627,000 $1,568,000 $1,573,000 $1,616,000 Operating Income $9,166,000 $7,766,000 $6,661,000 $5,839,000 Add’l income/expense items $12,000 $87,000 $13,000 ($36,000) Earnings Before Interest and Tax $9,178,000 $7,853,000 $6,674,000 $5,803,000 Interest Expense $711,000 $632,000 $606,000 $530,000 Earnings Before Tax $8,467,000 $7,221,000 $6,068,000 $5,273,000 Income Tax $3,082,000 $2,686,000 $2,185,000 $1,935,000 Minority Interest $0 $0 $0 $0 Equity Earnings/Loss Unconsolidated Subsidiary $0 $0 $0 $0 Net Income-Cont. Operations $5,385,000 $4,535,000 $3,883,000 $3,338,000 Net Income $5,385,000 $4,535,000 $3,883,000 $3,338,000 Net Income Applicable to Common Shareholders $5,385,000 $4,535,000 $3,883,000 $3,338,000 Period Ending: 02/02/2014 03/02/2013 29/01/2012 30/01/2011 Current Assets Cash and Cash Equivalents $1,929,000 $2,494,000 $1,987,000 $545,000 Short-Term Investments $0 $0 $0 $0 Net Receivables $1,398,000 $1,395,000 $1,245,000 $1,085,000 Inventory $11,057,000 $10,710,000 $10,325,000 $10,625,000 Other Current Assets $895,000 $773,000 $963,000 $1,224,000 Total Current Assets $15,279,000 $15,372,000 $14,520,000 $13,479,000 Long-Term Assets Long-Term Investments $0 $0 $135,000 $139,000 Fixed Assets $23,348,000 $24,069,000 $24,448,000 $25,060,000 Goodwill $1,289,000 $1,170,000 $1,120,000 $1,187,000 Intangible Assets $0 $0 $0 $0 Other Assets $602,000 $473,000 $295,000 $260,000 Deferred Asset Charges $0 $0 $0 $0 Total Assets $40,518,000 $41,084,000 $40,518,000 $40,125,000 Current Liabilities Accounts Payable $9,379,000 $8,871,000 $8,199,000 $7,903,000 Short-Term Debt / Current Portion of Long-Term Debt $33,000 $1,321,000 $30,000 $1,042,000 Other Current Liabilities $1,337,000 $1,270,000 $1,147,000 $1,177,000 Total Current Liabilities $10,749,000 $11,462,000 $9,376,000 $10,122,000 Long-Term Debt $14,691,000 $9,475,000 $10,758,000 $8,707,000 Other Liabilities $2,042,000 $2,051,000 $2,146,000 $2,135,000 Deferred Liability Charges $514,000 $319,000 $340,000 $272,000 Misc. Stocks $0 $0 $0 $0 Minority Interest $0 $0 $0 $0 Total Liabilities $27,996,000 $23,307,000 $22,620,000 $21,236,000 Stock Holders Equity Common Stocks $88,000 $88,000 $87,000 $86,000 Capital Surplus $8,402,000 $7,948,000 $6,966,000 $6,556,000 Retained Earnings $23,180,000 $20,038,000 $17,246,000 $14,995,000 Treasury Stock ($19,194,000) ($10,694,000) ($6,694,000) ($3,193,000) Other Equity $46,000 $397,000 $293,000 $445,000 Total Equity $12,522,000 $17,777,000 $17,898,000 $18,889,000 Total Liabilities & Equity $40,518,000 $41,084,000 $40,518,000 $40,125,000 Don’t worry about #1 Let’s assume I did it correctly Please look at these on the next sheet Market Price with Shortest Maturity 108.68 Short-term Debt/Current Portion of Long Term Debt $3,300,000 Long-term Debt $1,469,100,000 Cash $192,900,000 Book Value of Debt $1,279,500,000 Market Value of Debt $139,056,060,000 Number of Shares Outstanding 1,368,097,000 Current Stock Price $79.52 *Delayed – data as of Apr. 29, 2014 Market Value of Equity $108,791,073,440.00 Market Debt to Equity Ratio 1.278193657 cost of levered equity 12% D/E ratio 1.28 yield to maturity 0.623% Cost of Capital of Levered Equity 0.265420092 Market Value of Debt $139,056,060,000 Market Value of Equity $108,791,073,440.00 Total Capital Structure $247,847,133,440.00 Debt Percentage 56.11% Equity percentage 43.89% Cost of levered equity 26.54% yield to maturity 0.623% WACC 12.00% Market Value of Debt $139,056,060,000 Market Value of Debt $139,056,060,000 Add 1,000,000,000 Subtract 1,000,000,000 New Market Value of Debt $140,056,060,000 New Market Value of Debt $138,056,060,000 Market Value of Equity $108,791,073,440.00 Market Value of Equity $108,791,073,440.00 Subtract 1,000,000,000 Add 1,000,000,000 New Market Value of Equity $107,791,073,440.00 New Market Value of Equity $109,791,073,440.00 New DE Ratio 1.299328929 New DE Ratio 1.257443394 Cost of Levered Equity Cost of Levered Equity cost of levered equity 12% cost of levered equity 12% D/E ratio 1.30 D/E ratio 1.26 yield to maturity 0.623% yield to maturity 0.623% New Cost of Capital of Levered Equity 0.267901 New Cost of Capital of Levered Equity 0.2633502 WACC WACC New Market Value of Debt $140,056,060,000 New Market Value of Debt $138,056,060,000 New Market Value of Equity $107,791,073,440.00 New Market Value of Equity $109,791,073,440.00 Total Capital Structure $247,847,133,440.00 Total Capital Structure $247,847,133,440.00 Debt Percentage 56.51% Debt Percentage 55.70% Equity percentage 43.49% Equity percentage 44.30% Cost of levered equity 26.79% Cost of levered equity 26.33% yield to maturity 0.623% yield to maturity 0.623% New WACC 12.00% New WACC 12.01%

Hi there! Hope all is well. Can you check my work please. You can skip #1 and assume that it is correct along with the yield to maturity rate you will see. If I need to separate this question let me know.

Period Ending:	02/02/2014	03/02/2013	29/01/2012	30/01/2011
Total Revenue	$78,812,000 	$74,754,000 	$70,395,000 	$67,997,000 
				
				
Cost of Revenue	$51,422,000 	$48,912,000 	$46,133,000 	$44,693,000 
				
				
Gross Profit	$27,390,000 	$25,842,000 	$24,262,000 	$23,304,000 
				
				
Operating Expenses				
Research and Development	$0 	$0 	$0 	$0 
				
Sales, General and Admin.	$16,597,000 	$16,508,000 	$16,028,000 	$15,849,000 
				
				
Non-Recurring Items	$0 	$0 	$0 	$0 
				
Other Operating Items	$1,627,000 	$1,568,000 	$1,573,000 	$1,616,000 
				
				
Operating Income	$9,166,000 	$7,766,000 	$6,661,000 	$5,839,000 
				
				
Add'l income/expense items	$12,000 	$87,000 	$13,000 	($36,000)
				
				
Earnings Before Interest and Tax	$9,178,000 	$7,853,000 	$6,674,000 	$5,803,000 
				
				
Interest Expense	$711,000 	$632,000 	$606,000 	$530,000 
				
				
Earnings Before Tax	$8,467,000 	$7,221,000 	$6,068,000 	$5,273,000 
				
				
Income Tax	$3,082,000 	$2,686,000 	$2,185,000 	$1,935,000 
				
				
Minority Interest	$0 	$0 	$0 	$0 
				
Equity Earnings/Loss Unconsolidated Subsidiary	$0 	$0 	$0 	$0 
				
Net Income-Cont. Operations	$5,385,000 	$4,535,000 	$3,883,000 	$3,338,000 
				
				
Net Income	$5,385,000 	$4,535,000 	$3,883,000 	$3,338,000 
				
				
Net Income Applicable to Common Shareholders	$5,385,000 	$4,535,000 	$3,883,000 	$3,338,000 

Period Ending:	02/02/2014	03/02/2013	29/01/2012	30/01/2011
Current Assets				
Cash and Cash Equivalents	$1,929,000 	$2,494,000 	$1,987,000 	$545,000 
				
				
Short-Term Investments	$0 	$0 	$0 	$0 
				
Net Receivables	$1,398,000 	$1,395,000 	$1,245,000 	$1,085,000 
				
				
Inventory	$11,057,000 	$10,710,000 	$10,325,000 	$10,625,000 
				
				
Other Current Assets	$895,000 	$773,000 	$963,000 	$1,224,000 
				
				
Total Current Assets	$15,279,000 	$15,372,000 	$14,520,000 	$13,479,000 
				
				
Long-Term Assets				
Long-Term Investments	$0 	$0 	$135,000 	$139,000 
				
Fixed Assets	$23,348,000 	$24,069,000 	$24,448,000 	$25,060,000 
				
				
Goodwill	$1,289,000 	$1,170,000 	$1,120,000 	$1,187,000 
				
				
Intangible Assets	$0 	$0 	$0 	$0 
				
Other Assets	$602,000 	$473,000 	$295,000 	$260,000 
				
				
Deferred Asset Charges	$0 	$0 	$0 	$0 
				
Total Assets	$40,518,000 	$41,084,000 	$40,518,000 	$40,125,000 
				
Current Liabilities				
Accounts Payable	$9,379,000 	$8,871,000 	$8,199,000 	$7,903,000 
				
				
Short-Term Debt / Current Portion of Long-Term Debt	$33,000 	$1,321,000 	$30,000 	$1,042,000 
				
				
Other Current Liabilities	$1,337,000 	$1,270,000 	$1,147,000 	$1,177,000 
				
				
Total Current Liabilities	$10,749,000 	$11,462,000 	$9,376,000 	$10,122,000 
				
				
Long-Term Debt	$14,691,000 	$9,475,000 	$10,758,000 	$8,707,000 
				
				
Other Liabilities	$2,042,000 	$2,051,000 	$2,146,000 	$2,135,000 
				
				
Deferred Liability Charges	$514,000 	$319,000 	$340,000 	$272,000 
				
				
Misc. Stocks	$0 	$0 	$0 	$0 
				
Minority Interest	$0 	$0 	$0 	$0 
				
Total Liabilities	$27,996,000 	$23,307,000 	$22,620,000 	$21,236,000 
				
				
Stock Holders Equity				
Common Stocks	$88,000 	$88,000 	$87,000 	$86,000 
				
Capital Surplus	$8,402,000 	$7,948,000 	$6,966,000 	$6,556,000 
				
				
Retained Earnings	$23,180,000 	$20,038,000 	$17,246,000 	$14,995,000 
				
				
Treasury Stock	($19,194,000)	($10,694,000)	($6,694,000)	($3,193,000)
				
Other Equity	$46,000 	$397,000 	$293,000 	$445,000 
				
				
Total Equity	$12,522,000 	$17,777,000 	$17,898,000 	$18,889,000 
				
				
Total Liabilities & Equity	$40,518,000 	$41,084,000 	$40,518,000 	$40,125,000 


														
														
														
														
														
														
														
														
														
														
														
														
														
														
														
														
														
														
														
														Don't worry about #1
														Let's assume I did it
														correctly
														
														
														
														
														
														
														
														
														
														
														
														
														
														
														
														Please look at these on
														the next sheet
													
													
													
													
													
													
													
													
Market Price with Shortest Maturity					108.68								
Short-term Debt/Current Portion of Long Term Debt					$3,300,000 								
Long-term Debt					$1,469,100,000 								
Cash					$192,900,000 								
Book Value of Debt					$1,279,500,000 								
Market Value of Debt					$139,056,060,000 								
Number of Shares Outstanding					1,368,097,000								
Current Stock Price					$79.52 	*Delayed - data as of Apr. 29, 2014							
Market Value of Equity					$108,791,073,440.00 								
Market Debt to Equity Ratio					1.278193657								
													
													
													
													
													
													
													
													
													
cost of levered equity 			12%										
D/E ratio 			1.28										
yield to maturity 			0.623%										
Cost of Capital of Levered Equity			0.265420092										
													
													
													
													
													
													
													
													
													
													
Market Value of Debt					$139,056,060,000 								
Market Value of Equity					$108,791,073,440.00 								
Total Capital Structure					$247,847,133,440.00 								
Debt Percentage					56.11%								
Equity percentage 					43.89%								
Cost of levered equity 					26.54%								
 yield to maturity					0.623%								
WACC					12.00%								
													
													
													
													
													
													
													
													
													
Market Value of Debt					$139,056,060,000 			Market Value of Debt					$139,056,060,000 
Add					1,000,000,000			Subtract					1,000,000,000
New Market Value of Debt					$140,056,060,000 			New Market Value of Debt					$138,056,060,000 
Market Value of Equity					$108,791,073,440.00 			Market Value of Equity					$108,791,073,440.00 
Subtract					1,000,000,000			Add					1,000,000,000
New Market Value of Equity					$107,791,073,440.00 			New Market Value of Equity					$109,791,073,440.00 
New DE Ratio					1.299328929			New DE Ratio					1.257443394
													
Cost of Levered Equity								Cost of Levered Equity					
cost of levered equity 					12%			cost of levered equity 					12%
D/E ratio 					1.30			D/E ratio 					1.26
yield to maturity 					0.623%			yield to maturity 					0.623%
New Cost of Capital of Levered Equity					0.267901			New Cost of Capital of Levered Equity					0.2633502
													
WACC								WACC					
New Market Value of Debt					$140,056,060,000 			New Market Value of Debt					$138,056,060,000 
New Market Value of Equity					$107,791,073,440.00 			New Market Value of Equity					$109,791,073,440.00 
Total Capital Structure					$247,847,133,440.00 			Total Capital Structure					$247,847,133,440.00 
Debt Percentage					56.51%			Debt Percentage					55.70%
Equity percentage 					43.49%			Equity percentage 					44.30%
Cost of levered equity 					26.79%			Cost of levered equity 					26.33%
 yield to maturity					0.623%			 yield to maturity					0.623%
New WACC					12.00%			New WACC					12.01%

Interested in a PLAGIARISM-FREE paper based on these particular instructions?...with 100% confidentiality?

Order Now