A computer problem at Castle Rock Appliance Repair has resulted in incomplete financial statements. Management of the

Question:

A computer problem at Castle Rock Appliance Repair has resulted in incomplete financial statements. Management of the company has asked you to see if you can fill in the missing data.


A computer problem at Castle Rock Appliance Repair has resulted

a. Recreate the financial statements as shown using formulas with the ratios given below to fill in the cells with the word "Ratio." Use the ROUND function to round each of these answers to the nearest $10.
Ratio Value
Current Ratio................................................ 0.898550
Inventory Turnover*.........................................2.109890
A/R Turnover.............................................. 10.000000
Fixed Asset Turnover...................................... 1.818180
LTD To Equity............................................. 0.395350
Times Interest Earned...................................... 2.786890
Net Profit Margin.......................................... 0.047688
Return on Total Assets.................................... 0.050870
Return on Equity........................................... 0.131440
* Uses Cost of Goods Sold in numerator.
b. Complete the financial statements by using formulas that refer to existing data to fill in the remaining cells.

Financial Statements
Financial statements are the standardized formats to present the financial information related to a business or an organization for its users. Financial statements contain the historical information as well as current period’s financial...
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Financial Analysis with Microsoft Excel

ISBN: 978-1111826246

6th edition

Authors: Timothy R. Mayes, Todd M. Shank

Question Posted: