need help understanding this

Study the Trial Balance. Using the space provided in Excel, explain the computations necessary to derive the following balances (see?-marks in Excel file): - Assets: Investments, \& Inventory - I/S Accounts: Sales Revenue, Interest Income, Cost of Goods Sold, Office Rent Expense, Supplies Expense, \& Income Tax Expense. Prepare an income statement, statement of retained earnings, and a balance sheet for Organic Footwear, Inc. for the year ended December 31, 2017, its first year in business. Follow the direction within the various tabs of the Excel worksheets to obtain the correct answers. Prepare the following year's Balance Sheet and Income Statement with a growth factor based on your analysis and research. Discuss your analysis and the results based on your assumptions. Be sure your forecast is flexible to allow for what if analysis. (Note: Insert tabs for the forecasted financial statements). Write up your discussion on your Excel file. Add a tab for discussion. Use the following questions in your discussion. Do you think it was a good idea to open the business? Why or why not? What does your answer depend on? Hints: Consider the following: 1) Did Cathy make a profit? Was the profit rate (ROI) adequate? Hint If other firms in the footwear industry obtain ROI greater than 10%, how would you view Organic Footwear? Use the ROI calculated on the Excel BS tab to support your answer. 2) Did she need or use all of the invested capital to nun the business during the first year? If you were to remove the ST Investments from the Initial Investment amount used to calculate ROI, and re-run the ROI statistic, what is the resulting percentage? Interpret her performance with this modification relative to industry? (Remember: if she does not have the ST Investment, she would not have earned the gain on investment after taxes.) 3) How much gross profit did Cathy make per pair (price per unit - cost per unit)? What is this as a percent of sales (gross profitprice)? Look up competitor firms and see what they earn for gross profit percentage. How does Cathy compare? 4) How much did Cathy spend in advertising per pair (advertising/units sold)? Once the brand is established, will Cathy need to advertise as heavily to generate the same volume of sales? 5) Cathy has substantial amounts of underutilized capital (in cash and ST investments), What are some options for utilizing these resources more effectively in the future? Study the Trial Balance. Using the space provided in Excel, explain the computations necessary to derive the following balances (see?-marks in Excel file): - Assets: Investments, \& Inventory - I/S Accounts: Sales Revenue, Interest Income, Cost of Goods Sold, Office Rent Expense, Supplies Expense, \& Income Tax Expense. Prepare an income statement, statement of retained earnings, and a balance sheet for Organic Footwear, Inc. for the year ended December 31, 2017, its first year in business. Follow the direction within the various tabs of the Excel worksheets to obtain the correct answers. Prepare the following year's Balance Sheet and Income Statement with a growth factor based on your analysis and research. Discuss your analysis and the results based on your assumptions. Be sure your forecast is flexible to allow for what if analysis. (Note: Insert tabs for the forecasted financial statements). Write up your discussion on your Excel file. Add a tab for discussion. Use the following questions in your discussion. Do you think it was a good idea to open the business? Why or why not? What does your answer depend on? Hints: Consider the following: 1) Did Cathy make a profit? Was the profit rate (ROI) adequate? Hint If other firms in the footwear industry obtain ROI greater than 10%, how would you view Organic Footwear? Use the ROI calculated on the Excel BS tab to support your answer. 2) Did she need or use all of the invested capital to nun the business during the first year? If you were to remove the ST Investments from the Initial Investment amount used to calculate ROI, and re-run the ROI statistic, what is the resulting percentage? Interpret her performance with this modification relative to industry? (Remember: if she does not have the ST Investment, she would not have earned the gain on investment after taxes.) 3) How much gross profit did Cathy make per pair (price per unit - cost per unit)? What is this as a percent of sales (gross profitprice)? Look up competitor firms and see what they earn for gross profit percentage. How does Cathy compare? 4) How much did Cathy spend in advertising per pair (advertising/units sold)? Once the brand is established, will Cathy need to advertise as heavily to generate the same volume of sales? 5) Cathy has substantial amounts of underutilized capital (in cash and ST investments), What are some options for utilizing these resources more effectively in the future