Need someone to assist me with the following regarding creating scenarios in Excel.

\fGranite City Books Financing Options for Expansion As of December 31, 2016 (000's omitted) 2015 Summary Balance Sheet Total assets Current liabilities Long-term liabilities Total liabilities Common stock Preferred stock Retained earnings Total stockholders' equity Total liabilities & stockholders' equity Ratio Analysis Debt-to-equity ratio Long-term-debt to equity ratio Debt-to-common-equity ratio Long-term-debt to common equity Preferred stock ratio Common-to-preferred equity Changes 2016 % Change $ 2,225 $ 2,500 $ 4,725 112.36% $ 278 $ 550 828 1,000 397 1,397 2,225 $ (27) $ 2,500 2,473 27 27 2,500 $ 251 3,050 3,301 1,000 424 1,424 4,725 -9.71% 454.55% 298.67% 0.00% 0.00% 6.80% 1.93% 112.36% $ 59.27% 39.37% 82.80% 55.00% 0.00% 0.00% 231.81% 214.19% 330.10% 305.00% 0.00% 0.00%