Needs to be in excel and labled so I can follow what you did and also know which question is which.

  1. The Minoso Corporation anticipates a 20% increase in sales for 2014, 2015, and 2016.  Minoso is currently operating at full capacity and thus expects to increase its investment in both current and fixed assets in order to support the increase in forecasted sales.  The Minoso Corporation’s 2013 income and balance sheet statements are attached.Minoso is seeking your assistance in preparing its projected financial statements using the percent-of-sales method.   Initial projected financial statements can be prepared by constructing spreadsheet–based solutions. You must submit the following information:

    1. Prepare a projected income statement using Excel for 2014 for Minoso before obtaining any additional financing.  [Hint: Review the GameToy Company Finacials Powerpoint which has been attached to this assignment.]

    2. Prepare a projected balance sheet using Excel for 2014 for Minoso before obtaining any additional financing.  Hint: Review the GameToyCompany Finacials Powerpoint which has been attached to this assignment.]

    3. Based on your projected balance sheet for Minoso for 2014, what is your estimate of additional financing needed?