Question
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
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.
Cash Marketable Securities Accounts Receivables Inventuines Current Assets Net Fixed Assets Total Assels 6,354,01X1.00 45,200.00 32,046,800.00 55,867,21X1.00 94.513,200.00 131,486,800.00 226,000,00X1.00 Cash Marketable Securities Accounts Receivables Invenkinies Current Assets Net Fixed Assets Total Assets 395,000.00 460,000.00 2,225,000.00 3,850,0X10.00 6,931,000.00 13,875,000.00 20,806,000.00 428,1X10,00 540,000.00 2,525,000.00 4,950,IXI0.00 8,443,000.00 14,576.1x10.00 23,019,1X10.00 587,100.00 638,000.00 3,758,000.00 6,013,000.00 10.996,000.00 17,568,000.00 28.561,000.00 Accounts Payables Accruals Noles Payables Current Liabilities Long Term Debt Total Liabilities Preferred Stock Common Slack Retained Earnings TotaCommon Tiquity Total Liabilities and Owner's Equity 5,085,000.00 3,073,600.00 1,898,40X1.00 10.057,000.00 72,885,0IXOC 82,942,000.00 11,752,000.00 30,510,DIXI.IO 100.796,000.00 131.306,00.00 226,000,000.00 Accounts Payables Accruals Noles Payables Currcut Liabilities Long Term Debt Total Liabilities Preferred Stock Cummun Suck Retainod Earings TotalCommon Equity Total Liabilitics and Owner's Equity 425,000.00 495,000.00 150.XI0.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,000.00 478,000.00 567,000.00 180,IXIO.00 1,225,000.00 6,714,140,00 7,939,140.00 1,950,000.00 9,500.IXI0.00 3,629,860.00 13,129,860,00 23,019,1X10,00 518,000.00 694,000.00 175,000.00 1,387,000.00 8,985,980.00 10.372,980.00 2,450,000.00 10,500,XII.CO 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 Preferrexl Dividends Net Income Select 6 (2015) 599,1X10,000 505,040,000 31.270,000 536,310,000 53,690,000 7,670,000 46,020,000 18,408,000 $40,000) 27,022,000 2013 28,255,000 22,321.450 2,775,000 25,196,450 3,158.550 325,000 2,833.550 1,133,420 108500 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 Tables Historical Sales for The Prentice Paper Company Year Revenues 1995 8,825,000 1996 12,450,000 19971 13,246,IXIO 1998 14,250,000 1999 16,275,0X10 2000 18,235,0X10 2001 21,234,000 2012 24,345,XIO 2003 28,255,000 2004 37,340,000 2005 54,670,XIO 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 Net Income 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 Cash Marketable Securities Accounts Receivables Inventuines Current Assets Net Fixed Assets Total Assels 6,354,01X1.00 45,200.00 32,046,800.00 55,867,21X1.00 94.513,200.00 131,486,800.00 226,000,00X1.00 Cash Marketable Securities Accounts Receivables Invenkinies Current Assets Net Fixed Assets Total Assets 395,000.00 460,000.00 2,225,000.00 3,850,0X10.00 6,931,000.00 13,875,000.00 20,806,000.00 428,1X10,00 540,000.00 2,525,000.00 4,950,IXI0.00 8,443,000.00 14,576.1x10.00 23,019,1X10.00 587,100.00 638,000.00 3,758,000.00 6,013,000.00 10.996,000.00 17,568,000.00 28.561,000.00 Accounts Payables Accruals Noles Payables Current Liabilities Long Term Debt Total Liabilities Preferred Stock Common Slack Retained Earnings TotaCommon Tiquity Total Liabilities and Owner's Equity 5,085,000.00 3,073,600.00 1,898,40X1.00 10.057,000.00 72,885,0IXOC 82,942,000.00 11,752,000.00 30,510,DIXI.IO 100.796,000.00 131.306,00.00 226,000,000.00 Accounts Payables Accruals Noles Payables Currcut Liabilities Long Term Debt Total Liabilities Preferred Stock Cummun Suck Retainod Earings TotalCommon Equity Total Liabilitics and Owner's Equity 425,000.00 495,000.00 150.XI0.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,000.00 478,000.00 567,000.00 180,IXIO.00 1,225,000.00 6,714,140,00 7,939,140.00 1,950,000.00 9,500.IXI0.00 3,629,860.00 13,129,860,00 23,019,1X10,00 518,000.00 694,000.00 175,000.00 1,387,000.00 8,985,980.00 10.372,980.00 2,450,000.00 10,500,XII.CO 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 Preferrexl Dividends Net Income Select 6 (2015) 599,1X10,000 505,040,000 31.270,000 536,310,000 53,690,000 7,670,000 46,020,000 18,408,000 $40,000) 27,022,000 2013 28,255,000 22,321.450 2,775,000 25,196,450 3,158.550 325,000 2,833.550 1,133,420 108500 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 Tables Historical Sales for The Prentice Paper Company Year Revenues 1995 8,825,000 1996 12,450,000 19971 13,246,IXIO 1998 14,250,000 1999 16,275,0X10 2000 18,235,0X10 2001 21,234,000 2012 24,345,XIO 2003 28,255,000 2004 37,340,000 2005 54,670,XIO 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 Net Income 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
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