70.2K

Verified Solution

Link Copied!

you will have to zoom in

Excel Financial Statement Project - 15 points Adjusting Entry Information 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. Instructions: 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. 110 1-10-30-610-30 MT M ACCOUNT TITIE VA TAANI THANE LONTE IR STAR II SIVA TERMS 210 Totate HotFat - BERRIA 11 Dissere AVINAGRONO TAMISE SOFT GAR How 11 ME RE HERRE INTE 1 Warna 009 10 SL NELS LLAH Data Excel File Eart View Format Insert Tools Window Help ExcelTBFor Students Sp2021 Developer Tell me AutoSave View Home Data Insert Draw Page Layout Formules Review Number Arial 10 + A A Merge Center $% 9 12 For Paste 110 -F20-10-4610-10) DENT G DAT CENT OT 440758 284100 11.00 TURI 100001 10100 1000 19 Ocampo 11 Mar 12 13 write LG 22.000 35 1. ISSO 16 11 10000 Rupreciation 11000 were Coo UABILITIES 20 Deep n 1000 a CA 21 cm 24 2010 1 11 LE 112135 1.1 11 1000 100 GLOBO SICHT Lech 22.000 20 11 VAROGA MIT 1 SOLO that Dahl In & RES Shed MacBook Air OSC 30 17 DO 000 Fle EOT Formal Tools Dua Wedom Het Sala View Inn Q Thala Liyaal ToForStudentspap21 Tell me D Data View Develop Free Style O Se 10301000101 H WW UN M THAL SE MacBook Air 188 w 1 2 $ 4 3 % 5 & 7 4 8 1 0 6 9 Q W E R T Y U O Home Insert Draw Page Layout Formulas Number Arial 10 Wrap Text - A A II

Answer & Explanation Solved by verified expert

See Answer