Posted: December 6th, 2014
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 🙂
Expert paper writers are just a few clicks away
Place an order in 3 easy steps. Takes less than 5 mins.