1,737
25
Essay, 2 pages (350 words)

Body shop pro forma financial statements essay sample

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.

Thank's for Your Vote!
Body shop pro forma financial statements essay sample. Page 1
Body shop pro forma financial statements essay sample. Page 2
Body shop pro forma financial statements essay sample. Page 3

This work, titled "Body shop pro forma financial statements essay sample" was written and willingly shared by a fellow student. This sample can be utilized as a research and reference resource to aid in the writing of your own work. Any use of the work that does not include an appropriate citation is banned.

If you are the owner of this work and don’t want it to be published on AssignBuster, request its removal.

Request Removal
Cite this Essay

References

AssignBuster. (2022) 'Body shop pro forma financial statements essay sample'. 6 January.

Reference

AssignBuster. (2022, January 6). Body shop pro forma financial statements essay sample. Retrieved from https://assignbuster.com/body-shop-pro-forma-financial-statements-essay-sample/

References

AssignBuster. 2022. "Body shop pro forma financial statements essay sample." January 6, 2022. https://assignbuster.com/body-shop-pro-forma-financial-statements-essay-sample/.

1. AssignBuster. "Body shop pro forma financial statements essay sample." January 6, 2022. https://assignbuster.com/body-shop-pro-forma-financial-statements-essay-sample/.


Bibliography


AssignBuster. "Body shop pro forma financial statements essay sample." January 6, 2022. https://assignbuster.com/body-shop-pro-forma-financial-statements-essay-sample/.

Work Cited

"Body shop pro forma financial statements essay sample." AssignBuster, 6 Jan. 2022, assignbuster.com/body-shop-pro-forma-financial-statements-essay-sample/.

Get in Touch

Please, let us know if you have any ideas on improving Body shop pro forma financial statements essay sample, or our service. We will be happy to hear what you think: [email protected]