Question
I need to forecast the income stateent for 2017, 2018, and 2019 in this format For Income Statement Sales COGS Gross Profit G&A Depreciation EBIT
I need to forecast the income stateent for 2017, 2018, and 2019 in this format
For Income Statement |
Sales |
COGS |
Gross Profit |
G&A |
Depreciation |
EBIT |
Interest Expense |
EBT |
Income Tax |
Net Income |
A business's pro forma is the forecast financial statements based on either anticipated future events or potentially changing business performance in upcoming periods. This is in contrast to regular financial statements that are financial summaries on a business's past. Businesses use pro forma statements to assist in their planning activities, both short term and long term. Attached is JcPennys income statement and balance sheet with the percentage of sales method. Consider how each item on that statement can or will be changed during the coming three years. You will need to estimate final sales and expenses for the current year to prepare a pro forma income statement for the upcoming three years. Make sure you explicitly show your assumptions with good critical analysis.
Revenue | 1/30/2016 | 1/31/2015 | 2/1/2014 | Total | Average(Total/3) | %age (Cost/Sales x 100) | ||||||
Sales Quantity | 12630 | 12260 | 11860 | 36750 | 12250 | |||||||
Sales price per unit | $ 999.60 | $ 999.76 | $ 999.92 | $ 999.76 | $ 999.76 | |||||||
Total Revenue | 12,625,000 | 12,257,000 | 11,859,000 | $ 36,741,000.00 | $ 12,247,000.00 | 100% | ||||||
Cost of Revenue | 8,074,000 | 7,996,000 | 8,367,000 | $ 24,437,000.00 | $ 8,145,666.67 | 66.51% | ||||||
Gross Profit | 4,551,000 | 4,261,000 | 3,492,000 | $ 12,304,000.00 | $ 4,101,333.33 | 33.49% | ||||||
Selling General and Administrative | 3,940,000 | 3,797,000 | 3,918,000 | $ 11,655,000.00 | $ 3,885,000.00 | 31.72% | ||||||
Non Recurring | 84,000 | 87,000 | 215,000 | $ 386,000.00 | $ 128,666.67 | 1.05% | ||||||
Others | 616,000 | 631,000 | 601,000 | $ 1,848,000.00 | $ 616,000.00 | 5.03% | ||||||
Total Operating Expenses | 4,640,000 | 4,515,000 | 4,734,000 | $ 13,889,000.00 | $ 4,629,666.67 | 37.80% | ||||||
Operating Income or Loss | -89,000 | -254,000 | -1,242,000 | $ (1,585,000.00) | $ (528,333.33) | -4.31% | ||||||
Income from Continuing Operations | ||||||||||||
Total Other Income/Expenses Net | -10,000 | -34,000 | -114,000 | $ (158,000.00) | $ (52,666.67) | -0.43% | ||||||
Earnings Before Interest and Taxes | -99,000 | -288,000 | -1,356,000 | $ (1,743,000.00) | $ (581,000.00) | -4.74% | ||||||
Interest Expense | 405,000 | 406,000 | 352,000 | $ 1,163,000.00 | $ 387,666.67 | 3.17% | ||||||
Income Before Tax | -504,000 | -694,000 | -1,708,000 | $ (2,906,000.00) | $ (968,666.67) | -7.91% | ||||||
Income Tax Expense | 9,000 | 23,000 | -430,000 | $ (398,000.00) | $ (132,666.67) | -1.08% | ||||||
Net Income From Continuing Ops | -523,000 | -751,000 | -1,392,000 | $ (2,666,000.00) | $ (888,666.67) | -7.26% | ||||||
Net Income | -513,000 | -717,000 | -1,278,000 | $ (2,508,000.00) | $ (836,000.00) | -6.83% | ||||||
Net Income Applicable To Common Shares | -513,000 | -717,000 | -1,278,000 | $ (2,508,000.00) | $ (836,000.00) | -6.83% |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started