Seeking help on accounting question

Jul 18th, 2015
KateS
Category:
Accounting
Price: $40 USD

Question description

assignment.docx 

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


Tutor Answer

(Top Tutor) Daniel C.
(997)
School: University of Virginia
PREMIUM TUTOR

Studypool has helped 1,244,100 students

8 Reviews


Summary
Quality
Communication
On Time
Value
Five Star Tutor
Dec 7th, 2016
" Outstanding Job!!!! "
SjSurvivor143
Nov 22nd, 2016
" Thanks for the help. "
Joemoe
Nov 9th, 2016
" <3 it, thanks for saving me time. "
tinytim47
Oct 31st, 2016
" Wow this is really good.... didn't expect it. Sweet!!!! "
pmallory
Oct 26th, 2016
" Totally impressed with results!! :-) "
mixedballz
Oct 17th, 2016
" excellent work as always thanks for the help "
kiln82
Oct 4th, 2016
" awesome work thanks "
darnay
Sep 25th, 2016
" The best tutor out there!!!! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1825 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