Week3 Finance Assignment Excel

Week3 Finance Assignment Excel - 115 28.75 Net Fixed Asset...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 Balance Sheet Landis Corporation as of December 31 2008 Asset Amount (In Millions) Liabilities Cash 5.75 Account Payable Account Receivable 17.25 Accruals Inventory 28.75 Long Term Bond Net Fixed Asset 46 Notes Payable Common Stock Retained Earnings Total Asset 97.75 Total Liabilities Working Asset Percentage Sales Amount Cash 5.00% 115 5.75 AR 15.00% 115 17.25 Inventory 25.00%
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 115 28.75 Net Fixed Asset 40.00% 115 46 Total Asset 97.75 Liabilities Account Payable 15.00% 115 17.25 Accruals 10.00% 115 11.5 Long term Bond 5 Common Stock 10 Notes Payable (12+5.55) 17.55 Retained Earning(33+115*6%*(1-.50)) 36.45 Total Liab. 97.75 Sheet1 Page 2 Amount (In Millions) 17.25 11.5 5 17.55 10 36.45 97.75...
View Full Document

Page1 / 2

Week3 Finance Assignment Excel - 115 28.75 Net Fixed Asset...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online