Please use Apple's financial statements to perform the following financial problems. Include both the Excel sheet with the calculations as well as the table mentioned.

a) Gross Profit Margin (GPM)

b) Operating Profit Margin (OPM)

c) Net Profit Margin (NPM)

d) Return on Investment (Return on Total Assets) (ROI)

e) Operating Return on Assets (OROA)

f) Return on Equity (ROE)

g) Cash Dividends

h) Dividend Yield (DY)

i) Holding Period Return (Annual) (HPR)

j) Book Value per Share

k) Market-to-Book Ratio

l) Earnings per Share (EPS)

m) Payout Ratio

n) Price/Earnings Ratio (P/E)

Apple ine. CONDENSED CONSOLIDATED STATEMENTS OF OPERATIONS (Unaudited) (In milions, eveect number of ahares which are retiected in thousands and per share amounts) Operating expenses Operating income Other income/lexpensel, net Income before provision for inceme tawes Provision for income taxes Net income Earnings per share: Basic Diluted Shares used in computing eartings per share: BasicDiluted16,762,96516,262,20316,629,37116,781,73516,277,82416,394,93716,772,65616,941,527 whet sales by reportable segment it Net sales by category: Apple Inc. CONOENSED CONSOUDATED BALANCE SHEETS (Unaudited) (In milions, eucept number of shares which are refected in thousands and par value) Non-current assets: LABILITES AND SHAREHOLDERS' EQUITY: Current liabilities: Non-eurrent labilities: Commitrments and contingencies Shareholders' equity: Common stoek and additional paid-in capital, 50.00001 par value: 50,400,000 shares authorized 16,095,378 and 16,426,786 shares issued and outstanding, respectively Retaned earnings Accumulated other comprehensive income/(loss) Total shareholders' equity Total liabilities and shareholders' equity Apple Inc. CONDENSED CONSOLIDATED STATEMENTS OF CASH FLOWS (Unaudited) tin millions