Abbvie

Abbvie Order Description Conduct a five-year financial statement forecast of Abbvie. In a short memo, provide an explanation of the basis for your identification of the most important forecasting parameters and the logic behind the values you assigned to each parameter. Conclude by identifying the external financing needs and/or capital surplus for Abbvie over the next five years. Address your memo to Ms. Wendy Drennen. Chief Lending officer for Conflag Capital Corporation. Be sure to include a short description of Abbvie’s general business model to create the context for your analysis. Abbott Laboratories        ANNUAL BALANCE SHEET TICKER:    ABT SIC:    2834 GICS:    35101010 Dec-13    Dec-12    Dec-11    Dec-10    Dec-09    Dec-08    Dec-07    Dec-06    Dec-05    Dec-04    Dec-03 ASSETS Cash & Equivalents     $8,098.00      $15,173.98      $8,097.36      $7,323.94      $9,932.05      $5,079.63      $2,820.83      $1,373.44      $2,956.09      $2,058.96      $1,286.42 Net Receivables     $3,986.00      $7,612.86      $7,683.92      $7,184.03      $6,541.94      $5,465.66      $4,946.88      $4,231.14      $3,576.79      $3,696.12      $3,989.41 Inventories     $2,693.00      $3,792.31      $3,284.25      $3,188.73      $3,264.88      $2,775.85      $2,951.44      $2,806.42      $2,541.98      $2,620.46      $2,738.44 Prepaid Expenses     @CF      @CF      @CF      @CF      @CF      @CF      @CF      @CF      @CF      @CF      @CF Other Current Assets     $4,470.00      $4,743.43      $4,703.25      $4,620.82      $3,575.03      $3,721.43      $3,323.59      $2,870.89      $2,311.16      $2,358.95      $2,276.14 ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------ Total Current Assets     $19,247.00      $31,322.58      $23,768.77      $22,317.53      $23,313.89      $17,042.56      $14,042.73      $11,281.88      $11,386.03      $10,734.49      $10,290.42 Gross Plant, Property & Equipment     $12,870.00      $18,928.89      $18,016.56      $17,374.30      $16,486.91      $15,188.67      $15,597.80      $14,401.94      $12,760.42      $12,501.69      $13,290.75 Accumulated Depreciation     $6,965.00      $10,865.84      $10,142.61      $9,403.35      $8,867.42      $7,969.51      $8,079.65      $7,455.50      $6,757.28      $6,493.82      $7,008.94 ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------ Net Plant, Property & Equipment     $5,905.00      $8,063.05      $7,873.96      $7,970.96      $7,619.49      $7,219.17      $7,518.15      $6,946.44      $6,003.14      $6,007.87      $6,281.81 Investments at Equity     $-        $-        $-        $-        $-        $-        $159.00      $162.00      $167.00      $76.00      $340.00 Other Investments     $119.00      $273.60      $378.23      $302.05      $1,132.87      $1,073.74      $1,125.26      $1,229.87      $134.01      $145.85      $406.36 Intangibles     $15,507.00      $24,362.41      $25,695.02      $28,081.71      $19,492.16      $15,138.47      $15,849.32      $15,852.90      $9,960.89      $10,856.72      $8,539.29 Deferred Charges     $-        $-        $-        $-        $-        $-        $-        $-        $-        $-        $- Other Assets     $2,175.00      $3,213.31      $2,560.92      $790.03      $858.21      $1,945.28      $1,019.46      $705.08      $1,490.13      $946.57      $857.47 ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------ TOTAL ASSETS     $42,953.00      $67,234.95      $60,276.90      $59,462.27      $52,416.62      $42,419.20      $39,713.93      $36,178.17      $29,141.20      $28,767.49      $26,715.34 LIABILITIES Long Term Debt Due In One Year     $9.00      $308.82      $1,026.90      $2,044.97      $247.29      $1,956.89      $898.55      $95.28      $1,849.56      $156.03      $1,709.27 Notes Payable     $3,164.00      $2,081.84      $2,347.86      $4,349.80      $4,978.44      $1,691.07      $1,827.36      $5,305.99      $212.45      $1,836.65      $828.09 Accounts Payable     $1,026.00      $1,796.99      $1,721.13      $1,535.76      $1,280.54      $1,351.44      $1,219.53      $1,175.59      $1,032.52      $1,054.46      $1,754.37 Taxes Payable     $175.00      $655.42      $514.95      $1,307.72      $442.14      $805.40      $80.41      $262.34      $488.93      $156.42      $158.84 Accrued Expenses     $4,406.00      $8,215.76      $9,115.12      $7,343.44      $5,480.44      $5,228.05      $4,572.89      $4,658.01      $3,347.94      $3,129.29      $2,805.62 Other Current Liabilities     $727.00      $221.34      $754.28      $680.75      $620.64      $559.06      $504.54      $453.99      $484.12      $492.79      $383.35 ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------ Total Current Liabilities     $9,507.00      $13,280.18      $15,480.23      $17,262.43      $13,049.49      $11,591.91      $9,103.28      $11,951.20      $7,415.51      $6,825.64      $7,639.54 Long Term Debt     $3,388.00      $18,085.30      $12,039.82      $12,523.52      $11,266.29      $8,713.33      $9,487.79      $7,009.66      $4,571.50      $4,787.93      $3,452.33 Deferred Taxes     $466.00      $710.00      @CF      @CF      @CF      $-        $-        $-        $583.08      @CF      @CF Investment Tax Credit     $-        $-        $-        $-        $-        $-        $-        $-        $-        $-        $- Minority Interest     $-        $-        $-        $-        $-        @CF      @CF      @CF      @CF      @CF      @CF Other Liabilities     $4,325.00      $8,346.23      $8,230.70      $7,199.85      $5,202.11      $4,634.42      $3,344.32      $3,163.13      $2,155.84      $2,828.13      $2,551.22 ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------ TOTAL LIABILITIES     $17,686.00      $40,421.71      $35,750.75      $36,985.80      $29,517.90      $24,939.65      $21,935.39      $22,123.99      $14,725.93      $14,441.71      $13,643.08 EQUITY Preferred Stock - Redeemable     $-        $-        $-        $-        $-        $-        $-        $-        $-        $-        $- Preferred Stock - Nonredeemable     $-        $-        $-        $-        $-        $-        $-        $-        $-        $-        $- ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------ Total Preferred Stock     $-        $-        $-        $-        $-        $-        $-        $-        $-        $-        $- Common Stock     $12,048.00      $11,754.55      $9,817.13      $8,744.70      $8,257.87      $7,444.41      $6,104.10      $4,290.93      $3,523.77      $3,239.58      $3,034.05 Capital Surplus     $-        $-        $-        $-        $-        $-        $-        $-        $(46.31)     $(50.11)     $(56.34) Retained Earnings     $19,967.00      $20,557.32      $18,310.18      $17,560.26      $17,908.10      $12,661.54      $12,887.57      $9,958.49      $11,150.07      $11,357.17      $10,324.24 Less: Treasury Stock     $6,844.00      $5,590.91      $3,687.48      $3,916.82      $3,310.35      $2,626.40      $1,213.13      $195.24      $212.26      $220.85      $229.70 ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------ Common Equity     $25,171.00      $26,720.96      $24,439.83      $22,388.14      $22,855.63      $17,479.55      $17,778.54      $14,054.19      $14,415.27      $14,325.78      $13,072.26 ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------ TOTAL EQUITY     $25,171.00      $26,720.96      $24,439.83      $22,388.14      $22,855.63      $17,479.55      $17,778.54      $14,054.19      $14,415.27      $14,325.78      $13,072.26 ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------      ------------------ TOTAL LIABILITIES & EQUITY     $42,953.00      $67,234.95      $60,276.90      $59,462.27      $52,416.62      $42,419.20      $39,713.93      $36,178.17      $29,141.20      $28,767.49      $26,715.34 COMMON SHARES OUTSTANDING      1,548.10      1,576.67      1,570.38      1,546.98      1,551.17      1,552.43      1,549.91      1,537.24      1,539.24      1,560.02      1,564.52 PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT :)