LearnHow to Solve All ACC/290 Week 2 Problems with Excel

with excelwizard

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.

• BYP2-2: Hershey + Tootsie Roll
• IFRS2-6: Cole Bowling Alley
• E3-4: Colaw
• E3-8: Crofoot Real Estate
• E3-10: Crofoot Real Estate
• BYP3-2: Hershey + Tootsie Roll
• IFRS 3-2: Zetar PLC
• P3-5A: Foyle Architects
• P3-6A: Solis Company

Fully Explained Problems in the Spreadsheet

preview of the tips you will find in the main excel 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 Calculations Solution Hershey 2046558 - 1173775 \$872,783.00 Tootsie Roll 212201 - 58355 \$153,846.00 ExcelWizard Tip: Working Capital = Current Assets - Current Liabilities Current Ratio 2015 Calculations Solution Hershey 2046558 / 1173775 1.7 Tootsie Roll 212201 / 58355 3.6 ExcelWizard Tip: Current Ratio = Current Assets / Current Liabilities Debt to Assets Ratio 2015 Calculations Solution Hershey 3539551 / 4412199 80.2% Tootsie Roll 191921 / 857856 22.4% ExcelWizard Tip: Debt to Assets = Total Liabilities / Total Assets Free Cash Flow  2015 Calculations Solution 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 Calculations Solution Hershey 628962 / 220688 \$2.85 Tootsie Roll 43938 / 57892 \$0.76 ExcelWizard Tip: EPS = Net Income / Shares Outstanding

This Section is Locked!

Unlock this lesson for \$10 to view all sections.