Paste B Font Merge & Center v S% ldeas Conditional Formal Cell Formatting as Table Styles Sort Filter Sensitivity Format Find & Select D48 fx A V N a AOCT 251 EXCEL ASSIGNMENT - PREPARING FINANCIAL STATEMENTS IN EXCEL (see instructions tab for detailed instructions) Pregerea balance sheet ru Serie Prepare a transfer Porter Cangan Ni Durum Try since LT 31, 2017 Cail 15130 Accounts recewbie 1500 Sir - Land 7713 6100 Luigrant Z700130 You and Prepare a Pred amin at man Puiu CUTY Retsinnt minstens Fur the year and 11.2017 dancers Darby 31, 2. $ Vrtincome to the war $ Odend the sharhaldes $ andre $ Pregere Incomeament Purwa Cempat Murstprint Further and Denders, 2012 Sukes revenue Senkers 5 Dapenas Papel operas Rent aree ubiin operas ! suspis crec Tots pense 1.206520 591,680 193.810 12522 780,770 Pano Ch Land 151.2 771 $ ***** 2700 12.5117 12065 125.00 15131 100 101 AG 104 AU 68000 60 1.150 771,30 501 GRC 17ABO 165.130 3513C 202,730 270.000 111 ara 141 360 Inara Eq Suspio Acous Bodable 70442u 165 170 125620 27410 102670 1939 Bush Accounts are 10 Connahark 11 PM 12 Min 13 the laten 14 were able 15 and land LE IT Supple 18 Rantepas 19 OM 20 cents per 21 Equat 22 Sapi 23 Saks papaik 24 Nowa 25 26 160.0 1,150 203,720 1,001,160 347.3GP 341,160 6,360 301,36 babal els 52,2144 Accounts hates pel Sabri este Oderliablties Commar Ch antha.. Randemns Serie Uliks pats Palapese Surprises Rente 25.10 591.680 1,305,SAD 125.620 704/30 17.450 155,170 3.252570 1,252,570 2R 29 30 31 32 34 15 36 27 36 39 40 41 42 43 45 46 47 49 50 51 52 53 Assento estoin 10 ic less > Paste BI Merge & Center ldeas Conditional Format Formatting as Table Cell Styles Format Sort & Filter Find & Select Sensitivity D48 4 Answerte urtant ID Answers Question h11) Arowurte destaan n.12) way she sustard 200 A BA Return on Hamun way Bamins Shane Current Ratio Otto Evky a Answers Question 16) Paste B / U Merge & Center = = = ldeas Conditional Format Cell Formatting as Table Styles Sort X Filter Sensitivity Format Find Select E52 fx B D M A U w Y Z AA Step 2 Qular pest your comme freded from 11 to27inchames thoughts Stu:27 nalurns Hitrough SunParler Deva Palmalin"lab... ra pestay HS through 27 mat same la Porter vs Pabals Inball. Cose your spreadsheet fo-Cesel Project 11. Al work in utesent steps should be done of the "Portero vs Palede Indtat. Replace alours in the Parter Corporation income statemente retained camins, and balance sheet in Amay HE 527) mich fomulis rendre amous in the Porte Corporado Trial Balance fur sami in nad of the man 120h Styped ilu: the cel, the col should have the formu: -22 initialed. This student for alcuns in the Purier Loperation for wins. At he end of this step.nc cel in columns C.F.A.M. Nors should have numbers in them, but iretesdal should be populated with formuss. Siapa 314 35 16 27 38 99 40 41 42 43 44 45 46 47 48 49 50 51 52 53 Copy and paste al Information in row 5 10 27 imorows 29 to 51 After this step, itu formules in the following seles should be Am.nl 110 199910 NBS 759.770 S43043 2214.00 542 042 361.130 Step 4 Change the name of the company on the tree and statements in Row 29 to "Pak Alain Step 5 55 56 57 58 59 CO 61 Replace luse copy paste the information is columns Fon 34 to Row 52 with the folontaray of normation. This information will be Fachle Inc. Scenarol Amounts. Pale Ale Inc. Scariol Amounts: Service Pr. 41023,720 Uitpense 4211 JINA: Cash 5.146.240 Accounts receivable 5,440.000 German 3446.240 Parol 2945121 Bulaires 23.120.000 Other lates 216240 Inces payable 39.100 land 252262401 Retained eaming 20,117,120 Supples capens 593,640 MIES 5615.20 Tiends N773 Accounts payable 6.892.450 Equipment 9.180.000 Surplus 6.165 240 Sabates peab Notes payable 24,046,240 64 65 66 69 70 71 72 73 SIG 75 76 77 78 79 20 81 Check that the titule have the work in the forme Cell Destion Formua Total 140 Net Income 6.592.340 NBS and S41 Retained Eamings 25,822.180 143 Tutal Assis 25278,720 5 Total Labtes 16100330 S42 Total Stockhokers Ecuy 29.278,420 Siep? Accuentoitu right of this lange right of columnd using the Stammand. 24 Stseb Adria come to the right of the asset babices on the balance sheet to ther'sha of what row Column Batterportoint steal Paste Merge & Center = = = S % ldeas Conditional Formal Cell Formatting as Table Styles Sort & X Filter Sensitivity Format Find Select ES2 fx C D MN P H T U W Y AA 81 Si acum other night of the rester alenes so the night of column using the rart Sememand Best Ada column so the right of the asset babances on the balance sheet to the right of what is now column Rafter perfoming step 72). Step 7b And accumsathe right of the labely and equity habances on the balance sheet to the right of what is now come afte performing step 7h) 84 85 Ah 27 88 89 901 91 92 S1 da Populate Column with vertical coommonsis) analysis roties for Porter Corporation zing Service Revenue as the base amount Use an ABSOLLITE REFERENCE in the formu a furthermount. Step 8b Once you have created the tomus in Cell , use the copy/paste functions to populate the remaining ratios incolumn At the end of die step, allamours incum , must be poplated with fomulas with only reference cel no numbers included in die Pow.las. The farmlessed semperages with no da mal pris. Endilomale could include all wence. Populate Columns 5 and of the balance sheet with vertical common-szej analysis ratios for Porter Corporation with Total Assets as the base amount of the ratos Felow the instruction of steps 81-8b to perfom diep. Step a 94 S5 96 97 SH s9 100 Slep 9 Repeat steps in the much for Palee Inc Step 10 Answer the clowing question in mageredel 153 Pale Ale made 34 times more income than Porter Tp 186.6M HINS $104 ms that meat Pale Ale is more Reader will then Porier Lo? Why or why not 103 104 Step 11 Arower delelowing question in magerdoel 155 Pale Ale 34 debutan Hart Ca S 16M VS $1AM). Does this will be on debt to france its cry than Purier Lo? Why or why not 100 107 108 Step 12 Arower the clowing question in mergerade1159 Which campery do you think is w latter? Why or wtry ret? Step 13 110 111 112 111 114 115 116 117 118 119 120 Change the amounts in the following ocis to the following Pale Ale scenario 12 Amounts: Call Description Pale Ale Scenario A2 Amour Svi LUKKE 033 Account Resetable 20 000 000 234 Common Stock 15 000.030 236 wyrol Eden 40.000.000 1111101112 03 Ovidends 12 000 000 844 Accounts Payable 22478500 122 123 ched that all I has the following mons Description Pale Ale Scenario 12 Amount Net Income 5125 250 Tulal ASSAL 89.828.720 Totalt whis 61111 Total Stockholders Eauty 28252430 125 126 127 Slep 15 Using the last 2 Amount from Sp 13, perform ratio analysis Insels storing formides only.porubate the formatie Prorit Margir. Rebum on Assets. Return on Equity. Eamings Per Share, Current Ratio and Debt to Equity Patio SCHIhanachotamstolach 130 *** 121 Paste BI UW Merge & Center ldeas Conditional Formal Cell Formatting as Table Styles Sort X Filter Sensitivity Format Find Select E52 fx A B C G H M P H T U W Y Z AA 117 118 119 120 121 D E B42 Rent Expanse B3 Divine Mounts Payable 10.000 12.100 224750 Step 14 123 124 125 Check that Pak Alence has the following amonts. Description Pale Ale Sorris A2 Amount Net Income Total Assets 89.88,720 Total Liabilitas 61,586320 Tuta Slaktes tauly 20252 A 127 123 129 Step 15 Using the new Pall Scenario 12 Amounts from Soep 13, perfom ratio analysk. Inols 165 to L70, sing formulas only, populate the following ati Perit Marieluma Asorts, turn on any, tamns PrStar Creator Debt to Espio Assume that al balance sheet amounts are the averages for the year Assume that Notes Payable is long command al other labi ities are current Ube share amours in row 64 for Eamings PerStars 131 132 133 134 135 136 137 Step 16 Arewershefcloutre question in mergesel 171: After reviewing the financial statements of Porer Coand Palce Socnario 2, and the resulting verdical analysis and ratio of each company. which company do you think is einaste wir? 139 140 14 14 147 151 152 153 157 159 160 161 164 167 Paste B Font Merge & Center v S% ldeas Conditional Formal Cell Formatting as Table Styles Sort Filter Sensitivity Format Find & Select D48 fx A V N a AOCT 251 EXCEL ASSIGNMENT - PREPARING FINANCIAL STATEMENTS IN EXCEL (see instructions tab for detailed instructions) Pregerea balance sheet ru Serie Prepare a transfer Porter Cangan Ni Durum Try since LT 31, 2017 Cail 15130 Accounts recewbie 1500 Sir - Land 7713 6100 Luigrant Z700130 You and Prepare a Pred amin at man Puiu CUTY Retsinnt minstens Fur the year and 11.2017 dancers Darby 31, 2. $ Vrtincome to the war $ Odend the sharhaldes $ andre $ Pregere Incomeament Purwa Cempat Murstprint Further and Denders, 2012 Sukes revenue Senkers 5 Dapenas Papel operas Rent aree ubiin operas ! suspis crec Tots pense 1.206520 591,680 193.810 12522 780,770 Pano Ch Land 151.2 771 $ ***** 2700 12.5117 12065 125.00 15131 100 101 AG 104 AU 68000 60 1.150 771,30 501 GRC 17ABO 165.130 3513C 202,730 270.000 111 ara 141 360 Inara Eq Suspio Acous Bodable 70442u 165 170 125620 27410 102670 1939 Bush Accounts are 10 Connahark 11 PM 12 Min 13 the laten 14 were able 15 and land LE IT Supple 18 Rantepas 19 OM 20 cents per 21 Equat 22 Sapi 23 Saks papaik 24 Nowa 25 26 160.0 1,150 203,720 1,001,160 347.3GP 341,160 6,360 301,36 babal els 52,2144 Accounts hates pel Sabri este Oderliablties Commar Ch antha.. Randemns Serie Uliks pats Palapese Surprises Rente 25.10 591.680 1,305,SAD 125.620 704/30 17.450 155,170 3.252570 1,252,570 2R 29 30 31 32 34 15 36 27 36 39 40 41 42 43 45 46 47 49 50 51 52 53 Assento estoin 10 ic less > Paste BI Merge & Center ldeas Conditional Format Formatting as Table Cell Styles Format Sort & Filter Find & Select Sensitivity D48 4 Answerte urtant ID Answers Question h11) Arowurte destaan n.12) way she sustard 200 A BA Return on Hamun way Bamins Shane Current Ratio Otto Evky a Answers Question 16) Paste B / U Merge & Center = = = ldeas Conditional Format Cell Formatting as Table Styles Sort X Filter Sensitivity Format Find Select E52 fx B D M A U w Y Z AA Step 2 Qular pest your comme freded from 11 to27inchames thoughts Stu:27 nalurns Hitrough SunParler Deva Palmalin"lab... ra pestay HS through 27 mat same la Porter vs Pabals Inball. Cose your spreadsheet fo-Cesel Project 11. Al work in utesent steps should be done of the "Portero vs Palede Indtat. Replace alours in the Parter Corporation income statemente retained camins, and balance sheet in Amay HE 527) mich fomulis rendre amous in the Porte Corporado Trial Balance fur sami in nad of the man 120h Styped ilu: the cel, the col should have the formu: -22 initialed. This student for alcuns in the Purier Loperation for wins. At he end of this step.nc cel in columns C.F.A.M. Nors should have numbers in them, but iretesdal should be populated with formuss. Siapa 314 35 16 27 38 99 40 41 42 43 44 45 46 47 48 49 50 51 52 53 Copy and paste al Information in row 5 10 27 imorows 29 to 51 After this step, itu formules in the following seles should be Am.nl 110 199910 NBS 759.770 S43043 2214.00 542 042 361.130 Step 4 Change the name of the company on the tree and statements in Row 29 to "Pak Alain Step 5 55 56 57 58 59 CO 61 Replace luse copy paste the information is columns Fon 34 to Row 52 with the folontaray of normation. This information will be Fachle Inc. Scenarol Amounts. Pale Ale Inc. Scariol Amounts: Service Pr. 41023,720 Uitpense 4211 JINA: Cash 5.146.240 Accounts receivable 5,440.000 German 3446.240 Parol 2945121 Bulaires 23.120.000 Other lates 216240 Inces payable 39.100 land 252262401 Retained eaming 20,117,120 Supples capens 593,640 MIES 5615.20 Tiends N773 Accounts payable 6.892.450 Equipment 9.180.000 Surplus 6.165 240 Sabates peab Notes payable 24,046,240 64 65 66 69 70 71 72 73 SIG 75 76 77 78 79 20 81 Check that the titule have the work in the forme Cell Destion Formua Total 140 Net Income 6.592.340 NBS and S41 Retained Eamings 25,822.180 143 Tutal Assis 25278,720 5 Total Labtes 16100330 S42 Total Stockhokers Ecuy 29.278,420 Siep? Accuentoitu right of this lange right of columnd using the Stammand. 24 Stseb Adria come to the right of the asset babices on the balance sheet to ther'sha of what row Column Batterportoint steal Paste Merge & Center = = = S % ldeas Conditional Formal Cell Formatting as Table Styles Sort & X Filter Sensitivity Format Find Select ES2 fx C D MN P H T U W Y AA 81 Si acum other night of the rester alenes so the night of column using the rart Sememand Best Ada column so the right of the asset babances on the balance sheet to the right of what is now column Rafter perfoming step 72). Step 7b And accumsathe right of the labely and equity habances on the balance sheet to the right of what is now come afte performing step 7h) 84 85 Ah 27 88 89 901 91 92 S1 da Populate Column with vertical coommonsis) analysis roties for Porter Corporation zing Service Revenue as the base amount Use an ABSOLLITE REFERENCE in the formu a furthermount. Step 8b Once you have created the tomus in Cell , use the copy/paste functions to populate the remaining ratios incolumn At the end of die step, allamours incum , must be poplated with fomulas with only reference cel no numbers included in die Pow.las. The farmlessed semperages with no da mal pris. Endilomale could include all wence. Populate Columns 5 and of the balance sheet with vertical common-szej analysis ratios for Porter Corporation with Total Assets as the base amount of the ratos Felow the instruction of steps 81-8b to perfom diep. Step a 94 S5 96 97 SH s9 100 Slep 9 Repeat steps in the much for Palee Inc Step 10 Answer the clowing question in mageredel 153 Pale Ale made 34 times more income than Porter Tp 186.6M HINS $104 ms that meat Pale Ale is more Reader will then Porier Lo? Why or why not 103 104 Step 11 Arower delelowing question in magerdoel 155 Pale Ale 34 debutan Hart Ca S 16M VS $1AM). Does this will be on debt to france its cry than Purier Lo? Why or why not 100 107 108 Step 12 Arower the clowing question in mergerade1159 Which campery do you think is w latter? Why or wtry ret? Step 13 110 111 112 111 114 115 116 117 118 119 120 Change the amounts in the following ocis to the following Pale Ale scenario 12 Amounts: Call Description Pale Ale Scenario A2 Amour Svi LUKKE 033 Account Resetable 20 000 000 234 Common Stock 15 000.030 236 wyrol Eden 40.000.000 1111101112 03 Ovidends 12 000 000 844 Accounts Payable 22478500 122 123 ched that all I has the following mons Description Pale Ale Scenario 12 Amount Net Income 5125 250 Tulal ASSAL 89.828.720 Totalt whis 61111 Total Stockholders Eauty 28252430 125 126 127 Slep 15 Using the last 2 Amount from Sp 13, perform ratio analysis Insels storing formides only.porubate the formatie Prorit Margir. Rebum on Assets. Return on Equity. Eamings Per Share, Current Ratio and Debt to Equity Patio SCHIhanachotamstolach 130 *** 121 Paste BI UW Merge & Center ldeas Conditional Formal Cell Formatting as Table Styles Sort X Filter Sensitivity Format Find Select E52 fx A B C G H M P H T U W Y Z AA 117 118 119 120 121 D E B42 Rent Expanse B3 Divine Mounts Payable 10.000 12.100 224750 Step 14 123 124 125 Check that Pak Alence has the following amonts. Description Pale Ale Sorris A2 Amount Net Income Total Assets 89.88,720 Total Liabilitas 61,586320 Tuta Slaktes tauly 20252 A 127 123 129 Step 15 Using the new Pall Scenario 12 Amounts from Soep 13, perfom ratio analysk. Inols 165 to L70, sing formulas only, populate the following ati Perit Marieluma Asorts, turn on any, tamns PrStar Creator Debt to Espio Assume that al balance sheet amounts are the averages for the year Assume that Notes Payable is long command al other labi ities are current Ube share amours in row 64 for Eamings PerStars 131 132 133 134 135 136 137 Step 16 Arewershefcloutre question in mergesel 171: After reviewing the financial statements of Porer Coand Palce Socnario 2, and the resulting verdical analysis and ratio of each company. which company do you think is einaste wir? 139 140 14 14 147 151 152 153 157 159 160 161 164 167