Finance Case Study- Jones Electrical

Anonymous
timer Asked: May 4th, 2018
account_balance_wallet $80

Question description

This Case study Requires you to read the attached HBR Article, Fill in the financial Model on Excel the templatre for which is attached(Jones Electrical Student Template).. After filling in the Excel model, You have to answer the remaining questions provided in the Wordfile(Jones Electrical Questions). All the details regarding the assignment are given in the Wordfile. The Case itself is given in the PDF File Called Jones Electrical Distribution

Tutor Answer

RyanTopTutor
School: UIUC

Attached.
Attached.
Attached.
Attached.

Exhibit 1 Operating Statements for Years Ending December 31, 2004-2006,
and for the first quarter 2007 (thousands of dollars)
Exhibit 1

Net sales
Cost of goods sold
Gross profit on sales
Operating expense b
Interest expense
Net income before taxes
Provision for income taxes
Net income

2004
$1.624
$1.304
$320

2005
$1.916
$1.535
$381

2006
$2.242
$1.818
$424

$272
$27
$21

$307
$30
$44

$347
$31
$46

$7
$14

$15
$29

$16
$30
0,0134

First Quarter
2007 a
$608
$499
$109
$94
$8
$7
$2
$5

Exhibit 2 Balance Sheet as of December 31, 2004-2006
and March 31, 2007 (thousands of dollars)
Exhibit 2

2004

2005

2006

$45

$53

$23

Accounts receivable

$187

$231

$264

Inventory

$243

$278

$379

Total current assets

$475

$562

$666

Property & equipment

$187

$202

$252

Accumulated depreciation

($74)

($99)

($134)

Total PP&E, net

$113

$103

$118

Total assets

$588

$665

$784

$36

$42

$120

Cash

Accounts payable
Line of credit payable

$149

$214

$249

Accrued expenses

$13

$14

$14

Long te...

flag Report DMCA
Review

Anonymous
Wow this is really good.... didn't expect it. Sweet!!!!

Similar Questions
Hot Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors