you will have to zoom in to see but i need help with the balance sheet, statement of income and retained earnings as well as post closing.
use formulas
Excel Financial Statement Project - 15 points Adjusting Entry Information ad 1. Depreciation has not been booked for the year. Depreciation is $17,000. 2. Unearned revenue not yet earned as of yearend is $2,000 3. Federal Income Tax is $25,000 4. Bad Debt Expense is estimated at year end as (0.0025) of net sales. 5. The physical inventory taken at year end is $75,000. dt tal Instructions: ETS CEIV Using the format provided on Bb, complete the adjusting entries outlined above, and complete the worksheet. Use formulas to complete the rows, and foot the columns. Use formulas to prepare the Balance Sheet and income Statement and Retained Earnings Statements on the designated separate worksheets within the workbook. Use formulas to prepare the post-closing trial balance on the designated worksheet. Note: This is an excel project. Therefore, do not calculate numbers by hand and input to the spreadsheet. Use formulas and links, as are demonstrated to complete this project. T LIAS DUNTS 10:18 . 5G Expert Q&A LILLE |||||||| Tools Data Window Help Format File Excel Edit View Insert AB ExcelTBFor Studi AutoSave Data Review Formulas View Developer Tell me Home Insert Draw Page Layout 10 ab General X Calibri (Body) 11 A ili II LI lili BIV 19 $ % H19 f D H 1 XYZ Company BALANCE SHEET AT DECEMBER 31, 2019 AND 2018 ASSETS 2019 2018 7 CURRENT ASSETS 1 9 Tade accounts receivable at 10 About-employee 22 Inventory 12 Prepaid pentes Mates 24 Totalment 25 $0.00 0.00 0.00 0.00 0.00 000 0.00 $15,025 19 004.19 000 100.68100 O DO 0.00 119.770 35 17 36 20 23 25 & RES 22 MacBook A Excel Financial Statement Project - 15 points Adjusting Entry Information ad 1. Depreciation has not been booked for the year. Depreciation is $17,000. 2. Unearned revenue not yet earned as of yearend is $2,000 3. Federal Income Tax is $25,000 4. Bad Debt Expense is estimated at year end as (0.0025) of net sales. 5. The physical inventory taken at year end is $75,000. dt tal Instructions: ETS CEIV Using the format provided on Bb, complete the adjusting entries outlined above, and complete the worksheet. Use formulas to complete the rows, and foot the columns. Use formulas to prepare the Balance Sheet and income Statement and Retained Earnings Statements on the designated separate worksheets within the workbook. Use formulas to prepare the post-closing trial balance on the designated worksheet. Note: This is an excel project. Therefore, do not calculate numbers by hand and input to the spreadsheet. Use formulas and links, as are demonstrated to complete this project. T LIAS DUNTS 10:18 . 5G Expert Q&A LILLE |||||||| Tools Data Window Help Format File Excel Edit View Insert AB ExcelTBFor Studi AutoSave Data Review Formulas View Developer Tell me Home Insert Draw Page Layout 10 ab General X Calibri (Body) 11 A ili II LI lili BIV 19 $ % H19 f D H 1 XYZ Company BALANCE SHEET AT DECEMBER 31, 2019 AND 2018 ASSETS 2019 2018 7 CURRENT ASSETS 1 9 Tade accounts receivable at 10 About-employee 22 Inventory 12 Prepaid pentes Mates 24 Totalment 25 $0.00 0.00 0.00 0.00 0.00 000 0.00 $15,025 19 004.19 000 100.68100 O DO 0.00 119.770 35 17 36 20 23 25 & RES 22 MacBook A
