Need help understanding and completing this assignment. No instructions were given so I am not sure what the result should look like.

Review the financial statements for Lake of Egypt Marina, Inc.

Complete the following problem sets from Chapter 3 in Microsoft Excel:

• 3-29 Spreading the Financial Statements
• 3-30 Calculating Ratios

Format your assignment consistent with APA guidelines.

Page 1 of 2 PRINTED BY: johnsonerica2010@email.phoenix.edu. Printing is for personal, private use only. No part of this book may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted. 3-29 Spreading the Financial Statements Spread the balance sheets and income Page 75 statements of Lake of Egypt Marina, Inc., for 2015 and 2014. (LG3-6) 3-30 Calculating Ratios Calculate the following ratios for Lake of Egypt Marina, Inc., as of year-end 2015. (LG3-1 through LG3-5) 3-31 DuPont Analysis Construct the DuPont ROA and ROE breakdowns for Lake of Egypt Marina, Inc. (LG3-6) 3-32 Internal and Sustainable Growth Rates Calculate the internal and sustainable growth rate for Lake of Egypt Marina, Inc. (LG3-6) 3-33 Cross-Sectional Analysis Using the ratios from Problem 3-30 for Lake of Egypt Marina, Inc., and the industry, what can you conclude about Lake of Egypt Marina's financial performance for 2015? (LG3-7) ADVANCED PROBLEMS 3-34 Ratio Analysis Use the following information to complete the balance sheet below. (LG3-1 through LG3-5) Current ratio = 2.5 times Profit margin = 10% https://jigsaw.vitalsource.com/api/v0/books/1259827178/print?from=75&to=75 2/15/2016 Page 2 of 2 Sales = $1,200m https://jigsaw.vitalsource.com/api/v0/books/1259827178/print?from=75&to=75 Page 76 2/15/2016 Page 1 of 2 PRINTED BY: johnsonerica2010@email.phoenix.edu. Printing is for personal, private use only. No part of this book may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted. Use the following financial statements for Lake of Egypt Marina, Inc., to answer Page 74 Problems 3-29 through 3-33. https://jigsaw.vitalsource.com/api/v0/books/1259827178/print?from=74&to=74 2/15/2016 Page 2 of 2 Page 75 https://jigsaw.vitalsource.com/api/v0/books/1259827178/print?from=74&to=74 2/15/2016