Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can anyone help me with this accounting homework? I have the attachment of the question below. And this work required to complete in excel file.

Can anyone help me with this accounting homework? I have the attachment of the question below. And this work required to complete in excel file.

image text in transcribed Goal 5 Applying Excel Horizontal Analysis Vertical Analysis The goal of this assignment is for students to demonstrate their ability to use Microsoft Excel both proficiently and professionally. Requirements: 1. Complete only one Excel file with four spreadsheets (TABS) as follows: Horizontal Analysis Show formulas for Horizontal spreadsheet Vertical Analysis Show formulas for Vertical spreadsheet 2. 3. 4. 5. Round all percentages to the tenth decimal place. Format your spreadsheets exactly like the Exhibits in the chapter material. Place your name at the top left corner of each spreadsheet in your workbook. Review the PRINT AREA of each spreadsheet so they will print most effectively. Following each of the above requirements will be factored into the grading of this assignment. Additional Information and Hints: Complete this assignment by properly and professionally formatting your spreadsheet. Hints: All numbers must be formatted and numbers should always line up in a spreadsheet. Watch out when you format with symbols. Use them appropriately and make sure the digits line up in every column. View exhibits in your book as a reference. You are to use the Underline and Double Underline feature in Excel, do not use BORDER features for your lines/underlines. Use formulas to complete the computational components of this assignment. There are many formulas that can be used to obtain the desired results, however, you are to demonstrate your ability to choose the most \"efficient\" formula. I have provided links in the Competence in Technology content section of D2L to assist you. Even when you are first setting up your spreadsheet with the given information, use formulas when totaling or subtotaling as data crosscheck. To show the formulas, you will to copy your assignment to a new tab and then choose the show formulas feature, then properly format this spreadsheet for easy viewing and printing, and SAVE it. To check that this format was saved properly, you should close and reopen your file to review it. If the settings do not stay, please make a note of it in the D2L assignment box comments section. Working with others and/or sharing files: The purpose of this assignment is to determine each student's competence in using technology. All students have completed courses in this topic area and all students have access to resources in order to demonstrate their ability to apply their knowledge. Working with others and/or sharing files (continued): As such, helping others or working with others must be done with academic integrity. What this means is that each student will assume responsibility for their work and the materials submitted in fulfillment of these requirements. All work must represent each student's own efforts. Academic dishonesty includes but is not limited to: Copying work submitted by another student. Material copied directly from an online or printed source without reference. Allowing a friend or classmate to complete part of your coursework. You are expected to be honest in completing this assignment. Please remember, sharing any file is prohibited and you will receive a zero and be turned into the Office of Student Conduct and Conflict Resolution for further consequences. Here are the financial statements that you are to use. STARTER COMPANY Income Statement For the Years Ended December 31 2016 Revenues Sales (net) Other revenues $ 318,000 22,000 2015 $ 146,000 25,000 Total revenues Expenses Cost of goods sold Selling, general, and administrative Research and development expense Other expenses 340,000 171,000 145,000 14,000 22,000 47,000 62,000 5,000 9,000 22,000 Total expenses Income before income tax Income tax expense 228,000 112,000 25,000 98,000 73,000 21,000 Net income $ 87,000 $ 52,000 STARTER COMPANY Balance Sheets As of December 31 2016 Assets Current assets Cash Marketable securities Accounts receivable (net) Inventories Prepaid items Total current assets Investments Plant (net) Land Total assets Liabilities and Stockholders' Equity Liabilities Current liabilities Accounts payable Notes payable Salaries payable Total current liabilities Noncurrent liabilities Bonds payable Other Total noncurrent liabilities Total liabilities Stockholders' equity Common stock (No par; 50,000 shares authorized; 10,000 shares issued) Retained earnings Total stockholders' equity Total liabilities and stockholders' equity $ 427,000 50,000 104,000 160,000 25,000 766,000 52,000 379,000 29,000 1,226,000 $ $ $ 33,000 15,000 21,000 69,000 2015 $ $ $ 349,000 24,000 96,000 143,000 10,000 622,000 20,000 288,000 24,000 954,000 46,000 9,000 15,000 124,000 200,000 24,000 224,000 293,000 200,000 27,000 227,000 297,000 80,000 853,000 933,000 80,000 577,000 657,000 1,226,000 $ 954,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Financial Accounting

Authors: Carl S. Warren, Christine Jonick, Jennifer Schneider

16th Edition

1337913103, 9781337913102

More Books

Students also viewed these Accounting questions

Question

What is the purpose of the NOT keyword?

Answered: 1 week ago

Question

Write a program to check an input year is leap or not.

Answered: 1 week ago

Question

Write short notes on departmentation.

Answered: 1 week ago

Question

What are the factors affecting organisation structure?

Answered: 1 week ago

Question

What are the features of Management?

Answered: 1 week ago

Question

Briefly explain the advantages of 'Management by Objectives'

Answered: 1 week ago

Question

Improving creative problem-solving ability.

Answered: 1 week ago