Proforma Case Study

1) GENUINE MOTOR PRODUCTS Revised Pro forma Income Statement For 2007 Sales (1,000,000 units @ $30 per unit) Fixed costs Total variable costs (1,000,000 units @ $18.80 per unit) Operating Income (EBIT) Interest (10.75% x $12,000,000) Earnings before taxes Taxes (35%) Earnings after taxes Shares Earnings per share * Fixed costs include $2,800,000 in depreciation $ 30,000,000 5,800,000 18,800,000 5,400,000 1,290,000 4,110,000 1,438,500 2,671,500 2,320,000 1.15

Exhibit TN-4 CASH FLOW STATEMENTS (%) 2006 Operations Net Income Add/Minus : Depreciations Accounts Receivables Parts Inventory WIP Inventory FG Inventory Accounts Payable Total Investing Land, Plant and Equipment Other Assets Total Financing Long Term debt Total Change in Cash Profitability: 1,160,845,238 1,160,845,238 479,789,073 ,1594,740,016 1,594,740,016 646,808,200 267,974,210 267,974,210 -70,701,212 802,111,997 802,111,997

Pixar Company has the following financial statement. As April, 2005 (Table 2) shows net income has been increased by 200%

Mohana, R (2011). Financial Statement Analysis and Reporting. New Delhi: Asoke K. Ghosh, PHI Learni

BALANCE SHEET |Dec 1990 |Jan |Feb |Mar |Apr |May |June |July |Aug |Sept |Oct |Nov |Dec | |Cash |175 |556 |724 |175 |175 |175 |175 |175 |175 |175 |175 |175 |175 | |Accts receivable |2,628 |958 |234 |271 |270 |250 |250 |270 |1,603 |3,113 |3,580 |3,982 |3.063 | |Inventory |530 |948 |1,355 |1,749 |2,157 |2,564 |2,971 |3,365 |2,904 |2.314 |1,549 |697 |530 | |Net P/E |1,070 |1,070 |1,070 |1,070 |1,070 |1,070 |1,070 |1,070 |1,070 |1,070 |1,070 |1,070 |1,070 | |Total Assets |4,403 |3,533 |3,383 |3,265 |3,672 |4,059 |4,466

Consolidated Statements of Income (in thousands) 2003 2004 2005 Revenue Net sales Cost of goods sold Gross profit/(loss) Gross margin Operating expenses Sales and marketing Engineering and product development General and administrative Total operating expenses Operating income/loss Other income/expense Interest income/expense Other income/(expense) Income before provision for income taxes Income taxes Net income/(loss) Net margin 61,529 41,072 20,457 33.2% 64,063 43,155 20,908 32.6% 60,144 45,835 14,309 23.8%

Finally, we constructed a proforma income statement. Net sales is not a function of production, so we used the same forecasted net sales each month. We subtracted the cost of goods sold to determine the gross profit. Next, the operating expenses and taxes were subtracted to yield net profit. Each month's net profit is added to the shareholder's equity account on the balance sheet.

|Operating Cash Flow | | 5,956,000 | 9,916,000 | 11,500,000 | 6,748,000 | 3,580,000 |

Operating Results: |2001 |2002 |2003 |2004 |2005 |2006 |2007 |2008 | |Net Revenue |128,313 |144,460 |159,985 |175,820 |189,007 |201,292 |211,357 |219,811 | |Less: Operating Expenses |57,741 |65,007 |71,993 |79,119 |85,053 |90,581 |95,110 |98,915 | |Broadcast Cash Flow |70,572 |79,453 |87,992 |96,701 |103,954 |110,711 |116,246 |120,896 | |Less: Corporate Expense |5,080 |5,604 |5,660 |6,328 |6,803 |7,245 |7,607 |7,911 | |EBITDA |65,492 |73,849 |82,331 |90,373 |97,151 |103,466 |108,639 |112,985 | |Less: Depreciation |90,000 |90,000 |90,000 |90,000 |90,000 |90,000

Income Statement Revenue Cost of Goods Sold Gross Profit R&D Selling General & Administrative Non Recurring Others Operating Income Depreciation Expense Other Income/Expense EBIT Interest Expense Tax Expense Income from Cont Operations Net Income Balance Sheet Cash Short Term Investments Accounts Receivable Inventory Other Current Assets Total Current Assets Long Term Investments PP&E Net Goodwill Intangibles Other Assets Total Assets Current Year $ 61,494 49,128 12,366 661 7,302 0 0 4,403 970 116 3,549 199 715 2,635 2,635 Percent 100.0% 79.9% 20.1% 1.1% 11.9% 0.0% 0.0% 7.2% 1.6% 0.2% 5.8% 0.3% 1.2% 4.3% 4.3% Prior Year $ 52,902 42,789 10,113 624 6,465 0 0 3,024 852 12

In accounting, there is much to be learned, about the financial aspects of a business. In the past five weeks, this writer has learned the importance of financial reports and how they relate to the success of an establishment. These reports may include balance sheets and income statements, which help accountants and the public grasp the overall financial condition of a company. The information in these reports is significantly important to managers, owners, employees, and investors. Managers of a business can take and deduce financial data from the income statement which details monthly earnings as well as the company’s liabilities and equity position, and is also used to project future yearly budgets.

Table 1.2.2 Operating Statements for Years Ending December 31, 1988-1990, and for First Quarter 1991 (thousand of dollars)

Balance Sheet (2005 / 2006 / 2007) Income Statement (2005 / 2006 / 2007) Cash Flow Sheet (2005 / 2006 / 2007)

|  |Year 0 |Year 1 |Year 2 |Year 3 |Year 4 |Year5 | | |OCF | |$750,000 |$4,218,800 |$7,335,300 |$9,102,100 |$10,160,300 | | |Capital spending |–$50,000,000 |–25,000,000 | | | | | | |Net working capital | |–1,200,000 |–960,000 |–640,000 |–400,000 |–160,000 | | |Terminal value | | | | | |148,575,886 | | |Total cash flows |–$50,000,000 |–$25,450,000 |$3,258,800 |$6,695,300 |$8,702,100 |$158,576,186 | |

Year 2006 2007 2008 2009 2010 Total Assets 1191,25,12,487 1195,34,18,940 1481,96,65,441 1989,19,33,422 2137,23,99,509 Total Liabilities 396,25,92,062 370,24,79,293 436,94,63,296 900,62,26,808 539,83,13,058 Net Profit After Tax 47,06,58,563 35,30,67,878 54,53,41,273 62,47,40,307 105,16,48,808 Cash Ratio 0.229 0.052 0.028 0.455 0.585