We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Body Shop Pro Forma Financial Statements Essay

The assignment should be submitted on Blackboard. No late assignment will be accepted. Enjoy the problems! Assignment Instructions: For this homework you will have to predict the future financial statements of the Body Shop. There is a template provided. Use the figures for 2011 and the forecasting assumptions on the template to forecast the Income statement and balance sheet for the next three years. For some variables there are no assumptions provided since they should be calculated rather than predicted (e. g. retained earnings). Cash and Debt are the two plugs.

Assumptions for the cash and debt plugs are described In the question. Assignment Question: Question 1 (15 points) For debt the assumptions are different for each year. For all years, If there Is need for additional debt (compared to the year before) the company will have to increase debt. However, In the case where Forecast the Income Statement and the Balance Sheet for the next three years (2012-2014). The Body Shop, Inc. ants to maintain at east $300 of cash in all years. debt does not have to increase the following assumptions hold.

For 2012 the company does not want to retire any debt. For 2013 they can retire debt if possible, but not more than 75% of last years debt. Finally for 2014, they are allowed to retire as much debt as possible. Question 2 (10 points) Create data tables (using the data table tool) that show what happens to debt in all three years when sales growth, accounts receivable % of sales and accounts payable % of sales change. For sales growth rate try the following growth rates: 28%, 29%, 30%, 31% and 32%. For accounts receivable % of sales check 10%, 15%, 20% or 25%.

We will write a custom essay sample on Body Shop Pro Forma Financial Statements specifically for you
for only $16.38 $13.9/page

Order now

Finally, for accounts payable % try 3%, 6%, 9% and 12%. Body Shop Pro Forma Financial Statements Excel Assignment assumptions on the template to forecast the income statement and balance sheet for Debt are the two plugs. Assumptions for the cash and debt plugs are described in For debt the assumptions are different for each year. For all years, if there is need for debt. However, in the case where Forecast the Income Statement and the Balance they can retire debt if possible, but not more than 75% of last year’s debt.

How to cite this page
Choose cite format:

Body Shop Pro Forma Financial Statements. (2017, Jun 25). Retrieved from https://primetimeessay.com/body-shop-pro-forma-financial-statements/

We will write a custom essay sample onBody Shop Pro Forma Financial Statementsspecifically for you

for only $16.38 $13.9/page
Order now