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 Sample

The whole doc is available only for registered users OPEN DOC

Get Access

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

We can write a custom essay

Order an essay

## You May Also Find These Documents Helpful

Peculiarities of various assignment types

The educational process is diverse and full of interesting writing tasks which help students develop their academic abilities. Different assignments types are created by professionals in order to enhance students’ level of analytical, critical and writing skills and to vary the learning process. As a student, you will encounter numerous tasks of diverse complexities throughout your student life. Sometimes, maybe, too complicated! They have different peculiarities, structural...

Making decisions in health and social care

Critically analyses the concepts, features, and importance of costs and accounting in making decisions in health and social care Cost accounting is a method used in accounting to capture a company’s or organisation’s production costs. It assesses the input costs of every step in production, fixed costs like depreciation of capital equipment. Cost accounting measures and records costs individually then compare the input results via...

Сhildren development

Physical development 7-12 years By the age of 7 a child enjoys things such as bike riding and rollerblading they are now able to tie and untie shoelaces without adult help, they are now starting to understand what rules are and are able to follow simple rules. At 8-12 years a child improves the physical skills that they have already developed and start to see...

Introduction Forex exchange is on the rise in Namibia; resulting in more people wanting to learn how to trade to try to increase their income so that they can enhance their standard of living. Forex Foreign exchange identifies the process of converting domestic currency into international banknotes at particular exchange rates (Bofah, 2017, para.1). As the number of foreigners in Namibia is increasing, more Namibians...

Aristotelian idea of God

This image produced in 1544 shows emerging's of the Judeo-Christians and Aristotelian's traditions. Aristotle was very interested in the idea of motion and said “The world is in a constant state of motion and change”. An example of how the world is changing is the growth of trees and plants. Aristotle believed in a prime mover, which is the being which creates change in the...

### Essays 65,502

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.

Sorry, but only registered users have full access

immediately?

Become a member

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?