Reference no: EM13858018

Construct a 2013 P&L for a company with the following data and calculate eps: (NOTE: eps is NIAT "available to common shareholders" divided by 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