Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please put into excel pter 2 Homework Assignment I. Using the data presented below: Mike Owlal Manufactering Income Statements For the Years 2013 and 2014
Please put into excel
pter 2 Homework Assignment I. Using the data presented below: Mike Owlal Manufactering Income Statements For the Years 2013 and 2014 Sales Cost of Goods 2,625,000 $2,422,500 704.9751,621,87 Gress Prefit 920,025 63,000 Selling & Admin. Expense Lease Expense 3,250 652,350626250 48,750 48,750 155,925 Net Operating Iacome Earaings Before Taxes Net Income Interest Expense 71,925 25,174 $46,751 84,000$1,000 21,375 7.481 $13.894 Taxes Tax Rate 35.00% 75,000 $0.62 35.00% 60,000 SO 23 Earnings per Share Mike Owjal Manufactering Balance Sheet For the Year Ended December 31, 2014 2014 Cash Marketable Securities Accounts Receivable 39,000$30,750 15,750 315,000279,000 386.250 315,000 1826 Total Current Assets 42,076 Gross Fixed Assets Accunslated D 010,000.627 500 426,750363,750 8325011263.780 2.325.326 1,904 250 Ner Plant & Egipment Tetat Assets astnes & Oner's Eio Accounts Payable 378.750217.500 22.500 240,000 Accrued Expeses 6.250 405,000 Toial Curreet Liobilties Lone-tes Debt Total Eiabilinies Cooo Stock (st oo pan 283 3251035 750 75,000 518250 ed Hines 402000 868,500 $1.904 250 ota Liah & ner's Lwty Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started