This is an exercise in constructing a p&l from info provided. it

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

 

 

 

 

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.