The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 398 Weeks Ago, 2 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
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.
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll