please i need help with 3 and 4! i need formulas on how to do this on a excel document i am stuck and my homework is due in 2 hours

ncial Statements (20 points) Bear Tracks, Inc. has current assets of $2,030, net fixed assets of $9, current liabilities of $1,640, and long term debt of $4,490. -a. Produce a balance sheet for the firm. b. What is the value of the shareholders' equity account for the fir c. How much is the firm's net working capital...? d. What is the firm's current ratio.? ont System Analysis (17 points) Magatelli International 2013 2014 2015 Financial Leverage Multiplier 1.75 1.75 1.85 Net Profit Margin 0.059 0.058 0.049 Total Asset Turnover 2.11 2.18 2.14 Industry 2013 2014 2015 Financial Leverage Multiplier 1.67 1.69 1.64 Net Profit Margin 0.054 0.047 0.041 Total Asset Turnover 2.05 2.13 2.15 a. Using the DuPont Analysis, is Magatelli International more or profitable for stockholders compared to the industry in 2015? your answer. b. Is Magatelli International becoming more or less profitable for stockholders over 2013-2015? Explain your answer. c. What area(s) should Magatelli International seek to improve? your answer. nd Valuation (20 points) the value of a bond maturing in 6 year, with a $1,000 par value, ar interest rate of 10% (5% paid semi-annually) if the required retur risk bonds is 14% annual interest (ie, 7% paid semi-annually). Salem Company bond current sells for $955, has a 12% coupon intu da $1,000 par value, pays interest annually, and has 15 years to m ate the yield to maturity of this bond. ncial Statements (20 points) Bear Tracks, Inc. has current assets of $2,030, net fixed assets of $9, current liabilities of $1,640, and long term debt of $4,490. -a. Produce a balance sheet for the firm. b. What is the value of the shareholders' equity account for the fir c. How much is the firm's net working capital...? d. What is the firm's current ratio.? ont System Analysis (17 points) Magatelli International 2013 2014 2015 Financial Leverage Multiplier 1.75 1.75 1.85 Net Profit Margin 0.059 0.058 0.049 Total Asset Turnover 2.11 2.18 2.14 Industry 2013 2014 2015 Financial Leverage Multiplier 1.67 1.69 1.64 Net Profit Margin 0.054 0.047 0.041 Total Asset Turnover 2.05 2.13 2.15 a. Using the DuPont Analysis, is Magatelli International more or profitable for stockholders compared to the industry in 2015? your answer. b. Is Magatelli International becoming more or less profitable for stockholders over 2013-2015? Explain your answer. c. What area(s) should Magatelli International seek to improve? your answer. nd Valuation (20 points) the value of a bond maturing in 6 year, with a $1,000 par value, ar interest rate of 10% (5% paid semi-annually) if the required retur risk bonds is 14% annual interest (ie, 7% paid semi-annually). Salem Company bond current sells for $955, has a 12% coupon intu da $1,000 par value, pays interest annually, and has 15 years to m ate the yield to maturity of this bond