Question: A computer problem at Southglenn Photography Studios has resulted in incomplete financial statements. Management of the company has asked you to see if you can

A computer problem at Southglenn Photography Studios 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 Southglenn Photography Studios has resulted in

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.

Southglenn Photography Studios Southglemi Photography Studios Income Statement Balance Sheet For the Year Ended December 31,2014 As of December 31,2014 2014 Ratio Assets Ratio Cash 2014 Sales Cost of Goods Sold Gross Profit Operating Expenses Earnings Before Interest and Taxes Interest Expense Earnings Before Taxes 1,500 Ratio 136,500 Formula 378,000 Formula Ratio 450,000 Formula Accounts Receivable 141,000 Inventories Formula Total Current Assets Ratio Gross Fixed Assets Formula Accumulated Depreciation Formula Net Fixed Assets laxe3 Net Income Ratio Total Assets Liabilities and Owner's Equity Accounts Payable Short-tem BankNotes Notes: Tax Rate 30% Total Current Liablities Long-term Debt Common Equity Total Liabilities and Owner's Equity 66,000 Formula Ratio Ratio Ratio Formula

Step by Step Solution

★★★★★

3.54 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style16 msonumberformat 000 000 00220022 msostylenameComma msostyleid3 style0 msonumberformatGeneral textaligngeneral vertical... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

624-B-A-F-A (2181).xlsx

300 KBs Excel File

Students Have Also Explored These Related Accounting Questions!

Q:

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. Recreate the...

Q:

Flanan Photography Studios, Inc. (FPS) is preparing for a court-ordered bankruptcy and has issued the following preliquidation financial statements. TruValue Trustees Services (TTS) has been...

Q:

LilyMac Studios, a national chain of photography studios, is considering opening up a chain of coffee shop/art galleries. While the existing operations of the firm have a beta of 1.17, the new chain...

Q:

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...

Q:

please answer a and b for a good rating. plesse use excel if possible and show/explaon formulas use excel and display formulas if possible 2. A computer problem at Mike Owjai Finance has resulfed in...

Q:

Problems 1. Copy the Big Rock Candy Mountain Mining financial statements from a. Set up a ratio worksheet similar to the one in Exhibit 3-6, page 92, b. Identify at least two areas of potential...

Q:

101 TO 101 Unctions Introduced in this Chapter 1. Copy the Big Rock Candy Mountain Mining financial statements from Problem 1 a. Set up a ratio worksheet similar to the one in Exhibit 3-6, page 99,...

Q:

Part 1 Copy the Big Rock Candy Mountain Mining financial statements from Problem 1 in Chapter 2 into a new workbook. Set up a ratio worksheet similar to the one in Exhibit 3-6, page 99, and calculate...

Q:

do these on an excel please with formulas Sales 2. A computer problem at Mike Owjai Finance has resulted in incomplete financial statements. Management of the company has asked you to see if you can...

Q:

2. A computer problem at Mike Owjai Finance has resulted in incomplete financial statements. Management of the company has asked you to see if you can fill in the missing data. Me Owjal dance Mike...

Q:

We used the data in MEAP93.RAW for Example 2.12. Now we want to explore the relationship between the math pass rate (math10) and spending per student (expend). (i) Do you think each additional dollar...

Q:

Use your answers in question 2 to explain the following statement: The structure of an organizations information system (here a Web storefront) is determined by its competitive strategy. Write your...

Q:

July of the current tax year on a 3-year work assignment with his accounting firm,YK2000. The family purchased a home and the children attend school in Australia. Their previous home in Taiwan was...

Q:

Which of the following accounts represents a resource of the company? A) Common stock B) Service revenue C) Supplies D) Salaries expense

Q:

The Auraria Pet Foods Company is considering the purchase of more flexible equipment that will allow them to create new products and will also be less expensive to operate than the current machinery....

Q:

Chicago Turkey is considering a new turkey farm to service its western region stores. The stores currently require 500,000 turkeys per year, and they are purchased from various local turkey farms for...

Q:

Telluride Tours is currently evaluating two mutually exclusive investments. After doing a scenario analysis and applying probabilities to each scenario, it has determined that the investments have...

Q:

Your employer has asked you to examine the interest-rate risk of your bank relative to your direct competition. Management is concerned that interest rates will fall by the end of the year and wants...

Q:

8. If I find a correlation of .25 between hours of sleep and exam scores a.this means r squared is .0625 b.this means it is a significant relationship c.this means r squared is .05 d.this means it is...

Q:

Question 2 a. Calculate the net present value of the following project for discount rates of 0, 50, and 100%: Cash Flows () C1 C2 -6750 4500 18000 b. What is the IRR of the project