Discuss pro-forma income statement

Assignment Help Accounting Basics

Reference no: EM132450359

Using percentage of sales approach and following the Financial Planning and Forecasting Excel Template example (The template example is attached, its for GE), conduct financial forecasting for Wal-Mart using the Wal-Mart financial data attached:

Question 1. pro-forma income statement

Question 2. pro-forma balance sheet

Question3. Calculate internal and sustainable growth rates for your firm for each of the past three years.

Question 4. Calculate the actual growth in sales for your company over each of the past three years and the average actual growth rate over the past three years.

Question 5. Offer interpretive analysis of your company's actual growth rate compared to its internal and sustainable growth rates. Discuss what these numbers mean regarding your firm's ability to finance a growth strategy. Justify your projection of the sales growth rate for the next 5 years.

Question 6. Discuss whether the firm may need to seek external financing to fund your projected growth.ro

Attachment:- actual groeth.zip

Reference no: EM132450359

Questions Cloud

How long the sun initial supply of hydrogen can last : The Sun fuses about 600 billion kilograms of hydrogen each second. Based on your result from part a, calculate how long the Sun's initial supply of hydrogen can

The Christian and quality : The book of Deuteronomy is God's instructions to the people after their exodus out of Egypt.

Calculate the total mass of hydrogen available for fusion : Use the given data to calculate the total mass of hydrogen available for fusion over the lifetime of the Sun.Express your answer using two significant figures.

Compute the maximum amplitude for each of the wave : Compute the maximum amplitude, frequency, time period and phase for each of the wave. The x-axis represents the time in sec and y-axis represents the amplitude

Discuss pro-forma income statement : Calculate the actual growth in sales for your company over each of the past three years and the average actual growth rate over the past three years.

At what value will the bond sell : Tanner, Inc. issued a 10%, 5-year, $100,000 bond when the market rate of interest was 12%. At what value will the bond sell

Describe the smallest possible mutation in a dna strand : What is the term used to describe the smallest possible mutation in a DNA strand, which involves only one base?

Wavelength of a certain absorption line : Laboratory measurements demonstrate that the normal wavelength of thisspectral line is 486.133. Is it approaching us or receding from us. At what speed?

Discusses the encouragement of strategic thinking : Discusses the encouragement of strategic thinking and the purpose of it. It also defines the difference between strategic planning versus strategic thinking.

User Account

All Pages