Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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. - 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
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started