Answered step by step
Verified Expert Solution
Link Copied!

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.
image text in transcribed
image text in transcribed
- 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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions