Profitability Analysis:Summer Peebles, Inc.’s condensed 2014 financial data.

Do the assigned problems using Summer Peebles, Inc.’s condensed 2014 financial data below:AssetsCurrent Assets $250,000.00Noncurrent Assets $1,750,000.00Total Assets $2,000,000.00Liabilities and EquityCurrent Liabilities $200,000.00Noncurrent Liabilities (8% Bonds) $675,000.00Common Stockholders’ Equity $1,125,000.00Total Liabilities and Equity $2,000,000.00Additional Information: Net income for 2014 is $157,500. Income tax rate is 50%. A

mounts for total assets and shareholders’ equity are the same for 2013 and 2014. All assets and current liabilities are considered to be operating.Required: Determine whether leverage (from long-term debt) benefits Rose’s shareholders. (Hint: Examine ROCE with and without leverage.) 

Compute the NOPAT and RNOA (use ending NOA). Demonstrate the favorable effect of leverage given the disaggregation of ROCE and your answer to part (B)

.Your submission should: Be 1-2 pages for the written portion. Include the Excel spreadsheet with computations. Clearly separate your responses so your instructor knows the problems you are answering. Follow the CSU-Global Guide to Writing and APA Requirements (Links to an external site.)Links to an external site..