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

The whole doc is available only for registered users
• Pages: 2
• Word count: 378
• Category: Body

A limited time offer! Get a custom sample essay written according to your requirements urgent 3h delivery guaranteed

Order Now

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%.

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.

##### Related Topics

We can write a custom essay

According to Your Specific Requirements

Order an essay
300+
Materials Daily
100,000+ Subjects
2000+ Topics
Free Plagiarism
Checker
All Materials
are Cataloged Well

Sorry, but copying text is forbidden on this website. If you need this or any other sample, we can send it to you via email.

By clicking "SEND", you agree to our terms of service and privacy policy. We'll occasionally send you account related and promo emails.
Sorry, but only registered users have full access

How about getting this access
immediately?

Thank You A Lot!

Emma Taylor

online

Hi there!
Would you like to get such a paper?
How about getting a customized one?

Can't find What you were Looking for?

Get access to our huge, continuously updated knowledge base

The next update will be in:
14 : 59 : 59