please help me with number 4 using excel, i need the formulas on excel to show how the answers are gotten i am super stuck

3. Financial Statements (20 points) Bear Tracks, Inc. has current assets of 52,030, net fixed assets of $9,870. current liabilities of S1,640, and long term debt of S4,490. 2. Produce a balance sheet for the firm. b. What is the value of the shareholders' equity account for the firm...? c. How much is the firm's net working capital...? d. What is the firm's current ratio...? 4. DuPont System Analysis (17 points) Magatelli International 2013 2014 2015 Financial Leverage Multiplier 1.75 175 1.85 Net Profit Margin 0.059 0.058 0.049 Total Asset Turnover 2.11 2.15 2.14 Industry 2015 Financial Leverage Multiplier 167 1.69 164 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 less profitable for stockholders compared to the industry in 20157 Explain b. Is Magatelli International becoming more or less profitable for stockholders over 2013-2015? Explain your answer. c What area(s) should Magatella International seek to improve? Explain your answer. 5. Bond Valuation (20 points) a. Find the value of a bond maturing in 6 year, with a $1,000 par value, and a coupon interest rate of 10 (5% paid semi-annually) if the required return on similar risk bonds is 14% annual interest (ie, 7% paid semi-annually) b. The Salem Company bond current sells for $955, has a 125 coupon interest rate and a $1,000 par value, pays interest annually, and has 15 years to maturity. Calculate the yield to maturity of this bond Over the next 15 years, will the Salem bond increase in price, decrease in price, or stay the same. Explain your