# Seeking help on accounting problem below..

Jul 18th, 2015
SKTFaker
Category:
Accounting
Price: \$30 USD

Question description

Hi Folks,

See attached. This is an exercise in constructing a P&L from info provided. It involves determining various line-items based on A/R DSO, Inventory MOH, A/P Days, etc. info.

NOTE: The NIBT amount (Net Income Before Tax) can be determined by dividing NIAT by (1-tax rate % as a decimal). For example, if NIAT is \$250,000 and the tax rate is 38%, the NIBT would be:

NIBT = NIAT/(1 - 0.38) = \$250,000/0.62 = \$403,226.

The Expenses can be calculated as the difference between GP & NIBT.

Try this & let me know if you have any questions.

Ken

Construct a 2013 P&L for a company with the following data and calculate eps: (NOTE: eps is NIAT “available to common shareholders” divided ny share quantity.

Retained Earnings 12/31/12  \$1,250,000

Retained earnings 12/31/13    1,600,000

A/R 12/31/13    1,250,000 (60 days DSO)

Inventory 12/31/13    1,500,000 (4 months-on-hand)

A/P 12/31/13    562,500 (45 days)

Net Profit Margin    10%

Tax Rate    30%

Preferred Dividend 2013  \$100,000

Common Dividend  \$300,000

Common Stock    325,000 shares

Complete all line items:

Sales

COGS

Gross Profit (GP)

GP%

Expenses

NIBT

Tax

NIAT

EPS

(Top Tutor) Daniel C.
(997)
School: Rice University

Studypool has helped 1,244,100 students

## Review from our student for this Answer

SoccerBoss
Jul 18th, 2015
"<3 it, thanks for saving me time. "

1827 tutors are online

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