Let's Learn ACC290 Week 2 Accounting Step-By-Step
In this lesson, I will show you how to solve every problem in ACC/290 week 2 using Microsoft Excel. You will get introduced into intermediate accounting problems and learn how to prepare financial statements.
Here's a summary of the Problems we will Solve in this lesson.
Fully Explained Problems in the Spreadsheet
BYP2-2: Hershey + Tootsie Roll
Based on the information in the financial statements, compute these 2011 values for each company. (Do not adjust for the LIFO reserve.) Below is a quick preview of the solutions. Make sure to unlock my lesson and download the full excel spreadsheet for the full experience.
Sample of Solutions
|Working Capital 2015|
|Hershey||2046558 - 1173775||$872,783.00|
|Tootsie Roll||212201 - 58355||$153,846.00|
|ExcelWizard Tip: Working Capital = Current Assets - Current Liabilities|
|Current Ratio 2015|
|Hershey||2046558 / 1173775||1.7|
|Tootsie Roll||212201 / 58355||3.6|
|ExcelWizard Tip: Current Ratio = Current Assets / Current Liabilities|
|Debt to Assets Ratio 2015|
|Hershey||3539551 / 4412199||80.2%|
|Tootsie Roll||191921 / 857856||22.4%|
|ExcelWizard Tip: Debt to Assets = Total Liabilities / Total Assets|
|Free Cash Flow 2015|
|Hershey||580867 - (323961 + 304083)||-$47,177.00|
|Tootsie Roll||50390 - (16351 + 18407)||$15,632.00|
|ExcelWizard Tip: Free Cash Flow = Net Cash from Operating Activities - (Capital Expenditures + Dividends)|
|Earnings Per Share 2015|
|Hershey||628962 / 220688||$2.85|
|Tootsie Roll||43938 / 57892||$0.76|
|ExcelWizard Tip: EPS = Net Income / Shares Outstanding|
Full ACC/290 Week 2 Answer Sheet in Excel
This Section is Locked!
Unlock this lesson for $10 to view all sections.
Nobody has graded this lesson yet.
- I've been working with Microsoft Excel since the early 1990's. My primary skill-set involves programming advanced excel macros for use in finance, data analysis, and education.