Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the formula and the excel skill to fill all the yellow blank. The file I attached on that post. I am really appreciated for

image text in transcribed

Use the formula and the excel skill to fill all the yellow blank. The file I attached on that post.

I am really appreciated for your help and I am waiting for your support as soon as possible.

Thank you

image text in transcribed QUESTION 2 PHILIPPE CORPORATION Statement of Financial Position ASSETS 2012 215 $ $ 328 853 $ 1,072 $ 6,085 $ 7,157 $ 207 $ 1,427 $ 2,308 $ $ #VALUE! $ $ 1,987 1,000 2,248 3,248 Current Assets $ Cash Accounts Receivable $ $ Inventory Total 2011 210 355 Fixed Assets Net Plant and Equipment Total assets LIABILITIES AND OWNER'S EQUITY Current liabilities Accounts Payable Notes Payable Total Long-Term Debt O/E Common Stock 500 shares outstandin Retained Earnings Total Equity Total Liabilities and O/E PHILIPPE CORPORATION Statement of Comprehensive Income Sales 75% Credit $ 2012 4,053 $ 550 $ 502 $ $ 8.48 times 992 12.00 Cost of goods Sold Depreciation EBIT Interest Paid EBT 34% Taxes Net Income Dividends $ 47 Additions to R/E Additional Information Inventory Turnover Additions to fixed Assets Market Price of the Stock REQUIRED Using the additional information, complete the missing information on the Financial Statements where TBC is indicated Calculate the following information; Current Ratio Quick Ratio Times Interest Earned EPS Receivables Turnover Total Debt Ratio Price/Earnings Ratio Profit Margin

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental accounting principle

Authors: John J. Wild, Ken W. Shaw, Barbara Chiappetta

21st edition

1259119831, 9781259311703, 978-1259119835, 1259311708, 978-0078025587

Students also viewed these Finance questions

Question

1. Show enthusiasm for the subject you teach.

Answered: 1 week ago