Question: i need assistance on how to create an excel spreadsheet with formulas to become identical to the already completed income statement. Attached is the rubric

i need assistance on how to create an excel spreadsheet with formulas to become identical to the already completed income statement. Attached is the rubric for the excel spreadsheet and the completed income statement.
i need assistance on how to create an excel spreadsheet with formulas
to become identical to the already completed income statement. Attached is the

- Comprehensive Problem \#1: This assignment is assigned in CengaeNow which focuses on completing the accounting cycle. You will be limited to a maximum of ten "check my works" in CengageNow. The problem in CengageNow is worth 25 points. Once you have finalized this assignment in CengageNow you will prepare the Income Statement in Microsoft Excel. Please note the placement and data of the required 3-line heading. use of multiple columns, dollar value symbol use as well as single-line rulings and double-line rulings. From the completed CengageNOW problem, you will then input data into an Excel File, 100% of the points will be assigned based on the completion of the student-created Excel file. However, points will only be given if the CengageNOW HW problem has also been completed; this allows you to check your data answers through CengageNOW before used in the creation of the Excel spreadsheet file. Zero points will be awarded for this problem even if the Excel files are correct should the CengageNOW assignment not be completed and submitted through CengageNOW. The grading rubric is as follows: \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{ Kelly Consulting } \\ \hline \multicolumn{3}{|c|}{ Income Statement } \\ \hline \multicolumn{3}{|c|}{ For the Month Ended May 31, 20Y5 } \\ \hline Fees Earned & . & $40,000 \\ \hline & & \\ \hline \multicolumn{3}{|l|}{ Expenses: } \\ \hline Salaries Expense & $1,705 & \\ \hline Advertising Expense & $225 & \\ \hline Telephone Expense & $260 & \\ \hline Utilities Expense & $810 & \\ \hline Insurance Expense & 275 & \\ \hline Supplies Expenses & $1,370 & \\ \hline Depreciation Expense & $330 & \\ \hline Rent Expense & $1,600 & \\ \hline Total Expenses & & $6,575 \\ \hline Net Income & & $33,425 \\ \hline \end{tabular}

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!