Description
Attached is a link to an excel spreadsheet with balance sheets for 2015 and 2014 and an income statement for the year ended December 31, 2015. Please answer the questions shown at the bottom of the spreadsheet and show your work, as needed. You should save the worksheet using "SAVE AS" under the same file name with your surname included. For example, my file name would be Module 4 Cash Flow Assignment_Pratt.xlsx. After saving, upload your completed spreadsheet to ELMS.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
FINANCIAL CASH FLOW PROBLEM
Balance Sheet ($ in Millions)
Assets
12/31/2015
12/31/2014
$620
370
830
$1,820
$600
400
900
$1,900
Net Fixed Assests
$2,030
685
$1,345
$2,100
520
$1,580
Total Assets
$3,165
$3,480
Current Assets
Cash
Accounts Receivable
Inventory
Total Current Assets
Fixed Assets
Property, Plant, and Equipment
Less Accumulated Depreciation
Based on the above balance sheets and income statement, calculate the following
values and finan...
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
The English Patient
by Michael Ondaatje
The President is Missing
by James Patterson, Bill Clinton
Mockingjay
by Suzanne Collins
The Elegant Universe
by Brian Greene
Narrative of the Life of Frederick Douglass
by Frederick Douglass
Macbeth
by William Shakespeare
Where'd You Go Bernadette
by Maria Semple
Things That Matter
by Charles Krauthammer