Learn How to Solve All ACC/290 Week 2 Problems with Excel

with excelwizard

Chtwzjxnq2clfvv4aoju?cache=true

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

Uacwlfjsszgxnihlacbe
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


Full ACC/290 Week 2 Answer Sheet in Excel

This Section is Locked!

Unlock this lesson for $10 to view all sections.

Signup and Unlock for $10

Grades

Nobody has graded this lesson yet.

n 0.0%
Academics Accounting

  • 4 Unlocks
  • 393 Total Reads
  • 16 minutes Est. Learning Time