Purchase Solution

Home Depot Proformas using the Percent-of-Sales Method

Not what you're looking for?

Ask Custom Question

Based on the financial statement in the annual report for Home Depot (using 2007 figures) develop a set of pro forma financials (income and balance sheet only) for the next fiscal year-end using the percent-of-sales method. Assume that the company's sales have increased by 20%.

Attachments
Purchase this Solution
Solution Summary

In this solution the author completes Home Depot proformas using the percent-of-sales method. Calculations are included and the solution is provided in a Microsoft Excel document.

Purchase this Solution
Free BrainMass Quizzes
Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

View More Free Quizzes
Related BrainMass Solutions

  • Algebra Problems

    What was the percent growth in Home Depot's sales from 2002 to 2006? Do all your work by using scientific notation. The Home Depot, Inc. (2007, March 29). 2006 Annual Report.

  • Home Depot: Effects of a 3% Sales Decline

    452023 Home Depot: Effects of a 3% Sales Decline Home Depot was one major company in the building supplies industry that was adversely affected by the slowdown in the housing market.

  • Operating leverage, margin of safety and cost behavior

    512427 Operating leverage, margin of safety and cost behavior Explain how a 3 percent decline in sales at Home Depot could cause a 21 percent decline in profits.

  • Home Depot's Long-term Goals

    This boom will serve to increase the sales of Home Depot and enhance its position as the world's largest home improvement specialty retailer. There are a few long-term objectives that Home Depot wants to achieve.

  • Home Depot: Operating Leverage, Margin of Safety, and Cost

    A discussion of how various major types of costs incurred by Home Depot were likely affected by the decline in its sales. c. The effect of the decline in sales on Home Depot's margin of safety.

  • Intercompany Transactions and Accrual

    Only 80 percent of the transfers should be included because the sales were made by the subsidiary. c. Because the transfers were from a subsidiary organization, the cash flows are reported as investing activities. d.

  • Home Depot and Business Ethics

    on the sales.

  • Clearwater Development Co. Pro forma Percentage of sales

    Use the percentage-of-sales method to construct a pro forma income statement for 2010. b. You learn that 25 percent of the cost of goods sold and operating expense figures for 2009 are fixed costs that will not change in 2010.

  • Applying Algebra in Word Problems

    What was the percent growth in Home Depot's sales from 2002 to 2006? Do all your work by using scientific notation. (source: Home Depot Annual Report for FY 2006: http://www6.homedepot.com/annualreport/index.html) 4.

View More Related Solutions