- PREPARE Annual Income Statements, Cash Flow Statements, and Year End Balance Sheet for Years 3-6 (use BPG Reports file)- **YEAR 6 ONLY!!** Create Variance Analysis for actual vs formatted numbers...

- PREPARE Annual Income Statements, Cash Flow Statements, and Year End Balance Sheet for Years 3-6 (use BPG Reports file)- **YEAR 6 ONLY!!** Create Variance Analysis for actual vs formatted numbers with +/- 25% differences( PRO FORMA Y6 - Year vs. Annual Income Statement, Cash Flow, Year End Balance Sheet for Year 6, created using Financial Statement in BPG Report)- Point out different strengths and weaknesses company might currently have at end of Y6Q4
- Create a forecast financial statement for year 7 (income statement, cash flow, balance sheet) explain what should be done to improve condition/preformance of company


World 28, Company 2 Year 2 Quarter 4 CONSOLIDATED INCOME STATEMENT 01-27-2020 A BUSINESS POLICY GAME, 7TH EDITION 15:54:57 � � � � � ÿý� �2�0�1�7� �b�y� �R�i�c�h�a�r�d� �V�.� �C�o�t�t�e�r�,� �D�a�v�i�d� �J�.� �F�r�i�t�z�s�c�h�e� �a�n�d� �S�i�m�o�n� �A�.� �R�o�d�a�n ____________________________________________________________________________ Consoli- Merica Merica Merica dated Area 1 Area 2 Area 3 Pandau M$000s M$000s M$000s M$000s Rp000s Net Sales: to Customers 3965 1140 860 1140 4950 to Affiliates (cost + 20%) 0 0 1290 0 0 to Liquidators (at cost) 0 0 0 0 0 Less Cost of Goods sold 1831 638 1477 638 2206 Less Value Added Tax 82 0 0 0 495 Gross Profit 2052 502 673 502 2249 Selling Expense: Advertising Expense 144 40 46 40 105 Sales Salaries 115 30 36 30 116 Sales Commissions 70 23 17 23 40 General Selling Expense 403 100 103 100 603 Transportation Expense 194 64 9 64 341 Sales Office Depreciation 12 3 3 3 17 Total Selling Expense 938 260 214 260 1222 Admin and General Expense: Research and Development 72 0 72 0 0 Total Training Expense 104 10 78 10 35 Storage Expense 22 8 0 8 33 Executive Compensation 149 25 75 25 147 Other Expense 0 0 0 0 0 Total Adm & Gen Expense 347 43 225 43 215 Total Operating Expense 1285 303 439 303 1437 Operating Profit (Loss) 767 199 234 199 812 Other Income: CD Interest 8 0 8 0 0 Capital Gain (Loss) 0 0 0 0 0 Other Expense: Loan Interest 0 0 0 0 0 Bond Interest 50 0 50 0 0 Net Profit (Loss) Before Tax 725 199 192 199 812 Less Income Tax 283 78 74 78 317 Net Profit (Loss) After Tax 442 121 118 121 495 Foreign Currency Adjustment 14 Comprehensive Income(Loss) 428 121 118 121 495 ____________________________________________________________________________ Notes: Translation Exchange Rate 1.00 1.00 1.00 6.00 Minor differences in translation may be due to rounding errors. Purchases from Affiliates is consolidated with Sales to Affiliates. Dividends to Parent is consolidated with Dividends from Subsidiaries. World 28 Company 2 Year 2 Quarter 4 CONSOLIDATED CASH FLOW ANALYSIS 01-27-2020 B