Greg, the board of directors meeting is scheduled two weeks from today, and Im depending on you to come up with a realistic and honest appraisal of our companys position, said Warren, to his assistant Greg Chapman. Im sure that theres more to us than meets the eye! he quipped. But those darn analysts are still punishing us for Roberts accounting jugglery, he said with a frown. Why dont you prepare a detailed financial performance analysis of the firm for the most recent three years, complete with industry comparisons and a DuPont analysis? It will help me make the case to the rating agencies that they need to raise our rating. After that, Id like you to prepare a 12-month pro-forma forecast using a scenario analysis. Use our current average compound growth rate in sales as the base estimate and vary that up and down by 10% for the best-case and worst-case scenarios respectively. This will help us figure out how much additional funds we are going to have to acquire over the next year. The production folks tell me that we are currently operating at 90% of capacity, so we should be able to support some growth without additional plant and equipment, he added looking rather stressed. Warren Badges, the new CFO of Paramount Paper Inc., was hired last year to replace Robert Malnight. Robert was fired because the firm had come under Federal investigation for noncompliance of the Sarbanes-Oxley
Act (2002). Under Roberts watch, the stock had plummeted to its all-time low despite reasonably strong sales and income growth. Warren implemented various measures to bring the firm in compliance with the 2002 Act. The firms sales had been increasing steadily due to its excellent commitment to quality. However, stock market analysts had been unforgiving because the stock price was still hovering around its all-time low of $12. The significant growth rate that the firm had been experiencing had necessitated the infusion of more capital. But lenders were reluctant to lower interest rates due to their suspicions about the firms past reporting practices. Warren had a hunch that the company could save a bundle in interest costs if the markets were convinced that the firms accounting and reporting practices were clearly within the Sarbanes-Oxley guidelines. He knew that an upgrade in the firms credit rating would help expedite the process. Moreover, when he took over from Robert, Warren realized that there was no formal policy of conducting long-term planning and forecasting in place. Most of what Robert did was based on his gut feelings regarding the economy. Being an industry veteran, Warren was fully aware that haphazard growth could be a recipe for disaster. He was determined to set things straight and he knew that the market would take note. One of the first things that Warren did upon joining Paramount was to lure his assistant, Greg Chapman, away from their prior employer, Holland Paper. Greg had been working for Holland Paper for over 10 years. When the opportunity came up, Greg initially hesitated. He was enjoying a fairly comfortable lifestyle, and the city had a lot to offer. But Warren made him an offer that he found very hard to refuse. The remuneration package included a very attractive stock option plan and a signing bonus. Moreover, Greg knew that Warren was an honest, ethical person and he enjoyed working for him. Ill get on it right away, Warren, promised Greg. Well show those dumb analysts just how wrong they are! Greg had the folks in accounting send him the firms financial statements for the past three years, along with the aggregate financial statements for the select group of six firms that were their main competitors. In addition, he collected data regarding the firms sales history, its beta estimate, and other market information. Greg was fully aware that the firms stock price and capital cost structure depended on his analysis, and he was determined to present a comprehensive, convincing appraisal of the firms performance to the board.
1.Using a cash flow statement for the most recent 2 years, explain how Greg would sum up the companys cash position. 2.Analyze the firms liquidity, leverage, turnover, and profitability using ratio analysis. 3.Using common size statements, help Greg present an appraisal of the companys performance and financial condition vis--vis its key competitors. 4.What would Greg discover after performing a DuPont Analysis on the companys key profitability ratios? 5.How much additional sales can the company support without having to add fixed assets? 6.Will Paramount Paper have to raise external capital over the next 12 months? If so how much? If not, why not? 7.Is Warren correct in saying there is more to us than meets the eye? Explain. 8.If you are Warren, explain how you would attempt to convince the rating agencies that the firms debt rating should be raised.
(Answers for questions 1 and 3 please)
if you do answer all I will make sure you get lots of likes
Marketable Securities Accounts Receivables Inventures Current Assets Net Fixed Assets Total Assets 6,554,DIXIE 45,200.00 32,046,800.00 55,867,21x7.00 94.513,200.00 131,486,8IXI.00 226,000,000.00 Cash Marketable Securition Accounts Receivables Inventaries Currcut Assets Net Fixed Assets Total Assets 1996,0X10,00 460,000.00 2,225,000.00 3,850,0X10.00 6,93 1,000.00 13.875.0X10.00 20,816, XI0.00 428,1x0,00 540,000.00 2.525.000.00 4,950),IXIO,00 8,443,000.00 14,576,0X10,00 23,019,IXI0.00 587,02.0 638,000.00 3,758,000.00 6,013,1X10.10 10.996,000.00 17,568,000.00 28.564,000.00 Accounts Payables Accruals Notes Payables Current Liabilitics Lang Tern Debt Total Liabilities Preferred Stock Common Slack Retained Earnings TotaCommon Tiquity Total Liabilities and Owner's Equity 5,085,000.00 3,073,60X0.00 1,898,41x7.00 10.057,000.00 72,885,0X1.00 82,942,000.00 11,752,000.00 30,510,01X1.00 100.796,000.00 131,306,00X1.00 226,000,000.00 Accounts Payables Accruals Notes Payables Currcut Liabilities Long Term Deh! Total Liabilities Preferred Stock Common Stock Retained Eamings TotalCommon Equity Total Liabilities and Owner's Equity 425,000.00 495.000,00 150,0X10,00 1,070,000.00 5,250,0X10,00 6,320,000.00 1,550,000.00 10,250,0X10.00 2,686,000.00 12,936,000.00 20,806,0X10.00 478,000.00 567.000.00 180,IXI0.00 1,225,000.00 6,714,140,00 7,939,140.00 1,950,000.00 9,500,0X10,00 3,629,860.00 13,129,860.00 23.019,0x10.00 518,000.00 694,000.00 175,000.00 1,387,000.00 8,985,90.00 10.372,980.00 2,450,000.00 10.500,XX.CC 5.241,020.00 15,741,020.00 28.561,000.00 Sales Revenues Cash Operating costs Depreciation Total Operating Costs Operating Income (EBIT) Interest Expenses Taxable income Taxes Preletexi Dividencis Net Income Select 6 (2015) 590),(XI0,000) SOS,040.000 31.270,000 536,310,000 53,690,000 7,670,000 46,020,000 18,408,000 $90,000) 27,022,000 2013 28,255,000 22,321.450 2,775,000 25,1896.450) 3,158.550 325.000 2,833,550 1.133,420 108,500 1,591.630 Paramount Paper Inc. 2014 37,340,000 32,112,400 2,915,000 35,127,400 2,312.600 512,000 1,800,600 720.240 136,500 943.860 2015 54,670,000 47,562,900 3,513,000 51,075,900 3,594,100 623,000 2,971,100 1,188,440 171,500 1,611,160 Tahle 5 Historical Sales for The Premier Paper Company Year Revenues 1995 8,825.000 1996 12,450,000 1997 13,246,IXIO 1998 14,250,000 1999 16,275,0X10 2000 18,235,0X10 2001 21,234.000 ZIKI2 24,345,IXIO 2003 28,255,000 2004 37,340,000 2S 54,670,1X10 Table 4 Aggregate Income Statement for Paper Industry - Select 6 for year ended December 31st, 2005 Sales Revenues Cash Operating Costs Depreciation Total Operating Costs Operating Income (EBIT) Interest Expenses Taxable Income Taxes Preferred Dividends Net Income 590,000,000 505,040,000 31,270,000 536,310,000 53,690,000 7,670,000 46,020,000 18,408,000 590,000 27,022,000 Sales Revenues Cash Operating Costs Depreciation Total Operating Costs Operating Income (EBIT) Interest Expenses Taxable Income Taxes Preferred Dividends Table 1 The Premier Paper Co. Prior 3-year Income Statements 2003 2004 28,255,000 37,340,000 22,321,450 32,112,400 2,775,000 2,915,000 25,096,450 35,027,400 3,158,550 2,312,600 325,000 512,000 2,833,550 1,800,600 1,133,420 720,240 108,500 136,500 1,591,630 943,860 2005 54,670,000 47,562,900 3,513,000 51,075,900 3,594,100 623,000 2,971,100 1,188,440 171,500 1,611,160 Net Income Marketable Securities Accounts Receivables Inventures Current Assets Net Fixed Assets Total Assets 6,554,DIXIE 45,200.00 32,046,800.00 55,867,21x7.00 94.513,200.00 131,486,8IXI.00 226,000,000.00 Cash Marketable Securition Accounts Receivables Inventaries Currcut Assets Net Fixed Assets Total Assets 1996,0X10,00 460,000.00 2,225,000.00 3,850,0X10.00 6,93 1,000.00 13.875.0X10.00 20,816, XI0.00 428,1x0,00 540,000.00 2.525.000.00 4,950),IXIO,00 8,443,000.00 14,576,0X10,00 23,019,IXI0.00 587,02.0 638,000.00 3,758,000.00 6,013,1X10.10 10.996,000.00 17,568,000.00 28.564,000.00 Accounts Payables Accruals Notes Payables Current Liabilitics Lang Tern Debt Total Liabilities Preferred Stock Common Slack Retained Earnings TotaCommon Tiquity Total Liabilities and Owner's Equity 5,085,000.00 3,073,60X0.00 1,898,41x7.00 10.057,000.00 72,885,0X1.00 82,942,000.00 11,752,000.00 30,510,01X1.00 100.796,000.00 131,306,00X1.00 226,000,000.00 Accounts Payables Accruals Notes Payables Currcut Liabilities Long Term Deh! Total Liabilities Preferred Stock Common Stock Retained Eamings TotalCommon Equity Total Liabilities and Owner's Equity 425,000.00 495.000,00 150,0X10,00 1,070,000.00 5,250,0X10,00 6,320,000.00 1,550,000.00 10,250,0X10.00 2,686,000.00 12,936,000.00 20,806,0X10.00 478,000.00 567.000.00 180,IXI0.00 1,225,000.00 6,714,140,00 7,939,140.00 1,950,000.00 9,500,0X10,00 3,629,860.00 13,129,860.00 23.019,0x10.00 518,000.00 694,000.00 175,000.00 1,387,000.00 8,985,90.00 10.372,980.00 2,450,000.00 10.500,XX.CC 5.241,020.00 15,741,020.00 28.561,000.00 Sales Revenues Cash Operating costs Depreciation Total Operating Costs Operating Income (EBIT) Interest Expenses Taxable income Taxes Preletexi Dividencis Net Income Select 6 (2015) 590),(XI0,000) SOS,040.000 31.270,000 536,310,000 53,690,000 7,670,000 46,020,000 18,408,000 $90,000) 27,022,000 2013 28,255,000 22,321.450 2,775,000 25,1896.450) 3,158.550 325.000 2,833,550 1.133,420 108,500 1,591.630 Paramount Paper Inc. 2014 37,340,000 32,112,400 2,915,000 35,127,400 2,312.600 512,000 1,800,600 720.240 136,500 943.860 2015 54,670,000 47,562,900 3,513,000 51,075,900 3,594,100 623,000 2,971,100 1,188,440 171,500 1,611,160 Tahle 5 Historical Sales for The Premier Paper Company Year Revenues 1995 8,825.000 1996 12,450,000 1997 13,246,IXIO 1998 14,250,000 1999 16,275,0X10 2000 18,235,0X10 2001 21,234.000 ZIKI2 24,345,IXIO 2003 28,255,000 2004 37,340,000 2S 54,670,1X10 Table 4 Aggregate Income Statement for Paper Industry - Select 6 for year ended December 31st, 2005 Sales Revenues Cash Operating Costs Depreciation Total Operating Costs Operating Income (EBIT) Interest Expenses Taxable Income Taxes Preferred Dividends Net Income 590,000,000 505,040,000 31,270,000 536,310,000 53,690,000 7,670,000 46,020,000 18,408,000 590,000 27,022,000 Sales Revenues Cash Operating Costs Depreciation Total Operating Costs Operating Income (EBIT) Interest Expenses Taxable Income Taxes Preferred Dividends Table 1 The Premier Paper Co. Prior 3-year Income Statements 2003 2004 28,255,000 37,340,000 22,321,450 32,112,400 2,775,000 2,915,000 25,096,450 35,027,400 3,158,550 2,312,600 325,000 512,000 2,833,550 1,800,600 1,133,420 720,240 108,500 136,500 1,591,630 943,860 2005 54,670,000 47,562,900 3,513,000 51,075,900 3,594,100 623,000 2,971,100 1,188,440 171,500 1,611,160 Net Income
