Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with the following assignment in Excel. Weekly Discussions: A discussion topic related to the SEC 10K project will be posted each week.Answers

I need help with the following assignment in Excel.

Weekly Discussions:

A discussion topic related to the SEC 10K project will be posted each week.Answers to these weekly discussion questions may be used in your final deliverables, thus much of the work is completed in Weeks 2 through 5.

On Your Own:

DRAFT financial analysis in Excel. The spreadsheet should include 4 worksheets as follows:

1.Company information

2.Income Statement

3.Balance Sheet

4.Financial statement ratios related to accounts specific to cost accounting for your corporation. Vertical and horizontal analysis are important, particularly for the income statement. Consider cost components.How are they changing from year to year? How is the balance sheet, especially stockholders' equity, changing? For example, ratios related to the three inventory accounts, calculation of cost of goods sold, different product line sales in relation to total sales, etc.Be creative and create meaningful cost accounting ratios to assist management's decision making.

a.Formulas must be embedded into the cells (preferable) or written beside the cells.

b.If you do not know how to create formulas in Excel, click the following link and take a free 40-50 minute training course offered by Microsoft:http://office.microsoft.com/en-us/excel-help/overview-RZ101773335.aspx?section=1or use other resources.

I have the first three parts done, I just need help with the ratios. Not sure what all to show. and not sure how to upload my excel file that I have already done. please advise.

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

Corporate Finance

Authors: Stephen Ross, Randolph Westerfield, Jeffrey Jaffe, Bradford Jordan

12th edition

1259918947, 1260091908, 978-1259918940

More Books

Students also viewed these Accounting questions