Questions
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin...

Compute and Interpret Liquidity, Solvency and Coverage Ratios
Balance sheets and income statements for Lockheed Martin Corporation follow. Refer to these financial statements to answer the requirements.

Income Statement
Year Ended December 31 (In millions) 2005 2004 2003
Net sales
Products $ 31,518 $ 30,202 $ 27,290
Service 5,695 5,324 4,534
37,213 35,526 31,824
Cost of sales
Products 27,882 27,637 25,306
Service 5,073 4,765 4,099
Unallocated coporate costs 803 914 443
33,758 33,316 29,848
3,455 2,210 1,976
Other income (expenses), net (449) (121) 43
Operating profit 3,006 2,089 2,019
Interest expense 370 425 487
Earnings before taxes 2,636 1,664 1,532
Income tax expense 811 398 479
Net earnings $ 1,825 $ 1,266 $ 1,053
Balance Sheet
December 31 (In millions) 2005 2004
Assets
Cash and cash equivalents $ 2,164 $ 780
Short-term investments 429 396
Receivables 4,579 4,094
Inventories 1,921 1,864
Deferred income taxes 861 982
Other current assets 495 557
Total current assets 10,449 8,673
Property, plant and equipment, net 3,924 3,599
Investments in equity securities 196 812
Goodwill 8,447 7,892
Purchased intangibles, net 560 672
Prepaid pension asset 1,360 1,030
Other assets 2,728 2,596
Total assets $ 27,664 $ 25,274
Liabilities and stockholders' equity
Accounts payable $ 1,998 $ 1,726
Customer advances and amounts in excess of costs incurred 4,331 4,028
Salaries, benefits and payroll taxes 1,475 1,346
Current maturities of long-term debt 202 15
Other current liabilities 1,422 1,451
Total current liabilities 9,428 8,566
Long-term debt 4,664 5,264
Accrued pension liabilities 2,097 1,300
Other postretirement benefit liabilities 1,277 1,236
Other liabilities 2,331 1,887
Stockholders' equity
Common stock, $1 par value per share 432 438
Additional paid-in capital 1,724 2,223
Retained earnings 7,278 5,915
Accumulated other comprehensive loss (1,553) (1,532)
Other (14) (23)
Total stockholders' equity 7,867 7,021
Total liabilities and stockholders' equity $ 27,664 $ 25,274
Consolidated Statement of Cash Flows
Year Ended December 31 (In millions) 2005 2004 2003
Operating Activities
Net earnings $ 1,825 $ 1,266 $ 1,053
Adjustments to reconcile net earnings to net cash provided by operating activities
Depreciation and amortization 555 511 480
Amortization of purchased intangibles 150 145 129
Deferred federal income taxes 24 (58) 467
Changes in operating assets and liabilities:
Receivables (390) (87) (258)
Inventories (39) 519 (94)
Accounts payable 239 288 330
Customer advances and amounts in excess of costs incurred 296 (228) (285)
Other 534 568 (13)
Net cash provided by operating activities 3,194 2,924 1,809
Investing Activities
Expenditures for property, plant and equipment (865) (769) (687)
Acquisition of business/investments in affiliated companies (84) (91) (821)
Proceeds from divestiture of businesses/Investments in affiliated companies 935 279 234
Purchase of short-term investments, net (33) (156) (240)
Other 28 29 53
Net cash used for investing activities (19) (708) (1,461)
Financing Activities
repayment of long-term debt (413) (1,369) (2,202)
Issuances of long-term debt -- -- 1,000
Long-term debt repayment and issuance costs (12) (163) (175)
Issuances of common stock 406 164 44
Repurchases of common stock (1,310) (673) (482)
Common stock dividends (462) (405) (261)
Net cash used for financing activities (1,791) (2,446) (2,076)
Net increase (decrease) in cash and cash equivalents 1,384 (230) (1,728)
Cash and cash equivalents at beginning of year 780 1,010 2,738
Cash and cash equivalents at end of year $ 2,164 $ 780 $ 1,010

(a) Compute Lockheed Martin's current ratio and quick ratio for 2005 and 2004. (Round your answers to two decimal places.)
2005 current ratio = Answer


2004 current ratio = Answer



2005 quick ratio = Answer


2004 quick ratio = Answer






(b) Compute total liabilities-to-equity ratios and total debt-to-equity ratios for 2005 and 2004. (Round your answers to two decimal places.)
2005 total liabilities-to-stockholders' equity = Answer


2004 total liabilities-to-stockholders' equity = Answer



2005 total debt-to-equity = Answer


2004 total debt-to-equity = Answer





(c) Compute times interest earned ratio, cash from operations to total debt ratio, and free operating cash flow to total debt ratios. (Round your answers to two decimal places.)
2005 times interest earned = Answer


2004 times interest earned = Answer



2005 cash from operations to total debt = Answer


2004 cash from operations to total debt = Answer



2005 free operating cash flow to total debt = Answer


2004 free operating cash flow to total debt = Answer

In: Accounting

3. (5 pts) The following time series depicts US Total New Housing Units (in thousands), Jul2003...

3. (5 pts) The following time series depicts US Total New Housing Units (in thousands), Jul2003 - Dec2005
Time Period Housing
Jul 2003 1 175.8 a. Use Excel to calculate a simple housing index for every month, Jul2003 - Dec2005.
Aug 2 163.8       Use Jul2003 as the base.
Sep 3 171.3
Oct 4 173.5
Nov 5 153.7 b. Comment on the trend in the Housing Index from Jul 2003 to Dec 2005.
Dec 6 144.2       Explain the meaning of your Dec2005 index value.
Jan 2004 7 124.5
Feb 8 126.4
Mar 9 173.8
Apr 10 179.5
May 11 187.6
Jun 12 172.3
Jul 13 182.0
Aug 14 185.9
Sep 15 164.0
Oct 16 161.3
Nov 17 138.1
Dec 18 140.2
Jan 2005 19 142.9
Feb 20 149.1
Mar 21 156.2
Apr 22 184.6
May 23 197.9
Jun 24 192.8
Jul 25 187.6
Aug 26 192.0
Sep 27 187.9
Oct 28 180.4
Nov 29 160.7
Dec 30 136.0

In: Statistics and Probability

1. looking at the value of a publicly traded company does not provide an indication of...

1. looking at the value of a publicly traded company does not provide an indication of the value of a privately held company. True or false

2. The lack of marketability discount applies to noncontrolling ownership interest valuations. true or false

3. when recasting earnings, we must add back the items on the income statement that are in essence owner discretion items. These include owner's excessive compensation perks travel vacation homes etc. True or false

4. revenue ruling 59-60 recognizes the diffculty in valuing a privately held company, and reognizes the added value achieved by averaging various approaches to value. True or False

5. it would not be surprising for a valuator to have the same markeability discount for a controlling interest as they would when valuing a minority interest. true or false.

6. the illiquidity discount will not be applied to controlling owenership interest and business. true or false

7. histprical data is much harder to defend than future earnings forecasts, because the past financials are just history and the future is what will most likely occur. true or false

In: Finance

1. looking at the value of a publicly traded company does not provide an indication of...

1. looking at the value of a publicly traded company does not provide an indication of the value of a privately held company. True or false

2. The lack of marketability discount applies to noncontrolling ownership interest valuations. true or false

3. when recasting earnings, we must add back the items on the income statement that are in essence owner discretion items. These include owner's excessive compensation perks travel vacation homes etc. True or false

4. revenue ruling 59-60 recognizes the diffculty in valuing a privately held company, and reognizes the added value achieved by averaging various approaches to value. True or False

5. it would not be surprising for a valuator to have the same markeability discount for a controlling interest as they would when valuing a minority interest. true or false.

6. the illiquidity discount will not be applied to controlling owenership interest and business. true or false

7. histprical data is much harder to defend than future earnings forecasts, because the past financials are just history and the future is what will most likely occur. true or false

In: Finance

Assume that you are the CEO of a small publicly traded company. The operating performance of...

Assume that you are the CEO of a small publicly traded company. The operating performance of your company has fallen below market expectations, which is reflected in a depressed stock price. At your direction, your CFO provides you with the following recommendations that are designed to increase your company’s return on net operating assets (RNOA) and your operating cash flows, both of which will, presumably, result in improved financial performance and an increased stock price. , LO#2.1 #3.1 1. To improved net cash flows from operating activities, the CFO recommends that your company reduce inventories (raw material, work-in-process, and finished goods) and receivables (through selective credit granting and increased emphasis on collection of past-due accounts). 2. The CFO recommends that your company sell and lease back its office building. The lease will be structure so as to be classified as an operating lease under GAAP. The assets will, therefore, not be iincluded in the computation of the net ooperating assets (NOA), thus increasing RNOA. Evaluate each of the CFO recommendations. In your evaluation consider whether the recommendation will positively impact the operating pperformance of your company or whether it is cosmetic in nature.

In: Accounting

Allstate Corporation, a publicly traded insurance company, currently offers an annuity product for prospective retirees. A...

Allstate Corporation, a publicly traded insurance company, currently offers an annuity product for prospective retirees. A customer will receive an end-of-year annual payment of 25,000$ for each of 5 years, beginning at the end of Year 30. If the customer requires a return of 11%, what is the fair price of this product? Show the time line.

In: Finance

List the three financial statements required to be provided to the Securities and Exchange Commission by...

List the three financial statements required to be provided to the Securities and Exchange Commission by all publicly traded companies.

In: Finance

What is an example of a SMART annual objective for say a huge publicly traded high...

What is an example of a SMART annual objective for say a huge publicly traded high market cap bank?

In: Economics

We learned the differences between accounting for inventory under the FIFO, LIFO, and average costing methods....

We learned the differences between accounting for inventory under the FIFO, LIFO, and average costing methods. Additionally, we explored how the income statement impact may differ under each of the three methods.

Pick a retail company and research which method the company uses to account for inventory. Note: Please select publicly traded companies, as this will make the information easier to locate.

In: Accounting

In java, ask the user for a filename. Display the oldest car for every manufacturer from...

In java, ask the user for a filename. Display the oldest car for every manufacturer from that file.

Files Given:

car-list.txt

car-list-1.txt

car-list-2.txt

car-list-3.txt

(they are too big for question)

Required Output:

Standard Input                 Files in the same directory
car-list-1.txt
  • car-list.txt
  • car-list-1.txt
  • car-list-2.txt
  • car-list-3.txt
Enter filename\n
Oldest cars by make\n
          Acura                   Legend 1989 2T1BPRHE8EC858192\n
           Audi                    80/90 1988 2GKALMEK4E6424961\n
        Bentley  Continental Flying Spur 2006 WBA3G7C5XFK430850\n
            BMW                      600 1959 1N6AA0ED2FN639969\n
        Bugatti                   Veyron 2009 SCFEBBBC5AG474636\n
          Buick                  Century 1987 2HNYD18625H455550\n
       Cadillac                  DeVille 1994 19UUA56793A243886\n
      Chevrolet                   Camaro 1968 WAUDF98E18A693314\n
       Chrysler           Town & Country 1996 1GYS4EEJ3DR377025\n
          Dodge                  Charger 1970 WBAEW53475P758543\n
          Eagle                   Vision 1995 SCFHDDAJ3AA914259\n
        Ferrari          599 GTB Fiorano 2010 2G61M5S34E9207892\n
           Ford                 Fairlane 1966 2G4WF551041378204\n
            GMC              Sonoma Club 1992 WAUBFAFL9DN784019\n
          Honda                     CR-X 1984 1FT7W2A66EE489233\n
         Hummer                       H2 2008 5N1AR2MM0FC360861\n
        Hyundai                Entourage 2008 1GYS3SKJ7FR311229\n
       Infiniti                        Q 1992 SCFEBBAK0CG532695\n
          Isuzu                    Space 1994 2T1BURHEXEC222169\n
         Jaguar                   X-Type 2006 2G4GU5GV2C9513452\n
           Jeep                 Cherokee 1995 5XYKT3A67FG750891\n
            Kia                  Spectra 2006 2C3CDYAG7EH527567\n
    Lamborghini                 Countach 1988 JTMHY7AJ1B5630207\n
     Land Rover              Range Rover 1988 5UXFE8C59AL755549\n
          Lexus                       LS 1993 WAUNF78P97A339372\n
        Lincoln              Continental 1988 WAUXL68E74A407027\n
          Lotus                    Elise 2007 5NPEB4AC8CH254031\n
       Maserati                  Biturbo 1987 1G4HF57909U685797\n
        Maybach                       57 2004 1ZVBP8AM3B5509118\n
          Mazda                      626 1984 WUARL48H69K855595\n
  Mercedes-Benz                  S-Class 1986 JN1BJ0HP2EM742216\n
        Mercury                   Cougar 1970 WBANE73577C052898\n
     Mitsubishi                  Starion 1985 WAUSF98E66A919061\n
         Morgan                   Aero 8 2007 WBA3C3G57FN486516\n
         Nissan                    Quest 2001 1D4PT4GX3BW366571\n
     Oldsmobile           Custom Cruiser 1992 WDDHF5KB6FB836573\n
          Panoz                Esperante 2006 1G6KD57Y67U241895\n
       Plymouth                  Voyager 1992 WBAWB73589P509971\n
        Pontiac                  Tempest 1965 WBAKA4C59BC513301\n
        Porsche                      911 1986 JTHBE1KS8A0650998\n
    Rolls-Royce                  Phantom 2005 WAUCFAFH6EN529880\n
           Saab                     9000 1989 WBAVA37528N742448\n
         Saturn                      VUE 2006 1FBAX2CM5FK123544\n
          Scion                       xB 2006 4T3BA3BB7CU135336\n
         Shelby                    GT350 1969 KL4CJESB0FB714062\n
     Studebaker                   Avanti 1962 1GD312CG5DF955034\n
         Subaru                    Justy 1990 KM8JT3AB2CU942198\n
         Suzuki                       SJ 1986 WAU4FAFR9AA736195\n
         Toyota                   Celica 1982 3VWF17AT4FM332454\n
     Volkswagen                     Golf 1987 WDCYC7DF8FX386498\n
          Volvo                      850 1995 1GD312CG7BF949846\n
51 result(s)\n

Test Case 2

Standard Input                 Files in the same directory
car-list-2.txt
  • car-list.txt
  • car-list-1.txt
  • car-list-2.txt
  • car-list-3.txt
Enter filename\n
Oldest cars by make\n
          Acura                  Integra 1995 WBA3B5G54EN915107\n
     Alfa Romeo                      164 1994 5GAER23758J589585\n
           Audi                    4000s 1985 JN8AF5MR9DT832857\n
        Bentley  Continental Flying Spur 2007 JN1BY0AP0AM634709\n
            BMW                      600 1959 KNADM5A36E6321537\n
        Bugatti                   Veyron 2009 SCFEBBBC5AG474636\n
          Buick                 Somerset 1985 5N1AA0NC1DN101234\n
       Cadillac                  DeVille 1994 19UUA56793A243886\n
      Chevrolet                 Corvette 1953 3GYFNGEY7BS365963\n
       Chrysler                   Cirrus 1999 1GYFC33249R710666\n
         Daewoo                    Lanos 2002 KNDMG4C79E6368226\n
          Dodge                     Omni 1978 SALGR2VF2FA732350\n
          Eagle                   Summit 1996 KNAGM4AD9D5309595\n
        Ferrari             430 Scuderia 2008 1HGCP2E70CA912895\n
           Ford                 Fairlane 1966 2G4WF551041378204\n
            Geo                    Prizm 1994 SALGS2DF9DA398353\n
            GMC         Rally Wagon 3500 1993 1N6AF0KX1EN730343\n
          Honda                  Prelude 1985 19UUA76667A337717\n
        Hyundai                 Santa Fe 2001 JTDKN3DP0C3011229\n
       Infiniti                        Q 1992 1G4HP52K444142193\n
          Isuzu                  Trooper 1997 4F2CY0C75BK199939\n
         Jaguar                   X-Type 2006 2G4GU5GV2C9513452\n
           Jeep           Grand Cherokee 2003 1GYFK43549R321965\n
            Kia                   Sephia 1995 4F2CY0C77AK663764\n
    Lamborghini                 Countach 1989 1FTSW2A51AE796515\n
     Land Rover              Range Rover 1988 5UXFE8C59AL755549\n
          Lexus                       LS 1991 1G4HF57959U054981\n
        Lincoln                 Town Car 1989 1D7RV1CT3BS523594\n
          Lotus                     Elan 1990 WBANA53575C102986\n
       Maserati             Quattroporte 1984 1G6DS5E31C0696841\n
        Maybach                       57 2003 JTJBJRBZ7F2575213\n
          Mazda                      626 1985 19UUA56663A426458\n
  Mercedes-Benz                     W201 1991 SCFFBCCD3BG450032\n
        Mercury                   Cougar 1970 WBANE73577C052898\n
           MINI                   Cooper 2002 WBAYP1C51FD265309\n
     Mitsubishi                  Starion 1985 WAUSF98E66A919061\n
         Nissan                       NX 1992 WAUDV74F98N860145\n
     Oldsmobile                 Toronado 1992 JH4DC54893S582029\n
          Panoz                Esperante 2005 WA1CMAFE4ED877109\n
        Peugeot                      207 2007 3C63DPBL8CG511366\n
       Plymouth                  Voyager 1992 WBAWB73589P509971\n
        Pontiac                  Tempest 1965 WBAKA4C59BC513301\n
        Porsche                      911 1986 JTHBE1KS8A0650998\n
    Rolls-Royce                  Phantom 2005 WAUCFAFH6EN529880\n
           Saab                     9000 1989 WBAVA37528N742448\n
         Saturn                 S-Series 2002 2T1KU4EE6DC200286\n
          Scion                       xD 2011 YV1672MC1AJ515133\n
         Shelby                    GT350 1969 KL4CJESB0FB714062\n
         Subaru                     Brat 1986 3D7TT2CT3BG995173\n
         Suzuki                       SJ 1988 1D4PU5GK6BW944265\n
         Toyota                   Celica 1982 3VWF17AT4FM332454\n
     Volkswagen                   Passat 1987 1G6DV1EP8C0229130\n
          Volvo                      C70 1998 2C3CDZBT6FH112033\n
53 result(s)\n

Test Case 3

Standard Input                 Files in the same directory
car-list-3.txt
  • car-list.txt
  • car-list-1.txt
  • car-list-2.txt
  • car-list-3.txt
Enter filename\n
Oldest cars by make\n
          Acura                   Legend 1989 2T1BPRHE8EC858192\n
   Aston Martin              DB9 Volante 2006 KNDKG3A24A7680578\n
           Audi                    80/90 1988 2GKALMEK4E6424961\n
        Bentley  Continental Flying Spur 2006 2C3CCABG2CH411828\n
            BMW                      600 1959 1N6AA0ED2FN639969\n
          Buick                  Skylark 1986 1G6AB5R31F0410780\n
       Cadillac                  DeVille 1994 19UUA56793A243886\n
      Chevrolet                  Corvair 1960 1GTN1TEH5FZ654712\n
       Chrysler                 Imperial 1926 3N1CE2CP2FL275760\n
       Citroën                       CX 1989 1N6AA0CJ6EN188987\n
          Dodge                  Charger 1970 WBAEW53475P758543\n
          Eagle                   Vision 1995 SCFHDDAJ3AA914259\n
        Ferrari          599 GTB Fiorano 2010 2G61M5S34E9207892\n
           Ford                  Mustang 1971 WAUWFAFR6DA642708\n
            Geo                    Prizm 1993 SCFEDCAD4CG747594\n
            GMC              Sonoma Club 1992 WAUBFAFL9DN784019\n
          Honda                     CR-X 1984 1FT7W2A66EE489233\n
         Hummer                       H2 2008 5N1AR2MM0FC360861\n
        Hyundai                    XG350 2002 WAUFMAFC2EN588576\n
       Infiniti                        Q 1992 SCFEBBAK0CG532695\n
          Isuzu                    Space 1994 2T1BURHEXEC222169\n
         Jaguar                   S-Type 2001 WBASN2C55DC838510\n
           Jeep                 Cherokee 1995 5XYKT3A67FG750891\n
            Kia                  Spectra 2006 2C3CDYAG7EH527567\n
    Lamborghini                 Countach 1988 JTMHY7AJ1B5630207\n
     Land Rover              Range Rover 1988 5UXFE8C59AL755549\n
          Lexus                       LS 1993 WAUNF78P97A339372\n
        Lincoln              Continental 1988 WAUXL68E74A407027\n
          Lotus                    Exige 2004 1D7RV1CT6AS741379\n
        Maybach                       57 2004 1ZVBP8AM3B5509118\n
          Mazda                      626 1984 WUARL48H69K855595\n
  Mercedes-Benz                  S-Class 1986 JN1BJ0HP2EM742216\n
        Mercury                   Cougar 1970 WBANE73577C052898\n
     Mitsubishi                   Galant 1986 5N1AT2ML1EC611331\n
         Morgan                   Aero 8 2007 WBA3C3G57FN486516\n
         Nissan                       NX 1992 WAUDV74F98N860145\n
     Oldsmobile                 Toronado 1992 JH4DC54893S582029\n
          Panoz                Esperante 2008 3D73Y4EL2AG593685\n
       Plymouth                   Volare 1976 1G6EL12Y32B567559\n
        Pontiac                  Tempest 1965 WBAKA4C59BC513301\n
        Porsche                      911 1986 WBSBR93426P234215\n
    Rolls-Royce                    Ghost 2012 1D7RE2GK4BS527662\n
           Saab                      900 1996 ZFBCFACH5FZ823825\n
         Saturn                      VUE 2006 1FBAX2CM5FK123544\n
          Scion                       xB 2006 4T3BA3BB7CU135336\n
         Shelby                    GT350 1969 KL4CJESB0FB714062\n
     Studebaker                   Avanti 1962 1GD312CG5DF955034\n
         Subaru                    Justy 1990 KM8JT3AB2CU942198\n
         Suzuki                       SJ 1986 WAU4FAFR9AA736195\n
         Toyota                      MR2 1986 JTDKTUD35ED964783\n
     Volkswagen                     Golf 1987 WDCYC7DF8FX386498\n
          Volvo                      850 1995 1GD312CG7BF949846\n
52 result(s)\n

A few lines of cars-list that might help:

make    model  year   vin
Lexus  LX 2010   4T3BA3BB8CU505032
Dodge  Ram Van B350   1994   5N1CR2MNXEC243935
Volkswagen Type 2 1986   WAUDF48H17K529096
Buick  Lucerne    2011   1FTNX2A57AE582302
Isuzu  Axiom  2004   WBA3A5C53EP267014
GMC    3500 Club Coupe    1995   WBAEK73435B009775
Jaguar XF 2012   WBAFR7C50CC926771
Toyota Tacoma 2010   JTEBU5JR2C5510537
BMW    X6 M   2013   1D7RB1CT9BS271133
Pontiac    GTO    1964   WAUJFAFH5DN416041
Volkswagen CC 2013   1C3CCBAG9EN215371
Ford   LTD Crown Victoria 1993   WBXPA93424W053318
Ford   Aerostar   1994   1FMEU6FE6AU161181
Volvo  S60    2001   WAUSF78E27A949809
Mitsubishi Eclipse    1991   1FTEW1C80AK681226
Volkswagen Touareg    2004   1B3CB5HA6AD986681
Volvo  S80    2002   WBAYA8C58FG901796
Acura  RL 2008   19UUA66268A236346
Porsche    928    1986   2T1BURHE2FC730993
Buick  Somerset   1987   WAUCKAFR5AA102258
Volkswagen Touareg    2010   WAUKF98P49A574439
Chevrolet  Express    2006   JH4KB163X7C282844
Dodge  Charger    2011   WBAHL83566D244296
Toyota Matrix 2012   2C3CCAEG0FH601353
Chevrolet  2500   2000   WAUBF48H37K132190
Jaguar XK Series  2005   19UUA9F25BA671349
Hummer H3 2006   1FMEU6EE2AU658326
Lincoln    MKT    2010   1GT022CG3EF969732
Mitsubishi Galant 1997   WBAUC73528V077781
Lotus  Exige  2006   2T2BK1BA6EC560905
Suzuki Sidekick   1993   3C3CFFAR1DT265678
Mercury    Cougar 1993   3C63D3JL5CG653202
Dodge  Ram Wagon B350 1994   3VWKP7AJ8DM315908
Chevrolet  G-Series G20   1992   1D4RE5GG2BC413258
BMW    M3 2009   5N1AN0NUXFN200196
BMW    X5 2004   WAUUL78E75A789974
Ford   E-Series   1996   WP1AE2A27CL645373
Mazda  Mazda6 2007   WBAYP9C58ED417275
Mazda  Tribute    2005   19UUA9F76CA390478
Lotus  Elise  2007   1G6DJ5EG7A0576643
Dodge  Dakota 2002   WBA3A9C5XFK249518
Volkswagen Quantum    1984   WBANV13548C686202
Lexus  RX 2001   KM8JT3AB2DU052530
Pontiac    Turbo Firefly  1990   5NPDH4AE1CH808652
Land Rover Freelander 2010   4T1BD1EB7EU689348
Acura  NSX    2002   1FTNF2B54AE400508
Mercedes-Benz  SL-Class   2002   WBA3B9G54FN126853
Cadillac   Escalade   2004   2T1BU4EEXCC690200
Toyota Camry Solara   2008   3GYFNFE36FS186821

Notes in program and right format if possible, thanks. You can use any of the sorting searches like bubble or selection search or QuickSort since this is the section we are working on.

P.S This was the question I was given, I can't edit it to give more detail and I can't edit the outputs needed to have anything else because those are non editable and so are the given files.

In: Computer Science