Question: i really need help!! follow the directions Excel Financial Statement Project - 15 points Adjusting Entry Information 1. Depreciation has not been booked for the

i really need help!! follow the directions  i really need help!! follow the directions Excel Financial Statement Project
- 15 points Adjusting Entry Information 1. Depreciation has not been booked
for the year. Depreciation is $17,000. 2. Uneamed 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

Excel Financial Statement Project - 15 points Adjusting Entry Information 1. Depreciation has not been booked for the year. Depreciation is $17,000. 2. Uneamed 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. S. 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 formules and links, as are demonstrated to complete this project SH CE + VIC MET ACERIN BUS IMI WHITE BIAN LED AME w HIER FL th, w Adam LE WY M. TI ENTE 1 .. MORE 4 IN HINE SAS LLO WORTH MIVELANDCRUS al EVE 7.00 Hool Cost of 360 LE HD TP. 11.10 OF w AL AW 41 4340700 LIL LE 1.0 4 She WS 432. 19 BASED LIELS Edit View Insert Format Tools Auto Data Window Help BoltForStudentai2021 Review Developer Tal me Home Insert Draw Page Layout Formulas Data Q L- Arla 19 AA Peste Number AA E-9. 3-3-3- Merge Cente $% Con Form 0 If 30.1010-620-30 Cell wat we forma F S De RE I MI RUDE 1 A CRIME w THE SEL INT LE RE BAND LIR 1 pel OTI -F10-1201-4610-301 1 - BE 10 H H w HT HEHE MT H M 18 P WE WIRE O 15 M LI IS TER IRUN us Shot East inc & S Shell Excel Financial Statement Project - 15 points Adjusting Entry Information 1. Depreciation has not been booked for the year. Depreciation is $17,000. 2. Uneamed 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. S. 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 formules and links, as are demonstrated to complete this project SH CE + VIC MET ACERIN BUS IMI WHITE BIAN LED AME w HIER FL th, w Adam LE WY M. TI ENTE 1 .. MORE 4 IN HINE SAS LLO WORTH MIVELANDCRUS al EVE 7.00 Hool Cost of 360 LE HD TP. 11.10 OF w AL AW 41 4340700 LIL LE 1.0 4 She WS 432. 19 BASED LIELS Edit View Insert Format Tools Auto Data Window Help BoltForStudentai2021 Review Developer Tal me Home Insert Draw Page Layout Formulas Data Q L- Arla 19 AA Peste Number AA E-9. 3-3-3- Merge Cente $% Con Form 0 If 30.1010-620-30 Cell wat we forma F S De RE I MI RUDE 1 A CRIME w THE SEL INT LE RE BAND LIR 1 pel OTI -F10-1201-4610-301 1 - BE 10 H H w HT HEHE MT H M 18 P WE WIRE O 15 M LI IS TER IRUN us Shot East inc & S Shell

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!