really need help with this project

Excel Fle Edit View Insert Format Tools Data Window Help Unit 4 Final Project Rev Spring2019isx Home Insert Draw Page Layout Formulas Data Review View L' Coten. Formatting Fermati Table Cells Editing Cell Styles f& L13 the PanamaPajama Campary began eperations on January 2,2015 and iow in its thind year af operations djunted trial balance m of Stmt of Cash FlowsAnalysis 0 Excel File Edit View Insert Format Tools Data Window Help Unit 4 Final Project Rev Spring2019xlsx Home Insert Draw Page Layout Formulas Data Review View Condis nal Formatting v Format as Table w 13 far Decemb ind perform a vertical 29 (av Search Sheet' 5 , Unit 4 Final Project Rev Spring20 Autos aveFF Share Co e Insert Draw Page Layout Formulas Data Review View v -v % E! conditional Formatting v Font Alignment Number Cell Style Format as Table Cells Editing deas Sensitivity te trial balance as of December 31, 2018 appears below, along with prior year balance sheet data and some additional transaction data for 2018 THE PANAMA PAIAMA COMPANY Adjusted THal Balance 12/31/18 2018 Adjusted Trial Balance S 138,000 12000 35,600 11,000 Accounts Receable 20000 21,000 S 8,600 13,000 150,000 1,900 31,700 11,600 Outa for 2osa(Note these transactions were included in the trial balance numbers above.) 3,000 Requirements Dee sheet tabs at bottom. Use each sheet for the following requirements) must une formulas and IFRS Persp Stmt of Cash Flows - 29 ago cayotFormuldsData Review View Share Comment Conditional Formatting Format as Table Cell Styles aste Font Alignment Number Cells Editing Ideas Sensitivity Machinery & Took 21,000 Accounts Payable Nore Payable-Short Tem Note Payable- Long Tem Common 5ock, 510 par Retained Eamings 12,200 33,000 11,900 11,700 Sales Revenue Rent Expense Depreciation Goods Sol 1,500 2,500 2018 (Note, these were included n the t Cash paid for punchase of tools ofl dividends Requirements Gee sheet tabs at bottom Use each sheet for the following requirements) Prepare the Panama Pajama Company multi-step income statement for the year ended December 31, 2018. Include the EP Nso include a vertical analysis column at the right and perform a vertical analyus of the income statement. (Use percentage format with 1 decimal place.) and perform a vertical analysis of the balance sheet. (Use the percentage format with 1 decimal place.) Complete the analysis of the inancial statements as directed on the Analys sheet 2. Prepare the Panama Pajama Coem pany balance sheet for December 31, 2018. Include a vertical analysis column at the right 3. Preparethe Panama Pajama Company statement of cash Rows for the year ended December 33, 2018. Use the indirect method S. Answer the question Instructions Stmt of Cash Flows Analysis IFRS - 94% 29 : esc 0 Excel Fle Edit View Insert Format Tools Data Window Help Unit 4 Final Project Rev Spring2019isx Home Insert Draw Page Layout Formulas Data Review View L' Coten. Formatting Fermati Table Cells Editing Cell Styles f& L13 the PanamaPajama Campary began eperations on January 2,2015 and iow in its thind year af operations djunted trial balance m of Stmt of Cash FlowsAnalysis 0 Excel File Edit View Insert Format Tools Data Window Help Unit 4 Final Project Rev Spring2019xlsx Home Insert Draw Page Layout Formulas Data Review View Condis nal Formatting v Format as Table w 13 far Decemb ind perform a vertical 29 (av Search Sheet' 5 , Unit 4 Final Project Rev Spring20 Autos aveFF Share Co e Insert Draw Page Layout Formulas Data Review View v -v % E! conditional Formatting v Font Alignment Number Cell Style Format as Table Cells Editing deas Sensitivity te trial balance as of December 31, 2018 appears below, along with prior year balance sheet data and some additional transaction data for 2018 THE PANAMA PAIAMA COMPANY Adjusted THal Balance 12/31/18 2018 Adjusted Trial Balance S 138,000 12000 35,600 11,000 Accounts Receable 20000 21,000 S 8,600 13,000 150,000 1,900 31,700 11,600 Outa for 2osa(Note these transactions were included in the trial balance numbers above.) 3,000 Requirements Dee sheet tabs at bottom. Use each sheet for the following requirements) must une formulas and IFRS Persp Stmt of Cash Flows - 29 ago cayotFormuldsData Review View Share Comment Conditional Formatting Format as Table Cell Styles aste Font Alignment Number Cells Editing Ideas Sensitivity Machinery & Took 21,000 Accounts Payable Nore Payable-Short Tem Note Payable- Long Tem Common 5ock, 510 par Retained Eamings 12,200 33,000 11,900 11,700 Sales Revenue Rent Expense Depreciation Goods Sol 1,500 2,500 2018 (Note, these were included n the t Cash paid for punchase of tools ofl dividends Requirements Gee sheet tabs at bottom Use each sheet for the following requirements) Prepare the Panama Pajama Company multi-step income statement for the year ended December 31, 2018. Include the EP Nso include a vertical analysis column at the right and perform a vertical analyus of the income statement. (Use percentage format with 1 decimal place.) and perform a vertical analysis of the balance sheet. (Use the percentage format with 1 decimal place.) Complete the analysis of the inancial statements as directed on the Analys sheet 2. Prepare the Panama Pajama Coem pany balance sheet for December 31, 2018. Include a vertical analysis column at the right 3. Preparethe Panama Pajama Company statement of cash Rows for the year ended December 33, 2018. Use the indirect method S. Answer the question Instructions Stmt of Cash Flows Analysis IFRS - 94% 29 : esc 0