Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
Use formulas to calculate the ratios listed in column G for the BIG Company and the GOODE Company. Place your formulas into the yellow cells
Use formulas to calculate the ratios listed in column G for the BIG Company and the GOODE Company. Place your formulas into the yellow cells in columns H and I.Do not just type in the answers, the formula will calculate it for you. After the excel sheet is complete, please explain and indicate which company you think would be a better investment. Just resend the finished excel document and have the answer typed. Thank you so much.
CHT 2015 Results Goode Company 2016 Results (select) Big Company Goode Company Big Company Balance Sheet Cash Accounts receivable (net) Inventory Operating Assets fixed (net) Other Assets $ $ $ $ $ 41,000 38,000 99,000 140,000 84,000 $ $ $ $ $ 21,000 31,000 $ 40,000 $ 401,000 $ 305,000 18,000 $ 94,000 $ 154,000 $ 38,000 44,000 441,000 Total Assets $ 402,000 $ 798,000 $ 385,000 $ 841,000 Current Liabilities Long term debt* Common Stock Retained Earnings $ $ $ $ 99,000 65,000 177,000 61,000 49,000 60,000 $ 618,000 $ 71,000 $ 60,000 $ 177,000 $ 49,000 $ 48,000 618,000 126,000 Total Liabilities and SE $ 402,000 $ 798,000 Income Statement Revenue** Cost of Goods Sold Total Expenses Net Income $ $ $ $ 447,000 241,000 161,000 45,000 $ $ $ $ 802,000 398,000 311,000 93,000 17.00 $ 30% 15.00 30% 33,000 $ 17,700 34,000 $ 148,000 61,800 144,000 Other Data Ending 2013 Stock Price Tax Rate $ Dividends Declared and Paid for 2013 $ Shares Outstanding Cash flow from operations $ $ $ $ $ 17,700 61,800 Notes * Long term debt obligations carry an annual interest rate of 10% for both companies. ** 1/3 of the revenue from both companies is from credit sales. Both companies compete in the same industry. Goode Company Ratio Return on Equity Return on Assets Financial Leverage Earnings per Share Quality of Income Profit Margin Fixed Asset Turnover Cash Ratio Current Ratio Quick Ratio Receivable Turnover Inventory Turnover Times Interest Earned Debt to Equity P/E Ratio Dividend Yield Big CompanyStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started