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

b. Complete the financial statements by using formulas that refer to existing data to fill in the remaining cells.

Q3;

Choose your own company and repeat the analysis from Problem 1. You can get the data from MSN Money at http://money.msn.com/investing. To retrieve the data for your company, enter the ticker symbol to get a quote. Now choose Financials and then select the statements. Display the annual income statement, select the entire data section and copy. Now paste this data directly into a new worksheet. The data will be pasted in HTML format. In Excel 2010, a Smart Tag will appear that will allow you to either “Keep Source Formatting” or “Match Destination Formatting.” Experiment to see which one you like best.Repeat these steps for the balance sheet.

Alpha Geek

(8)

Status NEW Posted 06 Aug 2017 12:08 PM My Price 9.00

Ans-----------wer----------- a -----------and----------- b -----------INC-----------OME----------- ST-----------ATE-----------MEN-----------T S-----------ale-----------s $----------- 16-----------0,0-----------00 -----------Cos-----------t o-----------f G-----------ood-----------s S-----------old----------- $ -----------96,-----------000----------- Gr-----------oss----------- Pr-----------ofi-----------t $----------- 64-----------,00-----------0 O-----------per-----------ati-----------ng -----------Exp-----------ens-----------es -----------$ 4-----------7,0-----------00 -----------Ear-----------nin-----------gs -----------bef-----------ore----------- in-----------ter-----------est-----------

Not Rated(0)

• Buy Answer