Details of this Paper

Financial accounts and stock

Description

solution


Question

Hi - Wanted to know if you would be able to help with the following;1.Company A & B - Looking to establish the value of Company A & Stock price and a Price range to offer for company B to acquire Company A;2.Company C& D- Trying to value the companies and determine if merging will be beneficial by end year 2003;Please show all performance evaluations and work;Attachment Preview;Company Value & Acquisitions Analysis.xlsx Download Attachment;A;B;3;F;G;Acquiring Company B;45;46;47;48;49;50;51;52;53;54;55;56;57;58;59;60;61;62;63;64;65;66;67;68;69;70;71;72;73;74;75;76;77;78;79;80;81;82;83;E;Balance Sheets;(in millions of dollars);44;D;Target Company A;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18;19;20;21;22;23;24;25;26;27;28;29;30;31;32;33;34;35;36;37;38;39;40;41;42;43;C;Balance Sheets (Partial);(in millions of dollars);Assets;Cash and equivalents;Short-term investments;Accounts receivable;Inventories;Other Current Assets;Total current assets;Long Term Investments;Net plant and equipment;Intangible Assets;Deposits and other Assets;Total assets;Liabilities and equity;Accounts payable;Accued Comp;Accrued clinical trail costs;Accrued Interest;Accrued Expenss & other Liabilities;Current Capital Lease Obligation;Long Term Obligations;Total current liabilities;Deferred Rent;Deferred Revenue;Capital Lease obligations, less current portion;Long Term Obligations, less current portion;Total liabilities;Preferred stock ();Common stock ();Paid in Capital;Notes receivable;Deferred Compensation;Accumulated Deficit;Total Stockholder's equity (Deficit);Total liabilities and equity;Assets;Cash and equivalents;Marketable Securities;Trade receivable net;Inventor, net;Deferred Tax Assets;Other Current Asset;Total current assets;Property & Equipment, net;Deferred tax assets, net;Intangible Assets;Deposits and other Assets;Total assets;2000;$64,662;$67,651;$23,288;$4,264;$2,691;$162,556;$4,506;$27,707;$48,046;$5,924;$248,739;1999;$28,081;$24,235;$3,241;$2,082;$1,009;$58,648;$0;$25,635;$0;$7,411;$91,694;$5,106;$4,978;$1,974;$695;$7,654;$9;$5,945;$26,361;$2,095;$9,750;$0;$89,947;$128,153;$0;$25;$394,012;-$50;$0;-$273,401;$120,586;$248,739;$3,038;$1,739;$846;$1,438;$6,591;$101;$2,680;$16,433;$2,214;$0;$9;$112,657;$131,313;$0;$17;$143,822;-$83;-$96;-$183,279;-$39,619;$91,694;As of December 31, 2000;Corporate commercial paper;U.S. Corporate bonds;U.S. Government Agency Obligations;Total assets;Property and Eq;(in millions of;Property & Equipment;Manufacturing;Short-term investments;Accounts receivable;Inventories;Other Current Assets;Total current assets;Long Term Investments;Net plant and equipment;Intangible Assets;Deposits and other Assets;Total assets;Product Sa;(in millions of;2000;$84,974;$406,455;$115,635;$46,633;$22,319;$11,796;$687,812;$86,383;$194,761;$34,825;$2,794;$1,006,575;1999;$36,570;$214,750;$86,894;$31,777;$23,132;$8,715;$401,838;$87,452;$128,990;$19,074;$11,070;$648,424;As of December 31, 1999;Product A;Product B;Product C;Product D;Total;Stock Perfor;(in millions of;Liabilities and equity;Accounts payable Trade;Accued Exp;product Royalties payable;Deferred Revenu;Other Liabilities;$3,090;$72,159;$40,553;$33,966;$1,697;$2,995;$65,300;$28,527;$0;$2,130;Total current liabilities;$151,465;$98,952;$9,595;$1,933;$162,993;$0;$0;$0;$0;$0;$10,366;$2,027;$111,345;$0;$0;$0;$0;$0;$0;$0;$111,345;Long Term Obligations, less current portion;Other Liabilities;Total liabilities;Preferred stock ();Common stock ();Paid in Capital;Notes receivable;Deferred Compensation;Accumulated Deficit;Total Stockholder's equity (Deficit);Total liabilities and equity;As of December 31, 1999;Corporate Commercial Paper;U.S. Corporate Notes;U.S. Corporate Bonds;U.S. Government agency obligations;Municipal bonds;Total;$0;$162,993;1st Quarter;2nd Quarter;3rd Quarter;4th Quarter;Year End Close;A;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18;19;20;21;22;23;24;25;26;27;28;29;30;31;32;33;34;35;36;37;38;39;40;41;42;43;44;45;46;47;48;49;50;51;52;53;54;55;56;57;58;59;60;61;62;63;64;65;66;67;68;69;70;71;72;73;74;75;76;77;78;79;80;81;82;83;84;85;86;87;88;89;90;91;92;93;94;95;96;97;98;99;100;101;102;103;104;105;106;107;108;109;110;111;112;113;114;115;116;117;118;119;120;121;122;123;124;125;126;127;128;129;130;131;132;133;134;135;136;137;138;139;140;141;142;143;144;145;146;147;148;149;150;151;152;153;154;155;156;157;158;159;160;161;162;163;164;165;166;167;168;169;170;171;172;173;174;175;176;177;178;179;180;181;182;183;184;185;186;187;188;189;190;191;192;193;194;195;196;197;198;199;200;201;202;203;204;205;206;207;208;209;210;211;212;213;214;215;216;217;218;219;220;221;222;223;224;225;226;227;228;229;230;231;232;233;234;235;236;237;238;239;240;241;242;243;244;245;246;247;248;249;250;251;252;253;254;255;256;257;258;259;260;261;262;263;264;265;266;267;268;269;270;271;272;273;274;275;276;277;278;279;280;281;282;283;284;285;286;287;288;289;290;291;292;293;294;295;296;297;298;299;300;301;302;303;304;305;306;307;308;309;310;311;312;313;314;315;316;317;318;319;320;321;322;323;324;325;326;327;328;329;330;331;332;333;334;335;336;337;338;339;340;341;342;343;344;B;C;D;E;Company C;Company C - Balance Sheets;(in millions of dollars);Assets;Cash and equivalents;Short-term investments;Accounts receivable;Financing Receivables;Inventories;Other Curretn Assets;Total current assets;Property Plant & equipment;Long term Investment assets;Net operations;Total assets;#NAME?;$3,415;$592;$6,394;$2,174;$5,699;$4,970;$23,244;$6,265;$4,500;$0;$34,009;#NAME?;$5,411;$179;$5,958;$1,889;$4,863;$3,342;$21,642;$4,333;$5,789;$3,533;$35,297;$1,555;$5,049;$1,584;$2,046;$1,759;$3,204;$15,197;$3,105;$3,517;$1,287;$2,152;$1,437;$2,823;$14,321;Long Term debt;Others;Total liabilities;$3,402;$1,201;$19,800;$1,764;$917;$17,002;Common stock;Retained Earning;Other income;Total Stockholder's equity;Total liabilities and equity;$19;$14,097;$93;$14,209;$34,009;$20;$18,275;$0;$18,295;$35,297;#NAME?;$2,569;$0;$6,715;$1,677;$2,161;$1,989;$15,111;$3,431;$6,314;$24,856;#NAME?;$2,666;$636;$5,622;$1,063;$2,008;$1,854;$13,849;$3,249;$10,179;$27,277;$711;$4,233;$1,089;$5,516;$11,549;$453;$4,380;$872;$6,133;$11,838;$575;$652;$12,776;$0;$605;$12,443;$8,039;$5,347;$27;-$1,333;$12,080;$24,856;$7,627;$4,948;$2,919;-$660;$14,834;$27,277;Liabilities and equity;Notes Payable;Acounts Payable;Employee Compensation;Taxes;Deferred Revenues;Others;Total current liabilities;Company D;Balance Sheets;(in millions of dollars);Assets;Cash and equivalents;Short-term investments;trade accounts receivable, net;Leases & other accounts rec;Inventories;Other Curretn Assets;Total current assets;Property Plant & equipment;Long term Investment assets;Total assets;Liabilities and equity;Short-Term Borrowings;Accoounts Payable;Deferred Revenues;Other Liabilities;Total current liabilities;Long Term debt;Post Retirement Benefits;Total liabilities;Stockholders' Equitys;Common stock;Retained Earning;Other income;Total Stockholder's equity;Total liabilities and equity;F;G;View Full Attachment

 

Paper#18279 | Written in 18-Jul-2015

Price : $57
SiteLock