Negosim.xlsx - 1000 1 1200 0.75 10000 10 12000 7.5 487.5 1000 1 1200 2500 2.5 3000 Optimal capacity Max cap Investment Production Raw materials Labor

Negosim.xlsx - 1000 1 1200 0.75 10000 10 12000 7.5 487.5...

This preview shows page 1 - 10 out of 10 pages.

1000 10000 1 10 1200 12000 Optimal capacity 0.75 7.5 Max cap Investment Production 487.5 Raw materials Labor cost Plant dep 1000 2500 Quality effort 1 2.5 Total cost 1200 3000 Unit cost Optimal capacity Max cap Investment Production Raw materials Labor cost Plant dep Quality effort Total cost Unit cost
Image of page 1
Plant a Plant b 1,000 5,000 1,200 6,000 200,000 1,400,000 1,200 5,000 10 12,000 35,000 100 42,250 125,000 5,000 35,000 3,000 20,000 62,250 215,000 51.875 43 4% Plant a Plant b 1,000 5,000 1,200 6,000 200,000 1,400,000 1,000 5,000 10 10,000 35,000 60 19,500 125,000 5,000 35,000 2,500 20,000 37,000 215,000 37 43 -0.26
Image of page 2
JV 1190000 Mkt value 4,953,133 Procurement 133068.75 Shareholder's equity 2,476,442 Type1 140000 M/B 2.00010038596 Requied 1400000 Cash 554448 300000 Debt 2557845 1163068.75 3720913.75 Leverage d/e 1.5025240849574 0.98 1.03 Borrowing capacity 2,481,607 Sources of funds to setup plant B
Image of page 3
210000 15% 243750 Sales 2230000 14.7058824 Japan 44694 Germany 73350
Image of page 4
Income statement SALES 1,454,863 Cost of Goods Sold 892,561 GROSS MARGIN 562,301 SG & A EXPENSES Selling Expenses 218,225 General & Administrative 157,649 Other Operating Expenses - OPERATING PROFIT 186,427 Other Expenses - Other Income - EBIT (Earnings Before Interest and Taxes) 186,427 Net Financial Expenses 30,551 EARNINGS BEFORE TAXES
Image of page 5
Image of page 6
Image of page 7
Image of page 8
Image of page 9
Image of page 10

You've reached the end of your free preview.

Want to read all 10 pages?

  • Spring '20
  • Generally Accepted Accounting Principles, net financial expenses

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes