PLEASE! I need help doing this final project in excel, and I don't know how to please help me out. You can do a screenshot for the excel like I post the question and explain how you get the (workings) calculations.

The Total Assests should be: 9,266,521 and 12,784,053

Financial Statement Project - Spring 2020-3.xls - Compatib Home Insert Draw Page Layout Formulas Data Review View Tell me X Arial 10 ' General V ili II 29 Wrap Text 3. Merge & Center Paste BIU $ %, Con For 134 L M 0 fx B D H Financial Statements Project 3 You are required to prepare the following financial statements using Excel USE EXCEL EFFICIENTLY AND EFFECTIVELY TO COMPLETE THIS PROJECT (cel references, formulas, etc.) 6 (1) Using the data for Tuukka and Crew provided in the shoot labeled "Trial Balance preparo: 7 Balance Sheet-comparative, classified in proper format for fiscal years 2017 and 2018 8 Income Statement - multiple-step for fiscal years 2017 and 2018 Include earnings por share data Statement of Retained Earnings for 2018 Use separate sheets appropriately named for each fnancial statement in good form 11 12 List 5 notes that would be required if you were also preparing the notes to these financial statements 13 Do not prepare the notes, just briefly at the accounts, etc. for which GAAP would require disclosure 14 based on Tuukka financial statements 15 16 17 (2) Using the data for Pastas Pont provided in the shoot labeled "Cash Flows prepare 18 Statement of Cash Flows for fiscal year 2018 in proper format 10 Use a separate shoot, appropriately named, for the Statement of Cash Flows 20 21 22 23 24 25 26 (3) Noss counts Make sure the pages break in appropriate places for printing For instance, make sure the one 27 balance sheet prints out on one page Look at the annual report of your favorite company for help with 28 appropriate formatting, subang, underlining grouping to 29 30 THIS IS A PROJECT TO BE COMPLETED TOTALLY BY EACH STUDENT DO NOT POST 31 QUESTIONS TO THE DISCUSSION BOARD STUDENTS ARE TO RESEARCH ANY QUESTIONS 32 ON THEIR OWN OR ASK ME THROUGH MAIL IN BLACKBOARD 33 34 36 35 37 30 30 Arial Excel File Edit View Insert Format Tools Data Window Help AutoSave Financial Statement Project - Spring 2020-3.xls - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Tell me 12 ' ' = Pv 29 Wrap Text Text Paste Av Merge & Center $ %) Conditional Format Formatting as Table A3 fx December 31, 2018 M Pasta's Paint Ust of items for Statement of Cash Flows Statement December 31, 2018 thousands of dollars) L N 0 1600 200 2.300 3 12000 Dashne Casa Jawy 11 2018 Cash and Gover 1 2018 in expres Berand experime 190 11 in one poste 12 yie 13o saler 14 Posts 15 of 000 21 3.500 HO od 20,000 20 od 33.000 39, 400 50.200 120,000 17 18 for women 10 for purchase 20 pouces 21 Groot 22 free of 23 24 stre de oferte stored 25.000 81.00 00 120.000 0 000 175.000 2.000 139,000 06.200 Instructions Cashflows Trial Dal Shoot + Ready - - ME 138 x v fx D 0 Tuukka and crew List of Accounts from General Ledger in Alphabetical Order December 31, 2018 thousands of dollars) 2017 2018 Dr Dr Cr 999,210 CF 1,079,837 2,943,125 3,245,987 508,643 650 216 126.000 281 364 621,236 721,358 450, 350 90.478 150,190 85.000 1.999,999 402534 299, 304 75 1,829.834 802315 299,304 75 125.430 244,563 249.645 500,220 751329 300.000 284.000 3,673,235 4.500 275 720,125 849,860 62,598 81.236 229,000 449,283 Accounts Payable Accounts Receivable 10 Accrued Liabiles -Other 11 Accrued Pension abilities 12 Accrued Restructuring Changes 13 Acued Salaries, Wages and Commissions 14 Accumulated Other Comprensive Income (1.0) 15 Accumulated Depreciation Property, Plant & Equipment 16 Accumulated Post-Employment Benefit Obligation congtem) 17 Additional Paidin Capital, Common Stock Additional Paidin Capital Preferred Stock Allowance for Doubtful Accounts Bonds Payable Cash and Cash Equivalents Common Stock ($100 par value) Cost of Goods Sold Current Portion of Longtem Debt Deferred Tax Ass (current) pofered Tax Liabilities longtem) Depreciation Expense Dividends-Common Dividends Pred Ceneral Administrative Expenses 31 Goodwill and Other intangibles come Taxes Payable interest Expense nost income Investments in considered and companies Inventos ongtem Dob income from continued Operations et of Primed stock 19 par value Prepaid expenses property. Piant and Equipment Provision for income fare Herach and Development Expense Restung charges Petained tanungin Sating perses homens Stock Meme Revenvee 307,200 292,351 2010 311,236 214.95 MS 1.520 250 3.212.401 248.00 102.56 250,000 19.120 1221 201,000 1,235,000 103,214 2,100 675 324 361 3.223.713 12700 26.100 7453 90 141020 2.943.210 241,105 199,500 109,500 170.00 4.250 302.575 50,000 258.013 2.00.250 0.203.450 5171256 10,450,000 17.01 20.000 4472.000 232 123.0 2002 4,262 45625 Not Incore Weighted avea number of common shares FY 2016 00.40.070 2100 shares 218.464.140 FY 2015 D Instructions CashFlows TrialBal Sheet1 + c. D G 1 Financial Statements Project 3 You are required to prepare the following financial statements using Excel 4 USE EXCEL EFFICIENTLY AND EFFECTIVELY TO COMPLETE THIS PROJECT col references, fomus, 5 6 Using the data for Tuukka and Crew provided in the sheet labeled Tra Balance prepare 7 Balance Sheet-comparative classified in proper format for fcal year 2017 and 2018 Income Statement multiple-step fortscal year 2017 and 2010. Include oamings per share data 9 Statement of Retained Eamings for 2018 10 Use separate sheets, appropriately named for each financial statement in good form 11 12 List 5 notes that would be required you were also preparing the notes to those fnancial statements 13 Do not prepare the notes bryst the accounts etc for which GAAP would required 14 based on Tuukka's financial statements 15 16 17 (2) Using the data for Pasta's Point provided in the shoot labeled "Cash Flows preparo 18 Statement of Cash Flows for fiscal year 2018 in proper format 19 Use a separate sheet appropriately named for the Statement of Cash Flow 20 21 22 23 24 25 26 (3) Neatness counts. Make sure the pages break in appropriate places for printing For instance, make sure the entre 27 balance sheet prints out on one page. Look at the annual report of your favorite company for holo with 28 Appropriate formatting subtotaling underlining grouping, etc. 29 30 THIS IS A PROJECT TO BE COMPLETED TOTALLY BY EACH STUDENTA DO NOT POST 31 QUESTIONS TO THE DISCUSSION BOARD. STUDENTS ARE TO RESEARCH ANY QUESTIONS 32 ON THEIR OWN OR ASK ME THROUGH MAIL IN BLACKBOARD Ta and Crew UMCA from Geren Ledere Are December 31, 2017 2017 2010 De OF 00320 CH 19703337 21.125 32457 650 210 721156 450.30 0476 150.17 85000 2014 10 142434 02.11 299 300 4021 201304 15 7430 2440 24.04 300.000 234.000 26235 4500219 720 125 49 2. 16 779 44.263 AP Art ALLO APEL Accued Residury Charger Acred Stars Wapes Comida ACCO Come como 15 Accumon - Program Accued Pompayant Bened Ceiling Adsen Palencia Common 16 Adweek To Allowance for Doubt Acco 30 Day 21 Chand Cash Como Se 10 para Cost of Sede Guru Ranten of large 29 Dhe Taste Targe 29 Depreciation Experia 20 Dind.Connah Genel Adrive Expert Bowland Orange 2eme Tits P here Een a companies nores song mer Los come to Discoved perion, net of Tax Pred Sanok 19 ) po property. Platan Prvo torines Reserveres Returing Changes Red Eigs begirang ses Ang Epe Shoarm west Teratur Soccer semed Raven 107.200 2011 2.000 1717 429 32124 2010 311216 214955 945 1.520 250 1247491 246001 90230 750.000 10,126 18.227 125.000 214 7 100 675 12401 1213 3200 23.100 100 141.000 2943210 24 100 DOS 106 2,0256 9203450 900 110290 4982250 307 575 65000 755013 $123 10/09 125,890 32,882 4263954 4235 21200221 27 17070 20.000 4472.000 156325 23.21065 23216.458 Nel come Wird erwerage rochas 3 FY 2016 208 448.08 210-480 hans SP Duted FY 2015 Base Du 218 464 10 hares 220 06100 anos IS 120.000 19 Pasta's Point 2 List of items for Statement of Cash Flows Statement December 31, 2018 (thousands of dollars) 5 Cash and Cash Equivalents, January 1, 2018 60.200 7 Cash and Cash Equivalents December 31, 2013 180 200 & Ine have expenses 2.300 9 desena pada perses 960 10 Increase tentos 21350 11 dece income taxes payable 3.500 12 Increase the accounts payable 0.840 13 gainonsa of investment 111.000 14 increase in accountancata 20.000 15 gain one of und 20.500 10 landend payments 39.000 17 depreciation expense 39.900 18 payments for purchase of investments 40,500 19 payments for purchase of equipment 56,200 20 payments for pouchase of land 62 500 21 POReds from sale of land 85,000 22 proceeds from the nuance of stock 81.000 23 proceeds from san oinvestments 100.500 24 natin.com 120.000 25 Payments made to tre bonda payable 160.000 20 proceeds from the seance of a mortgage 175.000 27 payments for purchase of building 187.500 28 29 30 31 32 33 34 35 36 37 38 39 19.000 40 120.000 66,709 Financial Statement Project - Spring 2020-3.xls - Compatib Home Insert Draw Page Layout Formulas Data Review View Tell me X Arial 10 ' General V ili II 29 Wrap Text 3. Merge & Center Paste BIU $ %, Con For 134 L M 0 fx B D H Financial Statements Project 3 You are required to prepare the following financial statements using Excel USE EXCEL EFFICIENTLY AND EFFECTIVELY TO COMPLETE THIS PROJECT (cel references, formulas, etc.) 6 (1) Using the data for Tuukka and Crew provided in the shoot labeled "Trial Balance preparo: 7 Balance Sheet-comparative, classified in proper format for fiscal years 2017 and 2018 8 Income Statement - multiple-step for fiscal years 2017 and 2018 Include earnings por share data Statement of Retained Earnings for 2018 Use separate sheets appropriately named for each fnancial statement in good form 11 12 List 5 notes that would be required if you were also preparing the notes to these financial statements 13 Do not prepare the notes, just briefly at the accounts, etc. for which GAAP would require disclosure 14 based on Tuukka financial statements 15 16 17 (2) Using the data for Pastas Pont provided in the shoot labeled "Cash Flows prepare 18 Statement of Cash Flows for fiscal year 2018 in proper format 10 Use a separate shoot, appropriately named, for the Statement of Cash Flows 20 21 22 23 24 25 26 (3) Noss counts Make sure the pages break in appropriate places for printing For instance, make sure the one 27 balance sheet prints out on one page Look at the annual report of your favorite company for help with 28 appropriate formatting, subang, underlining grouping to 29 30 THIS IS A PROJECT TO BE COMPLETED TOTALLY BY EACH STUDENT DO NOT POST 31 QUESTIONS TO THE DISCUSSION BOARD STUDENTS ARE TO RESEARCH ANY QUESTIONS 32 ON THEIR OWN OR ASK ME THROUGH MAIL IN BLACKBOARD 33 34 36 35 37 30 30 Arial Excel File Edit View Insert Format Tools Data Window Help AutoSave Financial Statement Project - Spring 2020-3.xls - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Tell me 12 ' ' = Pv 29 Wrap Text Text Paste Av Merge & Center $ %) Conditional Format Formatting as Table A3 fx December 31, 2018 M Pasta's Paint Ust of items for Statement of Cash Flows Statement December 31, 2018 thousands of dollars) L N 0 1600 200 2.300 3 12000 Dashne Casa Jawy 11 2018 Cash and Gover 1 2018 in expres Berand experime 190 11 in one poste 12 yie 13o saler 14 Posts 15 of 000 21 3.500 HO od 20,000 20 od 33.000 39, 400 50.200 120,000 17 18 for women 10 for purchase 20 pouces 21 Groot 22 free of 23 24 stre de oferte stored 25.000 81.00 00 120.000 0 000 175.000 2.000 139,000 06.200 Instructions Cashflows Trial Dal Shoot + Ready - - ME 138 x v fx D 0 Tuukka and crew List of Accounts from General Ledger in Alphabetical Order December 31, 2018 thousands of dollars) 2017 2018 Dr Dr Cr 999,210 CF 1,079,837 2,943,125 3,245,987 508,643 650 216 126.000 281 364 621,236 721,358 450, 350 90.478 150,190 85.000 1.999,999 402534 299, 304 75 1,829.834 802315 299,304 75 125.430 244,563 249.645 500,220 751329 300.000 284.000 3,673,235 4.500 275 720,125 849,860 62,598 81.236 229,000 449,283 Accounts Payable Accounts Receivable 10 Accrued Liabiles -Other 11 Accrued Pension abilities 12 Accrued Restructuring Changes 13 Acued Salaries, Wages and Commissions 14 Accumulated Other Comprensive Income (1.0) 15 Accumulated Depreciation Property, Plant & Equipment 16 Accumulated Post-Employment Benefit Obligation congtem) 17 Additional Paidin Capital, Common Stock Additional Paidin Capital Preferred Stock Allowance for Doubtful Accounts Bonds Payable Cash and Cash Equivalents Common Stock ($100 par value) Cost of Goods Sold Current Portion of Longtem Debt Deferred Tax Ass (current) pofered Tax Liabilities longtem) Depreciation Expense Dividends-Common Dividends Pred Ceneral Administrative Expenses 31 Goodwill and Other intangibles come Taxes Payable interest Expense nost income Investments in considered and companies Inventos ongtem Dob income from continued Operations et of Primed stock 19 par value Prepaid expenses property. Piant and Equipment Provision for income fare Herach and Development Expense Restung charges Petained tanungin Sating perses homens Stock Meme Revenvee 307,200 292,351 2010 311,236 214.95 MS 1.520 250 3.212.401 248.00 102.56 250,000 19.120 1221 201,000 1,235,000 103,214 2,100 675 324 361 3.223.713 12700 26.100 7453 90 141020 2.943.210 241,105 199,500 109,500 170.00 4.250 302.575 50,000 258.013 2.00.250 0.203.450 5171256 10,450,000 17.01 20.000 4472.000 232 123.0 2002 4,262 45625 Not Incore Weighted avea number of common shares FY 2016 00.40.070 2100 shares 218.464.140 FY 2015 D Instructions CashFlows TrialBal Sheet1 + c. D G 1 Financial Statements Project 3 You are required to prepare the following financial statements using Excel 4 USE EXCEL EFFICIENTLY AND EFFECTIVELY TO COMPLETE THIS PROJECT col references, fomus, 5 6 Using the data for Tuukka and Crew provided in the sheet labeled Tra Balance prepare 7 Balance Sheet-comparative classified in proper format for fcal year 2017 and 2018 Income Statement multiple-step fortscal year 2017 and 2010. Include oamings per share data 9 Statement of Retained Eamings for 2018 10 Use separate sheets, appropriately named for each financial statement in good form 11 12 List 5 notes that would be required you were also preparing the notes to those fnancial statements 13 Do not prepare the notes bryst the accounts etc for which GAAP would required 14 based on Tuukka's financial statements 15 16 17 (2) Using the data for Pasta's Point provided in the shoot labeled "Cash Flows preparo 18 Statement of Cash Flows for fiscal year 2018 in proper format 19 Use a separate sheet appropriately named for the Statement of Cash Flow 20 21 22 23 24 25 26 (3) Neatness counts. Make sure the pages break in appropriate places for printing For instance, make sure the entre 27 balance sheet prints out on one page. Look at the annual report of your favorite company for holo with 28 Appropriate formatting subtotaling underlining grouping, etc. 29 30 THIS IS A PROJECT TO BE COMPLETED TOTALLY BY EACH STUDENTA DO NOT POST 31 QUESTIONS TO THE DISCUSSION BOARD. STUDENTS ARE TO RESEARCH ANY QUESTIONS 32 ON THEIR OWN OR ASK ME THROUGH MAIL IN BLACKBOARD Ta and Crew UMCA from Geren Ledere Are December 31, 2017 2017 2010 De OF 00320 CH 19703337 21.125 32457 650 210 721156 450.30 0476 150.17 85000 2014 10 142434 02.11 299 300 4021 201304 15 7430 2440 24.04 300.000 234.000 26235 4500219 720 125 49 2. 16 779 44.263 AP Art ALLO APEL Accued Residury Charger Acred Stars Wapes Comida ACCO Come como 15 Accumon - Program Accued Pompayant Bened Ceiling Adsen Palencia Common 16 Adweek To Allowance for Doubt Acco 30 Day 21 Chand Cash Como Se 10 para Cost of Sede Guru Ranten of large 29 Dhe Taste Targe 29 Depreciation Experia 20 Dind.Connah Genel Adrive Expert Bowland Orange 2eme Tits P here Een a companies nores song mer Los come to Discoved perion, net of Tax Pred Sanok 19 ) po property. Platan Prvo torines Reserveres Returing Changes Red Eigs begirang ses Ang Epe Shoarm west Teratur Soccer semed Raven 107.200 2011 2.000 1717 429 32124 2010 311216 214955 945 1.520 250 1247491 246001 90230 750.000 10,126 18.227 125.000 214 7 100 675 12401 1213 3200 23.100 100 141.000 2943210 24 100 DOS 106 2,0256 9203450 900 110290 4982250 307 575 65000 755013 $123 10/09 125,890 32,882 4263954 4235 21200221 27 17070 20.000 4472.000 156325 23.21065 23216.458 Nel come Wird erwerage rochas 3 FY 2016 208 448.08 210-480 hans SP Duted FY 2015 Base Du 218 464 10 hares 220 06100 anos IS 120.000 19 Pasta's Point 2 List of items for Statement of Cash Flows Statement December 31, 2018 (thousands of dollars) 5 Cash and Cash Equivalents, January 1, 2018 60.200 7 Cash and Cash Equivalents December 31, 2013 180 200 & Ine have expenses 2.300 9 desena pada perses 960 10 Increase tentos 21350 11 dece income taxes payable 3.500 12 Increase the accounts payable 0.840 13 gainonsa of investment 111.000 14 increase in accountancata 20.000 15 gain one of und 20.500 10 landend payments 39.000 17 depreciation expense 39.900 18 payments for purchase of investments 40,500 19 payments for purchase of equipment 56,200 20 payments for pouchase of land 62 500 21 POReds from sale of land 85,000 22 proceeds from the nuance of stock 81.000 23 proceeds from san oinvestments 100.500 24 natin.com 120.000 25 Payments made to tre bonda payable 160.000 20 proceeds from the seance of a mortgage 175.000 27 payments for purchase of building 187.500 28 29 30 31 32 33 34 35 36 37 38 39 19.000 40 120.000 66,709