Hello,

I need your help to do my homework in details and in excel with formulas. Thank you.

Case Study #2 Forever 30, Inc. is a national clothing chain providing casual wear. Below is a summary of their most recent annual report for fiscal year ended January 31, 2016. Forever 30 paid cash dividends of $.70 per common share in fiscal 2016, and an average of 86.816 million shares were outstanding during the year. The company's market price on January 31, 2016, was $17.85 per share. Compute the following ratios for fiscal 2016. You are required to recreate the entire annual report below in excel. Formulas are to be used for all calculations, totals and ratios. If you are unfamiliar with any of the ratios, you are required to research possible methods for calculating them. 1) 2) 3) 4) 5) 6) 7) 8) 9) Current ratio Total debt to equity Gross profit rate Return on sales Return on stockholders' equity Earnings per share Price earnings Dividend yield Dividend payout For the year ended January 31, 2016 Income Statement Net sales $ 3,540 Cost of sales 1,178 Gross Profit 2,362 Other expenses 1,911 Earnings before income taxes 451 Provision for income taxes 179 Net Earnings $ 272 Balance Sheet Assets Inventories Other current assets Total current assets Property and Equipment Other assets Total Assets Liabilities Current liabilities Long-Term liabilities Total Liabilities Stockholders' equity Total Liabilities and stockholders' equity 1/31/16 1/31/15 $ 372 713 1,085 1,399 364 $ 2,848 $ 333 807 1,140 1,318 110 $ 2,568 $ 450 553 1,003 1,845 $ 2,848 $ 543 406 949 1,619 $ 2,568